To iterate over rows in a DataFrame in Python Pandas, we can use a for loop.
For instance, we write
import pandas as pd
df = pd.DataFrame({'c1': [10, 11, 12], 'c2': [100, 110, 120]})
df = df.reset_index() # make sure indexes pair with number of rows
for index, row in df.iterrows():
print(row['c1'], row['c2'])
to loop through the df
dataframe with iterator returned by the df.iterrows
method.
We use the row
object to get the rows and the keys to get the values.