1. 问题说明

Traceback (most recent call last):File "D:\python3.8.5\lib\multiprocessing\pool.py", line 125, in workerresult = (True, func(*args, **kwds))File "E:\01-code\02-wind_profile\all_state\other.py", line 559, in main_functiondf_10min = spectral_wind_profile.shear_process(ws_start=ws_start, ws_end=ws_end)File "E:\01-code\02-wind_profile\all_state\other.py", line 128, in shear_processdf_ten_minute = self.data_processing(df_ten_minute)File "E:\01-code\02-wind_profile\all_state\other.py", line 144, in data_processingdata = data.interpolate(method='linear', limit_direction='backward', axis=1)File "D:\python3.8.5\lib\site-packages\pandas\util\_decorators.py", line 311, in wrapperreturn func(*args, **kwargs)File "D:\python3.8.5\lib\site-packages\pandas\core\frame.py", line 10931, in interpolatereturn super().interpolate(File "D:\python3.8.5\lib\site-packages\pandas\core\generic.py", line 7002, in interpolateraise TypeError(
TypeError: Cannot interpolate with all object-dtype columns in the DataFrame. Try setting at least one column to a numeric dtype.
"""

The above exception was the direct cause of the following exception:
Traceback (most recent call last):File "D:/PyCharm2023_profession/PyCharm 2023.1/plugins/python/helpers/pydev/pydevd.py", line 1496, in _execpydev_imports.execfile(file, globals, locals)  # execute the scriptFile "D:\PyCharm2023_profession\PyCharm 2023.1\plugins\python\helpers\pydev\_pydev_imps\_pydev_execfile.py", line 18, in execfileexec(compile(contents+"\n", file, 'exec'), glob, loc)File "E:\01-code\02-wind_profile\all_state\other.py", line 706, in <module>print('ok')File "E:\01-code\02-wind_profile\all_state\other.py", line 696, in mainans.append(data)File "D:\python3.8.5\lib\multiprocessing\pool.py", line 771, in getraise self._value
TypeError: Cannot interpolate with all object-dtype columns in the DataFrame. Try setting at least one column to a numeric dtype.

pandas 不能使用所有的 object 类型的列进行插值。这意味着在使用 pandas 的插值函数(例如 interpolate())时，所有的列都必须是数值类型的。如果其中有一列是 object 类型的，则会抛出异常。

要解决这个问题，你需要将 object 类型的列转换为数值类型。你可以使用 pandas.to_numeric 函数来实现这一点。例如：

import pandasas pddf['column_name'] = pd.to_numeric(df['column_name'], errors='coerce')

参考链接
[1] pandas Cannot interpolate with all object-dtype columns 2023.1；