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 + cimport pandas as pdload Pandas module | pd.DataFramecreates Pandas DataFrame object |
.to_datetime(convert given column values to datetime type (will automatically parse given strings) | date_time_strstring column with date & time |
'year'column will contain year | .dt.yearextracts 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
Related
More of Python Pandas
- What is opposite of melt() in Pandas
- How to convert column values to Int
- How to replace values in dataframe
- How to use melt() with dataframe - example
- How to use column names with spaces in queries
- How to use multiple conditions in mask()
- How to melt() multiple columns
- How to left join dataframes
- How to convert column object values to String
- How to replace strings in dataframe column
See more codes...