Conciseness

Mostly efficient — no explanation of pandas basics, terse MUST DO/MUST NOT lists, and dense code patterns. Minor trimming opportunities: the intro line 'Expert pandas developer specializing in efficient data manipulation...' duplicates the description, and the MUST NOT DO items on '.iterrows()' and chained indexing repeat the ❌ examples already shown in Code Patterns. Not 5: a few tokens don't earn their place; not 3: padding is minor and localized.

Actionability

Every pattern is fully executable and copy-paste ready: merge with 'validate="m:1"' and indicator-based unmatched-row reporting, named-argument groupby aggregation, resample/agg, pivot_table with margins, ffill/interpolate, and downcasting — covering the common pandas cases. Not 4: no gaps in executable detail for the common cases it targets.

Workflow Clarity

Core Workflow gives a clear five-step sequence (Assess → Design → Implement → Validate → Optimize) with assessment code in step 1 and explicit validation asserts in step 4 ('assert result.shape[0] == expected_rows', null and column checks). Not 5: checkpoints exist but there is no explicit error-recovery feedback loop (e.g., 'if asserts fail, fix the transform and re-validate'); not 3: validation is explicit, not merely implied.

Progressive Disclosure

The Reference Guide table signals all five references with topic and 'Load When' conditions, each file verified to exist in references/ (dataframe-operations, data-cleaning, aggregation-groupby, merging-joining, performance-optimization) — well-signaled, one level deep, with the body appropriately holding only core patterns. Not 4: navigation and content split are clean with no organization gaps.

Specificity

Lists multiple concrete actions — 'joining DataFrames on multiple keys, pivoting tables, resampling time series, handling NaN values with interpolation or forward-fill, groupby aggregations, type conversion, or performance optimization of large datasets' — matching the anchor 'multiple specific concrete actions; comprehensive coverage'. Not 4: coverage spans seven-plus specific operations with no notable gaps in the pandas domain.

Completeness

Explicitly answers both: 'Performs pandas DataFrame operations for data analysis, manipulation, and transformation' (what) and 'Use when working with pandas DataFrames, data cleaning, aggregation, merging, or time series analysis. Invoke for data manipulation tasks such as...' (when, with concrete trigger phrases). Not 4: both what and when are explicit and specific rather than merely present.

Trigger Term Quality

Natural terms users would actually say are comprehensively covered: 'pandas DataFrames', 'data cleaning', 'aggregation', 'merging', 'time series', 'groupby', 'pivoting tables', 'NaN', plus synonyms ('data analysis, manipulation, and transformation'). Not 4: only file extensions are absent, which are inapplicable to a library-domain skill; common variations users say are present.

Distinctiveness Conflict Risk

Clear niche anchored to 'pandas DataFrame operations' with domain-distinct triggers (groupby, resampling, forward-fill, pivoting). Matches the score-5 anchor example's structure. Not 4: overlap risk is minimal — even generic-sounding triggers ('data cleaning', 'type conversion') are framed within pandas DataFrame work, and a 'Use when working with pandas' scoping clause is present.