import pandas as pd
from sklearn.tree import export_graphviz
from sklearn.externals.six import StringIO
from sklearn.tree import DecisionTreeClassifier as DTC
filename = 'E:/百度下载视频/Python数据分析与挖掘实战/chapter5/demo/data/sales_data.xls'
data = pd.read_excel(filename, index_col=u'序号')
data[data == u'好'] = 1
data[data == u'是'] = 1
data[data == u'高'] = 1
data[data != 1] = -1
x = data.iloc[:, :3].values.astype(int)
y = data.iloc[:, :3].values.astype(int)
dtc = DTC(criterion='entropy')
dtc.fit(x, y)
x = pd.DataFrame(x)
with open("E:/百度下载视频/Python数据分析与挖掘实战/chapter5/demo/data/tree.dot", 'w') as f:
f = export_graphviz(dtc, feature_names=x.columns, out_file=f)