Converting json value from integer to string format: Python

Question

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

Got no error on pandas 1.3.5.

RomanPerekhrest
– RomanPerekhrest

2022-12-21 20:09:42 +00:00
Commented Dec 21, 2022 at 20:09 — RomanPerekhrest
– RomanPerekhrest, Commented Dec 21, 2022 at 20:09

Libra · Accepted Answer · 2022-12-21 20:05:11Z

1

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

edited Dec 21, 2022 at 20:05

answered Dec 21, 2022 at 19:59

Libra

2,5951 gold badge10 silver badges29 bronze badges

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

Comments

Unmitigated · Accepted Answer · 2022-12-21 20:04:10Z

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)

answered Dec 21, 2022 at 20:04

Unmitigated

91.4k12 gold badges102 silver badges109 bronze badges

Collectives™ on Stack Overflow

Converting json value from integer to string format: Python

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related