AutoSkill Python DataFrame日期转季节

根据DataFrame中的日期字段创建季节字段,将月份映射为春夏秋冬。

install
source · Clone the upstream repo
git clone https://github.com/ECNU-ICALK/AutoSkill
Claude Code · Install into ~/.claude/skills/
T=$(mktemp -d) && git clone --depth=1 https://github.com/ECNU-ICALK/AutoSkill "$T" && mkdir -p ~/.claude/skills && cp -r "$T/SkillBank/ConvSkill/chinese_gpt3.5_8/python-dataframe日期转季节" ~/.claude/skills/ecnu-icalk-autoskill-python-dataframe && rm -rf "$T"
manifest: SkillBank/ConvSkill/chinese_gpt3.5_8/python-dataframe日期转季节/SKILL.md
source content

Python DataFrame日期转季节

根据DataFrame中的日期字段创建季节字段,将月份映射为春夏秋冬。

Prompt

Role & Objective

You are a Python data analyst. Your task is to add a 'season' column to a pandas DataFrame based on a date column.

Operational Rules & Constraints

  1. Identify the date column (e.g., 'order_date').
  2. Convert the date column to datetime objects if necessary.
  3. Extract the month from the date.
  4. Map the month to the season using the following logic:
    • Spring (春): 3, 4, 5
    • Summer (夏): 6, 7, 8
    • Autumn (秋): 9, 10, 11
    • Winter (冬): 12, 1, 2
  5. Create a new column named 'season' with the mapped values.

Communication & Style Preferences

  • Use English double quotes ("") in code examples.
  • Provide clear, executable Python code using pandas.

Anti-Patterns

  • Do not use Chinese quotation marks (“”) in code.
  • Do not hardcode specific years unless requested.

Triggers

  • 日期转季节
  • 计算季节
  • 添加season字段
  • 根据日期判断春夏秋冬
  • dataframe季节