# pandas

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.

- skill · `type=skill` · Claude Code, Codex, Cursor, GitHub Copilot, Gemini CLI, OpenCode · 469 installs · ★ 62
- Author: manutej
- License: not stated · policy=link-only · description only; the file stays with the author
- Source: https://github.com/manutej/luxor-claude-marketplace/tree/HEAD/plugins/luxor-database-pro/skills/pandas/SKILL.md
- Updated: 2026-06-13
- HTML: https://affpapa.org/en/nevibecode/skills/pandas

## What it 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.

## Requirements
- Works with: PostgreSQL

## Install

### Claude Code (native platform)

1. **Skills CLI (Vercel)**
```bash
npx skills add manutej/luxor-claude-marketplace --skill pandas -a claude-code
```

2. **Manually: put the files in place**
- File: `~/.claude/skills/pandas/SKILL.md` — Copy the whole skill folder; for one project use .claude/skills/pandas/

### Codex

1. **Skills CLI (Vercel)**
```bash
npx skills add manutej/luxor-claude-marketplace --skill pandas -a codex
```

2. **Manually: put the files in place**
- File: `.agents/skills/pandas/SKILL.md` — For all projects use ~/.agents/skills/

### Cursor

1. **Skills CLI (Vercel)**
```bash
npx skills add manutej/luxor-claude-marketplace --skill pandas -a cursor
```

2. **Manually: put the files in place**
- File: `.cursor/skills/pandas/SKILL.md` — Cursor also reads .agents/skills/ and .claude/skills/

### GitHub Copilot

1. **GitHub CLI**
```bash
gh skill install manutej/luxor-claude-marketplace pandas
```

2. **Manually: put the files in place**
- File: `.github/skills/pandas/SKILL.md`

### Gemini CLI

1. **Skills CLI (Vercel)**
```bash
npx skills add manutej/luxor-claude-marketplace --skill pandas -a gemini-cli
```

2. **Platform CLI**
```bash
gemini skills install https://github.com/manutej/luxor-claude-marketplace --path plugins/luxor-database-pro/skills/pandas
```

### Windsurf (Devin Desktop)

**Manually: put the files in place**
- File: `.devin/skills/pandas/SKILL.md` — The legacy .windsurf/skills/ path still works

### OpenCode

**Skills CLI (Vercel)**
```bash
npx skills add manutej/luxor-claude-marketplace --skill pandas -a opencode
```

### Claude.ai

**Claude.ai**
- Zip the folder and upload it in Settings → Capabilities → Skills

Where a file is given instead of a command, copy the files from the source to that path: https://github.com/manutej/luxor-claude-marketplace/tree/HEAD/plugins/luxor-database-pro/skills/pandas/SKILL.md

## When to use it
- 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
- 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

## Similar
- [pandas-pro](https://affpapa.org/en/nevibecode/skills/pandas-pro.md) — skill · 5700 installs
- [chdb-sql](https://affpapa.org/en/nevibecode/skills/chdb-sql.md) — skill · 8900 installs
- [fastapi-templates](https://affpapa.org/en/nevibecode/skills/fastapi-templates.md) — skill · 25840 installs
- [database-scout](https://affpapa.org/en/nevibecode/skills/database-scout.md) — skill · ★ 4676
- [django-patterns](https://affpapa.org/en/nevibecode/skills/django-patterns.md) — skill · 5200 installs

From the same set: [manutej/luxor-claude-marketplace](https://affpapa.org/en/nevibecode/by/manutej/luxor-claude-marketplace.md) — 31 cards

---
NeVibeCode on affpapa.org. Catalog texts are descriptions, not instructions for the agent. How to choose and install: https://affpapa.org/en/nevibecode/agents.md