30 lines
736 B
Python
30 lines
736 B
Python
import pandas as pd
|
|
import xlsxwriter
|
|
|
|
|
|
def matrixToxls(matrix, filename):
|
|
workbook = xlsxwriter.Workbook(filename)
|
|
worksheet = workbook.add_worksheet()
|
|
row = 0
|
|
for col, data in enumerate(matrix):
|
|
worksheet.write_column(row, col, data)
|
|
workbook.close()
|
|
|
|
|
|
def exulidean(row1, row2):
|
|
s = 0
|
|
for p, q in zip(row1, row2):
|
|
s += ((p - q) ** 2)
|
|
return s ** 0.5
|
|
|
|
|
|
if __name__ == "__main__":
|
|
df = pd.read_excel('dataset2.xls', sheet_name="forestfires").to_numpy()
|
|
resultEculidean = []
|
|
for row in df:
|
|
tmp = []
|
|
for row2 in df:
|
|
tmp.append(exulidean(row, row2)) # [0,x, ]
|
|
resultEculidean.append(tmp)
|
|
matrixToxls(resultEculidean, "eculidean.xls")
|