Python提取json数据并存入csv，提取json文件内容信息报错

代码

import json
import csv

# 打开JSON文件并加载数据
with open('4_.json', 'rb') as f:
    data_list = json.load(f)
    arr = data_list['data']
    print(arr['list'])
    for data in arr:
        # 提取停车场信息
        mchname = data['list']['mchname']
        parkname = data['list']['parkname']
        totalspace = data['list']['totalspace']
        usedspace = data['list']['usedspace']
        freeMinute = data['list']['freeMinute']

# 将信息写入CSV文件
with open('parking_info2.csv', 'w', newline='') as f:
    writer = csv.writer(f)
    writer.writerow(['运营公司', '停车场名称', '总车位数', '当前使用车位数','免费时长'])
    writer.writerow([mchname, parkname, totalspace, usedspace,freeMinute])

报错信息

Traceback (most recent call last):
  File "F:\text1\爬虫\pc4.py", line 11, in <module>
    mchname = data['list']['mchname']
TypeError: string indices must be integers

json文件

{
    "status":1,
    "msg":"success",
    "data":{
        "total":153,
        "offset":0,
        "limit":0,
        "list":[
            {
                "id":173,
                "parkid":"1-01-2-3019",
                "parentid":null,
                "mchid":"161",
                "mchname":"碑林区运营公司",
                "parkname":"测绘路路北",
                "address":"测绘路路北",
                "citycode":"西安市",
                "areacode":"碑林区",
                "streetcode":"测绘路",
                "lng":108.96202,
                "lat":34.238243,
                "img":null,
                "totalspace":32,
                "usedspace":22,
                "price":2,
                "parktype":1,
                "ischarge":false,
                "isbook":false,
                "isused":true,
                "servicescope":null,
                "text":null,
                "maxPriceOfDay":null,
                "freeMinute":15,
                "dist":1394.5372,
                "unuse":10,
                "isstore":null,
                "paytypelist":null,
                "usableBookingCarportNumber":null,
                "monthvipid":null,
                "pricestrategyid":5,
                "pricenewenergyid":9,
                "innerpricestrategyid":null,
                "strobeflag":null,
                "businesspricestrategyid":null,
                "pricepublicityid":7,
                "pricePublicityFrontList":null,
                "aliParkingid":"",
                "carPortBOS":null,
                "outerinfo":false,
                "limitType":null,
                "limitDate":null,
                "limitTime":null,
                "limitWorkday":null,
                "bookingRule":"",
                "bookingTimeFrameBOS":null,
                "nowtime":null,
                "bookingTimeRule":false,
                "districtid":4,
                "parkArea":2
            },
            {
                "id":96,
                "parkid":"1-01-2-4025",
                "parentid":null,
                "mchid":"161",
                "mchname":"碑林区运营公司",
                "parkname":"皇甫路（兴庆路-交大街段）双侧",
                "address":"皇甫路（兴庆路-交大街段）双侧",
                "citycode":"西安市",
                "areacode":"碑林区",
                "streetcode":"皇甫路",
                "lng":108.99051,
                "lat":34.24799,
                "img":null,
                "totalspace":92,
                "usedspace":31,
                "price":2,
                "parktype":1,
                "ischarge":false,
                "isbook":false,
                "isused":true,
                "servicescope":null,
                "text":null,
                "maxPriceOfDay":null,
                "freeMinute":15,
                "dist":1394.5374,
                "unuse":61,
                "isstore":null,
                "paytypelist":null,
                "usableBookingCarportNumber":null,
                "monthvipid":null,
                "pricestrategyid":5,
                "pricenewenergyid":9,
                "innerpricestrategyid":null,
                "strobeflag":null,
                "businesspricestrategyid":null,
                "pricepublicityid":7,
                "pricePublicityFrontList":null,
                "aliParkingid":"",
                "carPortBOS":null,
                "outerinfo":false,
                "limitType":null,
                "limitDate":null,
                "limitTime":null,
                "limitWorkday":null,
                "bookingRule":"",
                "bookingTimeFrameBOS":null,
                "nowtime":null,
                "bookingTimeRule":false,
                "districtid":5,
                "parkArea":2
            },
            {
                "id":68,
                "parkid":"1-01-2-3031",
                "parentid":null,
                "mchid":"161",
                "mchname":"碑林区运营公司",
                "parkname":"测绘东路（测绘路至友谊东路段）双侧",
                "address":"测绘东路（测绘路至友谊东路段）双侧",
                "citycode":"西安市",
                "areacode":"碑林区",
                "streetcode":"测绘东路",
                "lng":108.960236,
                "lat":34.237778,
                "img":null,
                "totalspace":49,
                "usedspace":32,
                "price":2,
                "parktype":1,
                "ischarge":false,
                "isbook":false,
                "isused":true,
                "servicescope":null,
                "text":null,
                "maxPriceOfDay":null,
                "freeMinute":15,
                "dist":1394.5521,
                "unuse":17,
                "isstore":null,
                "paytypelist":null,
                "usableBookingCarportNumber":null,
                "monthvipid":null,
                "pricestrategyid":5,
                "pricenewenergyid":9,
                "innerpricestrategyid":null,
                "strobeflag":null,
                "businesspricestrategyid":null,
                "pricepublicityid":7,
                "pricePublicityFrontList":null,
                "aliParkingid":"",
                "carPortBOS":null,
                "outerinfo":false,
                "limitType":null,
                "limitDate":null,
                "limitTime":null,
                "limitWorkday":null,
                "bookingRule":"",
                "bookingTimeFrameBOS":null,
                "nowtime":null,
                "bookingTimeRule":false,
                "districtid":4,
                "parkArea":2
            },
            {
                "id":69,
                "parkid":"1-01-2-3032",
                "parentid":null,
                "mchid":"161",
                "mchname":"碑林区运营公司",
                "parkname":"测绘东路（建设路-测绘路段）双侧",
                "address":"测绘东路（建设路-测绘路段）双侧",
                "citycode":"西安市",
                "areacode":"碑林区",
                "streetcode":"测绘东路",
                "lng":108.960236,
                "lat":34.237778,
                "img":null,
                "totalspace":62,
                "usedspace":54,
                "price":2,
                "parktype":1,
                "ischarge":false,
                "isbook":false,
                "isused":true,
                "servicescope":null,
                "text":null,
                "maxPriceOfDay":null,
                "freeMinute":15,
                "dist":1394.5521,
                "unuse":8,
                "isstore":null,
                "paytypelist":null,
                "usableBookingCarportNumber":null,
                "monthvipid":null,
                "pricestrategyid":5,
                "pricenewenergyid":9,
                "innerpricestrategyid":null,
                "strobeflag":null,
                "businesspricestrategyid":null,
                "pricepublicityid":7,
                "pricePublicityFrontList":null,
                "aliParkingid":"",
                "carPortBOS":null,
                "outerinfo":false,
                "limitType":null,
                "limitDate":null,
                "limitTime":null,
                "limitWorkday":null,
                "bookingRule":"",
                "bookingTimeFrameBOS":null,
                "nowtime":null,
                "bookingTimeRule":false,
                "districtid":4,
                "parkArea":2
            },
            {
                "id":61,
                "parkid":"1-01-2-3021",
                "parentid":null,
                "mchid":"161",
                "mchname":"碑林区运营公司",
                "parkname":"草场坡（南二环-永宁路段）双侧",
                "address":"草场坡（南二环-永宁路段）双侧",
                "citycode":"西安市",
                "areacode":"碑林区",
                "streetcode":"草场坡",
                "lng":108.94981,
                "lat":34.23448,
                "img":null,
                "totalspace":142,
                "usedspace":130,
                "price":2,
                "parktype":1,
                "ischarge":false,
                "isbook":false,
                "isused":true,
                "servicescope":null,
                "text":null,
                "maxPriceOfDay":null,
                "freeMinute":15,
                "dist":1394.5819,
                "unuse":12,
                "isstore":null,
                "paytypelist":null,
                "usableBookingCarportNumber":null,
                "monthvipid":null,
                "pricestrategyid":5,
                "pricenewenergyid":9,
                "innerpricestrategyid":null,
                "strobeflag":null,
                "businesspricestrategyid":null,
                "pricepublicityid":7,
                "pricePublicityFrontList":null,
                "aliParkingid":"",
                "carPortBOS":null,
                "outerinfo":false,
                "limitType":null,
                "limitDate":null,
                "limitTime":null,
                "limitWorkday":null,
                "bookingRule":"",
                "bookingTimeFrameBOS":null,
                "nowtime":null,
                "bookingTimeRule":false,
                "districtid":3,
                "parkArea":2
            },
            {
                "id":62,
                "parkid":"1-01-2-3022",
                "parentid":null,
                "mchid":"161",
                "mchname":"碑林区运营公司",
                "parkname":"草场坡（长安北路-永宁路段）双侧",
                "address":"草场坡（长安北路-永宁路段）双侧",
                "citycode":"西安市",
                "areacode":"碑林区",
                "streetcode":"草场坡",
                "lng":108.94981,
                "lat":34.23448,
                "img":null,
                "totalspace":30,
                "usedspace":30,
                "price":2,
                "parktype":1,
                "ischarge":false,
                "isbook":false,
                "isused":true,
                "servicescope":null,
                "text":null,
                "maxPriceOfDay":null,
                "freeMinute":15,
                "dist":1394.5819,
                "unuse":0,
                "isstore":null,
                "paytypelist":null,
                "usableBookingCarportNumber":null,
                "monthvipid":null,
                "pricestrategyid":5,
                "pricenewenergyid":9,
                "innerpricestrategyid":null,
                "strobeflag":null,
                "businesspricestrategyid":null,
                "pricepublicityid":7,
                "pricePublicityFrontList":null,
                "aliParkingid":"",
                "carPortBOS":null,
                "outerinfo":false,
                "limitType":null,
                "limitDate":null,
                "limitTime":null,
                "limitWorkday":null,
                "bookingRule":"",
                "bookingTimeFrameBOS":null,
                "nowtime":null,
                "bookingTimeRule":false,
                "districtid":3,
                "parkArea":2
            },
            {
                "id":137,
                "parkid":"2-01-2-3024",
                "parentid":null,
                "mchid":"161",
                "mchname":"碑林区运营公司",
                "parkname":"友谊东路路南（西安市卫生学校家属院前）",
                "address":"友谊东路路南（西安市卫生学校家属院前）",
                "citycode":"西安市",
                "areacode":"碑林区",
                "streetcode":"友谊东路",
                "lng":108.96803,
                "lat":34.241184,
                "img":null,
                "totalspace":17,
                "usedspace":14,
                "price":2,
                "parktype":1,
                "ischarge":false,
                "isbook":false,
                "isused":true,
                "servicescope":null,
                "text":null,
                "maxPriceOfDay":null,
                "freeMinute":15,
                "dist":1394.6275,
                "unuse":3,
                "isstore":null,
                "paytypelist":null,
                "usableBookingCarportNumber":null,
                "monthvipid":null,
                "pricestrategyid":5,
                "pricenewenergyid":9,
                "innerpricestrategyid":null,
                "strobeflag":null,
                "businesspricestrategyid":null,
                "pricepublicityid":7,
                "pricePublicityFrontList":null,
                "aliParkingid":"",
                "carPortBOS":null,
                "outerinfo":false,
                "limitType":null,
                "limitDate":null,
                "limitTime":null,
                "limitWorkday":null,
                "bookingRule":"",
                "bookingTimeFrameBOS":null,
                "nowtime":null,
                "bookingTimeRule":false,
                "districtid":3,
                "parkArea":2
            },
            {
                "id":139,
                "parkid":"2-01-2-4009",
                "parentid":null,
                "mchid":"161",
                "mchname":"碑林区运营公司",
                "parkname":"友谊东路路南（铁安一街-铁安二街段）",
                "address":"友谊东路路南（铁安一街-铁安二街段）",
                "citycode":"西安市",
                "areacode":"碑林区",
                "streetcode":"友谊东路",
                "lng":108.96803,
                "lat":34.241184,
                "img":null,
                "totalspace":16,
                "usedspace":14,
                "price":2,
                "parktype":1,
                "ischarge":false,
                "isbook":false,
                "isused":true,
                "servicescope":null,
                "text":null,
                "maxPriceOfDay":null,
                "freeMinute":15,
                "dist":1394.6275,
                "unuse":2,
                "isstore":null,
                "paytypelist":null,
                "usableBookingCarportNumber":null,
                "monthvipid":null,
                "pricestrategyid":5,
                "pricenewenergyid":9,
                "innerpricestrategyid":null,
                "strobeflag":null,
                "businesspricestrategyid":null,
                "pricepublicityid":7,
                "pricePublicityFrontList":null,
                "aliParkingid":"",
                "carPortBOS":null,
                "outerinfo":false,
                "limitType":null,
                "limitDate":null,
                "limitTime":null,
                "limitWorkday":null,
                "bookingRule":"",
                "bookingTimeFrameBOS":null,
                "nowtime":null,
                "bookingTimeRule":false,
                "districtid":4,
                "parkArea":2
            },
          
        ],
        "searchCount":true
    }
}

问题报错怎么解决

写回答
好问题 0 提建议
追加酬金
关注问题
分享
邀请回答
编辑收藏删除
收藏举报

4条回答默认最新

P2441M 2023-06-05 10:11

关注

import json
import csv

rows = []

# 不用二进制读取
with open('4_.json', 'r', encoding='utf-8') as f:
    data_list = json.load(f)
    arr = data_list['data']['list']
    print(arr)
    for data in arr:
        # 提取停车场信息
        mchname = data['mchname']
        parkname = data['parkname']
        totalspace = data['totalspace']
        usedspace = data['usedspace']
        freeMinute = data['freeMinute']
        rows.append([mchname, parkname, totalspace, usedspace, freeMinute])

with open('parking_info2.csv', 'w', newline='', encoding='utf-8') as f:
    writer = csv.writer(f)
    writer.writerow(['运营公司', '停车场名称', '总车位数', '当前使用车位数', '免费时长'])
    writer.writerows(rows)

本回答被题主选为最佳回答 , 对您是否有帮助呢?

查看更多回答(3条)

报告相同问题？

关注问题

PYTHON3.9 使用JSON库读取本地内容报错 json python 开发语言
2021-09-17 18:46

回答 1 已采纳你的代码有些许可以调整的地方，我稍微调整下，你试试就没有问题 with open("details.json", w) as f: # json = open('details.json',
python提取json数据出错 python
2023-02-13 23:39

回答 3 已采纳我猜测问题可能在于你试图从列表中提取键，而不是字典。可以尝试以下代码以获取 "content" 数据： content_data = dic['data']['indexList'][0]['**c
从json文件中提取文本报错KeyError: 0怎么修改 json pycharm python 有问必答
2022-03-30 18:37

回答 3 已采纳 value是传入的整数，语句中作为索引引用，而js_l是字典，所以报没有键的错误。如果要像代码那样运行，需要将js_l写成列表，即js_l=[]for ...: js=json.loads(li
python中csv、json文件的写入和读取
2021-01-20 03:33

txt文本文件读取： #txt文本文件读取 def txt_writter(): 写文件#函数说明文档 with open('data.txt','w',encoding='utf-8') as f: f.write('hi\n')#写一行 lines = [ 'hello\n' 'welcome\n' ] f.writelines...
python json 数据字典提取数据报错KeyError: 'vchange' python
2021-03-22 11:28

回答 4 已采纳应该是你的data_list中不是每个data都有‘vchange‘这个key的，只是部分有，部分没有，然后遍历到没有的时候就报错了。不信的话你在55行打印print(data[‘vchange‘])
python json 数据字典提取数据报错KeyError: 'visible_mask'，但我的json文件里明明有这个key json python
2022-04-13 15:41

回答 2 已采纳我打印出来没有visible_mask字段，另外两个字段category_id，segmentation有，下图是我打印的结果。这是怎么回事啊？我用记事本打开名为annotations的json文件发
利用python提取csv文件中特定列的字符（电话号码） python
2022-05-04 15:54

回答 4 已采纳为什么不能直接这样呢：df['phone'] = df['text'].apply(lambda x:re.findall(r"1[3-9]\d{9}",x))
Python提取JSON文件中的指定数据并保存在CSV或Excel表格文件内
2023-08-29 23:34

疯狂学习GIS的博客本文介绍基于Python语言，读取JSON格式的数据，提取其中的指定内容，并将提取到的数据保存到.csv格式或.xlsx格式的表格文件中的方法~
python中json.dump追加存储文件时如何添加换行符？ json python
2022-05-17 10:08

回答 2 已采纳在json.dump(username.rstrip()+"\n",b_file) 下面加一行代码 b_file.write("\n")单独加换行
python如何提取csv文件中的指定行并保存到新csv文件中 python 有问必答
2021-07-09 09:47

回答 2 已采纳用datetime函数转换一下日期，使用pandas提取出指定日期的数据，to_csv保存为另一个csv文件即可。转换语句可以用data['date'] = data['date'].apply(la
json提取数据显示KeyError: 'list' json python
2022-02-23 12:07

回答 2 已采纳 for改成这句：你取数据取错了 for info in page_text.get("data", dict()).get("list", []):
Python提取JSON数据中的键值对并保存为.csv文件
2023-09-16 00:04

疯狂学习GIS的博客本文介绍基于Python，读取JSON文件数据，并将JSON文件中指定的键值对数据转换为.csv格式文件的方法~
Python 怎么将这种类型的csv文件转换成以下json文件。 python
2022-10-14 17:20

回答 2 已采纳用python读取excel的库 xlrd读取数据，数据拿到后怎么拼接是你的事情：python操作excel表格(xlrd/xlwt) - 单曲荨环 - 博客园
如何使用python把json文件转换为csv文件
2021-03-12 16:43

孙晨c的博客文章目录了解json整体格式转换格式提取key和value使用pandas写入csv 了解json整体格式这里有一段json格式的文件，存着全球陆地和海洋的每年异常气温(这里只选了一部分)：global_temperature.json { "description":...
python把json数据生成csv文件
2022-11-13 20:49

小疯仔的博客用python把json数据生成csv文件
没有解决我的问题, 去提问

问题事件

关注

码龄粉丝数原力等级 --

被采纳

被点赞

采纳率
系统已结题 6月13日
关注

码龄粉丝数原力等级 --

被采纳

被点赞

采纳率
已采纳回答 6月5日
关注

码龄粉丝数原力等级 --

被采纳

被点赞

采纳率
创建了问题 6月5日

悬赏问题

¥15 verilog 非阻塞赋值下的移位拼接错误
¥100 两个按钮控制一个LED
¥15 用C语言写离散数学相关问题
¥30 如何用python的GephiStreamer连接到gephi中，把Python和Gephi的具体操作过程都展示，重点回答Gephi软件的调试，以及如果代码的端口在浏览器中无法显示怎么处理
¥15 ansys机翼建模肋参数
¥15 Sumo软件无法运行
¥15 如何在vscode里搭建stata的编辑环境？
¥15 dify知识库创建问题
¥15 如何用C#的chart画1000万个点不卡顿
¥15 爬虫技术找到网上看过房源客户的电话

Python提取json数据并存入csv，提取json文件内容信息报错

4条回答 默认 最新

问题事件

悬赏问题

4条回答默认最新