Skip to main content
affpapa.org
RU EN
skill CX Codex

pandas — Claude Code skill: support ticket analytics

A skill that brings pandas expertise to support operations: SLA compliance, agent metrics, PostgreSQL pulls. Useful when you need to dig through tickets and build a report.

Install into Claude Code · Skills CLI (Vercel) All methods and platforms ↓ 
npx skills add manutej/luxor-claude-marketplace --skill pandas -a claude-code
Open on GitHub

What pandas does

The skill gives the agent pandas patterns aimed at customer support: DataFrame operations, .loc[] and .iloc[] indexing, the query method, multi-level indexes, time series work. It ships with ready-made function templates — first response and resolution times, SLA checks split by priority, ticket volume resampled by period with rolling averages, and per-agent metrics covering CSAT and reopen rate.

There is a separate section on PostgreSQL through SQLAlchemy: building the connection engine and loading tickets with a date filter. Dependencies are listed in the skill itself: pandas>=2.2.0, sqlalchemy>=2.0.0, psycopg2-binary>=2.9.0, numpy>=1.26.0, openpyxl>=3.1.0, pytest>=8.0.0. Install them first. Without psycopg2-binary the PostgreSQL connection will not come up, and without openpyxl you get no Excel export.

The skill targets several platforms: Claude, Codex, Cursor, GitHub Copilot, Gemini CLI and OpenCode. Each has its own install path and its own SKILL.md location.

What it helps with

  • measure first response and resolution time per ticket
  • check whether support meets SLA targets by priority
  • build weekly volume trends with rolling averages
  • compare agents on CSAT and reopen rate
  • pull tickets from PostgreSQL into a DataFrame and export a report to Excel

Example prompts for the agent

  • Compute SLA compliance for last month's tickets, broken down by priority
  • Build agent metrics: average response time, CSAT, reopen rate
  • Load tickets from PostgreSQL for the quarter and chart the weekly trend

How to install pandas

1Skills CLI (Vercel)

npx skills add manutej/luxor-claude-marketplace --skill pandas -a claude-code

2Manually: put the files in place

~/.claude/skills/pandas/SKILL.md

Copy the whole skill folder; for one project use .claude/skills/pandas/

Step by step, with commands for each platform: How to install skills in Claude Code: five ways

Questions about pandas

How do I install pandas in Claude?

Run npx skills add manutej/luxor-claude-marketplace --skill pandas -a claude-code. The skill lands in ~/.claude/skills/pandas/SKILL.md.

What does the pandas skill do?

It hands the agent data analysis templates for support work: SLA calculations, agent metrics, ticket volume over time, and PostgreSQL loads via SQLAlchemy.

What do I need before using it?

The dependencies it lists: pandas>=2.2.0, sqlalchemy>=2.0.0, psycopg2-binary>=2.9.0, numpy>=1.26.0, openpyxl>=3.1.0, pytest>=8.0.0.

Similar skills

All skills for Data and databases →
pandas-pro https://github.com/Jeffallan Skill for efficient pandas work: data cleaning, aggregation, table joins, time series. Useful if you manipulate DataFrames often and want to skip indexing errors and row loops. CX Codex +1 5,700installs chdb-sql chdb-io A skill that teaches your agent analytical SQL over parquet, CSV, S3 and remote databases with chDB, which is ClickHouse running inside Python. No server to start. CX Codex +1 8,900installs fastapi-templates Seth Hobson This skill scaffolds FastAPI projects with async routes, dependency injection, and error handling. Use it when starting a Python API. CX Codex 25,840installs database-scout zebbern A read-only skill for SQLite and PostgreSQL: lists tables, inspects schemas, previews rows and renders Mermaid ER diagrams. Queries stay read-only. CX Codex +1 ★ 4,676repo stars django-patterns affaan-m Guides agents on Django and DRF architecture: modular settings, custom user models, and optimized QuerySets without N+1 queries. CX Codex +1 5,200installs

From the same set31

rust-systems-programming A skill on systems Rust: ownership, borrowing, threads, async, unsafe and performance. Useful when you write low-level code or port C/C++. CX Codex +1 485installs api-gateway-patterns A skill for building API gateways on Kong: routing, rate limiting, auth, load balancing. Useful when your microservices exist but lack a single entry point. CX Codex +1 481installs react-patterns A skill that hands your agent ready React recipes: hooks, component composition, state management and fewer wasted re-renders. CX Codex +1 471installs SQLAlchemy ORM Expert A SQLAlchemy 2.0+ skill for customer support backends: ticket models, sessions, async queries and PostgreSQL. Useful when you build on FastAPI. CX Codex +1 470installs database-management-patterns A reference skill for PostgreSQL and MongoDB work: schema design, indexing, transactions, replication and sharding. CX Codex +1 466installs react-development A skill that feeds your coding agent React patterns: components, hooks, state and effects, taken from the official react.dev docs. CX Codex +1 464installs tailwind-css A Tailwind CSS skill covering utility classes, responsive variants, dark mode and production optimization. Handy when you build UI and want to stay in your markup. CX Codex +1 461installs vector-database-management A skill for Pinecone, Weaviate and Chroma: indexes, embeddings, similarity search and RAG. Useful when you need semantic search in a project. CX Codex +1 459installs

Project sponsors

Companies that keep this analytics open
Gold sponsor
Nutra.Club

Impressions, clicks and code copies — open statistics. We keep the numbers public for the same reason NeBlask itself is public. Become a sponsor