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
- How to convert column values to Int
- What is opposite of melt() in Pandas
- How to use melt() with dataframe - example
- How to load dataframe data from SQL query
- How to execute not equal query on dataframe
- How to create dataframe from Mysql table
- Get first N rows (head) from data frame
- How to query dataframe using multiple conditions
- How to convert dataframe to list of lists
- How to left join dataframes
See more codes...