import pandas as pd
from scipy import ndimage
import numpy as np
import xlrd
workbook = xlrd.open_workbook('D:\C盘\铅球\\111.xls')
sheet = workbook.sheet_by_index(0)
x = sheet.col_values(0)[1:]
y = sheet.col_values(1)[1:]
z = sheet.col_values(2)[1:]
print(x)
print(y)
print(z)
data = np.column_stack((x, y, z))
r = 1
smoothed_data = ndimage.gaussian_filter(data, sigma=(r,r, r), order=0)
print(smoothed_data)
