sorting datetime columns pandas

Question

I have a dataframe table that has columns containing datetime information. As you can see from the table below, the 2019-xx field is between the years 2018 and 2016 so I need to arrange it properly.

I tried to use .sort_index(axis=1, inplace=True) but in vain (I don't know why it has no effect at all).

Dataframe:

                      2017-12-31   2018-12-31  2019-12-31   2016-12-31  2020-06-30
Unnamed: 0
WaterFlow   -26084000.0 -257404000.0 -84066000.0  135075000.0         NaN
trailing1HourWaterFlow         NaN          NaN -84066000.0          NaN   6823000.0

The problem is that:
1. I don't know how to arrange columns orders when it's represented as datetime info.
2. The table above seems strange since that "Unnamed: 0" row is empty and there's a space between the columns and rows unlike other ordinary dataframes.

What is print (df.info()) ?

jezrael
– jezrael

2020-11-06 08:35:08 +00:00
Commented Nov 6, 2020 at 8:35 — jezrael
– jezrael, Commented Nov 6, 2020 at 8:35

Shaido · Accepted Answer · 2020-11-06 09:32:12Z

2

I think you need convert the columns to datetimes, then do the sorting. If Unnamed: 0 is the index name you can remove it by using DataFrame.rename_axis:

df.columns = pd.to_datetime(df.columns)
df = df.sort_index(axis=1).rename_axis(None)

edited Nov 6, 2020 at 9:32

Shaido

28.6k26 gold badges76 silver badges82 bronze badges

answered Nov 6, 2020 at 8:36

jezrael

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

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

1 Comment

BangolPhoenix Over a year ago

Thanks you so much for the solution! It finally solved my problem thank you again.

Collectives™ on Stack Overflow

sorting datetime columns pandas

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related