报错strptime() argument 1 must be str, not Timestamp
时间: 2024-05-10 11:20:26 浏览: 18
这个错误提示表明在使用strptime()函数时,第一个参数需要传入字符串类型,而不是Pandas中的Timestamp类型。
解决方法:
1.将Timestamp类型转换为字符串类型:
```python
import pandas as pd
from datetime import datetime
df = pd.DataFrame({'date': pd.date_range('2022-01-01', periods=3)})
df['date_str'] = df['date'].apply(lambda x: x.strftime('%Y-%m-%d %H:%M:%S'))
df['date_parsed'] = pd.to_datetime(df['date_str'], format='%Y-%m-%d %H:%M:%S')
print(df)
```
输出:
```
date date_str date_parsed
0 2022-01-01 2022-01-01 00:00:00 2022-01-01 00:00:00
1 2022-01-02 2022-01-02 00:00:00 2022-01-02 00:00:00
2 2022-01-03 2022-01-03 00:00:00 2022-01-03 00:00:00
```
2.使用Pandas的to_datetime()函数直接将Timestamp类型转换为DateTime类型:
```python
import pandas as pd
df = pd.DataFrame({'date': pd.date_range('2022-01-01', periods=3)})
df['date_parsed'] = pd.to_datetime(df['date'], format='%Y-%m-%d %H:%M:%S')
print(df)
```
输出:
```
date date_parsed
0 2022-01-01 2022-01-01 00:00:00
1 2022-01-02 2022-01-02 00:00:00
2 2022-01-03 2022-01-03 00:00:00
```
相关推荐
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![pdf](https://img-home.csdnimg.cn/images/20210720083512.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![xlsx](https://img-home.csdnimg.cn/images/20210720083732.png)
![rar](https://img-home.csdnimg.cn/images/20210720083606.png)