pandas利用函数或映射进行数据转换_哪个函数可以做数据映射转换?-优快云博客

本文链接：https://blog.youkuaiyun.com/cuihuijun1hao/article/details/78249064

本文展示了如何使用pandas DataFrame的映射功能和lambda函数将'food'列转换为对应的动物来源。通过将食物名称转换为小写并查找对应的动物，创建了新的'animal'列。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

data = DataFrame({‘food’:[‘bacon’,’pull_pork’,’bacon’,’Pastrami’,’corned beef’,’Bacon’,’pastrami’,’honey ham’,’novs lox’],
‘ounces’:[4,3,12,6,7.5,8,3,5,6]})
print(data)
meat_to_animal = {
‘bacon’:’pig’,
‘pulled pork’:’pig’,
‘pastrami’:’cow’,
‘corned beef’:’cow’,
‘honey ham’:’pig’,
‘nova lox’:’salmon’
}
print(meat_to_animal)
data[‘animal’] = data[‘food’].map(str.lower).map(meat_to_animal)
print(data)
以上用的是映射的方式，我们也可以定义一个函数

import pandas as pd
from pandas import *
import numpy as np
data = DataFrame({‘food’:[‘bacon’,’pulled pork’,’bacon’,’Pastrami’,’corned beef’,’Bacon’,’pastrami’,’honey ham’,’nova lox’],
‘ounces’:[4,3,12,6,7.5,8,3,5,6]})
print(data)
meat_to_animal = {
‘bacon’:’pig’,
‘pulled pork’:’pig’,
‘pastrami’:’cow’,
‘corned beef’:’cow’,
‘honey ham’:’pig’,
‘nova lox’:’salmon’
}
result = data[‘food’].map(lambda x:meat_to_animal[x.lower()])
print(data)