Skip to content
Related Articles

Related Articles

Improve Article
Python | Creating DataFrame from dict of narray/lists
  • Last Updated : 02 Apr, 2019

As we know Pandas is all-time great tools for data analysis. One of the most important data type is dataframe. It is a 2-dimensional labeled data structure with columns of potentially different types. It is generally the most commonly used pandas object.
Pandas DataFrame can be created in multiple ways. Let’s discuss how to create Pandas dataframe using dictionary of ndarray (or lists).

Let’s try to understand it better with few examples.

Code #1:




# Python code demonstrate creating 
# DataFrame from dict narray / lists 
# By default addresses. 
  
import pandas as pd 
  
# intialise data of lists. 
data = {'Category':['Array', 'Stack', 'Queue'],
        'Marks':[20, 21, 19]} 
  
# Create DataFrame 
df = pd.DataFrame(data) 
  
# Print the output. 
print(df )
Output:
Category  Marks
0    Array     20
1    Stack     21
2    Queue     19

Note: To create DataFrame from dict of narray/list, all the narray must be of same length. If index is passed then the length index should be equal to the length of arrays. If no index is passed, then by default, index will be range(n) where n is the array length.



 
Code #2:




# Python code demonstrate creating 
# DataFrame from dict narray / lists 
# By default addresses. 
  
import pandas as pd 
  
# intialise data of lists. 
data = {'Category':['Array', 'Stack', 'Queue'],
        'Student_1':[20, 21, 19], 'Student_2':[15, 20, 14]} 
  
# Create DataFrame 
df = pd.DataFrame(data) 
  
# Print the output. 
print(df.transpose())
Output:
              0      1      2
Category   Array  Stack  Queue
Student_1     20     21     19
Student_2     15     20     14

 
Code #3: Providing index list to dataframe




# Python code demonstrate creating 
# DataFrame from dict narray / lists 
# By default addresses. 
  
import pandas as pd 
  
# intialise data of lists. 
data = {'Area':['Array', 'Stack', 'Queue'],
        'Student_1':[20, 21, 19], 'Student_2':[15, 20, 14]} 
  
# Create DataFrame 
df = pd.DataFrame(data, index =['Cat_1', 'Cat_2', 'Cat_3']) 
  
# Print the output. 
print(df)
Output:
        Area  Student_1  Student_2
Cat_1  Array         20         15
Cat_2  Stack         21         20
Cat_3  Queue         19         14

 Attention geek! Strengthen your foundations with the Python Programming Foundation Course and learn the basics.  

To begin with, your interview preparations Enhance your Data Structures concepts with the Python DS Course. And to begin with your Machine Learning Journey, join the Machine Learning – Basic Level Course




My Personal Notes arrow_drop_up
Recommended Articles
Page :