unable to iterate over rows in Pandas Dataframe

Question

I know this question has been asked many times but I have tried almost all methods I am trying to iterate over rows in DataFrame using following code.

import pandas as pd

df = pd.read_csv(r"file.csv")

for row in df:
    print(row)

there is only one column in csv file and it only prints header of file. I have also used .items() , .iterrows() and .itertuples(), all these methods give tuples as output which I don't need. Further task I am trying to do in loop only accepts output from for row in df:. kindly help that how can I print actual rows this way rather than just header name. Thank you.

@Ajay This is the answer can you please post in answer section so I can mark it. Thank you for your time and effort — mike reed
– mike reed, Commented Dec 15, 2020 at 7:48

Linden · Accepted Answer · 2020-12-15 08:05:08Z

2

The df.iterrows() method iterates over each row of a dataframe, returning a tuple of (row_number, row_data). So to just get the row data, you can unpack each tuple as part of the iterration and only use the second part:

for num, row in df.iterrows():
    print(row)

answered Dec 15, 2020 at 8:05

Linden

5714 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Ajay A · Accepted Answer · 2020-12-15 08:15:42Z

1

Try this, using the specific column on which you want to iterate

for row in df[col_name].to_list():

answered Dec 15, 2020 at 8:15

Ajay A

1,0531 gold badge9 silver badges20 bronze badges

Collectives™ on Stack Overflow

unable to iterate over rows in Pandas Dataframe

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related