How to save JSON key data to Python Variables

Question

is there a way to store my JSON key data(id,name,price...) on each of my variable(id1-id3, id1-id3, price1-price3...)

here is my sample code

import json

from kivy.properties import StringProperty

f = open('sample.json')
data = json.load(f)

id1 = StringProperty(None)
id2 = StringProperty(None)
id3 = StringProperty(None)

name1 = StringProperty(None)
name2 = StringProperty(None)
name3 = StringProperty(None)

price1 = StringProperty(None)
price2 = StringProperty(None)
price3 = StringProperty(None)

quantity1  = StringProperty(None)
quantity2  = StringProperty(None)
quantity3  = StringProperty(None)

for i in data:
    print(i)

and here is the JSON file

[
  {
    "id": "p01",
    "name": "Name 1",
    "price": 1,
    "quantity": 1
  },
  {
    "id": "p02",
    "name": "Name 2",
    "price": 2,
    "quantity": 2
  },
  {
    "id": "p03",
    "name": "Name 3",
    "price": 3,
    "quantity": 3
  }
]

i'm planning to use bigger data. but for simplicity's sake, i just use 3 items as an example

Why do you want to use variables? You can simply convert JSON to Python dictionary with json.loads(). — Muhammad Yousuf Noor
– Muhammad Yousuf Noor, Commented Feb 3, 2021 at 4:24
@MuhammadYousufNoor, I will be using this variables in the future, so i need to extract the individual data like name, price, and quantity from the JSON file. I'm relatively new to JSON module so please bare with me. — Jonathan Dacian
– Jonathan Dacian, Commented Feb 3, 2021 at 4:33

Muhammad Yousuf Noor · Accepted Answer · 2021-02-03 04:52:35Z

1

You don't need to store each value of JSON in a new variable, you can use a python dictionary.

See JSON and Python Dictionary

import json

#opening json file
with open("data.json") as f:
    #converting json to python dict and stroing it in data variable
    data = json.loads(f.read())

#iterating dict items and printing values
for items in data:
    print(items['id'],items['name'],items['price'])

#you can also access dict values like this
#0 is the index number.
print(data[0]['id'])
print(data[0]['name'])
print(data[0]['price'])

#similarly
print(data[1]['id'])
print(data[2]['id'])

answered Feb 3, 2021 at 4:52

Muhammad Yousuf Noor

2072 silver badges7 bronze badges

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

1 Comment

Jonathan Dacian Over a year ago

Thank You This Works, Just a follow up question. What if I have another table, how should I access the dict values for table 2? I'll attach the modified JSON code

Rani Rajput · Accepted Answer · 2021-02-03 05:06:52Z

0

You can simply use json module with python dictionary as follow:

# Import the module
import json

# String with JSON format
data_JSON =  """
[
  {
    "id": "p01",
    "name": "Name 1",
    "price": 1,
    "quantity": 1
  },
  {
    "id": "p02",
    "name": "Name 2",
    "price": 2,
    "quantity": 2
  },
  {
    "id": "p03",
    "name": "Name 3",
    "price": 3,
    "quantity": 3
  }
]
"""

# Convert JSON string to dictionary
data_dict = json.loads(data_JSON)
print(data_dict)

answered Feb 3, 2021 at 5:06

Rani Rajput

411 silver badge6 bronze badges

Collectives™ on Stack Overflow

How to save JSON key data to Python Variables

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related