擅长:python、mysql、java
<p>这对你有用。必须去掉“Job”列或删除列之间的txt文件中的空白。你知道吗</p>
<pre><code>import pandas as pd
xls = pd.read_excel('sample2.xlsx')
csv_df = pd.read_csv('sample.txt', header=None)
csv_df.columns = ['Age', 'Job']
csv_df['Job'] = csv_df['Job'].map(str.strip)
xls = xls.merge(csv_df, on='Job')
print(xls)
</code></pre>