accessing a string in a nested dictionary
I have a nested json file, i am trying to access the latitude , i tried the code below latitude = data["props"]["pageProps"]["property"]["address"]["latitude"] but i got an error. I also tried loading it in a data_loaded = json.loads(data) but got the error in the picture attached below "Expecting ',' delimiter: line 1 column 53 (char 52)"
data = '{
"props": {
"pageProps": {
"property": {
"uprn": "61019296",
"address": {
"uprn": "61019296",
"fullAddress": "8 Arthur Street Barnoldswick BB18 5JZ",
"postcode": "BB18 5JZ",
"country": "England",
"outcode": "BB18",
"latitude": 53.9229587,
"longitude": -2.1940256
},
"attributes": {
"bathrooms": null,
"bedrooms": 3,
"floorAreaSqM": 109,
"livingRooms": null,
"tenure": "Freehold",
"propertyType": "Mid Terrace House",
"userSubmitted": null
},
"energy": {
"currentEnergyRating": "C"
},
"rentEstimate": {
"lowerPrice": 700,
"currentPrice": 750,
"upperPrice": 800
},
"saleEstimate": {
"lowerPrice": 128000,
"currentPrice": 135000,
"upperPrice": 141000,
"confidenceLevel": "HIGH",
"valueChange": {
"numericChange": -16000,
"percentageChange": -10.596026490066226,
"saleDate": "2024-12-20"
},
"ingestedAt": "2025-02-06T14:05:28.374Z"
},
"history": {
"historicListings": [],
"historicSales": [
{
"date": "2024-12-20",
"price": 151000,
"percentageChange": 41.1214953271028,
"numericChange": 44000
},
{
"date": "2024-01-10",
"price": 107000,
"percentageChange": 3.3816425120772946,
"numericChange": 3500
},
{
"date": "2007-01-19",
"price": 103500,
"percentageChange": 168.8311688311688,
"numericChange": 65000
},
{
"date": "2001-05-25",
"price": 38500,
"percentageChange": null,
"numericChange": null
}
],
"soldPricesDataSource": "landRegistry"
},
"staticMapImage": {
"devices": {
"mobile": 0,
"mobile2x": 1,
"medium": 2,
"large": 3
},
"urls": [
{
"height": 200,
"width": 400,
"src": "https://maps.zoopla.co.uk/styles/portal/static/-2.194025653.922958716/400x200.webp?marker=-2.1940256%2C53.9229587%7Chome-property-pin%402x.png%7Cscale%3A0.5"
},
{
"height": 200,
"width": 400,
"src": "https://maps.zoopla.co.uk/styles/portal/static/-2.194025653.922958716/400x200@2x.webp?marker=-2.1940256%2C53.9229587%7Chome-property-pin%402x.png%7Cscale%3A0.5"
},
{
"height": 170,
"width": 1024,
"src": "https://maps.zoopla.co.uk/styles/portal/static/-2.194025653.922958716/1024x170.webp?marker=-2.1940256%2C53.9229587%7Chome-property-pin%402x.png%7Cscale%3A0.5"
},
{
"height": 170,
"width": 1024,
"src": "https://maps.zoopla.co.uk/styles/portal/static/-2.194025653.922958716/1024x170@2x.webp?marker=-2.1940256%2C53.9229587%7Chome-property-pin%402x.png%7Cscale%3A0.5"
}
]
}
}
},
"__N_SSP": true,
"page": "/property/uprn/[uprn]",
"query": {
"uprn": "61019296"
},
"buildId": "qkeVHjsjKJkHtFt7X0D5w",
"assetPrefix": "https://cdn.prod.zoopla.co.uk",
"isFallback": false,
"dynamicIds": [
6573899826
],
"gssp": true,
"customServer": true,
"scriptLoader": []
}
}
'
Solution
Multiline text has to be in ''' or """ (3 quotes).
And next you have to use data = json.loads(text) to convert it to dictionary.
And later data["props"]["pageProps"]["property"]["address"]["latitude"] works.
Full working code:
text = '''{
"props": {
"pageProps": {
"property": {
"uprn": "61019296",
"address": {
"uprn": "61019296",
"fullAddress": "8 Arthur Street Barnoldswick BB18 5JZ",
"postcode": "BB18 5JZ",
"country": "England",
"outcode": "BB18",
"latitude": 53.9229587,
"longitude": -2.1940256
},
"attributes": {
"bathrooms": null,
"bedrooms": 3,
"floorAreaSqM": 109,
"livingRooms": null,
"tenure": "Freehold",
"propertyType": "Mid Terrace House",
"userSubmitted": null
},
"energy": {
"currentEnergyRating": "C"
},
"rentEstimate": {
"lowerPrice": 700,
"currentPrice": 750,
"upperPrice": 800
},
"saleEstimate": {
"lowerPrice": 128000,
"currentPrice": 135000,
"upperPrice": 141000,
"confidenceLevel": "HIGH",
"valueChange": {
"numericChange": -16000,
"percentageChange": -10.596026490066226,
"saleDate": "2024-12-20"
},
"ingestedAt": "2025-02-06T14:05:28.374Z"
},
"history": {
"historicListings": [],
"historicSales": [
{
"date": "2024-12-20",
"price": 151000,
"percentageChange": 41.1214953271028,
"numericChange": 44000
},
{
"date": "2024-01-10",
"price": 107000,
"percentageChange": 3.3816425120772946,
"numericChange": 3500
},
{
"date": "2007-01-19",
"price": 103500,
"percentageChange": 168.8311688311688,
"numericChange": 65000
},
{
"date": "2001-05-25",
"price": 38500,
"percentageChange": null,
"numericChange": null
}
],
"soldPricesDataSource": "landRegistry"
},
"staticMapImage": {
"devices": {
"mobile": 0,
"mobile2x": 1,
"medium": 2,
"large": 3
},
"urls": [
{
"height": 200,
"width": 400,
"src": "https://maps.zoopla.co.uk/styles/portal/static/-2.194025653.922958716/400x200.webp?marker=-2.1940256%2C53.9229587%7Chome-property-pin%402x.png%7Cscale%3A0.5"
},
{
"height": 200,
"width": 400,
"src": "https://maps.zoopla.co.uk/styles/portal/static/-2.194025653.922958716/400x200@2x.webp?marker=-2.1940256%2C53.9229587%7Chome-property-pin%402x.png%7Cscale%3A0.5"
},
{
"height": 170,
"width": 1024,
"src": "https://maps.zoopla.co.uk/styles/portal/static/-2.194025653.922958716/1024x170.webp?marker=-2.1940256%2C53.9229587%7Chome-property-pin%402x.png%7Cscale%3A0.5"
},
{
"height": 170,
"width": 1024,
"src": "https://maps.zoopla.co.uk/styles/portal/static/-2.194025653.922958716/1024x170@2x.webp?marker=-2.1940256%2C53.9229587%7Chome-property-pin%402x.png%7Cscale%3A0.5"
}
]
}
}
},
"__N_SSP": true,
"page": "/property/uprn/[uprn]",
"query": {
"uprn": "61019296"
},
"buildId": "qkeVHjsjKJkHtFt7X0D5w",
"assetPrefix": "https://cdn.prod.zoopla.co.uk",
"isFallback": false,
"dynamicIds": [
6573899826
],
"gssp": true,
"customServer": true,
"scriptLoader": []
}
}
'''
import json
data = json.loads(text)
print('lat :', data["props"]["pageProps"]["property"]["address"]["latitude"])
print('long:', data["props"]["pageProps"]["property"]["address"]["longitude"])
Result:
lat : 53.9229587
long: -2.1940256
- Create a new column of dictionaries where keys are in another column of lists, and values are found by looking up the keys in another column
- When I create an array of Numpy floats, I get an array of Python floats
- Download an image from image url
- Regarding good coding practices, what is meant by "Useless return at end of function and method"?
- Can the * (unpacking) operator be typed in Python? Or any other variadic args function such that all variadic types are in the result type?
- Why does using the GPU cause a slowdown when performing svd on a double-precision array?
- Python convert mm/dd/yyyy to yyyymmdd using date_format
- Python Webscraping: grequests vs. mult-threaded requests?
- With python sh module, how to preserve combined stdout and stderr?
- How to suppress py.test internal deprecation warnings
- Python: check for data type in list
- Why does inspect identify decorated methods as functions instead of methods in Python?
- Pycharm stopped displaying import errors
- Strange session behaviour with a Flask app on Heroku
- NameError: name 'Frame' is not defined (Python)
- Is there difference between _function and function?
- Does Python have an ordered set?
- Create JSON from CSV and add some header lines with Pandas
- How can I get the date from weeknr and year using strptime
- Python error with request post : 'Connection aborted, timeout('The write operation timed out')
- Why is this monkeypatch in pytest not working?
- Find common characters between two strings
- SSL: CERTIFICATE_VERIFY_FAILED certificate verify failed: unable to get local issuer certificate (_ssl.c:1129)')))
- python equivalent to clojure's partition-all?
- python equivalent of java OutputStream?
- Python TimedRotatingFileHandler overwrites logs
- python 2.7 equivalent of built-in method int.from_bytes
- Getting all combinations of key/value pairs in a Python dict
- how to run a django python file from command line
- Why do I get this DBeaver error when importing data from a CSV file?