没什么好说的,直接上代码吧:
with open('file.csv', "w", encoding='utf-8', newline='') as csvfile:
writer = csv.writer(csvfile)
# 首先是表头
writer.writerow(["id", "name", "gender", "birthday", "rating"])
# 然后是循环写入内容
for row in results:
writer.writerow([row[0], row[1], row[2], row[3], row[4]])
其中,with open()里的newline=’'是为了定义下一行开始前不空行,不加它的话,csv文件中每个条目的下面会多出一个空行