Tables
by josca42
Preview denmark statistics fact tables and inspect their metadata
Skill Details
Repository Files
2 files in this skill directory
name: tables description: Preview denmark statistics fact tables and inspect their metadata
tables CLI
Inspect a denmark statistics fact table before loading it into Postgres and view its official table metadata.
Run the CLI from .claude/skills/tables:
python scripts/tables.py --help
view — preview a fact table
python scripts/tables.py view FOLK1A --rows 5
python scripts/tables.py view FOLK1A --db-format # show the DB-ready schema
--rows/-ncontrols how many rows to display (default 10).--db-format/-druns the same processing used during ingestion (renames to lower-case, normalizes dtypes, parses date strings).
Output is always a column|dtype list followed by a pipe-delimited preview (TABLE.head(n)), which stays consistent whether you use the raw or DB-formatted view.
info — metadata snapshot
python scripts/tables.py info FOLK1A
Prints metadata for a single table, including id, title, description, unit and every dimension (text plus the coded values present in the metadata). The metadata is printed as XML. The XML is easy to feed into other tools or to scan quickly when deciding which dimensions to join.
python scripts/tables.py info FOLK1A --column "område"
Will print only the coded values ("id") and the text titles for the column specifiec. All unique values will be printed.
python scripts/tables.py info FOLK1A --normalize-col-names
Will normalize column names so they match the database schema. This means lowercasing col names and replacing å -> a, ø -> o, æ -> ae. So OMRÅDE becomes omrade.
Related Skills
Xlsx
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
Clickhouse Io
ClickHouse database patterns, query optimization, analytics, and data engineering best practices for high-performance analytical workloads.
Clickhouse Io
ClickHouse database patterns, query optimization, analytics, and data engineering best practices for high-performance analytical workloads.
Analyzing Financial Statements
This skill calculates key financial ratios and metrics from financial statement data for investment analysis
Data Storytelling
Transform data into compelling narratives using visualization, context, and persuasive structure. Use when presenting analytics to stakeholders, creating data reports, or building executive presentations.
Kpi Dashboard Design
Design effective KPI dashboards with metrics selection, visualization best practices, and real-time monitoring patterns. Use when building business dashboards, selecting metrics, or designing data visualization layouts.
Dbt Transformation Patterns
Master dbt (data build tool) for analytics engineering with model organization, testing, documentation, and incremental strategies. Use when building data transformations, creating data models, or implementing analytics engineering best practices.
Sql Optimization Patterns
Master SQL query optimization, indexing strategies, and EXPLAIN analysis to dramatically improve database performance and eliminate slow queries. Use when debugging slow queries, designing database schemas, or optimizing application performance.
Anndata
This skill should be used when working with annotated data matrices in Python, particularly for single-cell genomics analysis, managing experimental measurements with metadata, or handling large-scale biological datasets. Use when tasks involve AnnData objects, h5ad files, single-cell RNA-seq data, or integration with scanpy/scverse tools.
Xlsx
Spreadsheet toolkit (.xlsx/.csv). Create/edit with formulas/formatting, analyze data, visualization, recalculate formulas, for spreadsheet processing and analysis.