在CSV文件Python中将多个行和列编写为多行和列

Question

嗨，我对作为CSV的写列表有一些疑问，

我有多个列表，例如以下

head = ["name","roll_no","age"]
name = ["mohan","naveen","deepan"]
roll_no = [2087,2083,2090]
age = [23,23,24] 

我需要CSV文件输出为 头列必须标题

name     roll_no    age

mohan     2087       23
naveen    2083       23
deepan    2090       24

：我尝试过的代码：

    def write_csv(self, data, header_list):
        my_df = pd.DataFrame(data)
        my_df.to_csv(path_or_buf='my_csv.csv', index=True, header=header_list)
      

任何帮助都将不胜感激

Answer 1

尝试：

head = ["name", "roll_no", "age"]
name = ["mohan", "naveen", "deepan"]
roll_no = [2087, 2083, 2090]
age = [23, 23, 24]

df = pd.DataFrame(zip(name, roll_no, age), columns=head)
print(df)
df.to_csv("data.csv", index=False)

打印：

     name  roll_no  age
0   mohan     2087   23
1  naveen     2083   23
2  deepan     2090   24

并保存data.csv（从libreoffice屏幕截图）：