Skip to main content
 首页 » 编程设计

python之ValueError : Length mismatch: Expected axis has 23 elements, 新值有 2 个元素。 Pandas 长度不匹配

2024年11月01日13lautakyan007

我正在尝试使用从 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]

重命名它们