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:

Create PySpark dataframe from dictionary

gottumukkala_sivanagulu

Improve

Article Tags :

Practice Tags :

python

Create Pandas Dataframe from Dictionary of Dictionaries

Method 1: Using DataFrame()

Python3

Python3

Method 2: Using from_dict()

Python3

Similar Reads

Thank You!

What kind of Experience do you want to share?