Appending a data frame index doesn't work properly

Asked Sep 02 '22 at 13:56

Active Sep 02 '22 at 19:19

Viewed 27 times

I am trying to append a data frame index if certain condition is met, apparently when I print the append everything is looking right and the code is working. But when I look at the data frame index after leaving the if there is no appended value in there even if the condition was met.

if (year_and_month not in to_dashboard.index):
    print("I'm appending the index")
    new_index = pd.Index([year_and_month])
    print(new_index)
    to_dashboard.index.append(new_index)
    print(to_dashboard.index)

And there is the if output:

I am appending the index :

Index(['2022-08'], dtype='object')

Index(['2022-05', '2022-06', '2022-07'], dtype='object')

edited Sep 02 '22 at 19:19

R. Baraiya

1,490
1
4
17

asked Sep 02 '22 at 13:56

Grzegorz Szymala

1

`to_dashboard.reindex(to_dashboard.index.union(year_and_month))`? – Quang Hoang Sep 02 '22 at 13:58
It's still not appending – Grzegorz Szymala Sep 02 '22 at 14:04
maybe index expanding will help https://stackoverflow.com/questions/39516671/extend-a-pandas-datetimeindex-by-1-period – NoobVB Sep 03 '22 at 12:56

Appending a data frame index doesn't work properly

0 Answers0