costinflation/373k-prices-condiment-economy
372,714 prices: 5 categories, 12 U.S. ZIPs, 29 days Condiment Prices Raw Dataset (2026) How do listed and package-standardized prices for pickles, mayonnaise, ketchup, mustard, and pickle relish vary across U.S. ZIP markets and days? This fixed research snapshot contains 372,714 unaggregated, quality-filtered price observations across 5 condiment categories, 12 U.S. ZIP markets, and 29 consecutive dates from July 21 through August 18, 2026. The analysis-ready CSV preserves… See the full description on the dataset page: https://huggingface.co/datasets/costinflation/373k-prices-condiment-economy.
372,714 prices: 5 categories, 12 U.S. ZIPs, 29 days
Condiment Prices Raw Dataset (2026)
How do listed and package-standardized prices for pickles, mayonnaise, ketchup, mustard, and pickle relish vary across U.S. ZIP markets and days?
This fixed research snapshot contains 372,714 unaggregated, quality-filtered price observations across 5 condiment categories, 12 U.S. ZIP markets, and 29 consecutive dates from July 21 through August 18, 2026. The analysis-ready CSV preserves product titles, dates, geography, listed quantities and prices, plus a source-neutral within-category comparable-price field.
What “quality-filtered” means here: the rows are unaggregated product-level observations after category, safety, and exact-duplicate filtering. The file includes derived comparison fields and is a prepared research snapshot rather than an aggregate index.
Dataset at a glance
What one row represents
One row is one quality-filtered condiment product-title, ZIP-market, date, listed-quantity, and listed-price observation in one condiment category. It is not a sale, order, demand, inventory, market-share, consumption, nutrition, preference, or product-performance record. Multiple distinct offers can share a title, ZIP, and date; exact duplicate public rows have been removed.
Comparable-price method
price_amount preserves the listed price. For 208,199 rows, normalized_price_amount expresses that price at the fixed comparison target for the row's category. The remaining 164,515 rows retain their listed prices and leave normalized_price_amount blank because the quantity is unresolved or incompatible with the category target. Every nonblank comparable price has a positive resolved quantity and the stated within-category target.
Compare normalized values only within the same series_id. The targets are category-specific and do not make pickles, mayonnaise, ketchup, mustard, and pickle relish equivalent in ingredients, flavor, nutrition, quality, or intended use.
Category reference
Columns
Project ideas
- Compare standardized price distributions within each condiment category.
- Measure geographic price variation across the 12 ZIP markets without treating the selected ZIPs as citywide estimates.
- Track daily category medians, dispersion, and missing comparable-price coverage through the 29-day window.
- Compare package-size effects on listed and standardized price distributions within a category.
- Build a source-neutral condiment-price dashboard in Python, R, SQL, Excel, Tableau, or Power BI.
Quick start with Pandas
import pandas as pd
df = pd.read_csv(
"costinflation-condiment-economy-prices-2026-07-21-to-2026-08-18.csv",
dtype={"geography_id": "string", "series_id": "category"},
)
summary = (
df.groupby(["series_id", "geography_label"])["normalized_price_amount"]
.median()
.sort_values()
)
print(summary)Quality and interpretation
- All 29 expected dates, all 12 ZIP markets, and all 1,740 category × ZIP × date cells are present.
- Exact duplicate public rows: 0.
- Formula-leading product titles: 0.
- Every nonblank comparable price has a positive resolved quantity and the category's fixed comparison target.
- The 164,515 unresolved or dimension-incompatible rows retain their listed prices and leave the comparable-price field blank.
- Product titles are descriptive text, not stable public product identifiers.
- ZIP labels describe selected markets rather than citywide, metropolitan, state, or national estimates.
- Category-specific package comparisons do not establish ingredient, flavor, nutrition, quality, preference, or performance equivalence.
- Shipping, tax, redeemed promotions, purchases, availability outside the selected ZIP panel, consumption, nutrition, preferences, and product performance are outside this dataset.
Provenance
CostInflation prepared and released this fixed, source-neutral snapshot. Category assignment, geographic labels, exact-duplicate filtering, safety filtering, and within-category comparable-price calculations were applied consistently before publication. The public file contains only the 16 documented research columns.
License
Released under CC0 1.0 Universal for unrestricted reuse. Attribution is not required, but citation helps others find the release.
CostInflation Team. (2026). Condiment Prices Raw Dataset (2026). CC0 1.0 Universal.
Released by CostInflation Team.