Load JSON String into Pandas DataFrame Last Updated : 18 Aug, 2020 Comments Improve Suggest changes 1 Likes Like Report Let us see how can we use a dataset in JSON format in our Pandas DataFrame. This can be done using the built-in read_json() function. It enables us to read the JSON in a Pandas DataFrame. Example : Consider the JSON file path_to_json.json : path_to_json.json Python3 # importing the module import pandas # reading the file data = df.read_json("path_to_json.json") # displaying the DataFrame print(data) Output : Now, the final data frame also depends on the type of the JSON file. So there are mainly 3 types of orientations in JSON : Index OrientedValue-Oriented Column Oriented 1. Index Oriented This is an example of an Index Oriented JSON file. Python3 # importing the module import pandas # reading the file data = df.read_json("sample.json") # displaying the DataFrame print(data) Output : 2. Value-Oriented This is an example of a Value-Oriented JSON file. Python3 # importing the module import pandas # reading the file data = df.read_json("sample.json") # displaying the DataFrame print(data) Output : 3. Column Oriented This is an example of a Column-oriented JSON file. Python3 # importing the module import pandas # reading the file data = df.read_json("sample.json") # displaying the DataFrame print(data) Output : Create Quiz Comment A ayushmankumar7 Follow 1 Improve A ayushmankumar7 Follow 1 Improve Article Tags : Python Python-pandas Python pandas-dataFrame Python Pandas-exercise Explore Python FundamentalsPython Introduction 2 min read Input and Output in Python 4 min read Python Variables 5 min read Python Operators 4 min read Python Keywords 2 min read Python Data Types 8 min read Conditional Statements in Python 3 min read Loops in Python - For, While and Nested Loops 5 min read Python Functions 5 min read Recursion in Python 4 min read Python Lambda Functions 5 min read Python Data StructuresPython String 5 min read Python Lists 4 min read Python Tuples 4 min read Python Dictionary 3 min read Python Sets 6 min read Python Arrays 7 min read List Comprehension in Python 4 min read Advanced PythonPython OOP Concepts 11 min read Python Exception Handling 5 min read File Handling in Python 4 min read Python Database Tutorial 4 min read Python MongoDB Tutorial 2 min read Python MySQL 9 min read Python Packages 10 min read Python Modules 7 min read Python DSA Libraries 15 min read List of Python GUI Library and Packages 3 min read Data Science with PythonNumPy Tutorial - Python Library 3 min read Pandas Tutorial 4 min read Matplotlib Tutorial 5 min read Python Seaborn Tutorial 15+ min read StatsModel Library - Tutorial 3 min read Learning Model Building in Scikit-learn 8 min read TensorFlow Tutorial 2 min read PyTorch Tutorial 6 min read Web Development with PythonFlask Tutorial 8 min read Django Tutorial | Learn Django Framework 7 min read Django ORM - Inserting, Updating & Deleting Data 4 min read Templating With Jinja2 in Flask 6 min read Django Templates 5 min read Python | Build a REST API using Flask 3 min read How to Create a basic API using Django Rest Framework ? 4 min read Python PracticePython Quiz 1 min read Python Coding Practice 1 min read Python Interview Questions and Answers 15+ min read Like