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 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...