# _*_ coding:utf-8 _*_
import numpy as np
import pandas as pd
import matplotlib
import matplotlib.pyplot as plt
from pandas import to_datetime
#引入sklearn框架,导入k-means聚类算法
from sklearn.cluster import KMeans
#from sklearn.manifold import
inputfile = r'transformdata.xls' #待聚类的数据文件
outputfile = r'data_type.xls'
#读取数据并进行聚类分析
data = pd.read_excel(inputfile, skiprows=2)
# print(data