列表怎么保存到 csv 文件能用 excel 打开啊

[zcsnbb]

lst = [{"a": 1, "b": 1}, {"a": 2, "b": 2},{"a": 3, "b": 3},{"a": 3, "b": 3}] 比如这样

[liwufan]

饿…… https://docs.python.org/3/library/csv.html ？

[fangdingjun]

英文逗号分隔，中文要编码成 gbk

[xpresslink]

>>> import csv
>>> f = open('d:/tmp/test.csv', 'w', encoding='gbk')
>>> writer = csv.DictWriter(f, fieldnames=['a','b'])
>>> for dic in [{"a": 1, "b": 1}, {"a": 2, "b": 2},{"a": 3, "b": 3},{"a": 3, "b": 3}]: writer.writerow(dic)

5
5
5
5
>>> f.close()
>>>

[lazyload]

import pandas as pd
from pandas import DataFrame
lst = DataFrame([{"a": 1, "b": 1}, {"a": 2, "b": 2},{"a": 3, "b": 3},{"a": 3, "b": 3}])
lst.to_csv('test.csv')