Python的kemans聚类和数据标准化

Python的excel空间保存

pip install openpyxl -i https://pypi.tuna.tsinghua.edu.cn/simple/

程序代码如下

#-*- coding: utf-8 -*-
from openpyxl import Workbook
wb = Workbook()
# grab the active worksheet
ws = wb.active
# Data can be assigned directly to cells
ws['A1'] = 42
# Rows can also be appended
ws.append([1, 2, 3])
# Python types will automatically be converted
import datetime
ws['A2'] = datetime.datetime.now()
# Save the file
wb.save("sample.xlsx")

或者用以下方法将数据对象保存到excel中去

data.to_excel(zscoredfile, index = False) #数据写入

指定Excel的sheet读取数据

data1= pd.read_excel("C:\\Users\\Administrator\\Desktop\\V1_data.xlsx",sheet_name='Sheet3', encoding="gbk")

Python数据的标准化

#-*- coding: utf-8 -*-
#标准差标准化

import pandas as pd

datafil