Related Articles

Related Articles

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:

filter_none

edit
close

play_arrow

link
brightness_4
code

# 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 )

chevron_right


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:

filter_none

edit
close

play_arrow

link
brightness_4
code

# 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())

chevron_right


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

filter_none

edit
close

play_arrow

link
brightness_4
code

# 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)

chevron_right


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.




My Personal Notes arrow_drop_up
Recommended Articles
Page :