擅长:python、mysql、java
<p>我最终能够通过以下方式做到这一点:</p>
<pre><code>df = A
tix = B
</code></pre>
<pre><code>ticker_2_CIK = dict(zip(tix.Ticker,tix.CIK)) # create a dict
tmp = df.reset_index().assign(CIK=lambda x: x['ticker'].map(ticker_2_CIK)) # use dict to find the correct value for colum
# data was unclean, some ticker symbols were created after the period my data is from
# and data was incomplete with some tickers missing
solution = tmp.dropna(subset=['CIK']).astype({'CIK':int})
</code></pre>