Here is the information presented in a table format:

Note:

• Some products have prices per liter instead of per kg, as indicated.
• Some products have discounted prices or additional sizes available, but only the main price and weight are shown here for simplicity.
• The table is sorted by the weight of the products.

Certainly! Here is the table converted to a CSV format suitable for DuckDB:

csv
Copy
Product Name,Weight,Price per kg,Original Price,Discounted Price
HEITMANN pure Reine Citronensäure,350 g,9.28571,3.69,3.09
Purux Zitronensäure Pulver,5 kg,3.39,,
Feinwälder® Premium Zitronensäure Pulver,5 kg,4.00,20.99,19.99
GreatVita Zitronensäure Monohydrat Pulver,5 kg,3.18,17.99,15.89
PLANTAWA Zitronensäure-Pulver,1 kg,8.95,,
SOLUP Zitronensäure Pulver,5 kg,5.50,29.90,26.12
JKR Spices® Zitronensäure Pulver,250 g,30.00,,7.12
Zitronensäure Pulver für technische Anwendungen,5 kg,2.80,,
2 kg Zitronensäure in Pulver,2 kg,4.20,,
HEITMANN pure Reine Citronensäure,2x 350 g,13.79,,
HEITMANN pure Reine Citronensäure (Flüssig),500 ml,6.50,,2.92
Nortembio Zitronensäure,1 kg,16.22,,15.41
Maxxi Clean Zitronensäure Pulver,2x 900 g,7.72,,12.51
Zitronensäure Pulver für technische Anwendungen,1 kg,4.99,,
1 kg Zitronensäure Lebensmittelqualität,1 kg,5.49,,
5 kg Zitronensäure Lebensmittelqualität,5 kg,3.60,,

You can save this content to a file with a .csv extension and then use it with DuckDB.

To load the CSV file into a table named x using the DuckDB CLI, you can use the following command:

sh
Copy
duckdb ~/tmp/zitronensauere.csv -c "CREATE TABLE x AS SELECT * FROM read_csv_auto('~/tmp/zitronensauere.csv');"

Here's a step-by-step breakdown of what this command does:

1. duckdb ~/tmp/zitronensauere.csv: This starts the DuckDB CLI and opens the specified CSV file.
2. -c "CREATE TABLE x AS SELECT * FROM read_csv_auto('~/tmp/zitronensauere.csv');": This command creates a table named x and populates it with the data from the CSV file using the read_csv_auto function.

Alternatively, if you are already in the DuckDB CLI, you can execute the following command:

sql
Copy
CREATE TABLE x AS SELECT * FROM read_csv_auto('~/tmp/zitronensauere.csv');

This will create the table x and load the data from the CSV file into it.