Skill 002

Requirements for Outputs

General Pivot Table Standards

Data Source Integrity

• Ensure that the data source for pivot tables is complete and well-structured to avoid errors.
• Pivot tables should not reference cells that contain errors or are blank.

Naming Conventions

• Use clear and descriptive names for pivot tables and their associated fields to enhance usability.

Pivot Table Creation Techniques

Basic Creation Steps

• Pivot tables should be created directly from well-structured data ranges.
• Example code snippet:

import pandas as pd

def create_pivot_table(df):
    pivot_table = df.pivot_table(values='Sales', index='Product', columns='Region', aggfunc='sum')
    return pivot_table

Advanced Modifications

• Users should be able to modify pivot tables to include calculated fields and filters as needed.
• Example code snippet:

def add_calculated_field(pivot_table):
    pivot_table['Profit'] = pivot_table['Sales'] - pivot_table['Cost']
    return pivot_table

Documentation and Validation Requirements

Metadata Inclusion

• Each pivot table must include metadata specifying its source data and any calculations performed.
• Example: "Pivot Table based on Sales Data from 2023 Q1."

Change Tracking

• Maintain a log of changes made to pivot tables to facilitate auditing and validation.

Source & license

This open-source skill is cataloged on AgentStack and links to its original source — we do not rehost the code.

• Author: legendtkl
• Source: legendtkl/agentic-skill-router
• License: MIT
• Homepage: https://legendtkl.github.io/agentic-skill-router/

Install and usage instructions live in the source repository linked above.