Alder Table Bistro: Till import in the European dialect
Till 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.
item_code;item_name;category;price;tax_code;modifier_group
MENU-01;Roast chicken plate;Mains;24,00;GST5;MG-MENU-01
MENU-02;Tomato soup;Starters;11,50;GST5;MG-MENU-02
MENU-03;Garden salad;Starters;13,00;GST5;MG-MENU-03
MENU-04;Potato gratin;Sides;12,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;Maison blanc, Okanagan, 150 ml;By the glass;7,75;GST5;
DRK-02G;Maison rouge, Okanagan, 150 ml;By the glass;8,00;GST5;
DRK-03G;Brut sparkling, 150 ml;By the glass;10,50;GST5;
DRK-04G;Draught lager, 473 ml;By the glass;8,50;GST5;
DRK-01B;Maison blanc, Okanagan, 750 ml;By the bottle;38,00;GST5;
DRK-02B;Maison rouge, Okanagan, 750 ml;By the bottle;40,00;GST5;
DRK-03B;Brut sparkling, 750 ml;By the bottle;52,00;GST5;
DRK-05B;R�serve rouge, 750 ml;By the bottle;64,00;GST5;
GIFT-25;Gift card 25;Stored value;25,00;EXEMPT;
Specifications
- Kit
- restaurant-bistro
- 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 Alder Table Bistro 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
“Alder Table Bistro: 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
- 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.
- csvJuniper Corner Cafe: Till import in the European dialectTill 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.
- 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.
