About

Imported from gabrielmoreira/agent-skills-mirror (mirrors/repos/ECNU-ICALK@AutoSkill/SkillBank/ConvSkill/english_gpt4_8/time-series-imputation-feasibility-analysis/SKILL.md). Install upstream with npx skills add gabrielmoreira/agent-skills-mirror --skill time-series-imputation-feasibility-analysis. Copyright stays with the author.

Time Series Imputation Feasibility Analysis

Name: Time Series Imputation Feasibility Analysis
Author: gabrielmoreira

Analyze the feasibility of imputing missing data for short time series by checking date alignment with similar series based on shared key columns using Polars.

Prompt

Role & Objective

You are a Data Analyst using the Polars library in Python. Your task is to analyze the feasibility of imputing missing data points for short time series by checking if their dates align with similar series.

Operational Rules & Constraints

Filter Short Series: Filter the series lengths DataFrame to identify series with data points less than or equal to a specified threshold (e.g., 15).
Retrieve Full Data: Join the filtered series IDs back to the main dataset (e.g., dataset_newitem) using an inner join to get the full rows for these limited series.
Aggregate Date Info: Group the limited data by the series identifier (e.g., unique_id). Collect the list of dates, minimum date, and maximum date. Use pl.col('date_column').collect_list() to create lists, not .list().
Identify Similar Series: Join the limited series data back to the full dataset on specific key columns (e.g., MaterialID, SalesOrg, DistrChan) to find similar series. Do not split concatenated IDs if raw columns are available in the source dataset.
Collect Neighbor Data: Group by the original series identifier and collect the dates and quantities (e.g., OrderQuantity) from the similar series to assess overlap.

Anti-Patterns

Do not split concatenated string IDs (like unique_id) if the original component columns (e.g., MaterialID, SalesOrg) exist in the source DataFrame.
Do not use pl.col().list() for aggregation; use pl.col().collect_list().

Triggers

check if imputation is feasible
analyze similar series dates
find similar series for backfill
check date alignment for short time series

Use it

Copy one of these into your project. Installing also returns the manifest and these snippets.

yaml

targets:
  - https://api.opensmartroute.ai/api/v1/registry/gabrielmoreira-agent-skills-mirror-time-series-imputatio-3841b5/manifest   # or paste the manifest below

Manifest

An Open Capability Manifest: the router reads it to know what this does, what it costs and when to pick it.

gabrielmoreira-agent-skills-mirror-time-series-imputatio-3841b5.ocm.jsonjson

{
  "ocm": "1",
  "id": "gabrielmoreira-agent-skills-mirror-time-series-imputatio-3841b5",
  "kind": "skill",
  "name": "Time Series Imputation Feasibility Analysis",
  "description": "Analyze the feasibility of imputing missing data for short time series by checking date alignment with similar series based on shared key columns using Polars.",
  "publisher": "gabrielmoreira",
  "version": "1.0.0",
  "capabilities": {
    "domains": [
      "general"
    ],
    "tags": [
      "skill-md",
      "polars",
      "time-series",
      "data-imputation",
      "data-analysis",
      "python",
      "github"
    ],
    "languages": [
      "en"
    ]
  },
  "quality_prior": 0.6,
  "examples": [
    "Analyze the feasibility of imputing missing data for short time series by checking date alignment with similar series based on shared key columns using Polars."
  ],
  "primary": false,
  "metadata": {
    "source": {
      "provider": "github",
      "repository": "https://github.com/gabrielmoreira/agent-skills-mirror",
      "path": "mirrors/repos/ECNU-ICALK@AutoSkill/SkillBank/ConvSkill/english_gpt4_8/time-series-imputation-feasibility-analysis/SKILL.md",
      "ref": "d5c793801e2fc9c29aa3531805809b3460b19d09",
      "url": "https://github.com/gabrielmoreira/agent-skills-mirror/blob/d5c793801e2fc9c29aa3531805809b3460b19d09/mirrors/repos/ECNU-ICALK@AutoSkill/SkillBank/ConvSkill/english_gpt4_8/time-series-imputation-feasibility-analysis/SKILL.md",
      "key": "gabrielmoreira/agent-skills-mirror/mirrors/repos/ECNU-ICALK@AutoSkill/SkillBank/ConvSkill/english_gpt4_8/time-series-imputation-feasibility-analysis/SKILL.md"
    }
  },
  "instructions": "# Time Series Imputation Feasibility Analysis\n\nAnalyze the feasibility of imputing missing data for short time series by checking date alignment with similar series based on shared key columns using Polars.\n\n## Prompt\n\n# Role & Objective\nYou are a Data Analyst using the Polars library in Python. Your task is to analyze the feasibility of imputing missing data points for short time series by checking if their dates align with similar series.\n\n# Operational Rules & Constraints\n1. **Filter Short Series**: Filter the series lengths DataFrame to identify series with data points less than or equal t",
  "cost": {
    "context_tokens": 471
  }
}

Fetch it by URL: GET /api/v1/registry/gabrielmoreira-agent-skills-mirror-time-series-imputatio-3841b5/manifest?version=1.0.0

Reviews

Star ratings from people who tried it. One review per account; edit yours any time.

No reviews yet. Install it, try it, and be the first to rate it.