擅长:python、mysql、java
<pre class="lang-py prettyprint-override"><code>import numpy as np
import pandas as pd
#make a list of all the names with bad loans:
names = df[df["bad_loan"]=="Yes"]["name_client"]
#set bad loan to yes if name in list
df["bad_loan"] = np.where(df["name_client"].isin(names),"Yes","No")
</code></pre>