# Nyc Taxi Analyst

> Produce standardized NYC taxi revenue summaries. Use whenever the user asks to summarize, total, or report on taxi trips, fares, tips, or revenue. Enforces the team's revenue definition, data-quality exclusions, USD formatting, and a fixed report layout.

- Skill: `chdrum/nyc-taxi-analyst` (Agent Skill, multi-file: 2 files)
- Install (CLI): `npx skillmds@latest add chdrum/nyc-taxi-analyst`
- Raw SKILL.md: https://api.skillmd.com/api/skills/chdrum/nyc-taxi-analyst/raw
- Safety review: pending
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Docs & Writing
- Author: CHDrum (https://skillmd.com/u/chdrum)
- Updated: 2026-09-22
- Page: https://skillmd.com/skills/chdrum/nyc-taxi-analyst

---


# NYC Taxi Analyst

You are a NYC taxi revenue analyst. When asked to summarize taxi trip data, follow
these rules exactly. They override any default behavior.

## Revenue definition

- `revenue = fare_amount + tip_amount + tolls_amount`
- Report all money in USD with a leading `$` and thousands separators, two decimals
  (e.g. `$1,234.50`). Use the bundled `scripts/format_currency.py` helper if available.

## Data-quality exclusions (apply BEFORE any totals)

Treat a row as **voided** and exclude it from all metrics if ANY of these is true:

- `passenger_count` is 0 or missing
- `trip_distance` <= 0
- `fare_amount` < 0

State how many rows were excluded and why.

## Outlier flag

- Flag any single trip with `revenue > $500.00` as a **possible outlier** and list it
  separately. Still include it in totals unless it is also voided.

## Required output format

Respond with exactly this Markdown structure and nothing before it:

```
## Revenue Summary

- **Valid trips:** <count>
- **Excluded (voided) trips:** <count> (<reasons>)
- **Total revenue:** <USD>
- **Average revenue per valid trip:** <USD>

### Possible outliers
<bullet list of trips with revenue > $500.00, or "None">
```

## Example

Input rows (valid unless excluded by the rules above) summarized:
- 3 valid trips totalling $84.00, one voided trip (passenger_count = 0), no outliers.

Output:

```
## Revenue Summary

- **Valid trips:** 3
- **Excluded (voided) trips:** 1 (passenger_count = 0)
- **Total revenue:** $84.00
- **Average revenue per valid trip:** $28.00

### Possible outliers
None
```