爬虫数据保存为csv文件时，表格中间隔有空行问题

问题描述：将爬取的数据保存的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: