How to read a json file directly into a Pandas DataFrame in Python

December 2, 20211 min readJson Pandas DataFrame Data Manipulation

7-Day Challenge

Land Your First Data Science Job

A proven roadmap to prepare for $75K+ entry-level data roles. Perfect for Data Scientist ready to level up their career.

Build portfolios that hiring managers love

Master the Python and SQL essentials to be industry-ready

Practice with real interview questions from tech companies

Access to the $100k/y Data Scientist Cheatsheet

You might came up needing to read a JSON file and get it in a DataFrame format.

This for various reasons, but most obviously the ease of manipulation.

To do so, you will need a JSON with records in it.

Here is an example

[
    {"firstname" : "Jason",
     "lastname" : "Smith",
     "age" : 28,
     "city" : "Melbourne",
     "studies" : "Psychology"
    },
    {"firstname" : "Sofia",
     "lastname" : "Johnson",
     "age" : 24,
     "city" : "Sydney",
     "studies" : "Law"
    },
    {"firstname" : "John",
     "lastname" : "Bly",
     "age" : 31,
     "city" : "New York",
     "studies" : "Marketing"
    }
]

Here is our my_json_file.json

Here is the code

import pandas as pd

# we read our json file
df = pd.read_json("my_json_file.json")

Here you are! You now know how to read a json directly into a pandas DataFrame!

7-Day Challenge

Land Your First Data Science Job

A proven roadmap to prepare for $75K+ entry-level data roles. Perfect for Data Scientist ready to level up their career.

Build portfolios that hiring managers love

Master the Python and SQL essentials to be industry-ready

Practice with real interview questions from tech companies

Access to the $100k/y Data Scientist Cheatsheet

Continue your learning journey with these related topics

Fundamentals

1 min read

6 ways to efficiently store data in Python

Learn various ways to store data efficiently in Python, including relational databases, NoSQL databases, data serialization, data compression, and data containers like NumPy array and Pandas DataFrame.

2/13/2023Read More

Fundamentals

2 min read

How to read an excel, csv, json file in Python

Learn how to easily read and manipulate data from excel, csv and json formats in Python using popular libraries such as pandas, openpyxl, and json

2/12/2023Read More

Free Newsletter

Master Data Science in Days, Not Months 🚀

Skip the theoretical rabbit holes. Get practical data science skills delivered in bite-sized lessons – Approach used by real data scientist. Not bookworms. 📚

Weekly simple and practical lessons

Access to ready to use code examples

Skip the math, focus on results

Learn while drinking your coffee

Land Your First Data Science Job

Here is an example

Here is the code

Land Your First Data Science Job

Related Articles

Master Data Science in Days, Not Months 🚀