From 3854500520dec78e5b386b6533404d6f6373f907 Mon Sep 17 00:00:00 2001 From: Gunnar Morling Date: Thu, 28 Dec 2023 22:33:15 +0100 Subject: =?UTF-8?q?=F0=9F=93=88=20More=20stations?= MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit --- .../dev/morling/onebrc/CreateMeasurements.java | 22 ++++++++++++++++++++++ 1 file changed, 22 insertions(+) (limited to 'src/main/java/dev/morling/onebrc') diff --git a/src/main/java/dev/morling/onebrc/CreateMeasurements.java b/src/main/java/dev/morling/onebrc/CreateMeasurements.java index ff4b7d7..5f1fdae 100644 --- a/src/main/java/dev/morling/onebrc/CreateMeasurements.java +++ b/src/main/java/dev/morling/onebrc/CreateMeasurements.java @@ -52,6 +52,28 @@ public class CreateMeasurements { System.exit(1); } + // data from https://en.wikipedia.org/wiki/List_of_cities_by_average_temperature; + // converted using https://wikitable2csv.ggor.de/ + // brought to form using DuckDB: + // D copy ( + // select City, regexp_extract(Year,'(.*)\n.*', 1) as AverageTemp + // from ( + // select City,Year + // from read_csv_auto('List_of_cities_by_average_temperature_1.csv', header = true) + // union + // select City,Year + // from read_csv_auto('List_of_cities_by_average_temperature_2.csv', header = true) + // union + // select City,Year + // from read_csv_auto('List_of_cities_by_average_temperature_3.csv', header = true) + // union + // select City,Year + // from read_csv_auto('List_of_cities_by_average_temperature_4.csv', header = true) + // union + // select City,Year + // from read_csv_auto('List_of_cities_by_average_temperature_5.csv', header = true) + // ) + // ) TO 'output.csv' (HEADER, DELIMITER ','); List stations = Arrays.asList( new WeatherStation("Adelaide", 17.3), new WeatherStation("Melbourne", 15.1), -- cgit v1.2.3