import json

#string containing json data
people_string = '''
{
"people":[
    {
    "name":"kushagra gupta",
    "phone":"9876543210",
    "emails":["kushagra224@gmail.com","kushagra225@gmail.com"],
    "has_license":false
    },
    {
    "name":"Jane Doe",
    "phone":"1234567890",
    "emails":null,
    "has_license":true
    }
  ]
}
'''

#loading json into python
data =json.loads(people_string)
#printing json data
print(data)
#it looks like python dictionary, let's check it's type

{'people': [{'name': 'kushagra gupta', 'phone': '9876543210', 'emails': ['kushagra224@gmail.com', 'kushagra225@gmail.com'], 'has_license': False}, {'name': 'Jane Doe', 'phone': '1234567890', 'emails': None, 'has_license': True}]}

print(type(data))

<class 'dict'>

#that's bcz python converts the follow
#json          python
#object        dict
#array         list
#string        str
#number(int)   int
#number(real)  float
#true          True
#false         False
#null          None


#you can check the conversion in the above output statement.

print(type(data['people']))

<class 'list'>

for person in data['people']:
    print(person)

{'name': 'kushagra gupta', 'phone': '9876543210', 'emails': ['kushagra224@gmail.com', 'kushagra225@gmail.com'], 'has_license': False}
{'name': 'Jane Doe', 'phone': '1234567890', 'emails': None, 'has_license': True}

for person in data['people']:
    print(person['name'])

kushagra gupta
Jane Doe

#Loading python data in json
#first deleting phone numbers from our data
for person in data['people']:
    del person['phone']

#now dumping python data in json
new_string = json.dumps(data, indent=2, sort_keys=True)  #indent is to indent the data and sort_keys is to sort the data

#new json string without phone
print(new_string)

{
  "people": [
    {
      "emails": [
        "kushagra224@gmail.com",
        "kushagra225@gmail.com"
      ],
      "has_license": false,
      "name": "kushagra gupta"
    },
    {
      "emails": null,
      "has_license": true,
      "name": "Jane Doe"
    }
  ]
}

#Loading Json file from system
with open('sample_states.json') as f:
    data = json.load(f)
for state in data['states']:
    print(state)
    print(state['name'],state['abbreviation'])

{'name': 'Alabama', 'abbreviation': 'AL'}
Alabama AL
{'name': 'Arizona', 'abbreviation': 'AZ'}
Arizona AZ
{'name': 'California', 'abbreviation': 'CA'}
California CA
{'name': 'Hawaii', 'abbreviation': 'HI'}
Hawaii HI
{'name': 'Indiana', 'abbreviation': 'IN'}
Indiana IN
{'name': 'Michigan', 'abbreviation': 'MI'}
Michigan MI
{'name': 'Minnesota', 'abbreviation': 'MN'}
Minnesota MN
{'name': 'Missouri', 'abbreviation': 'MO'}
Missouri MO
{'name': 'Montana', 'abbreviation': 'MT'}
Montana MT
{'name': 'Nebraska', 'abbreviation': 'NE'}
Nebraska NE
{'name': 'New Hampshire', 'abbreviation': 'NH'}
New Hampshire NH
{'name': 'New Jersey', 'abbreviation': 'NJ'}
New Jersey NJ
{'name': 'New Mexico', 'abbreviation': 'NM'}
New Mexico NM
{'name': 'New York', 'abbreviation': 'NY'}
New York NY
{'name': 'North Dakota', 'abbreviation': 'ND'}
North Dakota ND
{'name': 'Ohio', 'abbreviation': 'OH'}
Ohio OH
{'name': 'Oklahoma', 'abbreviation': 'OK'}
Oklahoma OK
{'name': 'Rhode Island', 'abbreviation': 'RI'}
Rhode Island RI
{'name': 'South Carolina', 'abbreviation': 'SC'}
South Carolina SC
{'name': 'South Dakota', 'abbreviation': 'SD'}
South Dakota SD
{'name': 'Utah', 'abbreviation': 'UT'}
Utah UT
{'name': 'Vermont', 'abbreviation': 'VT'}
Vermont VT
{'name': 'Washington', 'abbreviation': 'WA'}
Washington WA
{'name': 'Wisconsin', 'abbreviation': 'WI'}
Wisconsin WI

#removing abbrevation from json data
for state in data['states']:
    del state['abbreviation']

#saving new json object in file
with open('new_states.json','w') as f:
    json.dump(data, f,indent=2)
    
# If you want to dump the JSON into a file/socket or whatever, then you should go for dump(). If you only need it as a string (for printing, parsing or whatever) then use dumps() (dump string)

#working with real json data
import json
from urllib.request import urlopen

#API to get finance data from yahoo
with urlopen("https://finance.yahoo.com/webservice/v1/symbols/allcurrencies/quote?format=json") as response:
    source = response.read()

#print the data we get
#print(source)
 
data = json.loads(source)
usd_rates=dict()

for item in data['list']['resoureces']:
    name = item['resource']['fields']['name']
    price = item['resource']['fields']['price']
    usd_rates[name]=price
print(usd_rates['USR/EUR'])