saturn

/home/coolhand/html/datavis/data_trove/entertainment/gaming/users_metadata.json 1 rows sample n=1 seed 42 2026-06-21T23:42:05+00:00

Overview

Source/home/coolhand/html/datavis/data_trove/entertainment/gaming/users_metadata.json
Total rows1
Profiled sample1
Columns6
Generated2026-06-21T23:42:05+00:00
Show data table
Per-column null rate across the corpus.
columnkindnull %
dataset_namecategorical0.0%
last_updatedcategorical0.0%
sourcecategorical0.0%
record_countnumeric0.0%
fieldsunknown0.0%
notescategorical0.0%

Insights opt-in

Model-generated narrative. These are opinions, not facts — the stats below are what saturn measured. Generated by: anthropic:default.

Dataset low anthropic:default

This is a single-row metadata record describing the Steam Users dataset, a collection of 14,306,064 Steam user profiles sourced from Steam Store data (likely via Kaggle or SteamSpy) and last updated on 2025-01-20. Rather than being an analytical dataset itself, it serves as a data catalogue entry pointing analysts toward the actual user data file (185 MB) which links to a recommendations.csv via user_id. The most important thing to note is the scale: over 14 million user profiles covering library size and review activity represent a substantial analytical resource. Before diving in, analysts should locate and join the referenced recommendations.csv to unlock the full relational value of this dataset.

dataset_name high anthropic:default

This column is a dataset-level identifier or metadata tag indicating the source dataset, with every row labelled 'Steam Users'. With only 1 row and 1 unique value, the column carries zero entropy (0.0) and a top_rate of 1.0 — it is a constant and provides no discriminative information. The long_tail and imbalance alerts are technically correct but trivially explained by the single-row, single-value nature of the data.

last_updated high anthropic:default

This column is a timestamp or date field indicating when a record was last updated, stored as a categorical string. The dataset contains only a single row (n=1), and that row holds the value '2025-01-20', giving a cardinality of 1 and top_rate of 1.0. With only one observation, no distributional insight is possible; the 'long_tail' and 'imbalance' alerts are artefacts of the trivial sample size rather than meaningful signals.

notes high anthropic:default

This column is a dataset-level metadata note, not a real data column — it contains a single static string describing the dataset itself (14.3 million Steam user profiles, file size 185 MB, join key user_id). With n=1 and cardinality=1, it appears to be a singleton annotation row or a schema-level descriptor accidentally included in the profiled data. The entropy of 0.0 and top_rate of 1.0 confirm it carries zero analytical signal.

source high anthropic:default

This column records the data provenance or source attribution for the dataset, with every single row carrying the identical value 'Steam Store user data (likely via Kaggle or SteamSpy)'. With n=1, cardinality=1, entropy=0.0, and top_rate=1.0, there is zero variance whatsoever — this is a constant column. It adds no analytical signal and likely exists as a metadata annotation injected during data collection or curation.

record_count high anthropic:default

This column is a record count field, almost certainly a metadata scalar reporting the total row count of a source dataset — here fixed at 14,306,064 across all rows. With n=1, n_unique=1, and a constant value equal to mean, min, and max, there is zero variance; saturn has flagged it as 'constant'. This is not a feature or target but a summary statistic embedded in the dataset, likely from an ETL or export header row.

fields low anthropic:default

This column contains only a single row and was skipped by the profiler, yielding no distributional statistics. With n=1 and no uniqueness or type information available, no meaningful inference about its content or role is possible beyond the fact that it is non-null. The 'unknown' kind designation and empty stats block indicate the profiler could not parse or classify the value.

dataset_name categorical

1 singleton categories top value is 100.0% of rows
rows1
null0 (0.0%)
unique1
top_valueSteam Users
top_rate1.000
cardinality1
entropy-0.000
entropy_ratio0.000
Show data table
Top values for dataset_name (1 unique shown, of 1 total).
valuecountshare
Steam Users1100.0%
Top values (rank 1–20)
  1. Steam Users — 1

last_updated categorical

1 singleton categories top value is 100.0% of rows
rows1
null0 (0.0%)
unique1
top_value2025-01-20
top_rate1.000
cardinality1
entropy-0.000
entropy_ratio0.000
Show data table
Top values for last_updated (1 unique shown, of 1 total).
valuecountshare
2025-01-201100.0%
Top values (rank 1–20)
  1. 2025-01-20 — 1

source categorical

1 singleton categories top value is 100.0% of rows
rows1
null0 (0.0%)
unique1
top_valueSteam Store user data (likely via Kaggle or SteamSpy)
top_rate1.000
cardinality1
entropy-0.000
entropy_ratio0.000
Show data table
Top values for source (1 unique shown, of 1 total).
valuecountshare
Steam Store user data (likely via Kaggle or SteamSpy)1100.0%
Top values (rank 1–20)
  1. Steam Store user data (likely via Kaggle or SteamSpy) — 1

record_count numeric

only one distinct value
rows1
null0 (0.0%)
unique1
min14,306,064
max14,306,064
mean14,306,064
median14,306,064
std0.000
q114,306,064
q314,306,064
iqr0.000
skew0.000
kurtosis0.000
n_outliers0
outlier_rate0.000
zero_rate0.000
Show data table
Histogram bins for record_count (median: 14306064.0).
bincount
1.431e+07 – 1.431e+070
1.431e+07 – 1.431e+070
1.431e+07 – 1.431e+071
1.431e+07 – 1.431e+070
1.431e+07 – 1.431e+070

fields unknown

no profiler for kind=unknown
rows1
null0 (0.0%)

notes categorical

1 singleton categories top value is 100.0% of rows
rows1
null0 (0.0%)
unique1
top_value14.3 million Steam user profiles with library size and review activity. File is 185 MB. Links to recommendations.csv via user_id.
top_rate1.000
cardinality1
entropy-0.000
entropy_ratio0.000
Show data table
Top values for notes (1 unique shown, of 1 total).
valuecountshare
14.3 million Steam user profiles with library size and review activity. File is 185 MB. Links to recommendations.csv via user_id.1100.0%
Top values (rank 1–20)
  1. 14.3 million Steam user profiles with library size and review activity. File is 185 MB. Links to recommendations.csv via user_id. — 1