擅长:python、mysql、java
<p>假设您想知道A列中的名称是否在Excel C列的列表中。你知道吗</p>
<pre><code>df['Boolean'] = df['id'].isin(list(df_advisor['company_id'])
df['auditor_compensation'] = ''
df.loc[df['Boolean'] == False, 'auditor_compensation'] = '0 disclosed'
df.loc[df['Boolean'] == True, 'auditor_compensation'] = 'Independent'
</code></pre>