主页 / 问题 / 949997
Accepted
Vadim
Asked:2020-02-27 16:20:26 +0800 CST2020-02-27 16:20:26 +0800 CST

Python 创建 csv 文件

  • 772

我csv为会计墨盒创建了一个文件

import csv

with open('cartridge_accounting.csv', 'w') as csvfile:
    filewriter = csv.writer(csvfile, delimiter=',',
    quotechar='|', quoting=csv.QUOTE_MINIMAL)
    filewriter.writerow(['Date', 'Model', 'Mark'])
    filewriter.writerow(['2019-02-26', 'CE255X', 'nv print'])
    filewriter.writerow(['2019-02-26', 'CE255X', 'nv print'])

结果，文件被写入了一行

['Date', 'Model', 'Mark']
[]
['2019-02-26', 'CE255X', 'nv print']
[]
['2019-02-26', 'CE255X', 'nv print']
[]

请告诉我如何摆脱它。以及如何添加索引行使文件如下所示：

['Date', 'Model', 'Mark']
[0,'2019-02-26', 'CE255X', 'nv print']
[1,'2019-02-26', 'CE255X', 'nv print']
[2,'2019-02-26', 'CE255X', 'nv print']
[3,'2019-02-26', 'CE255X', 'nv print']
python

2 个回答

  1. Best Answer

    该文档建议像这样解决它

    with open('cartridge_accounting.csv', 'w', newline='') as csvfile:
    • 5

  2. 对于此类任务， Pandas模块是理想的：

    import pandas as pd   #  pip install pandas

columns=['Date', 'Model', 'Mark']

data = [
['2019-02-26', 'CE255X', 'nv print'],
['2019-02-26', 'CE255X', 'nv print'],
['2019-02-26', 'CE255X', 'nv print'],
['2019-02-26', 'CE255X', 'nv print']
]

df = pd.DataFrame(data, columns=columns)
df.to_csv(r'/path/to/cartridge_accounting.csv')

    结果：

    ,Date,Model,Mark
0,2019-02-26,CE255X,nv print
1,2019-02-26,CE255X,nv print
2,2019-02-26,CE255X,nv print
3,2019-02-26,CE255X,nv print
    • 2

相关问题