Pandas numbers in index are strings/object

Question

Running

for index, row in df.iterrows():
    print(df.iloc[index,0])

yields the following error:

ValueError: Location based indexing can only have [integer, integer slice (START point is INCLUDED, END point is EXCLUDED), listlike of integers, boolean array] types

Index is 0:

index
Out[57]: '0'

But somehow, my index consists of strings which I can confirm via

type(index)
Out[63]: str

This is although I've applied df.reset_index().

How can I ensure that the index of my df (df.index) consists of integers?

EDIT:

df.index
Out[69]: 
Index(['0', '1', '2', '3', '4', '5', '6', '7', '8', '9',
       ...
       '14829', '14830', '14831', '14832', '14833', '14834', '14835', '14836',
       '14837', '14838'],
      dtype='object', length=14839)

bigbounty · Accepted Answer · 2020-07-17 12:22:52Z

2

In [85]: df.index
Out[85]: Index(['0', '1', '2', '3', '4', '5', '6'], dtype='object')

In [86]: df.index = df.index.astype(int)

In [87]: df.index
Out[87]: Int64Index([0, 1, 2, 3, 4, 5, 6], dtype='int64')

Make use of astype

answered Jul 17, 2020 at 12:22

bigbounty

17.5k7 gold badges46 silver badges76 bronze badges

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

Comments

Koti · Accepted Answer · 2020-07-17 12:19:45Z

0

index results in '0' which means it is a string. You can easily make it an integer by using int() function.

At your case, int(index) will solve the problem.

edited Jul 17, 2020 at 12:19

answered Jul 17, 2020 at 12:17

Koti

17612 bronze badges

3 Comments

Stücke Over a year ago

Thank you for your answer. This will not change the entire df.index() to ints.

Stücke Over a year ago

I've updated my question to make my request more clear.

Koti Over a year ago

Well, you make try to use df[column_name] = df[column_name].astype(int) after creating the DataFrame.

Collectives™ on Stack Overflow

Pandas numbers in index are strings/object

2 Answers 2

Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related