2 回答

TA貢獻1799條經驗 獲得超9個贊
每個列表在 CSV 文件中的顯示方式取決于數據結構。data
對于列表列表,以下代碼應該可以正常工作。data
import csv
data = []
d1 = ['00:00', 'abc', '2', 'xyz']
d2 = ['00:01', 'cde', '3', 'sda']
data.append(d1)
data.append(d2)
with open('results_file.csv', mode='w') as results_file:
results_writer = csv.writer(results_file, delimiter='|', quotechar='"',
quoting=csv.QUOTE_MINIMAL)
results_writer.writerow(['A','B','C','D'])
for x in data:
results_writer.writerow(x)
results_file.csv看起來像:
A|B|C|D
00:00|abc|2|xyz
00:01|cde|3|sda

TA貢獻1797條經驗 獲得超6個贊
方法如何?漂亮又簡單...pandas
import pandas as pd
data = [['00:00', 'abc', '2', 'xyz'], ['00:01', 'cde', '3', 'sda']]
cols = ['A', 'B', 'C', 'D']
# Load data into a DataFrame.
df = pd.DataFrame(data, columns=cols)
# Write the CSV.
df.to_csv('output.csv', sep='|', index=False)
根據文檔,您可以使用參數更改分隔符。sep
[編輯]輸出:
的內容,如控制臺所示:output.csv
user@host ~/Desktop/so
$ cat output.csv
A|B|C|D
00:00|abc|2|xyz
00:01|cde|3|sda
添加回答
舉報