有人可以帮助我处理此错误消息“ValueError:无法将字符串转换为float:'X'”

Question

我需要得到一个标准矩阵，但我有一些问题。。。这是我的密码：

import pandas as pd
df = pd.read_excel(r'C:/Users/DESICHRIS/Desktop/INPUT.xlsx')
df.as_matrix()
print (df)
from sklearn.preprocessing import StandardScaler
# Get column names first
names = df.columns
# Create the Scaler object
scaler = StandardScaler().fit_transform(df)
# Fit your data on the scaler object
scaled_df = scaler.fit_transform(df)
scaled_df = pd.DataFrame(scaled_df, columns=names)
print (scaled_df)

Python显示错误消息，如上所示：

File "c:/Users/DESICHRIS/Desktop/ATUAL TESE DESIREE/pesquisa Desiree/python/mteste.py", line 11, in 
scaled_df = scaler.fit_transform(df)
File "C:\Users\DESICHRIS\AppData\Local\Programs\Python\Python37-32\lib\site-packages\sklearn\base.py", line 464, in fit_transform
return self.fit(X, **fit_params).transform(X)
File "C:\Users\DESICHRIS\AppData\Local\Programs\Python\Python37-32\lib\site-packages\sklearn\preprocessing\data.py", line 645, in fit
return self.partial_fit(X, y)
File "C:\Users\DESICHRIS\AppData\Local\Programs\Python\Python37-32\lib\site-packages\sklearn\preprocessing\data.py", line 669, in partial_fit
force_all_finite='allow-nan')
File "C:\Users\DESICHRIS\AppData\Local\Programs\Python\Python37-32\lib\site-packages\sklearn\utils\validation.py", line 527, in check_array
array = np.asarray(array, dtype=dtype, order=order)
File "C:\Users\DESICHRIS\AppData\Local\Programs\Python\Python37-32\lib\site-packages\numpy\core\numeric.py", line 538, in asarray
return array(a, dtype, copy=False, order=order)
ValueError: could not convert string to float: 'X'

有人能帮我吗

Answer 1

在您的数据帧中，有些值被标记为“X”，而不是浮点数。 您可以使用以下方法删除它们：

df = df.drop(df[(df.name_of_column == 'X')].index)