提取和重写csv数据

Question

我有一个cvs文件，需要提取名字、姓氏和电话号码。该列表源自使用以下格式分隔数据的电子邮件：

Level,Name,Address 1,Address 2,City,State,ZIPcode,Phone,Title,Freq,Next Ship Date,ARO S,ARO ID,Prod,FName
0,"FAUST, A ","6 TYNE DR","","FRANKLIN ",KY,37064 ,309-279-5026,SSC, , , , , ,A FAUST

我能够在excel中保存为csv文件。我现在尝试使用python提取名字、姓氏和电话号码，然后写入一个新的csv文件。到目前为止，我有以下代码：

import pandas as pd

df = pd.read_csv((r'C:\Users\me\OneDrive\Documents\customers.csv'),encoding= 'unicode_escape')
print (df)

结果:

     0,"FAUST, A ","6 TYNE DR","","FRANKLIN ",KY,39064 ,309-279-5026,SSC, , , , , ,A FAUST
0    1,"ANDERSON, B ","91 CHAMPIONS CIR","",...                                                 
1    1,"ANDREWS, A ","1474 CANNON ST","","DA...  

谢谢你的帮助

Answer 1

问题是您使用索引创建了新的数据帧（和导出）

只需保存它而不使用隐式索引

即

df.to_excel("./excel.xls", index=False)