Python Pandas : How to Create DataFrame from dictionary ?

How to create DataFrame from dictionary in Python ?

In this article we will discuss about various ways of creating DataFrame object from dictionaries.

So, let's start exploring different approaches to achieve this result.

Create DataFrame from Dictionary using default Constructor

Create DataFrame from Dictionary with custom indexes

Create DataFrame from Dictionary and skip data

Create DataFrame from Dictionary with different Orientation

Create DataFrame from nested Dictionary

Want to expert in the python programming language? Exploring Python Data Analysis using Pandas tutorial changes your knowledge from basic to advance level in python concepts.

Method-1 : Create DataFrame from Dictionary using default Constructor :

In python DataFrame constructor accepts n-D array, dictionaries etc.

#program : # import pandas library import pandas as pd # dictionary with list object in values data = { 'Name' : ['Satya', 'Omm', 'Rakesh'], 'Age' : [21, 21, 23], 'From' : ['BBSR', 'RKL', 'KDP'] } # creating a Dataframe object df_obj = pd.DataFrame(data) df_obj

Output :        Name    Age   From 0      Satya      21      BBSR 1 Omm 21 RKL 2 Rakesh 23 KDP

Method-2 : Create DataFrame from Dictionary with custom indexes :

#program : # import pandas library import pandas as pd # dictionary with list object in values data = { 'Name' : ['Satya', 'Omm', 'Rakesh'], 'Age' : [21, 21, 23], 'From' : ['BBSR', 'RKL', 'KDP'] } # creating a Dataframe object df_obj = pd.DataFrame(data, index = ['a','b','c']) df_obj

Output :         Name    Age     From a      Satya      21      BBSR b     Omm       21     RKL c     Rakesh     23     KDP

Method-3 : Create DataFrame from Dictionary and skip data

#program : # import pandas library import pandas as pd # dictionary with list object in values data = { 'Name' : ['Satya', 'Omm', 'Rakesh'], 'Age' : [21, 21, 23], 'From' : ['BBSR', 'RKL', 'KDP'] } # creating a Dataframe object #items skipped with key 'Age' df_obj = pd.DataFrame(data, columns=['name', 'From']) df_obj

Output :        Name        From 0      Satya        BBSR 1     Omm          RKL 2     Rakesh       KDP

Method-4 : Create DataFrame from Dictionary with different Orientation

#program : # import pandas library import pandas as pd # dictionary with list object in values data = { 'Name' : ['Satya', 'Omm', 'Rakesh'], 'Age' : [21, 21, 23], 'From' : ['BBSR', 'RKL', 'KDP'] } # creating a Dataframe object #items skipped with key 'Age' df_obj = pd.DataFrame(data,orient='index') df_obj

Output :             0           1            2 Aame   Satya   Omm     Rakesh From     BBSR    RKL       KDP Age       21         21         23

Method-5 : Create DataFrame from nested Dictionary :

#program : # import pandas library import pandas as pd # dictionary with list object in values # Nested Dictionary data = { 0 : { 'Name' : 'Satya', 'Age' : 21, 'From' : 'BBSR' }, 1 : { 'Name' : 'Omm', 'Age' : 21, 'From' : 'RKL' }, 2 : { 'Name' : 'Rakesh', 'Age' : 23, 'From' : 'KDP' } } # creating a Dataframe object #items skipped with key 'Age' df_obj = pd.DataFrame(data) df_obj

Output :             0           1            2 Aame   Satya   Omm     Rakesh From     BBSR    RKL       KDP Age       21         21         23

Read more Articles on Python Data Analysis Using Padas - Creating Dataframe Objects:

How to create an empty DataFrame and add data to it later?

How to convert lists to a dataframe?

How to read a csv file to Dataframe with custom delimiter?

How to skip rows while reading csv file to a Dataframe using read_csv()?