import pandas as pd
import numpy as np
datafile = '../data/normalization_data.xls' # 参数初始化
data = pd.read_excel(datafile, header=None) # 读取数据
映射到0 − 100 0-1000−100区间>>> (data - data.min()) / (data.max() - data.min()) * (100 - 0) + 0# 最小-最大规范化
0 1 2 3
0 7.438017 93.729097 92.351974 100.000000
1 61.983471 0.000000 0.000000 85.094067
2 21.487603 11.956522 81.332237 0.000000
3 0.000000 100.000000 100.000000 56.367583
4 100.000000 94.230769 99.671053 80.414858
5 26.446281 83.862876 81.496711 90.931018
6 63.636364 84.698997 78.618421 92.957067
>>> (data - data.mean()) / data.std() # 零-均值规范化