Format a Date Column in a Data Frame

How to change the datetime format in Pandas

You can use dt.strftime if you need to convert datetime to other formats (but note that then dtype of column will be object (string)):

import pandas as pd

df = pd.DataFrame({'DOB': {0: '26/1/2016', 1: '26/1/2016'}})
print (df)
         DOB
0  26/1/2016 
1  26/1/2016

df['DOB'] = pd.to_datetime(df.DOB)
print (df)
         DOB
0 2016-01-26
1 2016-01-26

df['DOB1'] = df['DOB'].dt.strftime('%m/%d/%Y')
print (df)
         DOB        DOB1
0 2016-01-26  01/26/2016
1 2016-01-26  01/26/2016

Change dd-mm-yyyy date format of dataframe date column to yyyy-mm-dd

Use '%Y-%m-%d'

Ex:

import pandas as pd

df = pd.DataFrame({"Date": ["26-12-2007", "27-12-2007", "28-12-2007"]})
df["Date"] = pd.to_datetime(df["Date"]).dt.strftime('%Y-%m-%d')
print(df)

Output:

         Date
0  2007-12-26
1  2007-12-27
2  2007-12-28

How to convert date column in dataframe from numbers to formatted text? (Python)

First create some sample data:

dates = pd.date_range("2021-07-27", periods=48, freq="H").tz_localize("America/New_York")

Then fill the DataFrame

dt = pd.DataFrame({"startDateEST": dates})

Have a look at python datetime formatting strings and format accordingly

dt["startDateEST_Long"] = dt["startDateEST"].dt.strftime('%b %d, %Y, %I:%M%p')

dt.head()

0 2021-07-27 00:00:00-04:00  Jul 27, 2021, 12:00AM
1 2021-07-27 01:00:00-04:00  Jul 27, 2021, 01:00AM
2 2021-07-27 02:00:00-04:00  Jul 27, 2021, 02:00AM
3 2021-07-27 03:00:00-04:00  Jul 27, 2021, 03:00AM
4 2021-07-27 04:00:00-04:00  Jul 27, 2021, 04:00AM

How do I change the format of all dates in my dataframe from dd-mm-yyyy to yyyy-mm-dd (in r)

Do this in 2 steps. First, use as.Date to convert your text dates to bona fide R dates. Then use format to convert back to text, in the format you want.

dates <- as.Date(df$Date, format="%d-%m-%Y")
df$Date <- format(dates, "%Y-%m-%d")

How to convert the date format in a dataframe using Python?

import pandas as pd
dates = ['05/01/2021','05/02/2021','05/03/2021','05/04/2021','05/05/2021']
values = [1,2,3,4,5]

df = pd.DataFrame({'dates': dates,
               'values': values})

df['to_datetime'] = pd.to_datetime(df['dates'])

# this is converted date
df['target_date'] = '0'+ df['to_datetime'].dt.day.astype(str) + '/' + \
'0'+ df['to_datetime'].dt.month.astype(str) + '/' + 
df['to_datetime'].dt.year.astype(str)

format a Date column in a Data Frame

This should do it (where df is your dataframe)

df$JoiningDate <- as.Date(df$JoiningDate , format = "%m/%d/%y")

df[order(df$JoiningDate ),]

---

Related Topics