R语言如何为分类变量的每个取值生成对应列,值取关联的Insurance字段内容
实现方案
你之前尝试转置、cbind、merge没成功的核心原因是没有为不同教育水平分组的行添加对齐标识,直接拼接会出现行列不匹配的问题,按以下代码即可实现需求:
R语言实现
library(tidyverse) # 你的原始数据可直接读取,此处为模拟示例 homes <- tibble( `Education level` = c("Primary", "Primary", "Primary", "College", "College", "High-Sch", "High-Sch", "Terciary"), Insurance = c("YES", "NO", "NO", "YES", "YES", "YES", "NO", "YES") ) # 核心处理逻辑 result <- homes %>% group_by(`Education level`) %>% mutate(row_id = row_number()) %>% # 为每个分组内的行添加序号,用于后续对齐 ungroup() %>% pivot_wider( id_cols = row_id, names_from = `Education level`, values_from = Insurance ) %>% select(-row_id) # 不需要行号可直接删除
如果需要把缺失值替换为其他内容,可在pivot_wider中添加values_fill = "你需要的填充值"参数调整。
Python实现
import pandas as pd # 你的原始数据可直接读取,此处为模拟示例 homes = pd.DataFrame({ "Education level": ["Primary", "Primary", "Primary", "College", "College", "High-Sch", "High-Sch", "Terciary"], "Insurance": ["YES", "NO", "NO", "YES", "YES", "YES", "NO", "YES"] }) # 核心处理逻辑 homes["row_id"] = homes.groupby("Education level").cumcount() # 为每个分组内的行添加序号 result = homes.pivot(index="row_id", columns="Education level", values="Insurance").reset_index(drop=True)
如果需要修改列名或者替换缺失值,可后续操作result.columns和result.fillna方法调整。
内容的提问来源于stack exchange,提问作者AgusDam87
相关产品推荐
相关产品推荐

