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 ch-05.ipynb 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 the read_json() function to create a pandas Series from the JSON string in the previous example:

data = pd.read_json(json_str, typ='series') 
print("Series\n", data) 

In the resulting...