擅长:python、mysql、java
<p>我假设“用户电话号码”需要“us_pn”作为变量。我还假设代码不需要返回任何值</p>
<pre><code>import pandas as pd
import os
file1= 'C:/Users/madhu/Desktop/Excel1.xlsx'
file2= 'C:/Users/madhu/Desktop/Book1.xlsx'
df1 = pd.read_excel(file1)
df2 = pd.read_excel(file2)
# Uncomment the following piece of code if the excel files have nan.
# df2.fillna('0', inplace=True)
print(df2)
for row2 in df2.values:
word_list = list(row2[0].split(' '))
# This is to handle the special case of 'user phone number'
# with output of 'us_pn'.
# If the desired output is otherwise
# 'us_ph_num', then this piece of code is not needed.
if 'phone number' in row2[0]:
word_list[word_list.index('phone')] = 'phone number'
word_list[word_list.index('number')] = ''
var_list = []
for word in word_list:
for row1 in df1.values:
if word == row1[0]:
var_list.append(row1[1])
row2[1] = "_".join(var_list)
</code></pre>
<p>如果我的假设有任何错误,那么一定要让我知道,我会相应地修改代码</p>