Series.map
Series.map(arg, na_action=None)
根据输入对应关系映射系列的值。
用于将Series中的每个值替换为另一个值,该值可能来自函数、dict或Series。
Parameters
| arg | 映射关系 |
|---|---|
| na_action | ignore:忽略NaN值 |
Example
import pandas as pddf = pd.DataFrame({'site':['google', 'baidu', 'wiki', 'pandas'],'color': ['red', 'black', None, 'red']})df.site = df.site.map({'google': 'facebook', 'baidu': 'bing'})df--------------------------------------------------------------------site color0 facebook red1 bing black2 NaN None3 NaN red
Example
import pandas as pddf = pd.DataFrame({'site':['google', 'baidu', 'wiki', 'pandas'],'color': ['red', 'black', None, 'red']})df.site = df.site.map('I like {}'.format)df------------------------------------------------------site color0 I like google red1 I like baidu black2 I like wiki None3 I like pandas red
Example
import pandas as pddf = pd.DataFrame({'site':['google', 'baidu', 'wiki', 'pandas'],'color': ['red', 'black', None, 'red']})df.color = df.color.map('I like {}'.format, na_action='ignore')dfsite color0 google I like red1 baidu I like black2 wiki None3 pandas I like red
Example
import pandas as pddf = pd.DataFrame({'site':['google', 'baidu', 'wiki', 'pandas'],'color': ['red', 'black', None, 'red']})df.color = df.color.map(lambda x: "blue" if x is None else x)dfsite color0 google red1 baidu black2 wiki blue3 pandas red
