将如下列表数据转为csv文件
['ID', 'Name', 'Age'] ['1', 'Tom', '18'] ['2', 'Jerry', '19'] ['3', 'Mary', '20']
# 方式一
# 将list 转为csv
import csv
# 定义list
list_a=[]
list_a.append(['ID', 'Name', 'Age'])
list_a.append(['1', 'Tom', '18'])
list_a.append(['2', 'Jerry', '19'])
list_a.append(['3', 'Mary', '20'])
print(list_a)
with open('/root/list_to_csv.csv', 'w', newline='') as f:
writer = csv.writer(f)
writer.writerows(list_a)
# 读取CSV文件
import csv
with open('/root/list_to_csv.csv', 'r') as f:
reader = csv.reader(f)
result = list(reader)
#print(type(result))
print(result)
#print(result[0])
#print(result[1])
# 输出结果：
[['ID', 'Name', 'Age'], ['1', 'Tom', '18'], ['2', 'Jerry', '19'], ['3', 'Mary', '20']]
# 方式二
import pandas as pd
list=[[1,2,3],[4,5,6],[7,9,9]]
name=[ 'one', 'two', 'three']
name2=['a', 'b', 'c']
test=pd.DataFrame( columns=name, index=name2, data=list)
print(test)
test.to_csv('/root/testcsv.csv', encoding= 'gbk')
# 读取CSV文件
import csv
with open('/root/testcsv.csv', 'r') as f:
reader = csv.reader(f)
print(reader)
for row in reader:
print(row)
# 输出结果：
['', 'one', 'two', 'three']
['a', '1', '2', '3']
['b', '4', '5', '6']
['c', '7', '9', '9']
import pandas as pd
reader=pd.read_csv("/root/testcsv.csv")
print(reader)
# 输出结果：
>>> print(reader)
Unnamed: 0 one two three
0 a 1 2 3
1 b 4 5 6
2 c 7 9 9
>>>
最终检查生成的csv文件
# more /root/testcsv.csv ,one,two,three a,1,2,3 b,4,5,6 c,7,9,9 #
