9951 explained code solutions for 126 technologies


python-pandasHow to convert datetime to month


import pandas as pd

df = pd.DataFrame({
  'date_time_str': ['3/10/2022 14:43:24', '3/11/2022 14:43:24', '3/12/2022 14:43:24'],
  'value': [1,2,3]
})

df['month'] = pd.to_datetime(df['date_time_str']).dt.monthctrl + c
import pandas as pd

load Pandas module

pd.DataFrame

creates Pandas DataFrame object

.to_datetime(

convert given column values to datetime type (will automatically parse given strings)

date_time_str

string column with date & time

'month'

column will contain month

.dt.month

extracts month from datetime column


Usage example

import pandas as pd

df = pd.DataFrame({
  'date_time_str': ['3/10/2022 14:43:24', '3/11/2022 14:43:24', '3/12/2022 14:43:24'],
  'value': [1,2,3]
})

df['month'] = pd.to_datetime(df['date_time_str']).dt.month
print(df)
output
        date_time_str  value  month
0  3/10/2022 14:43:24      1      3
1  3/11/2022 14:43:24      2      3
2  3/12/2022 14:43:24      3      3