该楼层疑似违规已被系统折叠 隐藏此楼查看此楼
import pandas as pd
import numpy as np
path1 = r'C:\Users\user\Desktop\radar.xls'
path2 = r'C:\Users\user\Desktop\fakepoint.xls'
radar_data = pd.read_excel(path1)
fakepoint_data = pd.read_excel(path2)
print(radar_data)
print('*'*100)
print(fakepoint_data)
List1 = []
for i in range(5):
for j in range(3):
List.append(radar_data.iloc[i, j])
data = [List1[i:i+3] for i in range(0, len(List1), 3)]
print(data)
List2 = []
for i in range(20):
for j in range(3):
List2.append(fakepoint_data.iloc[i, j])
data2 = [List2[i:i+3] for i in range(0, len(List2), 3)]
print(data2)
for i in range(0,len(data)):
print(i)
print(data[i])
for j in range(0,19):
print(j)
print(data2[j])
data2.pop(j)
print(data2)
for k in range(0,18):
data2.pop(k)
print(data2[k])
for l in range(0,17):
print(data2[l])
a = data[i]-data2[j]
b = data[i]-data2[k]
c = data[k]-data2[l]
d = np.dot(a,np.cross(b, c).T)