9951 explained code solutions for 126 technologies


python-pandasHow to convert datetime to year


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['year'] = pd.to_datetime(df['date_time_str']).dt.yearctrl + 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

'year'

column will contain year

.dt.year

extracts year 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['year'] = pd.to_datetime(df['date_time_str']).dt.year
print(df)
output
        date_time_str  value  year
0  3/10/2022 14:43:24      1  2022
1  3/11/2022 14:43:24      2  2022
2  3/12/2022 14:43:24      3  2022