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

2024-04-24 07:22:41 发布

您现在位置:Python中文网/ 问答频道 /正文

我需要在Python上读取csv,并且我拥有的文本文件具有以下结构:

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

分度计:

新线:@

我的代码:

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

这段代码只打印一行,因为它不能将@识别为换行符, 并用引号打印出来:

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

Tags: csvcsvfile代码datastockreaderrowmaterial