我正在尝试将数据帧中的字符串日期时间转换为日期时间,但我收到错误ValueError: time data DATETIME doesn't match format specified
.
print(chunk['DATETIME']) gives this
0 DATETIME
1 2019-12-25 15:46:42
2 2019-12-25 15:46:43
3 2019-12-25 15:47:39
4 2019-12-25 15:47:42
Name: DATETIME, dtype: object
这就是我所做的。
chunk['DATETIME'] = pd.to_datetime(chunk['DATETIME'], format='%Y-%m-%d %H:%M:%S')
print(chunk['DATETIME'])
这给了我错误。我试图删除可能存在的空白区域
chunk['DATETIME'] = chunk['DATETIME'].str.strip()
print(chunk['DATETIME'])
但我仍然得到同样的错误。您的帮助将不胜感激。
我尝试了您的代码,它似乎对我有用。您能提供有关您的数据的更多信息吗?或者尝试重新启动内核?
import pandas as pd
chunk = pd.DataFrame({"DATETIME":['2019-12-25 15:46:42','2019-12-25 15:46:43']})
chunk["DATETIME"] = pd.to_datetime(chunk["DATETIME"], format='%Y-%m-%d %H:%M:%S')
print(chunk['DATETIME'])
chunk.info()
输出
0 2019-12-25 15:46:42
1 2019-12-25 15:46:43
Name: DATETIME, dtype: datetime64[ns]
<class 'pandas.core.frame.DataFrame'>
RangeIndex: 2 entries, 0 to 1
Data columns (total 1 columns):
# Column Non-Null Count Dtype
--- ------ -------------- -----
0 DATETIME 2 non-null datetime64[ns]
dtypes: datetime64[ns](1)
memory usage: 144.0 bytes