#encoding = utf-8

#标准差标准化
import pandas as pd
datafile = '../data/zscoredata.xls'
zscoredfile = '../tmp/zscoreddata.xls'

data = pd.read_excel(datafile)
data = (data - data.mean(axis=0)) / (data.std(axis=0))

data.columns = ['Z' + i for i in data.columns]
data.to_excel(zscoredfile, index=False)


ad2b5ef19265dbcfd8ce9d27c976b6ca79be0150
<mask token>

<mask token>
data.to_excel(zscoredfile, index=False)

<mask token>
datafile = '../data/zscoredata.xls'
zscoredfile = '../tmp/zscoreddata.xls'
data = pd.read_excel(datafile)
data = (data - data.mean(axis=0)) / data.std(axis=0)
data.columns = [('Z' + i) for i in data.columns]
data.to_excel(zscoredfile, index=False)

import pandas as pd
datafile = '../data/zscoredata.xls'
zscoredfile = '../tmp/zscoreddata.xls'
data = pd.read_excel(datafile)
data = (data - data.mean(axis=0)) / data.std(axis=0)
data.columns = [('Z' + i) for i in data.columns]
data.to_excel(zscoredfile, index=False)

#encoding = utf-8

#标准差标准化
import pandas as pd
datafile = '../data/zscoredata.xls'
zscoredfile = '../tmp/zscoreddata.xls'

data = pd.read_excel(datafile)
data = (data - data.mean(axis=0)) / (data.std(axis=0))

data.columns = ['Z' + i for i in data.columns]
data.to_excel(zscoredfile, index=False)

