亚洲在线久爱草,狠狠天天香蕉网,天天搞日日干久草,伊人亚洲日本欧美

為了賬號安全,請及時綁定郵箱和手機立即綁定
已解決430363個問題,去搜搜看,總會有你想問的

CSV文件的標題欄怎么寫?

CSV文件的標題欄怎么寫?

郎朗坤 2021-08-14 21:27:19
def write_vt(d, filename):     f = open(filename, 'w')我應該以寫入模式打開新文件,然后在標題列中寫入,然后使用 for 循環將數據字符串添加到文件中。但我就是不知道如何做到這一點......原始文件名為votes.csv.
查看完整描述

2 回答

?
Qyouu

TA貢獻1786條經驗 獲得超11個贊

有很多方法可以做到這一點,具體取決于您的數據和您愿意使用的工具:


a) 用列表和標題逐行寫入 CSV

import csv



data_list = [

    ["Russia", "Moscow", "Russian"],

    ["US", "Washington, D.C.", "English"],

    ["Colombia", "Bogotá", "Spanish"]

]

header = ["col1", "col2", "col3"]


def write_csv_from_lists(data, header, filename):

    with open(filename, "w") as csv_file:

        csv_writer = csv.writer(csv_file)

        csv_writer.writerow(header) # write header

        for row in data:

            csv_writer.writerow(row) # write each row


write_csv_from_lists(data_list, header, "file1.csv")

文件1.csv

col1,col2,col3

Russia,Moscow,Russian

US,"Washington, D.C.",English

Colombia,Bogotá,Spanish

b) 用字典和標題逐行寫入 CSV

import csv



data_dict = [

    {"col1": "Russia", "col2": "Moscow", "col3": "Russian"},

    {"col1": "US", "col2": "Washington, D.C.", "col3": "English"},

    {"col1": "Colombia", "col2": "Bogotá", "col3": "Spanish"}

]

header = ["col1", "col2", "col3"]


def write_csv_from_dicts(data, header, filename):

    with open(filename, "w") as csv_file:

        dict_writer = csv.DictWriter(csv_file, fieldnames=header)

        dict_writer.writeheader() # write header

        for row in data:

            dict_writer.writerow(row) # write each row


write_csv_from_dicts(data_dict, header, "file2.csv")

文件2.csv

col1,col2,col3

Russia,Moscow,Russian

US,"Washington, D.C.",English

Colombia,Bogotá,Spanish

c) 用 Pandas 編寫 CSV

import pandas as pd



data_dict = [

    {"col1": "Russia", "col2": "Moscow", "col3": "Russian"},

    {"col1": "US", "col2": "Washington, D.C.", "col3": "English"},

    {"col1": "Colombia", "col2": "Bogotá", "col3": "Spanish"}

]


def write_csv_pandas(data, filename):


    pd.DataFrame(data).to_csv(filename, index=False)


write_csv_pandas(data_dict, "file3.csv")

文件3.csv

col1,col2,col3

Russia,Moscow,Russian

US,"Washington, D.C.",English

Colombia,Bogotá,Spanish


查看完整回答
反對 回復 2021-08-14
?
浮云間

TA貢獻1829條經驗 獲得超4個贊

您可以使用它來添加標題:


header = "col1,col2,col3"

with open('file.csv','w') as my_csv:

    my_csv.write(header+'\n')

關于用數據填充 CSV,這將取決于您將用作源的原始數據。


查看完整回答
反對 回復 2021-08-14
  • 2 回答
  • 0 關注
  • 410 瀏覽
慕課專欄
更多

添加回答

舉報

0/150
提交
取消
微信客服

購課補貼
聯系客服咨詢優惠詳情

幫助反饋 APP下載

慕課網APP
您的移動學習伙伴

公眾號

掃描二維碼
關注慕課網微信公眾號