诗岑 2022-07-11 14:10 采纳率: 93%
浏览 1711
已结题

AttributeError: 'str' object has no attribute 'keys'

检验了一下value的类型是字典,为什么会出现str?

# noinspection PyUnresolvedReferences
import json
import pandas as pd
import numpy as np
import requests
from lxml import html
import os
from bs4 import BeautifulSoup
import re
from operator import itemgetter
import csv
import demjson

#请求地址
url='https://ncov.dxy.cn/ncovh5/view/pneumonia'

#设置请求头
header={
    "User-agent":"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/103.0.0.0 Safari/537.36"
}

#发送请求
response =requests.get(url=url, headers=header)

page=response.content.decode('utf-8')


#构建BeautifulSoup对象
soup = BeautifulSoup(page, 'lxml')

#根据id属性查找
script=soup.find(id="getAreaStat")
#活动标签中的文本内容
data = script.text

json_str = re.findall(r'\[.+\]', data)[0]

resut = json.loads(json_str)

# resultData = json.dumps(resut,ensure_ascii=False)

#print(type(resut))
#print(type(resut[1]))
#print(len(resut))
#print(resut[1])                     resut是列表

city=list()
keys=['provinceName','cities']
for i in range (len(resut)):
    if(i>2):
        out = itemgetter(*keys)(resut[i])
        city.append(resut[i].get('cities'))
        #print(out)
        #print(i,city)#现在每一个city都是一个字典,把字典转换成列表

#print(city)

a=[]
for headers in sorted(city[0][0].keys()):#把字典的键取出来
    a.append(headers)
header=a#把列名给提取出来,用列表形式呈现
#print(header)

value={}
for m in range (len(city)):
    for n in range(len(city[m])):
        value.update(city[m][n].items())
        #print(type(value))
        mid = pd.DataFrame(data=value, index=[0])
        #print(type(mid))
        #mid.to_csv('C:/Users/Administrator/Desktop/实训/city1.csv',encoding='gbk')
print(type(value))
print(type(mid))
filednames=['cityName','currentConfirmedCount', 'confirmedCount','suspectedCount','curedCount','deadCount','highDangerCount','midDangerCount','locationId','currentConfirmedCountStr']
with open('C:\\Users\\Administrator\\Desktop\\实训\\city1.csv','w',newline='',encoding='gbk')as f2:
    writer=csv.DictWriter(f2,filednames)
    writer.writeheader()
    writer.writerows(value)

<class 'dict'>
<class 'pandas.core.frame.DataFrame'>
Traceback (most recent call last):
  File "C:\Users\Administrator\Desktop\实训\YQdata.py", line 78, in <module>
    writer.writerows(value)
  File "C:\Users\Administrator\AppData\Local\Programs\Python\Python310\lib\csv.py", line 157, in writerows
    return self.writer.writerows(map(self._dict_to_list, rowdicts))
  File "C:\Users\Administrator\AppData\Local\Programs\Python\Python310\lib\csv.py", line 147, in _dict_to_list
    wrong_fields = rowdict.keys() - self.fieldnames
AttributeError: 'str' object has no attribute 'keys'

  • 写回答

3条回答 默认 最新

  • 於黾 2022-07-11 14:22
    关注

    你以为rowdict是个字典,但是它其实是个str
    你放了一大堆代码,但是报错的这行代码没有放
    仔细往前找,看它什么时候就已经是个str了

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(2条)

报告相同问题?

问题事件

  • 系统已结题 7月19日
  • 已采纳回答 7月11日
  • 创建了问题 7月11日

悬赏问题

  • ¥15 metadata提取的PDF元数据,如何转换为一个Excel
  • ¥15 关于arduino编程toCharArray()函数的使用
  • ¥100 vc++混合CEF采用CLR方式编译报错
  • ¥15 coze 的插件输入飞书多维表格 app_token 后一直显示错误,如何解决?
  • ¥15 vite+vue3+plyr播放本地public文件夹下视频无法加载
  • ¥15 c#逐行读取txt文本,但是每一行里面数据之间空格数量不同
  • ¥50 如何openEuler 22.03上安装配置drbd
  • ¥20 ING91680C BLE5.3 芯片怎么实现串口收发数据
  • ¥15 无线连接树莓派,无法执行update,如何解决?(相关搜索:软件下载)
  • ¥15 Windows11, backspace, enter, space键失灵