Creating Pandas dataframe using list of lists



Pandas DataFrame 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 list of lists.

Code #1:


# Import pandas library 
import pandas as pd 

# initialize list of lists 
data = [['Geeks', 10], ['for', 15], ['geeks', 20]] 

# Create the pandas DataFrame 
df = pd.DataFrame(data, columns = ['Name', 'Age']) 

# print dataframe. 
print(df )


Output:

Name  Age
0  Geeks   10
1    for   15
2  geeks   20

Code #2:

# Import pandas library 
import pandas as pd 

# initialize list of lists 
data = [['DS', 'Linked_list', 10], ['DS', 'Stack', 9], ['DS', 'Queue', 7],
        ['Algo', 'Greedy', 8], ['Algo', 'DP', 6], ['Algo', 'BackTrack', 5], ] 

# Create the pandas DataFrame 
df = pd.DataFrame(data, columns = ['Category', 'Name', 'Marks']) 

# print dataframe. 
print(df )


Output:

Category         Name  Marks
0       DS  Linked_list     10
1       DS        Stack      9
2       DS        Queue      7
3     Algo       Greedy      8
4     Algo           DP      6
5     Algo    BackTrack      5

Code #3: Doing some operation of dataframe.

# Import pandas library 
import pandas as pd 

# initialize list of lists 
data = [[1, 5, 10], [2, 6, 9], [3, 7, 8]] 

# Create the pandas DataFrame 
df = pd.DataFrame(data)

# specifying cloumn names
df.columns = ['Col_1', 'Col_2', 'Col_3']

# print dataframe. 
print(df, "\n")

# transpose of dataframe
df = df.transpose()
print("Transpose of above dataframe is-\n", df)

Output:

Col_1  Col_2  Col_3
0      1      5     10
1      2      6      9
2      3      7      8 

Transpose of above dataframe is-
         0  1  2
Col_1   1  2  3
Col_2   5  6  7
Col_3  10  9  8

Last Updated on May 3, 2021 by admin

Leave a Reply

Your email address will not be published. Required fields are marked *

Recommended Blogs