擅长:python、mysql、java
<p>支持你的数据是这样的</p>
<pre><code>df=pd.DataFrame({'VenueCategory':['drink','wine','MOMA','MTA','sushi','Hudson']})
Bar=['drink','wine','alcohol']
Museum_ArtGallery=['MOMA','MCM']
Public_Transport=['MTA','MBTA']
Restaurant_FoodVenue=['sushi','chicken']
</code></pre>
<p>准备字典:</p>
<pre><code>from collections import defaultdict
d=defaultdict(lambda:'other')
d.update({x:'Bar' for x in Bar})
d.update({x:'Museum_ArtGallery' for x in Museum_ArtGallery})
d.update({x:'Public_Transport' for x in Public_Transport})
d.update({x:'Restaurant_FoodVenue' for x in Restaurant_FoodVenue})
</code></pre>
<p>生成新列并打印结果:</p>
<pre><code>df['BroadCategory']=df['VenueCategory'].apply(lambda x:d[x])
df
</code></pre>