data = pd.read_excel(r'C:\Users\Administrator\Desktop\sales_data.xls',index_col = '序号')
data['天气']= data['天气'].map({'坏':0,'好':1})
data['是否周末'] = data['是否周末'].map({'是':1,'否':0})
data['是否有促销'] = data['是否有促销'].map({'是':1,'否':0})
data['销量'] = data['销量'].map({'高':1,'低':0})
x = data.iloc[:,:3]
y = data.iloc[:,3]
from keras.models import Sequential
from keras.layers.core import Dense,Activation
model = Sequential()
model.add(Dense(input_dim = 3,output_dim = 10))#显式指出input_dim、output_dim
model.add(Activation('relu'))
model.add(Dense(input_dim = 10,output_dim = 1))
model.add(Activation('sigmoid'))
model.compile(loss = 'binary_crossentropy',optimizer = 'adam')
model.fit(x,y,nb_epoch = 1000,batch_size = 10)
yp = model.predict_classes(x)
y_1 = yp.reshape(len(y))#注意reshape
print(sum(y_1 ==y)/len(y))
0.7647058823529411