'OpenpyxlWriter' object is not subscriptable 运行出现这个错误,希望各位能帮解决一下。感谢!
错误代码:
Traceback (most recent call last):
File "E:/lyw/pythonProject/geography/statistical table.py", line 442, in
tables = Tables()
File "E:/lyw/pythonProject/geography/statistical table.py", line 17, in init
self.dataprocess()
File "E:/lyw/pythonProject/geography/statistical table.py", line 27, in dataprocess
split_data1 = self.data["年月日"].astype(str).str.split('.', expand=True)
TypeError: 'OpenpyxlWriter' object is not subscriptable
源代码:
```python
class Tables(QMainWindow, Ui_Dialog):
def __init__(self):
super().__init__()
self.ui = Ui_Dialog()
self.setupUi(self)
self.dataprocess()
self.zhenji.clicked.connect(self.zhenjishaixuan)
self.nianfen.clicked.connect(self.nianfen_0)
self.queding.clicked.connect(self.save)
#self.longitude()
def dataprocess(self):
self.data = pd.ExcelWriter('区划图强震目录.xlsx')
self.outputfile=pd.ExcelWriter(r"E:\lyw\text.xlsx")# 年份
# 对指定列进行分割
split_data1 = self.data["年月日"].astype(str).str.split('.', expand=True)
print(split_data1)
# 修改分割后的字段名称
split_data1.columns = ['D_' + str(i) for i in split_data1.columns]
self.data = self.data.join(split_data1)
self.data["年月日"].astype(str).str是个OpenpyxlWriter对象,不是str类型,不能split
你可以先强制转str试试
可以将数据发出来瞅瞅嘛