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

Converting json value from integer to string format: Python

I have a JSON file That provides the values as integers, so I need to change them to strings to continue with my project.

Here’s the JSON (there’s more pairs but this is for examples sake):

{
  "cotdata": [
    {
      "AUDLONGDEALERINTERMEDIARY": 22990,
      "GBPLONGASSETMANAGERS": 39765
    }
  ]
}

My code attempts to convert the values from integers to strings:

import json

with open("myjson.json", "r") as f:
    data = json.load(f)

df = data['cotdata']

for key in df:
    for value in key:
        key[value] = str(key[value])

Although the error I get is: TypeError: string indices must be integers

Is there a way for me to correct this code? Or should I try a different logic

Tags:

2

Answers


  1. 0

    I think this is what you’re intending to do:

    for key in df.keys():
    df[key] = str(df[key])

    Keep in mind this is assigning to df and not data.

    I think casting the int to a string wherever it is being used would be much more efficient than this, but it’s hard to say since I don’t know your use-case

    Login or Signup to reply.
  2. 0

    You need to loop over the keys of each dict in the list separately.

    df = data['cotdata']

for o in df:
    for k, v in o.items():
        o[k] = str(v)
    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search