Pandas Tutorial · Pandas Tutorial

Pandas Read JSON

Learn all about Pandas Read JSON in this comprehensive tutorial.

5 min read intermediate

Pandas Read CSV

Pandas Analyzing Data

•Big data sets are often stored, or extracted as JSON.
•If your JSON code is not in a file, but in a Python Dictionary, you can load it into a DataFrame directly:

Read JSON

Big data sets are often stored, or extracted as JSON.

JSON is plain text, but has the format of an object, and is well known in the world of programming, including Pandas.

In our examples we will be using a JSON file called 'data.json'.

Open data.json.

python

import pandas as pddf = pd.read_json('data.json')print(df.to_string())

Note: Tip: use to_string() to print the entire DataFrame.

Dictionary as JSON

Note: JSON = Python Dictionary JSON objects have the same format as Python dictionaries.

If your JSON code is not in a file, but in a Python Dictionary, you can load it into a DataFrame directly:

python

import pandas as pddata = {  "Duration":{    
  "0":60,    "1":60,    "2":60,    
  "3":45,    "4":45,    "5":60  
  },  "Pulse":{    "0":110,    
  "1":117,    "2":103,    "3":109,    
  "4":117,    "5":102  },  "Maxpulse":{    
  "0":130,    "1":145,    "2":135,    
  "3":175,    "4":148,    "5":127  
  },  "Calories":{    "0":409,    
  "1":479,    "2":340,    "3":282,    
  "4":406,    "5":300  }}
  df = pd.DataFrame(data)print(df)

Module quiz

2 questions

Which of the following is true about Pandas Read JSON?

It is strictly typedIt is evaluated at runtimeIt requires explicit memory managementIt is deprecated

What is the most common pitfall when working with Pandas Read JSON?

SyntaxErrorIndentationErrorNameErrorTypeError

Answer all questions to submit.