代码【import pandas as pd
HISTORICAL_DATA_PATH = r"C:\Users\THINK\Desktop\新建文件夹 (2)\2025年度枢纽公司议题收集统计表1.xlsx"
df_old = pd.read_excel(HISTORICAL_DATA_PATH, sheet_name='Sheet1', dtype=str )
df_old】 报错【---------------------------------------------------------------------------
TypeError Traceback (most recent call last)
Cell In[73], line 3
1 import pandas as pd
2 HISTORICAL_DATA_PATH = r"C:\Users\THINK\Desktop\新建文件夹 (2)\2025年度枢纽公司议题收集统计表1.xlsx"
----> 3 df_old = pd.read_excel(HISTORICAL_DATA_PATH, sheet_name='Sheet1', dtype=str )
4 df_old
File d:\安装目录\python\Python312\Lib\site-packages\pandas\io\excel\_base.py:517, in read_excel(io, sheet_name, header, names, index_col, usecols, dtype, engine, converters, true_values, false_values, skiprows, nrows, na_values, keep_default_na, na_filter, verbose, parse_dates, date_parser, date_format, thousands, decimal, comment, skipfooter, storage_options, dtype_backend, engine_kwargs)
511 raise ValueError(
512 "Engine should not be specified when passing "
513 "an ExcelFile - ExcelFile already has the engine set"
514 )
516 try:
--> 517 data = io.parse(
518 sheet_name=sheet_name,
519 header=header,
520 names=names,
521 index_col=index_col,
522 usecols=usecols,
523 dtype=dtype,
524 converters=converters,
525 true_values=true_values,
526 false_values=false_values,
527 skiprows=skiprows,
...
100 else:
101 attrib[tag] = obj
--> 103 return cls(**attrib)
TypeError: DataValidation.__init__() got an unexpected keyword argument 'id'
Output is truncated. View as a scrollable element or open in a text editor. Adjust cell output settings...】
最新发布