Solution # 1: To iterate over rows in DataFrame.iterrows ()
Pandas we can use DataFrame.iterrows ()
and then add the data of each row to the end of the list.
# import pandas as pd import pandas as pd # Create data frame df = pd.DataFrame ({ ’ Date’ : [ ’ 10/2 / 2011’ , ’11/2 / 2011’ , ’12/2 / 2011’ , ’ 13/2 / 11’ ], ’Event’ : [ ’Music’ , ’ Poetry’ , ’Theater’ , ’ Comedy ’ ], ’ Cost’ : [ 10000 , 5000 , 15000 , 2000 ]}) # Print data frame print (df) |
Output:
We will now use DataFrame.iterrows ()
to iterate over each row of the given Dataframe and building a list from the data of each row.
# Create empty list Row_list = [] # Iterate over each line for index, rows in df.iterrows (): # Create a list for the current line my_list = [rows.Date, rows.Event, rows.Cost] # add list to final list Row_list.append (my_list) # Print list print (Row_list) td > |
Output:
As we can see in the output, we have successfully extracted each row of a given dataframe into a list. Like any other Python list, we can perform any operation on the list of the retrieved list.
# Find the length again # list created print ( len (Row_list)) # Print first 3 items print (Row_list [: 3 ]) |
Output:
Solution # 2. To iterate over the lines in DataFrame.itertuples () Pandas, we can use DataFrame.itertuples ()
and then add each row’s data to the end of the list.
# import pandas as pd import pandas as pd # Create data frame df = pd.DataFrame ({ ’Date ’ : [ ’ 10/2 / 2011’ , ’11/2 / 2011’ , ’ 12/2 / 2011’ , ’13/2 / 11’ ], ’Event’ : [ ’ Music’ , ’Poetry’ , ’ Theater’ , ’Comedy’ ], ’ Cost’ : [ 10000 , 5000 , 15000 , 2000 ]}) # Print the data frame print (df) |
Output:
We will now use DataFrame.itertuples ()
to iterate over each row of the given Dataframe and create a list from each row’s data.
# Create empty list Row_list = [] # Iterate over each row for rows in df.itertuples (): # Create a list for the current line my_list = [rows.Date, rows.Event, rows.Cost] p> # add the list to final list Row_list.append (my_list) # Print list print (Row_list) |
Output:
As we can see in the output, we have successfully extracted each row of the given dataframe into a list. Like any other Python list, we can perform any operation on the list of the retrieved list.
# Find the length again # list created print ( len (Row_list)) # Print first 3 items print (Row_list [: 3 ]) |
Output:
Create list from strings in Pandas dataframe Python functions: Questions
Create list from strings in Pandas dataframe String Variables: Questions