Pandas按user_id与date分组判定question元素生成status列实现
Pandas 状态列生成实现方案
核心判定规则
- 以
user_id和date的配对组合作为分组依据,拆分全表数据 - 对每个分组下的
question列取值去重,检查是否同时存在a、b、c、d四个元素 - 满足判定条件的分组,所有对应行标记为Complete;不满足的分组,所有对应行标记为Incomplete
- 借助
transform方法将分组计算结果直接映射回原表行,避免手动做索引对齐
实现代码
import pandas as pd # 初始化测试数据 df = pd.DataFrame({ 'user_id': [1,1,1,1,1,1,1,2,2,2,2,2,2,2,3,3,3,3,3,3,3,4,4,4,4,4,4], 'date': [ "01-01-2020","01-01-2020","01-01-2020","01-01-2020","02-01-2020","02-01-2020","03-01-2020", "04-01-2020","04-01-2020","04-01-2020","05-01-2020","05-01-2020","06-01-2020","06-01-2020", "07-01-2020","08-01-2020","08-01-2020","09-01-2020","09-01-2020","09-01-2020","09-01-2020", "10-01-2020","10-01-2020","11-01-2020","11-01-2020","12-01-2020","12-01-2020" ], 'question': [ "a","b","c","d","a","b","a","a","b","c","a","b","a","b","a","a","b","a","b","c","d","a","b","a","b","a","b" ] }) # 定义需匹配的问题集合 required_questions = {"a", "b", "c", "d"} # 分组判定状态并生成新列 df['status'] = df.groupby(['user_id', 'date'])['question'].transform( lambda s: "Complete" if set(s) == required_questions else "Incomplete" )
匹配结果说明
代码运行生成的status列与预期输出完全一致:
user_id=1、日期为01-01-2020的分组,question取值覆盖全部四个选项,标记为Completeuser_id=3、日期为09-01-2020的分组,question取值覆盖全部四个选项,标记为Complete- 其余所有分组均存在question取值缺失,对应行统一标记为Incomplete
内容的提问来源于stack exchange,提问作者Victorbug
相关产品推荐
相关产品推荐

