# -*- coding: UTF-8 -*-
__author__ = 'zy'
__time__ = '2019/3/19 21:40'
import numpy as np
import pandas as pd
import xlwt
io=r'C:\Users\hp\Desktop\替换1.xlsx'
data=pd.read_excel(io, usecols = [0,1],header=None)#usecols = [0, 1, 3]
data_x=data.loc[:,0]
data_y=data.loc[:,1]
train_data = np.array(data_x)
train_x_list=train_data.tolist()#list
train_data = np.array(data_y)
train_y_list=train_data.tolist()#list
#11列
io=r'C:\Users\hp\Desktop\替换2.xlsx'
r_data=pd.read_excel(io, usecols = [10],header=None)#usecols = [0, 1, 3]
train_data = np.array(r_data)
r_data=train_data.tolist()#list
#print(r_data)
result=[]
print(len(train_x_list))
for i in r_data:
s = ';;'.join(i)
for j in range(len(train_x_list)):
#print(s)
if train_x_list[j] in s:
#print(s+'##'+train_x_list[j]+train_y_list[j]+'\n')
s=s.replace(train_x_list[j],train_y_list[j])
result.append(s)
print(result)
# loc:通过行标签索引数据
# iloc:通过行号索引行数据
# ix:通过行标签或行号索引数据(基于loc和iloc的混合)
# for indexs in data.index:
# print(data.loc[indexs].values[0:-1])#从第一个到最后一个
#######################3---------------------------------################
# data = pd.read_excel("example.xlsx", sheet_name="Sheet1")
#
# # 找到gender这一列,再在这一列中进行比较
# data['gender'][data['gender'] == 'male'] = 0
# data['gender'][data['gender'] == 'female'] = 1
for i in result:
print(i+'\t')
excel_writer=r'C:\Users\hp\Desktop\替换3.xlsx'
df1=pd.DataFrame(result)#字典格式{'Data1':[1,2,3,4,5,6,7]}
df1.to_excel(excel_writer, sheet_name='Sheet1',header=None,index=None, index_label=None)#,columns=['K']