python 将list转为csv文件.sql

将如下列表数据转为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
#