数据规范化主要有三种,原理参见https://blog.csdn.net/qq_18888869/article/details/83898566
代码必须用print输出,否则看不到结果:
import pandas as pd
import numpy as np
datafile = 'D:\Python练习使用数据/normalization_data.xls'
data = pd.read_excel(datafile, header=None)
print('原始数据是:\n', data)
print('最小最大规范化:\n', (data - data.min()) / (data.max() - data.min()))
print('零-均值规范化:\n', (data -data.mean()) / data.std())
print('小数定标规范化:\n', data / 10**np.ceil(np.log10(data.abs().max())))
运行结果为: