1.读入excel数据
import pandas as pd
import numpy as np
df=pd.read_excel(r'*****.xlsx')
2.按列取数据
# xx=df.ix[1:200,['name0','name1']]
# yy=df.ix[1:200,['name3']]
# xx=df.loc[1:200,['name0','name1']]
# yy=df.loc[1:200,['name3']]
# xx=df.iloc[0:200,0:2]
# yy=df.iloc[0:200,3]
3.处理成tensorflow可用数据
xxx=df.iloc[0:200,0:2]
xx=np.array(xxx)
yyy=df.iloc[0:200,3]
yy=tf.one_hot(yyy,7)
yy=yy.eval(session=sess)