Source: /home/coolhand/html/datavis/data_trove/data/policy/sector_indices.json
Saturn profiled 1 rows across 7 columns. The stats below are deterministic and machine-readable; the prose is a language-model interpretation of those stats (opt-in, added after the fact, never sees raw rows).
!pip install saturn-dissect
import subprocess
subprocess.run([
"saturn", "analyze", "/home/coolhand/html/datavis/data_trove/data/policy/sector_indices.json",
"--findings", "data-trove-market-sector-performance.json",
"--llm", "anthropic:default",
])This dataset is a single-record JSON stub describing S&P 500 sector ETF performance since the January 20, 2025 inauguration. With only 1 row and 7 columns — most of which are 'unknown' kind and skipped during profiling — there is very little structured, analyzable data surface available here. The two readable columns (_description and _stub) are fully constant and carry no variation. The meaningful content almost certainly lives inside the nested or unparsed fields (_etf_map, _fields, _key_findings, data), which would need to be unpacked before any real analysis can begin.
citing: row_count · column_count · columns[0].stats.top_value · columns[1].stats.top_value · columns[2].alerts · columns[6].alerts
saturn.schema() · 7 columns
| column | kind | n | null% | unique | alerts |
|---|---|---|---|---|---|
| _stub | categorical | 1 | 0.0% | 1 | long_tail imbalance |
| _description | categorical | 1 | 0.0% | 1 | long_tail imbalance |
| _sources | unknown | 1 | 0.0% | — | skipped |
| _fields | unknown | 1 | 0.0% | — | skipped |
| _etf_map | unknown | 1 | 0.0% | — | skipped |
| _key_findings | unknown | 1 | 0.0% | — | skipped |
| data | unknown | 1 | 0.0% | — | skipped |
| value | count | share |
|---|---|---|
| S&P 500 sector ETF performance since inauguration (2025-01-20) | 1 | 100.0% |
| value | count | share |
|---|---|---|
| True | 1 | 100.0% |
| column | kind | null % |
|---|---|---|
| _stub | categorical | 0.0% |
| _description | categorical | 0.0% |
| _sources | unknown | 0.0% |
| _fields | unknown | 0.0% |
| _etf_map | unknown | 0.0% |
| _key_findings | unknown | 0.0% |
| data | unknown | 0.0% |
This column, '_stub', is a single-row categorical field containing only the value 'True', with a top_rate of 1.0 and cardinality of 1 across n=1 records. It carries zero entropy and zero variance, making it entirely uninformative. The '_stub' name and degenerate structure strongly suggest this is a placeholder or scaffold artifact rather than real data.
Treatment: Drop immediately; zero-variance stub column with a single observation provides no modelling or analytical value.
saturn.columns["_stub"].stats
| stat | value |
|---|---|
| n | 1 |
| nulls | 0 (0.0%) |
| unique | 1 |
| top_value | True |
| top_rate | 1 |
| cardinality | 1 |
| entropy | 0 |
| entropy_ratio | 0 |
| alert: long_tail | 1 singleton categories |
| alert: imbalance | top value is 100.0% of rows |
_stub.
| value | count | share |
|---|---|---|
| True | 1 | 100.0% |
This column is a single-row dataset description or caption field, containing exactly one unique value: 'S&P 500 sector ETF performance since inauguration (2025-01-20)'. With n=1, cardinality=1, top_rate=1.0, and entropy of 0.0, it carries zero informational variance and is purely a metadata annotation. The 'long_tail' and 'imbalance' alerts are trivially explained by the single-value nature of the column and carry no analytical meaning here.
Treatment: Drop before modelling; retain only as a dataset-level annotation or provenance label.
saturn.columns["_description"].stats
| stat | value |
|---|---|
| n | 1 |
| nulls | 0 (0.0%) |
| unique | 1 |
| top_value | S&P 500 sector ETF performance since inauguration (2025-01-20) |
| top_rate | 1 |
| cardinality | 1 |
| entropy | 0 |
| entropy_ratio | 0 |
| alert: long_tail | 1 singleton categories |
| alert: imbalance | top value is 100.0% of rows |
_description.
| value | count | share |
|---|---|---|
| S&P 500 sector ETF performance since inauguration (2025-01-20) | 1 | 100.0% |
This column contains only a single row and was skipped during profiling, yielding no distributional statistics. It likely represents a metadata or provenance field (e.g., a list or structured object of data sources), but its type is flagged as 'unknown'. With n=1 and no further evidence, nothing meaningful can be inferred about its content or distribution.
Treatment: Inspect raw value manually; determine if it is a scalar, list, or JSON blob before deciding whether to expand, drop, or carry as metadata.
saturn.columns["_sources"].stats
| stat | value |
|---|---|
| n | 1 |
| nulls | 0 (0.0%) |
| unique | — |
| alert: skipped | no profiler for kind=unknown |
This column ('_fields') contains only a single row and was skipped during profiling, yielding no distributional statistics. Its name suggests a metadata or schema artifact—possibly a nested/struct field, a JSON blob, or an internal system column—rather than a modellable feature. With n=1 and kind='unknown', no meaningful inference about content or distribution is possible.
Treatment: Inspect raw value manually to determine if it encodes nested structure or is a system artifact; drop or unpack before modelling.
saturn.columns["_fields"].stats
| stat | value |
|---|---|
| n | 1 |
| nulls | 0 (0.0%) |
| unique | — |
| alert: skipped | no profiler for kind=unknown |
_etf_map appears to be a mapping or metadata column related to ETF (Exchange-Traded Fund) classification, likely storing a dictionary, list, or complex object serialized as a single value. The profile contains only 1 row and no stats were computed (kind marked 'unknown', analysis skipped), making it impossible to characterize value distribution, cardinality, or content. No further inference is possible from the available evidence.
Treatment: Inspect raw value to determine structure (e.g. JSON/dict), then flatten or parse before use; re-profile on a full dataset.
saturn.columns["_etf_map"].stats
| stat | value |
|---|---|
| n | 1 |
| nulls | 0 (0.0%) |
| unique | — |
| alert: skipped | no profiler for kind=unknown |
_key_findings is an unclassified column with only 1 row and no computed statistics, meaning saturn skipped profiling it entirely. No distribution, uniqueness, or type information is available. With n=1 the column cannot be meaningfully analysed—it may be a metadata artefact, a header row, or a singleton annotation field.
Treatment: Investigate data extraction; with only 1 row this column is unusable for modelling and should be dropped or manually inspected.
saturn.columns["_key_findings"].stats
| stat | value |
|---|---|
| n | 1 |
| nulls | 0 (0.0%) |
| unique | — |
| alert: skipped | no profiler for kind=unknown |
This column contains only a single row and was flagged as 'skipped' by the profiler, likely due to an unrecognized or unsupported data type. No distributional statistics, uniqueness counts, or type information are available, making it impossible to characterize the column's content or role. With n=1 and null_rate=0.0, the dataset itself appears to be a near-empty or singleton record.
Treatment: Investigate raw value and data type manually before deciding how to handle; profiler could not parse this column.
saturn.columns["data"].stats
| stat | value |
|---|---|
| n | 1 |
| nulls | 0 (0.0%) |
| unique | — |
| alert: skipped | no profiler for kind=unknown |
click to copy
@misc{saturn-data-trove-market-sector-performance-2026,
author = {Steuber, Luke},
title = {Saturn reading: data trove market sector performance},
year ={2026},
howpublished = {\url{https://dr.eamer.dev/saturn/view/data-trove-market-sector-performance}},
note = {Profiled with saturn-dissect v0.2.0, prompt saturn-insight-v2, model anthropic:default},
}
Steuber, L. (2026). Saturn reading: data trove market sector performance. Source: /home/coolhand/html/datavis/data_trove/data/policy/sector_indices.json. Profiled with saturn-dissect v0.2.0 (saturn-insight-v2, anthropic:default). Retrieved from https://dr.eamer.dev/saturn/view/data-trove-market-sector-performance