TypeError: 'int' object is not subscriptable in dataframe.iterrows

Question

I am trying to loop over a dataframe like the following:

for row, index in split[0].iterrows():
        kitname = row['kit_name'][0]
        print(kitname)

where split is a list of dataframes

split[0] :

  kit_name          kit_info         part_name part_number  
0  KIT0001  Standard FLC Kit  Standard FLC Kit           0   
1  KIT0001  Standard FLC Kit  Standard FLC Kit           0   
2  KIT0001  Standard FLC Kit  Standard FLC Kit           0

but the following error is coming:

TypeError: 'int' object is not subscriptable

I am using the same code in a different script and it's working fine there

try print(row['kit_name"], row['kit_name"]) to find the problem. You need to know how to find a look for a problem by yourself, if not you'll take so much time to develop your thing — azro
– azro, Commented Apr 1, 2022 at 5:57

jezrael · Accepted Answer · 2022-04-01 05:58:09Z

3

Problem is you swap index and row variables, so row are integers so select ['kit_name'] failed:

for row, index in split[0].iterrows():
    kitname = row['kit_name'][0]
    print(kitname)

Need:

for index, row in split[0].iterrows():
    kitname = row['kit_name'][0]
    print(kitname)

answered Apr 1, 2022 at 5:58

jezrael

868k103 gold badges1.4k silver badges1.3k bronze badges

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

Collectives™ on Stack Overflow

TypeError: 'int' object is not subscriptable in dataframe.iterrows

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related