Menu Close

How to iterate over rows in a DataFrame in Python Pandas?

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.

Posted in Python, Python Answers