擅长:python、mysql、java
<pre><code>import pandas as pd
#Replace all those localities with 'San Francisco'. For this we use .isin() function
df.loc[df['address'].isin(pd.Series(['Duboce Park','Twin Peaks','Bernal Heights','Holly Courts','Ocean Beach'])),'city']='San Francisco'
#Replace all NaNs with 'New York' with fillna().
df = df.fillna('New York')
df
Out[47]:
address city
0 BlockOf13thSt Treasure Isla
1 Lincoln Presidio
2 Duboce Park San Francisco
3 Twin Peaks San Francisco
4 Bernal Heights San Francisco
5 Holly Courts San Francisco
6 Ocean Beach San Francisco
7 Maiden Ln New York
8 Avenue N New York
</code></pre>