How can I check Index type in Python Data Frame?

Asked Sep 05 '22 at 07:07

Active Sep 05 '22 at 07:14

Viewed 227 times

There is my Data Frame, it has more than 45,000+ values.

Basically I work on bar_chart_race graph but suddenly it throws an error.

ValueError: Invalid fill method. Expecting pad (ffill) or backfill (bfill). Got linear

then I found a solution on this link. But there is an another issue how can i check Index data type? because in given link it can find issue with datetime format then it can be solved. but how can i know about type of index? e.g. Datetime , Date , timedelta,Object or a string?

About Data frame those value directly come from an API . Any other solutions? Bar_Chart_race datetime as an index.

edited Sep 05 '22 at 07:14

asked Sep 05 '22 at 07:07

Mehmaam

Use `df.index.dtype` – ChrisOram Sep 05 '22 at 07:14
it can return `dtype('O')`. what does it mean? – Mehmaam Sep 05 '22 at 07:15
1

See https://stackoverflow.com/a/37562101/15981783 for an explanation of this dtype. – ChrisOram Sep 05 '22 at 07:15
Then you can see this for converting the index to datetime https://stackoverflow.com/a/36264850/15981783. But instead use `df.index = pd.to_datetime(df.index, ...)` – ChrisOram Sep 05 '22 at 07:16
Can it work directly on Index or can i convert from columns then i can do that just like in a given link? – Mehmaam Sep 05 '22 at 07:18
Use `df.index = pd.to_datetime(df.index, format='%Y-%m-%d')` – ChrisOram Sep 05 '22 at 07:20
It can show an error `TypeError: is not convertible to datetime` – Mehmaam Sep 05 '22 at 07:21
Try doing `df.index = df.index.map(lambda x : str(x[0]))` first to cast the first element of the tuple to a string. – ChrisOram Sep 05 '22 at 07:27
It can remove date Index. – Mehmaam Sep 05 '22 at 07:32
Without the DataFrame this is a hard problem to debug. Print out the contents of the index, see why it's a tuple & what the elements of the tuple are. The goal is to convert the date part of the tuple to a single string as the index, then use the `pd.to_datetime` function on it. – ChrisOram Sep 05 '22 at 08:00

How can I check Index type in Python Data Frame?

0 Answers0