You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
A roughly working model is at the end of this description as "Gas Reserve Model", the file content as "CSV File Content".
Issues:
The header row includes a "." and spaces in names leading to Could not write to postgres database. syntax error at or near "." in these queries: CREATE TABLE IF NOT EXISTS Gas (.;Kritisch;Angespannt;Stabil;Speicherstand IST;gesetzliche Ziele text);, we should make sure those work by adding '' around column names in the postgres
Not all columns contain every datapoint, an easy fix (that is better than not being able to parse it) would be to drop rows that are not complete
The first value is a date string, we could add a build in datatype "date" that can parse it and save it as date in postgres
The Bundesnetzagentur publishes easy to parse CSV files here: https://www.bundesnetzagentur.de/DE/Gasversorgung/aktuelle_gasversorgung/_svg/Indikator3_Speicher/Indikator_Speicher.html?nn=1077982
A roughly working model is at the end of this description as "Gas Reserve Model", the file content as "CSV File Content".
Issues:
Could not write to postgres database. syntax error at or near "."
in these queries:CREATE TABLE IF NOT EXISTS Gas (.;Kritisch;Angespannt;Stabil;Speicherstand IST;gesetzliche Ziele text);
, we should make sure those work by adding '' around column names in the postgresCSV File Content
Gas Reserve Model
The text was updated successfully, but these errors were encountered: