state-county-rankings
Provides ranked demographic data for counties within a state based on local CSV files.
Install
mkdir -p .claude/skills/state-county-rankings && curl -L -o skill.zip "https://agentskills.codes/api/skills/download/11996" && unzip -o skill.zip -d .claude/skills/state-county-rankings && rm skill.zipInstalls to .claude/skills/state-county-rankings
Activation
This is the description your AI agent reads to decide when to run this skill — the better it matches your request, the more reliably it fires.
This skill should be used when users need ranked county-level demographic metrics within a state from a local CSV file, such as income, population, poverty, or rent.Key capabilities
- →Confirm input CSV path and state
- →Review column requirements for output headers
- →Ask for metrics and ranking direction
- →Run Rscript to get state county rankings
How it works
The skill confirms input parameters, then executes an R script to process a local CSV, ranking counties within a specified state for given demographic metrics.
Inputs & outputs
When to use state-county-rankings
- →Ranking counties by income
- →Analyzing poverty metrics by state
- →Generating demographic reports
About this skill
State County Rankings
Use this skill to rank counties within a state for one or more metrics from a local dataset.
Requirements
- R with
dplyr,tidyr,readr,stringr, andjsonlite - Local CSV input with
county, a state column (state,state_name, orstate_abbrev), and requested metric columns - Bundled Census CSV for immediate use:
skills/state-county-rankings/data/county_demographics_acs5_2023.csv - No API key required
Standard Workflow
- Confirm input CSV path and state.
--stateaccepts full names or USPS abbreviations (for example,GeorgiaorGA).- Default bundled input:
skills/state-county-rankings/data/county_demographics_acs5_2023.csv
- Review
skills/state-county-rankings/references/COLUMN_REQUIREMENTS.mdand use exact output headers before downstream filtering/selecting.- Output columns are
state,county,metric,value,rank, anddirection.
- Output columns are
- Ask for metrics (or use defaults) and ranking direction.
- Run:
Rscript skills/state-county-rankings/scripts/get_state_county_rankings.R --input skills/state-county-rankings/data/county_demographics_acs5_2023.csv --state "<state>"
- Return top/bottom county rankings and note missing/invalid fields.
Output
Return ranked rows with:
statecountymetricvaluerankdirection
When not to use it
- →When R with `dplyr`, `tidyr`, `readr`, `stringr`, and `jsonlite` is not installed
- →When the input CSV does not have `county`, a state column, and requested metric columns
- →When the user needs rankings for data other than county-level demographic metrics
Prerequisites
Limitations
- →Requires R and specific R packages
- →Input CSV must contain `county`, a state column, and metric columns
- →Limited to county-level demographic metrics within a state
How it compares
This skill provides a standardized R-based workflow for ranking county-level demographic data from a local CSV, ensuring consistent output headers and handling of state abbreviations.
Compared to similar skills
state-county-rankings side by side with the closest alternatives in the catalog.
| Skill | Installs | Updated | Safety | Difficulty |
|---|---|---|---|---|
| state-county-rankings (this skill) | 0 | 5mo | Review | Beginner |
| finance-manager | 12 | 9mo | Review | Intermediate |
| csv-data-summarizer | 15 | 10mo | Review | Beginner |
| xlsx | 87 | 6mo | Review | Intermediate |
Try saying
Example prompts that trigger this skill in your AI assistant.
More by amkessler
View all by amkessler →You might also like
finance-manager
ailabs-393
Comprehensive personal finance management system for analyzing transaction data, generating insights, creating visualizations, and providing actionable financial recommendations. Use when users need to analyze spending patterns, track budgets, visualize financial data, extract transactions from PDFs, calculate savings rates, identify spending trends, generate financial reports, or receive personalized budget recommendations. Triggers include requests like "analyze my finances", "track my spending", "create a financial report", "extract transactions from PDF", "visualize my budget", "where is my money going", "financial insights", "spending breakdown", or any finance-related analysis tasks.
csv-data-summarizer
coffeefuelbump
Analyzes CSV files, generates summary stats, and plots quick visualizations using Python and pandas.
xlsx
anthropics
Comprehensive spreadsheet creation, editing, and analysis with support for formulas, formatting, data analysis, and visualization. When Claude needs to work with spreadsheets (.xlsx, .xlsm, .csv, .tsv, etc) for: (1) Creating new spreadsheets with formulas and formatting, (2) Reading or analyzing data, (3) Modify existing spreadsheets while preserving formulas, (4) Data analysis and visualization in spreadsheets, or (5) Recalculating formulas
reconciliation
anthropics
Reconcile accounts by comparing GL balances to subledgers, bank statements, or third-party data. Use when performing bank reconciliations, GL-to-subledger recs, intercompany reconciliations, or identifying and categorizing reconciling items.
analyzing-financial-statements
anthropics
This skill calculates key financial ratios and metrics from financial statement data for investment analysis
financial-document-parser
OneWave-AI
Extract and analyze data from invoices, receipts, bank statements, and financial documents. Categorize expenses, track recurring charges, and generate expense reports. Use when user provides financial PDFs or images.