I want to convert a string value into int from a json.
Json
[
{
"date": "23.07. 16:59",
"odd": "3.50",
"change": "+0.05"
},
{
"date": "23.07. 16:07",
"odd": "3.45",
"change": "-0.15"
}
]
I tried to convert in this way json["change"] = int(json["change"]) but got TypeError: string indices must be integers
You have to convert change to a float and not int. Iterate over the contents of JSON list and do the conversion.
Here I have converted change to float.
import json
s = '''[
{
"date": "23.07. 16:59",
"odd": "3.50",
"change": "+0.05"
},
{
"date": "23.07. 16:07",
"odd": "3.45",
"change": "-0.15"
}
]'''
d = json.loads(s)
for i in d:
i['change'] = float(i['change'])
[{'date': '23.07. 16:59', 'odd': '3.50', 'change': 0.05}, {'date': '23.07. 16:07', 'odd': '3.45', 'change': -0.15}]
You have to do something like this:
Json=[
{
"date": "23.07. 16:59",
"odd": "3.50",
"change": "+0.05"
},
{
"date": "23.07. 16:07",
"odd": "3.45",
"change": "-0.15"
}
]
for i in range(len(Json)):
Json[i]["change"]=int(float(Json[i]["change"]))
I guess you want to convert it to float because it will return 0 if you convert to int so you can simply try:
for i in range(len(Json)):
Json[i]["change"]=int(float(Json[i]["change"]))
