tolist() to get a list using the pandas dataframe

We can create one list from DataFrame

import pandas as pd 
my_dict={'NAME':['Ravi','Raju','Alex','Ron','King','Jack'],
         'ID':[1,2,3,4,5,6],
         'MATH':[80,40,70,70,60,30],
         'ENGLISH':[80,70,40,50,60,30]}
df = pd.DataFrame(data=my_dict) # dataframe 
my_list=df.values.tolist() # creates a list 
print(type(my_list)) # <class 'list'>

This will hold all our dataframe data ( but without column names )

print(my_list)

Output

[['Ravi', 1, 80, 80], ['Raju', 2, 40, 70], 
['Alex', 3, 70, 40], ['Ron', 4, 70, 50], 
['King', 5, 60, 60], ['Jack', 6, 30, 30]]

Adding column names to the list.

We used list insert method to add the column names.

import pandas as pd 
my_dict={'NAME':['Ravi','Raju','Alex','Ron','King','Jack'],
         'ID':[1,2,3,4,5,6],
         'MATH':[80,40,70,70,60,30],
         'ENGLISH':[80,70,40,50,60,30]}
df = pd.DataFrame(data=my_dict) # dataframe 
my_list=df.values.tolist() # creates a list 
my_list.insert(0,df.columns) # adding column names to list
print(my_list)

Output

[Index(['NAME', 'ID', 'MATH', 'ENGLISH'], dtype='object'), 
['Ravi', 1, 80, 80], ['Raju', 2, 40, 70], 
['Alex', 3, 70, 40], ['Ron', 4, 70, 50], 
['King', 5, 60, 60], ['Jack', 6, 30, 30]]

Using DataFrame column to create a list

We can create a DataFrame by using read_excel() function. From the DataFrame we can use one column data to create one list.

import pandas as pd
df=pd.read_excel("D:\\my_data\\tk-colours.xlsx") # Create DataFrame.
my_list=df['Name'].values.tolist() # data source

Using DataFrame index to create list

Use any one

my_list=df.index.values.tolist()

my_list = list(df.index)

my_list = list(df.index.values)

tolist() is used to create LIST from DataFrame to create PDF table
Pandas DataFrame describe() head() to_string() rename()

Numpy arrays Python & MySQL Python- Tutorials

Subhendu Mohapatra

Author & Instructor at plus2net

I write and maintain practical tutorials on Python, PHP, SQL, JavaScript, HTML, jQuery, and web development at plus2net. The tutorials focus on clear explanations, working examples, and code that readers can test and adapt while learning.

About the author Watch on YouTube

Connect:

Subscribe to our YouTube Channel here

tolist(): List from Pandas DataFrame

Adding column names to the list.

Using DataFrame column to create a list

Using DataFrame index to create list

Subhendu Mohapatra