我正在努力编写下面的python脚本。
我有一个csv
文件
"SNo","Title1","Title2"
"A1-A3,A4-A5","A,B","C"
"A6-A7","X","Y"
"A8","Z","D"
输出应该是一个csv文件,应该生成
"SNo","Title1","Title2"
"A1","A,B","C"
"A2","A,B","C"
"A3","A,B","C"
"A4","A,B","C"
"A5","A,B","C"
"A6","X","Y"
"A7","X","Y"
"A8","Z","D"
我正在看文件
cols= [0,1,2]
with open('C:\\down\\1\\list.csv','rb') as f:
reader = csv.reader(f)
for row in reader:
content = list(row[i] for i in cols)
numberlist = content[0].replace("A","").split(",")
print numberlist[0],content[1],content[2]
但我还在努力。 请告诉我一个好办法。你知道吗
谢谢
我想这可以作为一个起点:
如果你想得到你发布的输出格式,你需要调整一下。你知道吗
你可以试试这个:
这将处理异常,如:“A3-A1”
假设
data
是包含csv
文件中数据的列表列表:输出:
相关问题 更多 >
编程相关推荐