Reading and writing JSON with pandas
We can easily create a pandas Series
from the JSON string in the previous example. The pandas read_json()
function can create a pandas Series
or pandas DataFrame
.
The following example code can be found in pd_json.py
of this book's code bundle:
import pandas as pd json_str = '{"country":"Netherlands","dma_code":"0","timezone":"Europe\/Amsterdam","area_code":"0","ip":"46.19.37.108","asn":"AS196752","continent_code":"EU","isp":"Tilaa V.O.F.","longitude":5.75,"latitude":52.5,"country_code":"NL","country_code3":"NLD"}' data = pd.read_json(json_str, typ='series') print "Series\n", data data["country"] = "Brazil" print "New Series\n", data.to_json()
We can either specify a JSON string or the path of a JSON file. Call ...
Get Python Data Analysis now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.