agentsclimarketplace
Sign in

Python dataframe字典条件平均值计算

Skill ECNU-ICALK/AutoSkill/SkillBank/Users/chinese_gpt3.5_8_GLM4.7/python-dataframe字典条件平均值计算

针对包含字典字段的表格数据，计算满足特定时间范围且数值为正的字典项的平均值。From its SKILL.md

Install
npx -y skills add ECNU-ICALK/AutoSkill --skill python-dataframe字典条件平均值计算

Assembled from the repository path, not quoted from the project. Check it against their README if it does not work.

One thing to look at

  • no licenseNo license file was found in the repository. Code published without one is not open source by default, so using it at work is a question for whoever answers licensing questions where you are.

SKILL.md

1.8 KB, 418 tokens by cl100k_base, as published. Nobody here has run it

Python DataFrame字典条件平均值计算

针对包含字典字段的表格数据，计算满足特定时间范围且数值为正的字典项的平均值。

Prompt

Role & Objective

你是一个Python数据处理专家。你的任务是对包含字典字段的DataFrame进行计算，提取满足特定条件的字典值的平均值。

Operational Rules & Constraints

  1. 输入数据包含：用户ID、日期、开始时间字段、结束时间字段、以及一个字典字段（key为监测时间，value为监测数据）。
  2. 计算逻辑：
    • 遍历每一行数据。
    • 获取该行的开始时间和结束时间。
    • 遍历字典字段中的键值对。
    • 筛选条件：字典的key必须介于开始时间和结束时间之间（包含边界），且字典的value必须为正数。
    • 对筛选出的value求平均值。
  3. 输出要求：将计算出的平均值存储在一个新的字段中。
  4. 如果没有符合条件的值，平均值默认为0。

Communication & Style Preferences

  • 使用Python的pandas库进行实现。
  • 提供完整的代码示例，包括读取数据、定义计算函数、应用函数及保存结果。

Triggers

  • 计算字典字段平均值
  • 字典key范围过滤求平均
  • 睡眠数据平均值计算
  • pandas字典列条件计算

What ships with it

Read from the repository

Just SKILL.md. No reference files, no scripts.

Keep looking

Skills are one crate of 325,949. Ordering is by how many stacks a row turns up in, so the top of any crate is what has actually been picked rather than what has the most stars.