You need to enable JavaScript to run this app. Pandas按user_id与date分组判定question元素生成status列实现
优惠活动
大模型
产品
解决方案
定价
更多

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取值覆盖全部四个选项,标记为Complete
  • user_id=3、日期为09-01-2020的分组,question取值覆盖全部四个选项,标记为Complete
  • 其余所有分组均存在question取值缺失,对应行统一标记为Incomplete

内容的提问来源于stack exchange,提问作者Victorbug

相关产品推荐
方舟 Agent Plan

超全模态模型 × Harness 升级,最新支持 Deepseek-V4.1-Flash、GLM-5.3 系列、Doubao-Seedream-5.0-pro、Kimi-K3 (部分), 限时 9.9 元起

最近更新时间:2026.11.06 20:54:04