问题遇到的现象和发生背景
算出来的余弦值大于1
用代码块功能插入代码,请勿粘贴截图
import xlrd
from math import pow
excle_file = r"我的文件地址"
data = xlrd.open_workbook(excle_file)
def get_unknow_centre(n): #矩阵中心化
table = data.sheet_by_name('Sheet3')
c = list(table.row_values(n-1))
sum_c = sum(c)
ave_c = sum_c/14
d = [x-ave_c for x in c]
return d
def get_know_centre(m):
table = data.sheet_by_name('Sheet3')
e = list(table.row_values(m-1))
sum_e = sum(e)
ave_e = sum_e/14
f = [x-ave_e for x in e]
return f
if __name__ == '__main__':
m = int(input('请输入对比到的行数:'))
n = int(input('请输入未知颜色的行数:'))
unknow_row_centre = get_unknow_centre(n)
know_row_centre = get_know_centre(m)
pow_unknow = pow((sum([w**2 for w in unknow_row_centre])),1/2)
pow_know = pow((sum([z**2 for z in know_row_centre ])),1/2)
Similarity = (sum([o*p for o in unknow_row_centre for p in know_row_centre if unknow_row_centre.index(o)==know_row_centre.index(p)]))/(pow_unknow * pow_know)
print(Similarity)
运行结果及报错内容
similarity值大于1 我想算的是两个向量的余弦值
我想要达到的结果
余弦值正常