xlsxl_filepath=r'C:UsersyanaiDoonloads103491291.Table.xlsx
x1sx2 filepath=rC:UserslyanaiDoonloads1103491291.Table.xlsx
data_l=pd.read_excel(xlsxl_filepath)
data_2=pd.read_excel(xlsx2_filepath)
rows_1,=data_1.shape
rows_2,=data_2.shape
data_1.insert(0,1abel’,[O]*rows_1)
data_2.insert(0,1abel’,[1]*rows_2)
data=pd.concat([data_1,data_2])
data=shuffle(data)
data=data.filina(0)
x=dataldata,columns[1:]]
y=data[’1abel’]
ColNames=X.columns
x=x.astype(np.f1oat64
x=StandardScaler().fit_transform(x)
x=pd.DataFrame(x)
x.columns=colNames
IyoeError Traceback(most recent call last)
<ipython-input-5-054231ae5c2d>in<module>
10 data=shuffle(data)
1ldata=data.filina(0)
>12 x=dataLdata,columnsl1:
13 y=datal’1abe1']
14colNames=X.columns
TypeError:module' object is not subscriptable
大师们,可以帮我看看这个问题出在哪儿吗?