Series.map

Series.map(arg, na_action=None)
根据输入对应关系映射系列的值。
用于将Series中的每个值替换为另一个值,该值可能来自函数、dict或Series。

Parameters

arg 映射关系
na_action ignore:忽略NaN值

Example

  1. import pandas as pd
  2. df = pd.DataFrame({'site':['google', 'baidu', 'wiki', 'pandas'],
  3. 'color': ['red', 'black', None, 'red']})
  4. df.site = df.site.map({'google': 'facebook', 'baidu': 'bing'})
  5. df
  6. --------------------------------------------------------------------
  7. site color
  8. 0 facebook red
  9. 1 bing black
  10. 2 NaN None
  11. 3 NaN red

Example

  1. import pandas as pd
  2. df = pd.DataFrame({'site':['google', 'baidu', 'wiki', 'pandas'],
  3. 'color': ['red', 'black', None, 'red']})
  4. df.site = df.site.map('I like {}'.format)
  5. df
  6. ------------------------------------------------------
  7. site color
  8. 0 I like google red
  9. 1 I like baidu black
  10. 2 I like wiki None
  11. 3 I like pandas red

Example

  1. import pandas as pd
  2. df = pd.DataFrame({'site':['google', 'baidu', 'wiki', 'pandas'],
  3. 'color': ['red', 'black', None, 'red']})
  4. df.color = df.color.map('I like {}'.format, na_action='ignore')
  5. df
  6. site color
  7. 0 google I like red
  8. 1 baidu I like black
  9. 2 wiki None
  10. 3 pandas I like red

Example

  1. import pandas as pd
  2. df = pd.DataFrame({'site':['google', 'baidu', 'wiki', 'pandas'],
  3. 'color': ['red', 'black', None, 'red']})
  4. df.color = df.color.map(lambda x: "blue" if x is None else x)
  5. df
  6. site color
  7. 0 google red
  8. 1 baidu black
  9. 2 wiki blue
  10. 3 pandas red