KeyError问题求助

KeyError问题求助,第1张

本人在对两个Excel表格数据合并后进行t检验时出现KeyError报错,提示为Excel表格每一列的名称,如“GG”等,请问该如何解决???

代码如下:

import pandas as pd
import numpy as np
from sklearn.utils import shuffle
from sklearn.preprocessing import StandardScaler
from sklearn.linear_model import LassoCV
from sklearn.model_selection import train_test_split,cross_val_score,KFold,RepeatedKFold,GridSearchCV
from scipy.stats import pearsonr,ttest_ind,levene
from sklearn.ensemble import RandomForestClassifier
from sklearn import svm

xlsx1_filePath="C:/Users/Administrator/Desktop/EE.xlsx"
xlsx2_filePath="C:/Users/Administrator/Desktop/FF.xlsx"
data_1=pd.read_excel(xlsx1_filePath)
data_2=pd.read_excel(xlsx2_filePath)
rows_1,__=data_1.shape
rows_2,__=data_2.shape
data_1.insert(0,"label",[0]*rows_1)
data_2.insert(0,"label",[1]*rows_2)
data=pd.concat([data_1,data_2])
data=shuffle(data)
data=data.fillna(0)
x=data[data.columns[1:]]
y=data["label"]
colNames=x.columns
x=x.astype(np.float64)
x=StandardScaler().fit_transform(x)
x=pd.DataFrame(x)
x.columns=colNames

index=[]
for colName in data.columns[1:]:
    if levene(data_1[colName],data_2[colName])[1]>0.05:
        if ttest_ind(data_1[colName],data_2[colName])[1]<0.05:
            index.append(colName)
    else:
        if ttest_ind(data_1[colName],data_2[colName],equal_var=False)[1]<0.05:
             index.append(colName)
print(len(index))

 

 

 

欢迎分享,转载请注明来源:内存溢出

原文地址: http://outofmemory.cn/langs/715569.html

(0)
打赏 微信扫一扫 微信扫一扫 支付宝扫一扫 支付宝扫一扫
上一篇 2022-04-25
下一篇 2022-04-25

发表评论

登录后才能评论

评论列表(0条)

保存