python-pandasHow to use datetime type
import pandas as pd
df = pd.DataFrame({
'date_str': ['3/10/2022', '3/11/2022', '3/12/2021'],
'value': [1,2,3]
})
df['date'] = pd.to_datetime(df['date_str'])ctrl + 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_strstring column with date |
'date'column with datetime type | |
Usage example
import pandas as pd
df = pd.DataFrame({
'date_str': ['3/10/2022', '3/11/2022', '3/12/2021'],
'value': [1,2,3]
})
df['date'] = pd.to_datetime(df['date_str'])
print(df)output
date_str value date
0 3/10/2022 1 2022-03-10
1 3/11/2022 2 2022-03-11
2 3/12/2021 3 2021-03-12
Related
More of Python Pandas
- How to convert yyyymmdd string to datetime
- How to convert column values to Float
- How to join dataframes on multiple columns
- How to left join dataframes
- How to convert column object values to String
- How to convert column values to Int
- How to replace values in dataframe
- What is opposite of melt() in Pandas
- How to use melt() with dataframe - example
- How to rename dataframe column by index
See more codes...