csv数据下载连接:https://pan.baidu.com/s/1KTS5WzfH4z9Y4U4rIG-3Ig
代码:
import numpy as np
import matplotlib.pyplot as plt
import pandas as pd
from sklearn.cluster import KMeans # 引入机器学习
# 用来正常显示中文
plt.rcParams['font.sans-serif'] = ['SimHei']
# 用来正常显示符号
plt.rcParams['axes.unicode_minus'] = False
class GuPiaoData():
def detedData(self,filePath): # 探索数据
df = pd.read_csv(filePath)
# print(df)
describe = df.describe(include='all')
# print(describe.T)
df.to_excel('data/Gupiaodata01.xls')
describe.T.to_excel('data/gupiaodata_desc