问题描述:将爬取的数据保存的csv文件,遇到几个问题,原代码如下:
with open('F:\\Pythontest1\\douban.csv','w') as f:
writer = csv.writer(f,dialect='excel')
writer.writerow(['rank','title','rate','autor','member','quote'])
for row in filmall:
writer.writerow(row)
1.保存文件乱码问题:
UnicodeEncodeError: 'gbk' codec can't encode character '\xa0' in position 46: illegal multibyte sequence
解决方法,with open('F:\\Pythontest1\\douban.csv','w',encoding='gb18030') as f
2.保存的csv文件,表格中间隔有空行问题:
解决方法,
with open('F:\\Pythontest1\\douban.csv','w',encoding='gb18030',newline='') as f: