Menu
用于在Pandas DataFrame执行合并操作后，清理由merge产生的后缀列（_x, _y）和指示列，使其符合数据库表结构以便进行to_sql插入操作。
The review-first prompt is selected by default. You can switch to a direct command or download a local copy.
Read SKILL.md and any companion files shown by SkillsMP before deciding whether to install.
Install with Codex or Claude Copy this prompt, paste it into Codex, Claude, or another assistant, and let it review the skill page and install it for you.
A direct command skips the review prompt. Inspect the source before running it.
npx skills add https://github.com/ECNU-ICALK/AutoSkill --skill dataframeThe command stays on one line. Scroll horizontally to inspect it before copying.
Prefer a local copy? Download the files currently available to SkillsMP.
Based on SOC occupation classification
Manage personal local Agent Skill files as an installable skill manager. Proactively and periodically detect reusable user-specific, team-specific, or broadly reusable skill material during or after meaningful sessions; run non-blocking extraction checks; offer candidate skill titles or accept a user-supplied topic when extraction direction is ambiguous; preserve the appropriate output language; search local and external skill ecosystems for similar skills; score candidates by evidence, recurrence, personal value, and portability; fully draft proposed skills or diffs before asking for approval; then, after explicit user approval, discard, improve, merge, or create `SKILL.md` folders.
布置结构化家庭作业，引导求助者记录现实互动事件、自动思维及情绪反应，并设计简易验证行动（如主动询问、观察反证），用于检验投射性认知偏差。适用于已识别出具体非理性信念（如‘别人肯定不喜欢我’）且情绪稳定者。
结构化8次CBT咨询流程，按评估性会谈→咨询性会谈→巩固性会谈三阶段推进，整合悬搁接地技术与认知行为策略，专用于强迫症伴轻度抑郁状态、具自省力与作业执行力的成年来访者。
Showing SKILL.md
| id | 28d7d005-d3d1-4cb0-b3b3-fbfb5da49fc0 |
| name | DataFrame合并后的列清理与数据库插入准备 |
| description | 用于在Pandas DataFrame执行合并操作后，清理由merge产生的后缀列（_x, _y）和指示列，使其符合数据库表结构以便进行to_sql插入操作。 |
| version | 0.1.0 |
| tags | ["pandas","dataframe","merge","database","sql","data-cleaning"] |
| triggers | ["清理merge后的_x_y列","dataframe to_sql 列名不匹配","pandas merge 数据库插入","合并数据后准备插入数据库","Unknown column in field list"] |
用于在Pandas DataFrame执行合并操作后，清理由merge产生的后缀列（_x, _y）和指示列，使其符合数据库表结构以便进行to_sql插入操作。
你是一个数据处理专家。你的任务是处理经过Pandas merge操作后的DataFrame，清理多余的列和后缀，使其准备好用于数据库插入（to_sql）。
pd.merge(df, existing_data, on=primary_key, how='outer', indicator=True) 合并了数据。你需要筛选出 _merge 列值为 'left_only' 的行，这些是需要插入的新数据。_merge 列。_x 结尾的列重命名，去掉 _x 后缀（例如 attack_x 变为 attack）。这些列包含来自左侧DataFrame（新数据）的值。_y 结尾的列。这些列包含来自右侧DataFrame（旧数据）的值，插入新数据时不需要。_x、_y 或 _merge 相关的列，列名必须与数据库表结构完全一致。df 上尝试删除 _x 或 _y 列，这些列只存在于 merge 后的结果中。_x 后缀的列名进行 to_sql 操作，这会导致“Unknown column”错误。_merge 列。left_only 行。