如何存取爬取的数据，万分感谢~~~

liubulong

我现在想把数据保存在excel表格中,但是报错了，麻烦大佬帮忙解答一下，谢谢~~~

代码如下:
import requests
from bs4 import BeautifulSoup
import openpyxl

def open_url(url):
    headers = {'user-agent': 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/55.0.2883.87 Safari/537.36'
    }
    html = requests.get(url, headers=headers).text
    return html

def get_data(html):
    content = BeautifulSoup(html, "html.parser")
    data = content.find_all('li', attrs={'class': 'stitle'})
    cinema_list = []
    for d in data:
        plist = d.find('a')['title']
        cinema_list.append(plist)
        return cinema_list

def save_as_excel(mylist):
    wb = openpyxl.Workbook()
    ws = wb.active

    ws['A1'] = '电影'

    for d in mylist:
        ws.append(d)

    wb.save('2023电影排行.xlsx')

def main():
    url = 'https://movie.douban.com/cinema/nowplaying/shanghai/'
    html = open_url(url)
    mylist = get_data(html)
    save_as_excel(mylist)

if __name__ == '__main__':
    main()

报错信息:
E:\anaconda3\python.exe C:/Users/lyl/PycharmProjects/pythonProject1/dangdang/dangdang/spiders/abc.py
Traceback (most recent call last):
  File "C:/Users/lyl/PycharmProjects/pythonProject1/dangdang/dangdang/spiders/abc.py", line 1719, in <module>
    main()
  File "C:/Users/lyl/PycharmProjects/pythonProject1/dangdang/dangdang/spiders/abc.py", line 1716, in main
    save_as_excel(mylist)
  File "C:/Users/lyl/PycharmProjects/pythonProject1/dangdang/dangdang/spiders/abc.py", line 1708, in save_as_excel
    ws.append(d)
  File "E:\anaconda3\lib\site-packages\openpyxl\worksheet\worksheet.py", line 675, in append
    self._invalid_row(iterable)
  File "E:\anaconda3\lib\site-packages\openpyxl\worksheet\worksheet.py", line 811, in _invalid_row
    raise TypeError('Value must be a list, tuple, range or generator, or a dict. Supplied value is {0}'.format(
TypeError: Value must be a list, tuple, range or generator, or a dict. Supplied value is <class 'str'>

Process finished with exit code 1

wp231957

TypeError: Value must be a list, tuple, range or generator, or a dict. Supplied value is <class 'str'>
value 必须是一个列表 元组 区域 或者生成器 或者一个字典   然而你给出的是str  

liubulong

wp231957 发表于 2023-4-20 15:51
TypeError: Value must be a list, tuple, range or generator, or a dict. Supplied value is
value 必 ...

那请问该如何修改呢？python小白求指教一下

isdkz

报错信息提示：在使用`ws.append()`方法时，传入的值必须是列表、元组、范围或生成器，或者是字典。但是你传入的值是一个字符串。为了解决这个问题，你需要将字符串放入一个列表中。修改`save_as_excel`函数如下：

def save_as_excel(mylist):
    wb = openpyxl.Workbook()
    ws = wb.active

    ws['A1'] = '电影'

    for d in mylist:
        ws.append([d])  # 将 d 放入一个列表中

    wb.save('2023电影排行.xlsx')

现在你的代码应该可以正常运行并将数据保存到Excel表格中。

liubulong

isdkz 发表于 2023-4-21 14:21
报错信息提示：在使用`ws.append()`方法时，传入的值必须是列表、元组、范围或生成器，或者是字典。但是你 ...

谢谢大佬~~~