我正在尝试使用从 csv 加载的数据计算 Pearson 系数相关性,当我运行我的代码时 - 我收到不匹配错误,不知道如何摆脱它。
这是 Python 3。我尝试将值存储在一个新变量中
def correl(filename, header_one, header_two):
df =pd.read_csv(filename)
df.columns = [header_one, header_two]
x= np.asarray(df[header_one])
y= np.asarray(df[header_two])
n_times_sum_of_x_times_y = len(x) * np.sum(np.multiply(x,y))
sum_of_x = np.sum(x)
sum_of_y = np.sum(y)
n_times_sum_of_x_squared = len(x) * np.sum(np.multiply(x, x))
n_times_sum_of_y_squared = len(x) * np.sum(np.multiply(y, y))
sum_of_x_squared = sum_of_x ** 2
sum_of_y_squared = sum_of_y ** 2
numerator = n_times_sum_of_x_times_y - sum_of_x * sum_of_y
denominator_squared = (n_times_sum_of_x_squared - sum_of_x_squared) * (n_times_sum_of_y_squared - sum_of_y_squared)
denominator = np.sqrt(denominator_squared)
p_correl_coefficient = (numerator / denominator)
return(p_correl_coefficient)
#print(correl("imdb.csv", 'gross', 'budget'))
我在运行代码时遇到的实际错误:
File "C:\Users\ruthi\Anaconda3\lib\site-packages\pandas\core\generic.py", line 638, in _set_axis self._data.set_axis(axis, labels)
File "C:\Users\ruthi\Anaconda3\lib\site-packages\pandas\core\internals\managers.py", line 155, in set_axis 'values have {new} elements'.format(old=old_len, new=new_len)) ValueError: Length mismatch: Expected axis has 23 elements, new values have 2 elements
请您参考如下方法:
这意味着在文件中您有 23 列,但您尝试仅使用 2 列重命名它们。如果 header_one 和 header_two 是现有列的名称,则执行 df = df[[header_one, header_two]],如果不是则首先选择两个您感兴趣的列,然后使用 df.columns = [header_one, header_two]
