Python 正如您在CSV Python代码中看到的,我正在尝试创建一个CSV文件,然后在其中添加一些数据。
import os
import csv
fields = ['Name', 'Branch', 'Year', 'CGPA']
rows = [['Nikhil', 'COE', '2nd', '9.0'],
['Karan', 'COE', '2nd', '9.1'],
['Aditya', 'IT', '2nd', '9.3'],
['Sagar', 'SE', '1st', '9.5'],
['Prateek', 'MCE', '3rd', '7.8'],
['Sahil', 'EP', '2nd', '9.1']]
filename = "university_reco.csv" as csvfile:
with open(filename, 'w') as csvfile
csvwriter = file.writer(csvfile)
csvwriter.writerow(fields)
csvwriter.writerows(rows)
我想我错过了什么。所以请帮我解决这个问题
您应该写成:
filename="university_reco.csv"
而不是
filename="university_reco.csv" as csvfile:
您可以使用Pandas。
import pandas as pd
pd.read_csv(file)
然后处理该数据帧并将其保存为csv
https://pandas.pydata.org/docs/reference/api/pandas.DataFrame.to_csv.html
这就是如何在Pytho Pandas库的帮助下创建csv文件。
import pandas as pd
rows = [('Nikhil', 'COE', '2nd', '9.0'),
('Karan', 'COE', '2nd', '9.1'),
('Aditya', 'IT', '2nd', '9.3'),
('Sagar', 'SE', '1st', '9.5'),
('Prateek', 'MCE', '3rd', '7.8'),
('Sahil', 'EP', '2nd', '9.1')]
df=pd.DataFrame(data=rows,columns=['Name', 'Branch', 'Year', 'CGPA'])
df.to_csv(file_name, encoding='utf-8', index=False)