How to Sort a Data Frame by Date

Convert Column to Date Format (Pandas Dataframe)

You can use pd.to_datetime() to convert to a datetime object. It takes a format parameter, but in your case I don't think you need it.

>>> import pandas as pd
>>> df = pd.DataFrame( {'Symbol':['A','A','A'] ,
    'Date':['02/20/2015','01/15/2016','08/21/2015']})
>>> df
         Date Symbol
0  02/20/2015      A
1  01/15/2016      A
2  08/21/2015      A
>>> df['Date'] =pd.to_datetime(df.Date)
>>> df.sort('Date') # This now sorts in date order
        Date Symbol
0 2015-02-20      A
2 2015-08-21      A
1 2016-01-15      A

For future search, you can change the sort statement:

>>> df.sort_values(by='Date') # This now sorts in date order
        Date Symbol
0 2015-02-20      A
2 2015-08-21      A
1 2016-01-15      A

How to sort a data frame by date

Assuming your data frame is named d,

d[order(as.Date(d$V3, format="%d/%m/%Y")),]

Read my blog post, Sorting a data frame by the contents of a column, if that doesn't make sense.

How to sort a pandas dataframe by date

I managed to solve this by transforming my date field into a datetime object, I assumed this would be done automatically by parse_date=True but it seems that will only parse a existing datetime object.

I added the following after my query to create a new datetime column from my date string, then I was able to use data.sort_index() and it worked as expected:

time_format = '%Y-%m-%d'
data = pd.read_gbq(query, project_id, dialect='standard', private_key=pkey)

data['n_date'] = pd.to_datetime(data['date'], format=time_format)  

data.index = data['n_date']

del data['date']
del data['n_date']

data.index.names = ['Date']

data = data.sort_index()

Sort pandas dataframe by date in day/month/year format

Try:

df.loc[:,'date'] = pd.to_datetime(df.loc[:, 'date'], format='%d/%m-%Y')

How do I sort a pandas data frame by date time

Reassign back to df or use the inplace=true parameter:

df = df.sort_values(by='Date')

OR

df.sort_values(by='Date', inplace=True)

print(df['Date'])

Output:

1    2015-01-01
2    2015-01-02
3    2015-01-02
4    2015-01-02
10   2015-01-02
6    2015-01-03
5    2015-01-05
7    2015-01-07
8    2015-01-07
9    2015-01-07
0    2015-03-05
Name: Date, dtype: datetime64[ns]

Sort Dates in Chronological order in pandas

First convert column type to datetime using pd.to_datetime then sort using pd.DataFrame.sort_values and then reset index.

df.Date = pd.to_datetime(df.Date, dayfirst=True)
df = df.sort_values('Date').reset_index(drop=True)
df
        Date  Confirmed
0 2020-01-01          2
1 2020-01-02         23
2 2020-02-01          3
3 2020-02-02          3
4 2020-03-01       1834
5 2020-03-02          5

---

Related Topics