Question 175893 in Json Question posted in
Our archive of expertly curated questions and answers provides insights and solutions to common problems related to this popular data interchange format. From parsing and manipulating JSON data to integrating it with various programming languages and web services, our archive has got you covered. Start exploring today and take your JSON skills to the next level

Can specific lines be removed from a Json file?

I am trying to clean the json file down below. I want to remove all the dict key value pairs for which the key is "Company" in the "Stores" list.

{
"Company": "Apple",
"Stores": [
    {"Company" : "Apple",
     "Location" : "-",
     "Sales": "-",
     "Total_Employees": "-"
     },
    {"Company" : "Apple",
     "Location" : "-",
     "Sales": "-",
     "Total_Employees"
     },
    {"Company" : "Apple",
     "Location" : "-",
     "Sales": "-",
     "Total_Employees": "-"
     },    
]

}

This is my code so far:

import json

with open("stores.json", 'r') as jf:
    jsonFile = json.load(jf)

print(len(jsonFile))
testJson = {}

for k, v in jsonFile.items():
    for key in v:
        if not key.startswith('Company'):
            print(key)
            testJson = jsonFile[key]

print(len(jsonFile))

When I run it im getting TypeError: ‘int’ object is not iterable.

Tags:

2

Answers


  1. 0

    First off, your json is wrong, it’s missing values for Total_employee

    you can modify it the following way :

    {
    "Company": "Apple",
    "Stores": [
        {"Company" : "Apple",
         "Location" : "-",
         "Sales": "-",
         "Total_Employees": ""
        },
        {"Company" : "Apple",
         "Location" : "-",
         "Sales": "-",
         "Total_Employees" : ""
         },
        {"Company" : "Apple",
         "Location" : "-",
         "Sales": "-",
         "Total_Employees": ""
        }    
        ]
}

    Then, to answer your first question

    with open('store.json', 'r') as file:
    json_data = json.load(file)

if 'Stores' in json_data:
    stores = json_data['Stores'] # Gets Stores dictionnary
    for store in stores:
        if 'Company' in store: # Verify if company key exist
            del store['Company'] # Delete company key inside Stores

# Convert the modified data back to JSON string
updated_json_string = json.dumps(json_data, indent=4)

with open('updated_data.json', 'w') as file:
    file.write(updated_json_string)
    Login or Signup to reply.
  2. 0

    Having made changes to the data shown in the question (to make it valid JSON) you could do this:

    import json
import os

FILENAME = '/Volumes/G-Drive/foo.json'

with open(FILENAME, 'r+') as data:
    d = json.load(data)
    for store in d.get('Stores', []):
        try:
            del store['Company']
        except KeyError:
            pass
    data.seek(0, os.SEEK_SET)
    json.dump(d, data, indent=2)
    data.truncate()
    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search