DataFrame get rows using index

Question

I am trying to find a way that gets the row of a dataframe using index that has the same result as using data_file.iterrows(). I tried the following code, but they are not indentical. Is there any way to do this? Thanks!

for row in data_file.iterrows():
    print(row == data_file.iloc[0])
    print(row)
    print(data_file.iloc[0])
    break

You should really be saying for ind, row in data_file.iterrows(): The iterator gives you a tuple of index, row — smci
– smci, Commented Feb 17, 2018 at 12:03

Anton vBR · Accepted Answer · 2018-02-16 23:06:09Z

2

The corresponding series value is on index1, does that help?

Docs: https://pandas.pydata.org/pandas-docs/stable/generated/pandas.DataFrame.iterrows.html

DataFrame.iterrows()[source]

Iterate over DataFrame rows as (index,Series) pairs.

print(row[1] == data_file.iloc[0])

Another solution:

for ind, row in data_file.iterrows():

edited Feb 16, 2018 at 23:06

answered Feb 16, 2018 at 22:58

Anton vBR

19k6 gold badges47 silver badges47 bronze badges

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

6 Comments

Cong Yang Over a year ago

Thanks! but why it is row[1]?

Anton vBR Over a year ago

@CongYang Because it is returned as a pair where you are looking for the 2nd element [1]. This: Iterate over DataFrame rows as (index,Series) pairs.

smci Over a year ago

Because you should really be saying for ind, row in data_file.iterrows(): The iterator gives you a tuple of index, row

Anton vBR Over a year ago

@smci Yeah well I agree. However I did link to the docs and the phrase: Iterate over DataFrame rows as (index,Series) pairs.

smci Over a year ago

(Anton vBR, I was addressing that to the OP)

|

dietzi96 · Accepted Answer · 2018-02-16 23:07:00Z

2

Because iterrows returns a tuple consisting of the index of the row and the row itself and iloc the row.

print(type(row))
<class 'tuple'>
print(type(pl0.iloc[0]))  
<class 'pandas.core.series.Series'>
print(type(row[1]))
<class 'pandas.core.series.Series'>

You may use python's ability to unpack tuples:

for index, row in data_file.iterrows():

Why are you not using iloc directly, anyway? Using iterrows is not recommended, because of its negative performance impact.

answered Feb 16, 2018 at 23:07

dietzi96

1332 silver badges6 bronze badges

Collectives™ on Stack Overflow

DataFrame get rows using index

2 Answers 2

6 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

6 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related