Juniper Corner Cafe: Till import in the European dialect
Till import in the European dialect for Juniper Corner Cafe. The same 21 rows as pos-import.csv in the other dialect a till exports: semicolon delimited, decimal comma in the price column, Latin-1 encoded and CRLF terminated. It carries the non-ASCII characters "é", so reading it as UTF-8 raises a decode error instead of silently producing mojibake.
item_code;item_name;category;price;tax_code;modifier_group
MENU-01;Flat white;Espresso bar;4,75;GST5;MG-MENU-01
MENU-02;Oat latte;Espresso bar;5,50;GST5;MG-MENU-02
MENU-03;Avocado toast;All day kitchen;12,00;GST5;MG-MENU-03
MENU-04;Breakfast sandwich;All day kitchen;10,50;GST5;MG-MENU-04
MOD-01;Extra portion;Modifier;2,50;GST5;MG-MENU-01
MOD-02;Takeaway packaging;Modifier;0,50;GST5;MG-MENU-01
MOD-03;Extra portion;Modifier;2,50;GST5;MG-MENU-02
MOD-04;Takeaway packaging;Modifier;0,50;GST5;MG-MENU-02
MOD-05;Extra portion;Modifier;2,50;GST5;MG-MENU-03
MOD-06;Takeaway packaging;Modifier;0,50;GST5;MG-MENU-03
MOD-07;Extra portion;Modifier;2,50;GST5;MG-MENU-04
MOD-08;Takeaway packaging;Modifier;0,50;GST5;MG-MENU-04
DRK-01G;Cold brew, 150 ml;By the glass;3,75;GST5;
DRK-02G;Pressed apple juice, 200 ml;By the glass;2,50;GST5;
DRK-03G;Sparkling water, 150 ml;By the glass;1,50;GST5;
DRK-04G;Matcha glac�, 400 ml;By the glass;5,75;GST5;
DRK-01B;Cold brew, 750 ml;By the bottle;18,00;GST5;
DRK-02B;Pressed apple juice, 1000 ml;By the bottle;12,00;GST5;
DRK-03B;Sparkling water, 750 ml;By the bottle;7,00;GST5;
DRK-05B;Kombucha, 330 ml;By the bottle;6,00;GST5;
GIFT-25;Gift card 25;Stored value;25,00;EXEMPT;
Specifications
- Kit
- restaurant-cafe
- Industry
- food-service
- Schema Version
- 1
- Synthetic
- true
- As Of
- 2026-09-08
- Currency
- CAD
- Menu Items
- 4
- Rows
- 21
- Columns
- 6
- Delimiter
- ;
- Decimal Separator
- ,
- Encoding
- ISO-8859-1
- Line Endings
- CRLF
Testing contract
Expected to pass- Scenario
- Use till import in the european dialect in the Juniper Corner Cafe menu, allergen and till import workflow.
- Expected result
- The same 21 rows as pos-import.csv in the other dialect a till exports: semicolon delimited, decimal comma in the price column, Latin-1 encoded and CRLF terminated. It carries the non-ASCII characters "é", so reading it as UTF-8 raises a decode error instead of silently producing mojibake.
What is a .csv file?
CSV (Comma-Separated Values) is a plain-text tabular format where rows are lines and fields are separated by commas, with quoting rules for values that contain delimiters, quotes, or newlines. It has no formal type system and depends on encoding and dialect conventions. It is the most portable format for tabular data exchange.
How to use this file
Use an example CSV to test parsers against quoting and embedded-delimiter edge cases, header handling, encoding detection, and import pipelines into databases or spreadsheets.
How to use this file for testing
“Juniper Corner Cafe: Till import in the European dialect” is a deterministic Testaroo fixture for Data import, CSV parsing, Encoding detection. Realistic faker-generated datasets with documented schemas for testing import and ETL flows.
Documented properties for this file: 21 rows · 6 columns · ISO-8859-1 · CRLF. Compare results against paired or grouped companions on this page when present (clean↔damaged, searchable↔scanned, or format twins) so scores stay reproducible across runs.
Download the file once, keep the path stable in CI or local scripts, and treat the spec table as the contract: dimensions, seeds, field lists, and roles are intentional. Corrupt or invalid samples are labelled as such, expect parsers to fail loudly rather than silently accept them.
Data fixtures document their exact quirks (delimiters, encodings, null handling, schema, and row counts) in the spec table. Point your parser or importer at the file and assert it handles the documented edge cases; clean and deliberately-messy siblings make before/after diffs straightforward.
Code examples
import pandas as pd
df = pd.read_csv("pos-import-semicolon-latin1.csv")
print(df.head())
print(df.dtypes)Generated by generation/restaurant_menus.py. Free for any use, no attribution required, license.
Related files
- csvAlder Table Bistro: Till import in the European dialectTill import in the European dialect for Alder Table Bistro. The same 21 rows as pos-import.csv in the other dialect a till exports: semicolon delimited, decimal comma in the price column, Latin-1 encoded and CRLF terminated. It carries the non-ASCII characters "é", so reading it as UTF-8 raises a decode error instead of silently producing mojibake.
- csvCedar Street Tacos: Till import in the European dialectTill import in the European dialect for Cedar Street Tacos. The same 21 rows as pos-import.csv in the other dialect a till exports: semicolon delimited, decimal comma in the price column, Latin-1 encoded and CRLF terminated. It carries the non-ASCII characters "ï", so reading it as UTF-8 raises a decode error instead of silently producing mojibake.
- csvCopper Oven Bakery: Till import in the European dialectTill import in the European dialect for Copper Oven Bakery. The same 21 rows as pos-import.csv in the other dialect a till exports: semicolon delimited, decimal comma in the price column, Latin-1 encoded and CRLF terminated. It carries the non-ASCII characters "à", so reading it as UTF-8 raises a decode error instead of silently producing mojibake.
- csvEmber Lane Pizza: Till import in the European dialectTill import in the European dialect for Ember Lane Pizza. The same 21 rows as pos-import.csv in the other dialect a till exports: semicolon delimited, decimal comma in the price column, Latin-1 encoded and CRLF terminated. It carries the non-ASCII characters "à", so reading it as UTF-8 raises a decode error instead of silently producing mojibake.
- csvHarbour Kitchen Group: Till import in the European dialectTill import in the European dialect for Harbour Kitchen Group. The same 21 rows as pos-import.csv in the other dialect a till exports: semicolon delimited, decimal comma in the price column, Latin-1 encoded and CRLF terminated. It carries the non-ASCII characters "à", so reading it as UTF-8 raises a decode error instead of silently producing mojibake.
- csvWillow Event Kitchen: Till import in the European dialectTill import in the European dialect for Willow Event Kitchen. The same 21 rows as pos-import.csv in the other dialect a till exports: semicolon delimited, decimal comma in the price column, Latin-1 encoded and CRLF terminated. It carries the non-ASCII characters "é", so reading it as UTF-8 raises a decode error instead of silently producing mojibake.
