Create Pandas Dataframe from Dictionary of Dictionaries - Coding

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:

Reffered: https://www.geeksforgeeks.org

Python

Related
Python Data Structures
Python - TSV conversion to JSON
Convert a TSV file to Excel using Python
How to use while True in Python
PyGame Tutorial

Type:	Geek
Category:	Coding
Sub Category:	Tutorial
Uploaded by:	Admin
Views:	9