peError Traceback (most recent call last)
Cell In[39], line 15
12 monthly_stats_reset = monthly_stats.reset_index()
14 # 确保 'date' 列是 datetime 类型
---> 15 monthly_stats_reset['date'] = pd.to_datetime(monthly_stats_reset['date'])
17 # 提取 Year 和 Month
18 monthly_stats_reset['Year'] = monthly_stats_reset['date'].dt.year
File D:\Anaconda\lib\site-packages\pandas\core\tools\datetimes.py:1068, in to_datetime(arg, errors, dayfirst, yearfirst, utc, format, exact, unit, infer_datetime_format, origin, cache)
1066 result = arg.map(cache_array)
1067 else:
-> 1068 values = convert_listlike(arg._values, format)
1069 result = arg._constructor(values, index=arg.index, name=arg.name)
1070 elif isinstance(arg, (ABCDataFrame, abc.MutableMapping)):
File D:\Anaconda\lib\site-packages\pandas\core\tools\datetimes.py:403, in _convert_listlike_datetimes(arg, format, name, tz, unit, errors, infer_datetime_format, dayfirst, yearfirst, exact)
401 orig_arg = arg
402 try:
--> 403 arg, _ = maybe_convert_dtype(arg, copy=False, tz=timezones.maybe_get_tz(tz))
404 except TypeError:
405 if errors == "coerce":
File D:\Anaconda\lib\site-packages\pandas\core\arrays\datetimes.py:2268, in maybe_convert_dtype(data, copy, tz)
2264 raise TypeError(f"dtype {data.dtype} cannot be converted to datetime64[ns]")
2265 elif is_period_dtype(data.dtype):
2266 # Note: without explicitly raising here, PeriodIndex
2267 # test_setops.test_join_does_not_recur fails
-> 2268 raise TypeError(
2269 "Passing PeriodDtype data is invalid. Use `data.to_timestamp()` instead"
2270 )
2272 elif is_extension_array_dtype(data.dtype) and not is_datetime64tz_dtype(data.dtype):
2273 # TODO: We have no tests for these
2274 data = np.array(data, dtype=np.object_)
TypeError: Passing PeriodDtype data is invalid. Use `data.to_timestamp()` instead
最新发布
扫一扫
752
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
