saturn·

data trove world of cheese

source /home/coolhand/html/datavis/data_trove/data/quirky/cheese_list.json 7,146 rows 4 columns profiled 2026-06-21 raw JSON static .html .ipynb Report Notebook

Reading

dataset summary · high confidence anthropic:default

This dataset is a multilingual catalogue of 7,146 cheese products spanning 32 categories and 111 countries of origin. The most immediately striking pattern is the geographic concentration: France alone accounts for 26% of all entries (1,853), followed by Germany and the United States, suggesting the dataset skews heavily toward Western European dairy traditions. On the category side, Cream Cheese dominates with 1,187 entries (17%), and the top 5 categories together cover over half the dataset — worth examining for potential over-representation. The 'value' column is entirely constant at 1.0 and can be safely ignored. Note also that the product names are highly multilingual (30 languages detected) with an 11% duplicate rate, indicating some cheese types are listed under multiple language variants.

citing: row_count · column_count · country.stats.top_value · country.stats.top_rate · country.n_unique · category.stats.top_value · category.stats.top_rate · category.n_unique · name.stats.duplicate_rate · name.language_counts · value.alerts

Schema

4 columns
Per-column summary. Click column name to jump to its detail.
Alerts
name text 0.0% 6,337
multilingual
country categorical 0.0% 111
category categorical 0.0% 32
value numeric 0.0% 1
constant

name

text label multilingual
This column contains the names of cheese products (or cheese-related food items), as evidenced by top values like 'Mozzarella', 'Cottage Cheese', and 'Gouda', and dominant words including 'cheese', 'mozzarella', 'fromage', and 'queso'. Notably, 11.3% of values are duplicates (809 out of 7146), partly due to case-inconsistent entries like 'Cottage cheese' (29) and 'Cottage Cheese' (27) being counted separately. A multilingual alert is triggered across 30 detected languages — English (1847), French (1029), German (552), Italian (389), and Spanish (251) are dominant — reflecting international product naming rather than true language mixing in a single entry. The mean name length is ~23 characters with a median of 3 words, consistent with structured product label strings rather than free text. Treatment: Normalise case before deduplication or grouping; consider language-aware normalisation to consolidate cross-lingual synonyms (e.g. 'fromage', 'queso', 'cheese') for modelling. high · anthropic:default
n
7,146
nulls
0 (0.0%)
unique
6,337
len_min
4
len_max
191
len_mean
22.96
len_median
21
len_p95
44
word_mean
3.443
word_median
3
n_empty
0
n_duplicates
809
duplicate_rate
0.1132
vocab_size
4,732
readability_flesch_mean
53.61
emoji_rate
0.0005598
url_rate
0
one_word_rate
0.1041
allcaps_rate
0.01707
boilerplate_rate
0

country

categorical feature
This column records the country of origin or residence for each record, spanning 111 distinct countries across 7,146 rows with no nulls. France dominates heavily, accounting for 25.9% of all records (1,853 rows), followed by Germany (907) and United States (759) — suggesting a strongly Europe-centric dataset, likely French-sourced. The entropy ratio of 0.628 indicates moderate distributional spread, but the long tail of 111 countries means many nations are sparsely represented beyond the top 10. Treatment: One-hot encode top countries and group sparse tail into an 'Other' category before modelling. high · anthropic:default
n
7,146
nulls
0 (0.0%)
unique
111
top_value
France
top_rate
0.2593
cardinality
111
entropy
4.268
entropy_ratio
0.6281

category

categorical label
This column is a product category label for what appears to be a cheese-focused retail or food dataset, with 32 distinct cheese types across 7,146 records and no nulls. The distribution is moderately uneven: 'Cream Cheese' dominates at 16.6% (1,187 rows), while the top 10 categories alone account for the vast majority of records. The entropy ratio of 0.82 suggests reasonable spread across categories but with a clear long tail beyond the top 10. No anomalies or alerts are present. Treatment: One-hot encode or target-encode for modelling; consider grouping low-frequency tail categories if sparse classes cause issues. high · anthropic:default
n
7,146
nulls
0 (0.0%)
unique
32
top_value
Cream Cheese
top_rate
0.1661
cardinality
32
entropy
4.098
entropy_ratio
0.8195

value

numeric other constant
This column is a numeric constant: every one of its 7,146 non-null rows holds exactly the value 1.0, with zero variance, zero skew, and a single unique value. It carries no information and will contribute nothing to any model or analysis. This is likely a placeholder, a join artifact, or a weight/flag column that was never populated with real data. Treatment: Drop immediately; zero-variance constant adds no predictive or descriptive value. high · anthropic:default
n
7,146
nulls
0 (0.0%)
unique
1
min
1
max
1
mean
1
median
1
std
0
q1
1
q3
1
iqr
0
skew
0
kurtosis
0
n_outliers
0
outlier_rate
0
zero_rate
0