擅长:python、mysql、java
<p>进行以下工作—</p>
<pre><code>df1 = df.unstack().reset_index()
df1.columns = ['dest1', 'dest2', 'workingdays']
#the second dataframe that you mention is the other_df
pd.merge(other_df,df1,how='left',on = ['dest1', 'dest2'])
</code></pre>
<pre><code>dest1 dest2 workingdays
0 DC DC 3 working days
1 DC NY 5 working days
2 DC SF 7 working days
3 DC AL 7 working days
4 NY DC 5 working days
5 NY NY 5 working days
6 NY SF 7 working days
7 NY AL 7 working days
8 SF DC 7 working days
9 SF NY 7 working days
10 SF SF 7 working days
11 SF AL 7 working days
12 AL DC 7 working days
13 AL NY 7 working days
14 AL SF 7 working days
15 AL AL 7 working days
</code></pre>