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 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 Series, the keys are ordered in alphabetical order:

Series
area_code...