python换行输入csv_如何使用换行符@在python上读取csv

I need to read a csv on Python, and the text file that I have has this structure:

"114555","CM13","0004","0","C/U"@"99172","CM13","0001","0","C/U"@"178672","CM13","0001","0","C/U"

delimeter: ,

newline: @

My code so far:

import csv

data = []

with open('stock.csv') as csvfile:

reader = csv.reader(csvfile, delimiter=',', lineterminator='@')

for row in reader:

data.append({'MATERIAL': row[0],'CENTRO': row[1], 'ALMACEN': row[2], 'STOCK_VALORIZADO' : row[3], 'STOCK_UMB':row[4]})

print(data) #this print just one row

This code only print one row, because it's not recognize @ as a newline,

and prints it with quotes:

[{'MATERIAL': '114555', 'CENTRO': 'CM13', 'ALMACEN': '0004', 'STOCK_VALORIZADO': '0', 'STOCK_UMB': 'C/U@"99172"'}]

解决方案

According to https://docs.python.org/2/library/csv.html :

"The reader is hard-coded to recognise either '\r' or '\n' as end-of-line, and ignores lineterminator. This behavior may change in the future." Hence for now, providing the argument lineterminator='@' will not work.

I think the best option is to read your entire file into a variable, and replace all '@' characters, you can do this as follows:

with open("stock.csv", "r") as myfile:

data = myfile.read().replace('@', '\n')

Now you need to adjust your algorithm in such a way that you can pass the variable data to csv.reader (instead of the file stock.csv), according to the python doc:

"The "iterable" argument can be any object that returns a line

of input for each iteration, such as a file object or a list. [...]"

Hence you can pass data.splitlines() to csv.reader.