How to delete particular field in a json file by using python

Question

1.I was trying to use python to delete a particular key and its value in a JSON file. Here is the JSON file structure:

[
  {
    "_id": {
      "$oid": "6066af7bcb0716461578fa70"
    },
    "FileName": "copy_of_ex_fts.csv",
    "BriefInfo": "",
    "Size": "13.532KB",
    "UserName": "12795757"
    "data":"123"
  }
]

I wrote some code to remove key "data" and "UserName" with their values but I only can remove the data and its value not for the "UserName". Can someone give me some suggestions for fixing this bug?

2.Here is the code for implementation. Firstly just open the JSON file and load the data. Then to check if the key "data" and "UserName" are in it or not. If yes, delete these keys and their value.

jsonFile = open('./dataNewJson.json', 'r')
    values = json.load(jsonFile)
    for element in values:
        if 'data' in element:
            del element['data']
            print("check")
        elif 'BriefInfo' in element:
            del element['BriefInfo']
        elif 'UserName' in element:
            print("SSS")
            del element['UserName']
    values = dumps(values, indent = 2)

MalcolmInTheCenter · Accepted Answer · 2021-04-02 06:05:33Z

6

 for element in values:     
     if 'data' in element:     
         del element['data']     
         print("check")     
     if 'BriefInfo' in element:     
         del element['BriefInfo']     
     if 'UserName' in element:     
         print("SSS")     
         del element['UserName']

elif needs to be if. on each iteration data is found first so it falls into that if statement and skips the others.

answered Apr 2, 2021 at 6:05

MalcolmInTheCenter

1,6556 gold badges31 silver badges49 bronze badges

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

Collectives™ on Stack Overflow

How to delete particular field in a json file by using python

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related