import csv
def write_csv():
data_list = [
["A1", "B1"],
["A2", "B2"],
["A3", "B3"]
]
# 注意: 如果写的内容中有中文,一定要设置编码格式为utf,否则会出现乱码,
# 默认情况下,每写一行都会回车,导致出现空行,所以采用newline=''取消空行
# 下面这种方式需要显示的关闭文件,如果用with方式打开,则不用显示关闭
file = open("test.csv", "w", encoding="utf_8_sig", newline='')
writer = csv.writer(file)
for data in data_list:
writer.writerow(data) # 向文件中写一行
file.close() # 关闭文件
def read_csv():
# 以读模式打开csv文件,并设置编码方式为utf_8_sig
file = open("test.csv", "r", encoding="utf_8_sig")
data_list = csv.reader(file)
for data in data_list:
print(data)
file.close()
def main():
write_csv()
read_csv()
if __name__ == '__main__':
main()
知乎:https://www.zhihu.com/people/xiao-ran-6-85-19/activities