Removing key from json file in Python (getting TypeError)

Question

I have a this json file:

{
 "DailyForecasts": [
  {
   "Temperature": {
    "Minimum": {
     "Value": 2.9
    },
    "Maximum": {
     "Value": 16.1
    }
  },
 "HoursOfSun": 12,
 "AirAndPollen": [
    {
      "Name": "AirQuality",
      "Value": 37,
      "CategoryValue": 1
    },
    {
      "Name": "UVIndex",
      "Value": 5,
      "CategoryValue": 2
    }
   ]
  }
 ]
}

I would like to remove "CategoryValue" key from "AirAndPollen" array. I tried this Python code, but getting:

TypeError: list indices must be integers or slices, not str

My Python code:

import json

with open('accu-test.json') as f:
    data = json.load(f)

for remove in data['DailyForecasts']:
    del remove['AirAndPollen']['CategoryValue']

print(json.dumps(data, indent=2))

What's the recommended approach in this case? Thank you.

user6597761 · Accepted Answer · 2020-04-12 19:03:04Z

1

AirAndPollen is a list, you would have to iterate through it too.

for i in data['DailyForecasts']:
    for j in i['AirAndPollen']:
        del j['CategoryValue']

from pprint import pprint
pprint(data)

 # {'DailyForecasts': [{'AirAndPollen': [{'Name': 'AirQuality', 'Value': 37},
 #                                       {'Name': 'UVIndex', 'Value': 5}],
 #                      'HoursOfSun': 12,
 #                      'Temperature': {'Maximum': {'Value': 16.1},
 #                                      'Minimum': {'Value': 2.9}}}]}

answered Apr 12, 2020 at 19:03

user6597761

Sign up to request clarification or add additional context in comments.

Comments

Larry Lustig · Accepted Answer · 2020-04-12 19:03:20Z

0

If you add a statement print(remove['AirAndPollen']) you'll see that remove['AirAndPollen'] is not a single object but rather a list. You need an additional loop to operate on each on of those objects in turn.

answered Apr 12, 2020 at 19:03

Larry Lustig

51.2k16 gold badges119 silver badges173 bronze badges

Comments

Gabio · Accepted Answer · 2020-04-12 19:07:15Z

try this one:

data = {
    "DailyForecasts": [
        {
            "Temperature": {
                "Minimum": {
                    "Value": 2.9
                },
                "Maximum": {
                    "Value": 16.1
                }
            },
            "HoursOfSun": 12,
            "AirAndPollen": [
                {
                    "Name": "AirQuality",
                    "Value": 37,
                    "CategoryValue": 1
                },
                {
                    "Name": "UVIndex",
                    "Value": 5,
                    "CategoryValue": 2
                }
            ]
        }
    ]
}

air_and_pollen = data.get("DailyForecasts")[0]["AirAndPollen"]
for i in air_and_pollen:
    i.pop("CategoryValue")
data.get("DailyForecasts")[0]["AirAndPollen"] = air_and_pollen
print(data)

halfer · Accepted Answer · 2022-01-26 22:19:09Z

0

You could use nested_delete from the nested_lookup module:

NB: I wrapped the json data into a content variable:

from nested_lookup import nested_delete

#specify the key u wish to remove
content = nested_delete(content,'CategoryValue')

print(content)

{'DailyForecasts': [{'Temperature': {'Minimum': {'Value': 2.9},
    'Maximum': {'Value': 16.1}},
   'HoursOfSun': 12,
   'AirAndPollen': [{'Name': 'AirQuality', 'Value': 37},
    {'Name': 'UVIndex', 'Value': 5}]}]}

edited Jan 26, 2022 at 22:19

halfer

20.2k20 gold badges110 silver badges207 bronze badges

answered Apr 12, 2020 at 22:57

sammywemmy

28.9k4 gold badges21 silver badges35 bronze badges

Collectives™ on Stack Overflow

Removing key from json file in Python (getting TypeError)

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related