Source: /home/coolhand/html/datavis/data_trove/data/quirky/hot_sauces.json
Saturn profiled 258 rows across 9 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/quirky/hot_sauces.json",
"--findings", "quirky-hot_sauces.json",
"--llm", "anthropic:claude-opus-4-7",
])This dataset catalogs 258 hot sauce products sourced entirely from OpenFoodFacts, with 9 categorical columns covering brand, category, country, ingredients, labels, name, and URL. Brands are highly fragmented across 158 unique values, with Tabasco (12) and McIlhenny Company, Tabasco (11) leading but no dominant player — and 37 records have a blank brand worth investigating. Geographically, the United States (54) and France (28) account for the largest shares of the 123 country values, though inconsistent encoding (e.g., 'en:us' vs 'United States') suggests a data-cleaning task. The labels column is sparse: 145 of 258 rows are blank, so dietary tags like 'No gluten' or 'Non GMO project' apply to only a small minority. Note that source and type are constant (OpenFoodFacts / hot_sauce_product) and carry no analytical signal.
citing: brand · countries · labels · categories · name · source · type
saturn.schema() · 9 columns
| column | kind | n | null% | unique | alerts |
|---|---|---|---|---|---|
| name | categorical | 258 | 0.0% | 221 | long_tail |
| brand | categorical | 258 | 0.0% | 158 | long_tail |
| countries | categorical | 258 | 0.0% | 123 | long_tail |
| categories | categorical | 258 | 0.0% | 106 | long_tail |
| ingredients | categorical | 258 | 0.0% | 207 | long_tail |
| labels | categorical | 258 | 0.0% | 77 | long_tail |
| url | categorical | 258 | 0.0% | 258 | long_tail |
| source | categorical | 258 | 0.0% | 1 | imbalance |
| type | categorical | 258 | 0.0% | 1 | imbalance |
| value | count | share |
|---|---|---|
| 37 | 14.3% | |
| Tabasco | 12 | 4.7% |
| McIlhenny Company, Tabasco | 11 | 4.3% |
| Flying Goose Brand | 6 | 2.3% |
| Melinda's | 5 | 1.9% |
| Lola's Fine Hot Sauce | 5 | 1.9% |
| Cholula | 4 | 1.6% |
| Encona | 4 | 1.6% |
| El Yucateco | 4 | 1.6% |
| Mrs. Renfro's | 4 | 1.6% |
| Huy Fong Foods, Inc. | 3 | 1.2% |
| Sauce Shop | 3 | 1.2% |
| Go-Tan | 2 | 0.8% |
| Vitasia | 2 | 0.8% |
| Valentina | 2 | 0.8% |
| Heinz | 2 | 0.8% |
| sauce shop | 2 | 0.8% |
| CHOLULA | 2 | 0.8% |
| TABASCO | 2 | 0.8% |
| Serpis | 2 | 0.8% |
| value | count | share |
|---|---|---|
| United States | 54 | 20.9% |
| France | 28 | 10.9% |
| en:us | 10 | 3.9% |
| en:gb | 8 | 3.1% |
| en:fr | 8 | 3.1% |
| en:france | 4 | 1.6% |
| en:germany | 4 | 1.6% |
| United States, World | 4 | 1.6% |
| en:United States | 4 | 1.6% |
| United Kingdom | 3 | 1.2% |
| en:United Kingdom | 3 | 1.2% |
| France, United States | 3 | 1.2% |
| en:Canada | 3 | 1.2% |
| World | 3 | 1.2% |
| France, en:morocco | 2 | 0.8% |
| en:ma | 2 | 0.8% |
| France,Royaume-Uni | 2 | 0.8% |
| en:Germany | 2 | 0.8% |
| Belgique,France | 2 | 0.8% |
| Canada | 2 | 0.8% |
| value | count | share |
|---|---|---|
| 145 | 56.2% | |
| No gluten | 9 | 3.5% |
| No GMOs, Non GMO project | 9 | 3.5% |
| Sans gluten | 5 | 1.9% |
| Halal | 4 | 1.6% |
| en:vegan | 4 | 1.6% |
| No GMOs, Non GMO project, en:no-gluten | 3 | 1.2% |
| Point Vert | 3 | 1.2% |
| Vegetarian, Vegan, Green Dot | 2 | 0.8% |
| Triman | 2 | 0.8% |
| No gluten, en:vegan | 2 | 0.8% |
| Punto Verde | 2 | 0.8% |
| Sans OGM,en:Non GMO project | 2 | 0.8% |
| en:halal | 2 | 0.8% |
| en:no-gluten | 2 | 0.8% |
| Sin gluten,Punto Verde | 1 | 0.4% |
| Vegetarian, Vegan, European Vegetarian Union, European Vegetarian Union Vegan, Nutriscore, Rainforest Alliance, en:green-dot | 1 | 0.4% |
| Vegetarian | 1 | 0.4% |
| Thai quality label, Halal, Natural colorings, Thailand Diversity & Refinement, The Central Islamic Committee of Thailand | 1 | 0.4% |
| No gluten, No added MSG | 1 | 0.4% |
| value | count | share |
|---|---|---|
| 35 | 13.6% | |
| Condiments, Sauces, Hot sauces, Groceries | 32 | 12.4% |
| Condiments, Sauces, Groceries | 23 | 8.9% |
| Condiments, Sauces, Dips, Groceries | 13 | 5.0% |
| Condiments, Sauces, Sauces chili, en:groceries | 9 | 3.5% |
| Condiments,Sauces | 8 | 3.1% |
| Condiments, Sauces, Hot sauces | 7 | 2.7% |
| Hot sauces | 5 | 1.9% |
| Condiments,Sauces,Hot sauces | 5 | 1.9% |
| Condiments,Sauces,Hot sauces,Groceries | 5 | 1.9% |
| Condiments, Sauces, en:hot-sauces | 4 | 1.6% |
| Condiments,Sauces,Sauces chili | 4 | 1.6% |
| Sauces chili | 3 | 1.2% |
| Condiments, Sauces, Sauces chili, Sauces sriracha, en:groceries | 3 | 1.2% |
| Condiments, Sauces, Barbecue sauces, Groceries | 3 | 1.2% |
| Condiments, Sauces | 3 | 1.2% |
| undefined | 3 | 1.2% |
| Condimentos,Salsas,Salsas de chiles,en:groceries | 2 | 0.8% |
| en:hot-sauces | 2 | 0.8% |
| Condiments, Sauces, Hot sauces, Sriracha sauces | 2 | 0.8% |
| value | count | share |
|---|---|---|
| Carolina Reaper Hot Sauce | 6 | 2.3% |
| Tabasco | 5 | 1.9% |
| Sriracha Hot Chilli Sauce | 3 | 1.2% |
| Sriracha Hot Chili Sauce | 3 | 1.2% |
| Sauce de piment sriracha | 3 | 1.2% |
| 3 | 1.2% | |
| Ghost pepper hot sauce | 3 | 1.2% |
| Carolina Reaper Sauce | 3 | 1.2% |
| Carolina reaper hot sauce | 3 | 1.2% |
| Carolina Reaper | 3 | 1.2% |
| Salsa Picante | 2 | 0.8% |
| Sriracha Sauce | 2 | 0.8% |
| Sriracha | 2 | 0.8% |
| Sauce sriracha | 2 | 0.8% |
| Sauce de Piment Sriracha | 2 | 0.8% |
| Tabasco Green Pepper Sauce | 2 | 0.8% |
| Tabasco® brand pepper sauce | 2 | 0.8% |
| Habanero Hot Sauce | 2 | 0.8% |
| Hot Sauce Chile Habanero | 2 | 0.8% |
| Ghost Pepper | 2 | 0.8% |
| column | kind | null % |
|---|---|---|
| name | categorical | 0.0% |
| brand | categorical | 0.0% |
| countries | categorical | 0.0% |
| categories | categorical | 0.0% |
| ingredients | categorical | 0.0% |
| labels | categorical | 0.0% |
| url | categorical | 0.0% |
| source | categorical | 0.0% |
| type | categorical | 0.0% |
This is a product name field for hot sauces, with 221 unique values across 258 rows and near-maximal entropy ratio of 0.984. The top value 'Carolina Reaper Hot Sauce' only covers 2.3% of rows, and casing/spelling variants ('Carolina Reaper Hot Sauce' vs 'Carolina reaper hot sauce', 'Sriracha Hot Chilli Sauce' vs 'Sriracha Hot Chili Sauce') plus a French entry and 3 empty strings indicate inconsistent normalization despite a 0.0 null rate.
Treatment: normalize casing and spelling variants (and treat empty strings as missing) before grouping or joining.
saturn.columns["name"].stats
| stat | value |
|---|---|
| n | 258 |
| nulls | 0 (0.0%) |
| unique | 221 |
| top_value | Carolina Reaper Hot Sauce |
| top_rate | 0.02326 |
| cardinality | 221 |
| entropy | 7.666 |
| entropy_ratio | 0.9843 |
| alert: long_tail | 199 singleton categories |
name.
| value | count | share |
|---|---|---|
| Carolina Reaper Hot Sauce | 6 | 2.3% |
| Tabasco | 5 | 1.9% |
| Sriracha Hot Chilli Sauce | 3 | 1.2% |
| Sriracha Hot Chili Sauce | 3 | 1.2% |
| Sauce de piment sriracha | 3 | 1.2% |
| 3 | 1.2% | |
| Ghost pepper hot sauce | 3 | 1.2% |
| Carolina Reaper Sauce | 3 | 1.2% |
| Carolina reaper hot sauce | 3 | 1.2% |
| Carolina Reaper | 3 | 1.2% |
| Salsa Picante | 2 | 0.8% |
| Sriracha Sauce | 2 | 0.8% |
| Sriracha | 2 | 0.8% |
| Sauce sriracha | 2 | 0.8% |
| Sauce de Piment Sriracha | 2 | 0.8% |
| Tabasco Green Pepper Sauce | 2 | 0.8% |
| Tabasco® brand pepper sauce | 2 | 0.8% |
| Habanero Hot Sauce | 2 | 0.8% |
| Hot Sauce Chile Habanero | 2 | 0.8% |
| Ghost Pepper | 2 | 0.8% |
Categorical brand label for what appears to be a hot sauce catalogue, with 158 distinct brands across 258 rows and very high entropy ratio (0.894) indicating a long tail. The most common value is the empty string at 37 occurrences (14.3% top rate), meaning missing-as-blank dominates over real brands like Tabasco (12) and McIlhenny Company, Tabasco (11). Note also that 'Tabasco' and 'McIlhenny Company, Tabasco' likely refer to the same maker but appear as separate categories, suggesting inconsistent normalisation.
Treatment: Replace empty strings with explicit nulls, normalise brand aliases (e.g. Tabasco vs McIlhenny), then group rare brands into 'Other' before encoding.
saturn.columns["brand"].stats
| stat | value |
|---|---|
| n | 258 |
| nulls | 0 (0.0%) |
| unique | 158 |
| top_value | |
| top_rate | 0.1434 |
| cardinality | 158 |
| entropy | 6.53 |
| entropy_ratio | 0.8941 |
| alert: long_tail | 132 singleton categories |
brand.
| value | count | share |
|---|---|---|
| 37 | 14.3% | |
| Tabasco | 12 | 4.7% |
| McIlhenny Company, Tabasco | 11 | 4.3% |
| Flying Goose Brand | 6 | 2.3% |
| Melinda's | 5 | 1.9% |
| Lola's Fine Hot Sauce | 5 | 1.9% |
| Cholula | 4 | 1.6% |
| Encona | 4 | 1.6% |
| El Yucateco | 4 | 1.6% |
| Mrs. Renfro's | 4 | 1.6% |
| Huy Fong Foods, Inc. | 3 | 1.2% |
| Sauce Shop | 3 | 1.2% |
| Go-Tan | 2 | 0.8% |
| Vitasia | 2 | 0.8% |
| Valentina | 2 | 0.8% |
| Heinz | 2 | 0.8% |
| sauce shop | 2 | 0.8% |
| CHOLULA | 2 | 0.8% |
| TABASCO | 2 | 0.8% |
| Serpis | 2 | 0.8% |
This is a country-of-origin or sale label for 258 records, with 123 distinct values and no nulls. The encoding is inconsistent: plain names ('United States', 54) coexist with Open Food Facts-style tag prefixes ('en:us', 10; 'en:United States', 4) and multi-country strings ('United States, World'), so the same country appears under several spellings. High entropy ratio (0.82) and a long tail confirm the values are fragmented well beyond the 20.9% top rate.
Treatment: Normalize to ISO country codes (strip 'en:' prefixes, split comma lists) before grouping or encoding.
saturn.columns["countries"].stats
| stat | value |
|---|---|
| n | 258 |
| nulls | 0 (0.0%) |
| unique | 123 |
| top_value | United States |
| top_rate | 0.2093 |
| cardinality | 123 |
| entropy | 5.676 |
| entropy_ratio | 0.8176 |
| alert: long_tail | 99 singleton categories |
countries.
| value | count | share |
|---|---|---|
| United States | 54 | 20.9% |
| France | 28 | 10.9% |
| en:us | 10 | 3.9% |
| en:gb | 8 | 3.1% |
| en:fr | 8 | 3.1% |
| en:france | 4 | 1.6% |
| en:germany | 4 | 1.6% |
| United States, World | 4 | 1.6% |
| en:United States | 4 | 1.6% |
| United Kingdom | 3 | 1.2% |
| en:United Kingdom | 3 | 1.2% |
| France, United States | 3 | 1.2% |
| en:Canada | 3 | 1.2% |
| World | 3 | 1.2% |
| France, en:morocco | 2 | 0.8% |
| en:ma | 2 | 0.8% |
| France,Royaume-Uni | 2 | 0.8% |
| en:Germany | 2 | 0.8% |
| Belgique,France | 2 | 0.8% |
| Canada | 2 | 0.8% |
Comma-delimited product category tags, dominated by condiment/sauce/hot-sauce hierarchies. Cardinality is high (106 unique across 258 rows, entropy ratio 0.82) and the most common value is the empty string at 13.6% (35 rows), indicating missing labels encoded as blanks rather than nulls. Near-duplicate variants differ only by spacing, casing, or 'en:' prefixes (e.g., 'Condiments,Sauces' vs 'Condiments, Sauces, Groceries'), so raw cardinality overstates the true taxonomy.
Treatment: Normalise delimiters/casing, treat empty strings as missing, then split into a multi-hot tag encoding.
saturn.columns["categories"].stats
| stat | value |
|---|---|
| n | 258 |
| nulls | 0 (0.0%) |
| unique | 106 |
| top_value | |
| top_rate | 0.1357 |
| cardinality | 106 |
| entropy | 5.506 |
| entropy_ratio | 0.8183 |
| alert: long_tail | 85 singleton categories |
categories.
| value | count | share |
|---|---|---|
| 35 | 13.6% | |
| Condiments, Sauces, Hot sauces, Groceries | 32 | 12.4% |
| Condiments, Sauces, Groceries | 23 | 8.9% |
| Condiments, Sauces, Dips, Groceries | 13 | 5.0% |
| Condiments, Sauces, Sauces chili, en:groceries | 9 | 3.5% |
| Condiments,Sauces | 8 | 3.1% |
| Condiments, Sauces, Hot sauces | 7 | 2.7% |
| Hot sauces | 5 | 1.9% |
| Condiments,Sauces,Hot sauces | 5 | 1.9% |
| Condiments,Sauces,Hot sauces,Groceries | 5 | 1.9% |
| Condiments, Sauces, en:hot-sauces | 4 | 1.6% |
| Condiments,Sauces,Sauces chili | 4 | 1.6% |
| Sauces chili | 3 | 1.2% |
| Condiments, Sauces, Sauces chili, Sauces sriracha, en:groceries | 3 | 1.2% |
| Condiments, Sauces, Barbecue sauces, Groceries | 3 | 1.2% |
| Condiments, Sauces | 3 | 1.2% |
| undefined | 3 | 1.2% |
| Condimentos,Salsas,Salsas de chiles,en:groceries | 2 | 0.8% |
| en:hot-sauces | 2 | 0.8% |
| Condiments, Sauces, Hot sauces, Sriracha sauces | 2 | 0.8% |
Free-text ingredient lists for what appears to be hot-sauce or chili products, with 207 distinct strings across 258 rows and entropy ratio 0.90 indicating near-unique values. The dominant 'value' is an empty string at 49 rows (19% top_rate), so roughly a fifth of records have no ingredients recorded. The remaining entries mix multiple languages (English, French, Norwegian, German) and formatting conventions, so direct categorical use is not viable.
Treatment: Treat empty strings as missing, then tokenize/normalize across languages and extract ingredient features before modelling.
saturn.columns["ingredients"].stats
| stat | value |
|---|---|
| n | 258 |
| nulls | 0 (0.0%) |
| unique | 207 |
| top_value | |
| top_rate | 0.1899 |
| cardinality | 207 |
| entropy | 6.922 |
| entropy_ratio | 0.8997 |
| alert: long_tail | 203 singleton categories |
ingredients.
| value | count | share |
|---|---|---|
| 49 | 19.0% | |
| Distilled Vinegar, Red Pepper (19%), Salt. | 2 | 0.8% |
| Vinaigre d'alcool, piment rouge (19%), sel. | 2 | 0.8% |
| Distilled vinegar, red pepper, salt. | 2 | 0.8% |
| Rød chillipepper 54%, sukker, hvitløk, salt, vann, syre (eddiksyre, sitronsyre), smaksforsterker (mononatriumglutamat), konserveringsmiddel (natriumbenzoat). | 1 | 0.4% |
| Wasser, 30% Zucker, 8% Chilischoten*, Paprika, modifizierte Stärke, Speisesalz Säuerungsmittel: Essigsäure; Knoblauch, Zwiebeln, Verdickungsmittel: Xanthan; Konservierungsstoff: Kaliumsorbat. | 1 | 0.4% |
| soybean oil [45%], chilli [25%], onion [15%], fermented soybeans [soybeans, water], flavour enhancer [e621], salt, sugar, sichuan pepper powder, | 1 | 0.4% |
| Water, Chili Pepper, Vinegar, Salt, Spice, Sodium Benzoate (Preservative). | 1 | 0.4% |
| Fermented Red Cayenne Peppers (35%), Spirit Vinegar, Water, Salt, Garlic Powder. | 1 | 0.4% |
| Eau, piments (5%), sel, acidifiant (acide acétique), stabilisant (gomme xanthane), farine de riz, épices, vinaigre de cidre, arômes naturels. | 1 | 0.4% |
| Vineger, Louisiana type Red Chili Pepper, Salt, Thickener(Xanthan Gum), Green Pepper Natural Identical Flavor, Natural Color(E120), Antioxidant (Ascorbic Acid). May Contain Celery. | 1 | 0.4% |
| chilli 61%, sugar, water, salt, garlic, flavour enhancer: monosodium glutamate, stabiliser: xanthan gum, acidity regulator: acetic acid, citric acid, preservative: potassium sorbate | 1 | 0.4% |
| pickled red chilli 64% [chili, salt, acidity regulator (acetic acid)), sugar, water, garlic, salt, thickener (modified starch, xanthan gum), acidity regulator (acetic acid, citric acid), flavour enhancer (yeast extract), preservative (potassium sorbate), colour (paprika oleoresin). | 1 | 0.4% |
| WATER, DRIED CHILI PEPPERS (5.0%) (ARBOL & PIQUIN), SALT, VINEGAR BLEND (SPIRIT VINEGAR CIDER VINEGAR), SPICES, STABILISER (XANTHAN GUM) | 1 | 0.4% |
| Red hot pepper (87%), Garlic, Coriander, Salt, Caraway, Acidifying : E330, | 1 | 0.4% |
| 45% raapzaadolie, water, 20% sriracha saus (rode pepers, suiker, knoflook, zout, water, voedingszuur (azijnzuur, citroenzuur),smaakversterker (mononatriumglutamaat), conserveermiddel (natriumbenzoaat)), suiker, azijn, mosterd (water, azijn, MOSTERDZAAD,suiker, zout), zout, gemodificeerde zetmelen, voedingszuur (melkzuur), HEEL EIPOEDER, conserveermiddelen (kaliumsorbaat,natriumbenzoaat), verdikkingsmiddel (xanthaangom), antioxidant (calcium-dinatrium-EDTA). | 1 | 0.4% |
| Chilis, Zucker, Knoblauch, Salz, Essigsäure E260, Konservierungsmittel Kaliumsorbat E202, Konservierungsmittel Natriumbisulfit E222, Xanthan E415. | 1 | 0.4% |
| water, 32% piri-piri pepper, salt, acidity regulators: acetic acid, lactic acid, citric acid, wine vinegar (contains sulphites), spices, thickener: xanthan gum, paprika extract, preservatives: sodium benzoate, potassium sorbate, | 1 | 0.4% |
| Chili (83.23%), Sugar, Salt, Garlic (3.60%), Acetic Acid, Potassium Sorbate and Sodium Bisulfite as preservatives, Xanthan Gum. CONTAINS SULPHITE (SODIUM BISULFITE) INGR | 1 | 0.4% |
| Chili 70%, Zucker, Wasser, Salz, Sauerungsmittel: Essigsäure, Citronensäure; Verdickungsmittel: Xanthan; Geschmacksverstärker Mononatriumglutamat; Konservierungsstoff Kaliumsorbat | 1 | 0.4% |
Free-form product label tags (dietary, certification, packaging) with 77 distinct values across 258 rows. Over half the rows (56.2%) carry an empty string rather than a true null, so null_rate=0 is misleading. Values mix languages (English 'No gluten' vs French 'Sans gluten') and formats (raw text vs Open Food Facts taxonomy codes like 'en:vegan'), and many cells concatenate multiple labels with commas.
Treatment: Treat empty strings as missing, split on commas, normalise language/taxonomy variants, then multi-hot encode.
saturn.columns["labels"].stats
| stat | value |
|---|---|
| n | 258 |
| nulls | 0 (0.0%) |
| unique | 77 |
| top_value | |
| top_rate | 0.562 |
| cardinality | 77 |
| entropy | 3.557 |
| entropy_ratio | 0.5675 |
| alert: long_tail | 62 singleton categories |
labels.
| value | count | share |
|---|---|---|
| 145 | 56.2% | |
| No gluten | 9 | 3.5% |
| No GMOs, Non GMO project | 9 | 3.5% |
| Sans gluten | 5 | 1.9% |
| Halal | 4 | 1.6% |
| en:vegan | 4 | 1.6% |
| No GMOs, Non GMO project, en:no-gluten | 3 | 1.2% |
| Point Vert | 3 | 1.2% |
| Vegetarian, Vegan, Green Dot | 2 | 0.8% |
| Triman | 2 | 0.8% |
| No gluten, en:vegan | 2 | 0.8% |
| Punto Verde | 2 | 0.8% |
| Sans OGM,en:Non GMO project | 2 | 0.8% |
| en:halal | 2 | 0.8% |
| en:no-gluten | 2 | 0.8% |
| Sin gluten,Punto Verde | 1 | 0.4% |
| Vegetarian, Vegan, European Vegetarian Union, European Vegetarian Union Vegan, Nutriscore, Rainforest Alliance, en:green-dot | 1 | 0.4% |
| Vegetarian | 1 | 0.4% |
| Thai quality label, Halal, Natural colorings, Thailand Diversity & Refinement, The Central Islamic Committee of Thailand | 1 | 0.4% |
| No gluten, No added MSG | 1 | 0.4% |
This column holds Open Food Facts product URLs, one per row, with the trailing path segment being the product barcode. Every one of the 258 values is unique (entropy_ratio 1.0, top_rate 0.0039), so it functions as a row identifier rather than a feature.
Treatment: Drop from modelling; keep as a lookup link or join key on the embedded barcode.
saturn.columns["url"].stats
| stat | value |
|---|---|
| n | 258 |
| nulls | 0 (0.0%) |
| unique | 258 |
| top_value | https://world.openfoodfacts.org/product/8710605030051 |
| top_rate | 0.003876 |
| cardinality | 258 |
| entropy | 8.011 |
| entropy_ratio | 1 |
| alert: long_tail | 258 singleton categories |
url.
| value | count | share |
|---|---|---|
| https://world.openfoodfacts.org/product/8710605030051 | 1 | 0.4% |
| https://world.openfoodfacts.org/product/20170196 | 1 | 0.4% |
| https://world.openfoodfacts.org/product/6921804700269 | 1 | 0.4% |
| https://world.openfoodfacts.org/product/0097339000054 | 1 | 0.4% |
| https://world.openfoodfacts.org/product/0041500888125 | 1 | 0.4% |
| https://world.openfoodfacts.org/product/3166296552214 | 1 | 0.4% |
| https://world.openfoodfacts.org/product/6221033171107 | 1 | 0.4% |
| https://world.openfoodfacts.org/product/8853662056029 | 1 | 0.4% |
| https://world.openfoodfacts.org/product/5020580016999 | 1 | 0.4% |
| https://world.openfoodfacts.org/product/0049733000215 | 1 | 0.4% |
| https://world.openfoodfacts.org/product/6194049100044 | 1 | 0.4% |
| https://world.openfoodfacts.org/product/8710605030044 | 1 | 0.4% |
| https://world.openfoodfacts.org/product/0024463061095 | 1 | 0.4% |
| https://world.openfoodfacts.org/product/20026752 | 1 | 0.4% |
| https://world.openfoodfacts.org/product/0024463061163 | 1 | 0.4% |
| https://world.openfoodfacts.org/product/8853662056067 | 1 | 0.4% |
| https://world.openfoodfacts.org/product/0702382999100 | 1 | 0.4% |
| https://world.openfoodfacts.org/product/9556041131063 | 1 | 0.4% |
| https://world.openfoodfacts.org/product/0016229912437 | 1 | 0.4% |
| https://world.openfoodfacts.org/product/0633148100624 | 1 | 0.4% |
This column records the data provenance, with every one of the 258 rows tagged 'OpenFoodFacts'. Cardinality is 1 and entropy is 0, so it carries no information for modelling and simply documents that the entire slice came from a single source.
Treatment: Drop before modelling; retain only as dataset-level provenance.
saturn.columns["source"].stats
| stat | value |
|---|---|
| n | 258 |
| nulls | 0 (0.0%) |
| unique | 1 |
| top_value | OpenFoodFacts |
| top_rate | 1 |
| cardinality | 1 |
| entropy | 0 |
| entropy_ratio | 0 |
| alert: imbalance | top value is 100.0% of rows |
source.
| value | count | share |
|---|---|---|
| OpenFoodFacts | 258 | 100.0% |
This column is a constant categorical tag identifying every row as 'hot_sauce_product', appearing in all 258 records with no nulls. Cardinality is 1 and entropy is 0, so it carries no discriminative information. It likely served as a type marker from an ingestion pipeline rather than a usable feature.
Treatment: Drop before modelling; single constant value provides no signal.
saturn.columns["type"].stats
| stat | value |
|---|---|
| n | 258 |
| nulls | 0 (0.0%) |
| unique | 1 |
| top_value | hot_sauce_product |
| top_rate | 1 |
| cardinality | 1 |
| entropy | 0 |
| entropy_ratio | 0 |
| alert: imbalance | top value is 100.0% of rows |
type.
| value | count | share |
|---|---|---|
| hot_sauce_product | 258 | 100.0% |
click to copy
@misc{saturn-quirky-hot-sauces-2026,
author = {Steuber, Luke},
title = {Saturn reading: quirky hot sauces},
year ={2026},
howpublished = {\url{https://dr.eamer.dev/saturn/view/quirky-hot_sauces}},
note = {Profiled with saturn-dissect v0.2.0, prompt saturn-insight-v2, model anthropic:claude-opus-4-7},
}
Steuber, L. (2026). Saturn reading: quirky hot sauces. Source: /home/coolhand/html/datavis/data_trove/data/quirky/hot_sauces.json. Profiled with saturn-dissect v0.2.0 (saturn-insight-v2, anthropic:claude-opus-4-7). Retrieved from https://dr.eamer.dev/saturn/view/quirky-hot_sauces