Skip to content
Related Articles

Related Articles

Improve Article
Save Article
Like Article

Create Pandas Dataframe from Dictionary of Dictionaries

  • Last Updated : 24 Oct, 2021

In this article, we will discuss how to create a pandas dataframe from the dictionary of dictionaries in Python.

Method 1: Using DataFrame()

We can create a dataframe using Pandas.DataFrame() method.

Syntax:

pandas.DataFrame(dictionary)

where

  • pandas are the module that supports DataFrame data structure
  • DataFrame is the datastructure that converts dictionary into dataframe
  • dictionary is the input dictionary

Example: Create pandas Dataframe from the dictionary of dictionaries.

Python3




# import pandas module
import pandas
  
# create student dictionary of dictionaries 
# with 3 students with Age and address
data = {'Ojaswi': {'Age': 15, 'Address': 'Hyderabad'},
        'Rohith':  {'Age': 9, 'Address': 'Hyderabad'},
        'Gnanesh':  {'Age': 15, 'Address': 'Guntur'}}
  
# create pandas dataframe from dictionary of 
# dictionaries
data = pandas.DataFrame(data)
  
# display
print(data)

Output:

Example 2: Example: Create pandas Dataframe from the dictionary of dictionaries.

Python3




# import pandas module
import pandas
  
# create student dictionary of dictionaries with
# 5 students with Age ,subject and  address
data = {'Ojaswi': {'Age': 15, 'subject': 'java', 'Address': 'Hyderabad'},
        'Rohith':  {'Age': 9, 'subject': 'python', 'Address': 'Hyderabad'},
        'Gnanesh':  {'Age': 15, 'subject': 'c/c++', 'Address': 'Guntur'},
        'divya':  {'Age': 21, 'subject': 'html', 'Address': 'ponnur'},
        'ramya':  {'Age': 15, 'subject': 'c/c++', 'Address': 'delhi'}}
  
# create pandas dataframe from dictionary of
# dictionaries
data = pandas.DataFrame(data)
  
# display
data

Output:

Method 2: Using from_dict()

from_dict() is used to convert the dataframe from the dictionary 

Syntax:

pandas.DataFrame.from_dict(dictionary)

Where, dictionary is the input dictionary of dictionaries

Example: Create pandas Dataframe from dictionary of dictionaries.

Python3




# import pandas module
import pandas
  
# create student dictionary of dictionaries with 3 
# students with Age and address
data = {'Ojaswi': {'Age': 15, 'Address': 'Hyderabad'},
        'Rohith':  {'Age': 9, 'Address': 'Hyderabad'},
        'Gnanesh':  {'Age': 15, 'Address': 'Guntur'}}
  
# create pandas dataframe from dictionary of dictionaries 
# using from_dict() method
data = pandas.DataFrame.from_dict(data)
  
# display
data

Output:


My Personal Notes arrow_drop_up
Recommended Articles
Page :

Start Your Coding Journey Now!