Pine Assembly Workshop: Shipment export CSV
Shipment export CSV for Pine Assembly Workshop. 16 shipments over 4 delivery rounds, 13 delivered and 3 still in transit. Every parcel is one DESK kit at 12.200 kg gross, so gross_weight_kg is always parcels times 12.200. Parcels total 56 and delivered_parcels total 44; the in-transit rows report 0 delivered and an empty delivery_date.
csv
text/csv
- Document Set
- logistics
- Industry
- logistics
- Source Kit
- inventory-manufacturing
- Synthetic
- true
- As Of
- 2026-09-08
- Rows
- 16
Binary csv: no in-browser preview. Download it above to open in a compatible application.
Specifications
- Document Set
- logistics
- Industry
- logistics
- Source Kit
- inventory-manufacturing
- Synthetic
- true
- As Of
- 2026-09-08
- Rows
- 16
- Columns
- 14
- Routes
- 4
- Parcels
- 56
- Delivered Parcels
- 44
- Encoding
- UTF-8
- Line Endings
- LF
Testing contract
Expected to pass- Scenario
- Import the shipment export and recompute the weight and the delivery totals.
- Expected result
- All 16 rows recompute: gross_weight_kg = parcels * 12.200 and minutes_variance = actual_minutes - planned_minutes for delivered rows, 0 for the rest. Parcels sum to 56, delivered_parcels to 44, and exactly 3 rows carry an empty delivery_date.
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
“Pine Assembly Workshop: Shipment export CSV” is a deterministic Novus Examples fixture for Data import. Realistic faker-generated datasets with documented schemas for testing import and ETL flows.
Documented properties for this file: 16 rows · 14 columns · UTF-8 · LF. 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("shipments-export.csv")
print(df.head())
print(df.dtypes)Related files
- csvPine Assembly Workshop: Bill of lading registerBill of lading register for Pine Assembly Workshop. 4 bills of lading, one per delivery round, covering all 16 shipments and all 56 pieces. The piece counts are 8, 12, 16, 20 and they sum to 56, which is the parcels column of shipments-export.csv. Freight terms are prepaid on every round.
- csvPine Assembly Workshop: Carrier invoice whose fuel surcharge uses the wrong basis on one lineCarrier invoice whose fuel surcharge uses the wrong basis on one line for Pine Assembly Workshop. The 13 billable shipments with a TOTAL row. Every line is correct except SHIP-07, whose fuel_surcharge was computed on the weight charge alone: 53.68 times 0.065 gives 3.49 instead of 5.05 on the base plus weight charge. The line is 1.56 light and the TOTAL row reads 859.63 against the correct 861.19.
- csvPine Assembly Workshop: Carrier rate sheetCarrier rate sheet for Pine Assembly Workshop. Two delivery zones. Zone A covers ROUTE-1 ROUTE-2 at 18.00 per stop plus 0.85 per kg; zone B covers ROUTE-3 ROUTE-4 at 24.00 per stop plus 1.10 per kg. A fuel surcharge of 0.065 applies to the base plus the weight charge, and every line rounds half up to cents.
- jsonPine Assembly Workshop: Carrier rate sheet JSONCarrier rate sheet JSON for Pine Assembly Workshop. The same two zones as rate-sheet.csv with the rating formula written out as a string, including the fact that the fuel surcharge applies to the base charge as well as the weight charge. That basis is the one most often got wrong.
- csvPine Assembly Workshop: Customs commercial invoice linesCustoms commercial invoice lines for Pine Assembly Workshop. 4 invoice lines covering the 20 kits on BOL-2026-0004, all classified under HS 9403.30 with country of origin CA. amount_usd equals quantity times unit_price_usd on every line and the column sums to 1360.00; net weight sums to 226.880 kg and gross to 244.000 kg, the difference being the packaging.
- xmlPine Assembly Workshop: Customs entry XMLCustoms entry XML for Pine Assembly Workshop. An import entry for the BOL-2026-0004 consignment on a CIF basis. Goods 1360.00 plus freight 388.08 gives a customs value of 1748.08; duty at 0.025 is 43.70 and import tax at 0.050 on the customs value plus duty is 89.59, a total payable of 133.29. The statistical breakdown restates the 226.880 kg across the three component codes.
Generated by generation/industry_documents.py. Free for any use, no attribution required, license.