Question 180017 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

How can I use Python to increment 'tokenId' values in a .json file?

I have a .json file but I got the tokenId numbering wrong. I need to increase all values of "tokenId" by 1 number

[
    {
        "Background": "Red",
        "Body": "Tunn",
        "Hat": "Bambu",
        "Outfit": "Pirate",
        "Expression": "Sad",
        "Accessory": "Rifle",
        "tokenId": 0
    },
    {
        "Background": "Lilac",
        "Body": "Tunn",
        "Hat": "Bicorn",
        "Outfit": "Pirate",
        "Expression": "Angry",
        "Accessory": "Balloons",
        "tokenId": 1
    },

          ...
    
    {
        "Background": "Green",
        "Body": "Tunn",
        "Hat": "Bicorn",
        "Outfit": "Pirate",
        "Expression": "Sad",
        "Accessory": "Balloons",
        "tokenId": 3000
    },

is it possible to do this with python? i created this .json file with python.

I tried this code, but I get an error

import json

with open('traits.json') as f:
    data = json.load(f)

for item in data['tokenId']:
    item['tokenId'] = item['tokenId'].replace([int('+1')])

with open('new_data.json', 'w') as f:
    json.dump(data, f)

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

Thank you!

Tags:

2

Answers


  1. 0

    The below seems to work

    data = [
    {
        "Background": "Red",
        "Body": "Tunn",
        "Hat": "Bambu",
        "Outfit": "Pirate",
        "Expression": "Sad",
        "Accessory": "Rifle",
        "tokenId": 0
    },
    {
        "Background": "Lilac",
        "Body": "Tunn",
        "Hat": "Bicorn",
        "Outfit": "Pirate",
        "Expression": "Angry",
        "Accessory": "Balloons",
        "tokenId": 1
    },

    {
        "Background": "Green",
        "Body": "Tunn",
        "Hat": "Bicorn",
        "Outfit": "Pirate",
        "Expression": "Sad",
        "Accessory": "Balloons",
        "tokenId": 3000
    }
]

for entry in data:
    entry['tokenId'] = entry['tokenId'] + 1
    print(entry)

    output

    {'Background': 'Red', 'Body': 'Tunn', 'Hat': 'Bambu', 'Outfit': 'Pirate', 'Expression': 'Sad', 'Accessory': 'Rifle', 'tokenId': 1}
{'Background': 'Lilac', 'Body': 'Tunn', 'Hat': 'Bicorn', 'Outfit': 'Pirate', 'Expression': 'Angry', 'Accessory': 'Balloons', 'tokenId': 2}
{'Background': 'Green', 'Body': 'Tunn', 'Hat': 'Bicorn', 'Outfit': 'Pirate', 'Expression': 'Sad', 'Accessory': 'Balloons', 'tokenId': 3001}
    Login or Signup to reply.
  2. 0

    To increase the values of the "tokenId" field in your JSON file by 1, you can modify your code as follows:

    import json

with open('traits.json') as f:
    data = json.load(f)

for item in data:
    item['tokenId'] += 1

with open('new_data.json', 'w') as f:
    json.dump(data, f)

    In your original code, you were trying to access data[‘tokenId’] as if it was a list, but it is actually a dictionary. Instead, you need to iterate over the list data and update the "tokenId" field of each item. By using item[‘tokenId’] += 1, you increment the value of "tokenId" by 1.

    Finally, the modified data is saved to a new JSON file named "new_data.json" using json.dump(data, f).

    After running this code, the "new_data.json" file will contain the updated "tokenId" values with an increment of 1.

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search