How to modify the multiple values in the JSON file using python

Question

I am trying to modify my JSON file in which I need to replace the file_name with the base path as structured below:

data = {"images": [
    {
        "id": 1,
        "file_name": "Folder1/Folder2/Folder3/Folder4/1110.jpg",
        "height": 3024,
        "width": 4032
    },
    {
        "id": 2,
        "file_name": "Folder1/Folder2/Folder3/Folder4/1111.jpg",
        "height": 3024,
        "width": 4032
    },
    {
        "id": 3,
        "file_name": "Folder1/Folder2/Folder3/Folder4/1112.jpg",
        "height": 3024,
        "width": 4032
    }
]}

Here is my code which I tried

data = json.load(open(".\example.json"))

First I have check the full file_name with below code

for img in data['images']:
    print(img["file_name"])

Below is the Output for this cell

Folder1/Folder2/Folder3/Folder4/1110.jpg
Folder1/Folder2/Folder3/Folder4/1110.jpg
Folder1/Folder2/Folder3/Folder4/1110.jpg

Then I modified it to get the base path as below

for feature in data['images']:
    feature['file_name'] = os.path.basename(feature["file_name"])
    print(feature['file_name'])

This is the output:

1110.jpg
1111.jpg
1112.jpg

When I am trying to dump this into a JSON file but I am only getting one file_name.

data = {1110.jpg}

I would like to get the output as below. Please help me with your inputs

data = {"images": [
    {
        "id": 1,
        "file_name": "1110.jpg",
        "height": 3024,
        "width": 4032
    },
    {
        "id": 2,
        "file_name": "1111.jpg",
        "height": 3024,
        "width": 4032
    },
    {
        "id": 3,
        "file_name": "1112.jpg",
        "height": 3024,
        "width": 4032
    }
]}

create a list and append all of the outputs there and then iterate throught the list and add items from it to the json file or do it directly. also could You provide a bit more code on how You dump those json files etc — Matiiss
– Matiiss, Commented Mar 31, 2021 at 12:30
Thank you for the quick response @Matiiss, Yes I missed the dump JSON file. Anyways the below answer has solved my query. — yogi
– yogi, Commented Mar 31, 2021 at 12:46

Krishna Chaurasia · Accepted Answer · 2021-03-31 12:38:02Z

1

The code works as expected if you have resolved the variable name difference.

Further, I would also suggest to open the file using context manager with so that it gets closed automagically when the with block is exited.

import json, os
with open(".\example.json", 'r') as f:
    data = json.load(f)

for feature in data['images']:
    feature['file_name'] = os.path.basename(feature["file_name"])
    
print(data)

Output:

Data in json file:

{'images': [{'id': 1, 'file_name': 'Folder1/Folder2/Folder3/Folder4/1110.jpg', 'height': 3024, 'width': 4032}, {'id': 2, 'file_name': 'Folder1/Folder2/Folder3/Folder4/1111.jpg', 'height': 3024, 'width': 4032}, {'id': 3, 'file_name': 'Folder1/Folder2/Folder3/Folder4/1112.jpg', 'height': 3024, 'width': 4032}]}

Formatted data:

{'images': [{'id': 1, 'file_name': '1110.jpg', 'height': 3024, 'width': 4032}, {'id': 2, 'file_name': '1111.jpg', 'height': 3024, 'width': 4032}, {'id': 3, 'file_name': '1112.jpg', 'height': 3024, 'width': 4032}]}

answered Mar 31, 2021 at 12:38

Krishna Chaurasia

9,6546 gold badges27 silver badges44 bronze badges

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

2 Comments

yogi Over a year ago

Thank You @Krishna, it worked exactly as per my expectations. As you mentioned this was the variable name difference issue. I corrected it.

Krishna Chaurasia Over a year ago

Glad that the problem was resolved quickly!

Sanchit.Jain · Accepted Answer · 2021-03-31 12:36:32Z

1

Issue is in this line for feature in temp['images']:, please change it to for feature in data['images']

for feature in data['images']:
    feature['file_name'] = os.path.basename(feature["file_name"])
print(data)

[{'file_name': '1110.jpg', 'height': 3024, 'id': 1, 'width': 4032},
 {'file_name': '1111.jpg', 'height': 3024, 'id': 2, 'width': 4032},
 {'file_name': '1112.jpg', 'height': 3024, 'id': 3, 'width': 4032}]

answered Mar 31, 2021 at 12:36

Sanchit.Jain

6083 silver badges7 bronze badges

1 Comment

yogi Over a year ago

Thank You @Sancith Jain.

Collectives™ on Stack Overflow

How to modify the multiple values in the JSON file using python

2 Answers 2

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related