staudtyves/ConsultancyProject_2_ETL
1
0
Fork 0
forked from stoffelmauro/ConsultancyProject_2_ETL
Code Pull Requests Activity

Commit Graph

  • c3ab7d8e2f global for movingAverage implemented main mmaurostoffel 2025-01-15 21:27:53 +01:00
  • 7e3862a578 global Extractions für region capacities monthly and weekdays eingefügt, closes #15 mmaurostoffel 2025-01-15 20:44:16 +01:00
  • 0733709366 diagramm etl Giò Diani 2025-01-15 17:48:12 +01:00
  • 3290c1cce3 some polishing Giò Diani 2025-01-15 16:57:18 +01:00
  • 959b84d1e1 my fault fixes #14 Giò Diani 2025-01-15 14:31:07 +01:00
  • a5a21fb925 Überarbeitung Dashboard Giò Diani 2025-01-14 22:11:31 +01:00
  • 8bef4b9621 added simple caching for etl Giò Diani 2025-01-14 19:56:15 +01:00
  • d436c5d892 added missing logic to etl_region_movAverage mmaurostoffel 2025-01-13 23:06:42 +01:00
  • cd66207bc7 Prediction Charts Giò Diani 2025-01-13 22:50:03 +01:00
  • 18a672a5de bugfix unnecessary parentheses broke api Giò Diani 2025-01-13 19:22:54 +01:00
  • 3d7d5bbbe3 etl_region_capacities_monthly eingefügt closes #10 mmaurostoffel 2025-01-13 18:02:19 +01:00
  • d8d2d1e757 Werte von 0-1 zu 0-100 angepasst closes #12 mmaurostoffel 2025-01-13 17:17:46 +01:00
  • 4487932f1b Merge branch 'main' of https://gitea.fhgr.ch/stoffelmauro/ConsultancyProject_2_ETL mmaurostoffel 2025-01-13 17:12:15 +01:00
  • fcd7ca34ad closes #11 mmaurostoffel 2025-01-13 17:08:37 +01:00
  • ebcd647a2f Einige Anpassungen am Dashboard. Region Ansicht. Giò Diani 2025-01-13 17:06:54 +01:00
  • a3121bf58e navigation, regions Giò Diani 2025-01-12 20:55:46 +01:00
  • 50ea3f1bd8 fix module not found error (matplotlib not needed) Giò Diani 2025-01-12 20:44:05 +01:00
  • af1c2301a9 Added Enpoint for movAvg mmaurostoffel 2025-01-12 20:38:16 +01:00
  • a571c8c40f Merge branch 'main' of https://gitea.fhgr.ch/stoffelmauro/ConsultancyProject_2_ETL mmaurostoffel 2025-01-12 20:30:03 +01:00
  • b23879b6d3 First Version of etl_region_movAverage.py eingefügt mmaurostoffel 2025-01-12 20:27:33 +01:00
  • 0250221d96 implements regions base endpoint #9 Giò Diani 2025-01-12 20:16:20 +01:00
  • f31c23ea51 Merge branch 'main' of https://gitea.fhgr.ch/stoffelmauro/ConsultancyProject_2_ETL mmaurostoffel 2025-01-12 16:53:33 +01:00
  • c059890ba7 singleScrape_of_region eingefügt mmaurostoffel 2025-01-12 16:53:31 +01:00
  • 992e299829 Überarbeitung Property Giò Diani 2025-01-12 16:49:29 +01:00
  • 67c0d85213 Betrifft #7. Möglicher fix, bitte Resultat kontrollieren. Das Problem lag m.E. darin, dass durch das hin und her zwischen Listen und DataFrame die Typisierungen der Werte verloren gehen, weshalb es dann auch entsprechenden Fehler schmeisste. Giò Diani 2025-01-12 11:56:33 +01:00
  • e176d1e73f Bugfix: Testfunktion aus etl_region_comparison gelöscht mmaurostoffel 2025-01-12 11:28:53 +01:00
  • f114eb7f5a strict=False hinzugefügt wie in der Fehlermeldung vorgeschlagen mmaurostoffel 2025-01-12 11:20:39 +01:00
  • 99a112df24 longer timeouts Giò Diani 2025-01-11 21:54:26 +01:00
  • 2013d2b440 Wiederinstandsetzung Heatmap @stoffelmauro musste dazu etwas in der API anpassen. Giò Diani 2025-01-11 20:52:02 +01:00
  • 67382003ca closes #7: etl_region_capacities erstellt mmaurostoffel 2025-01-11 17:33:50 +01:00
  • 774e30c945 fix daily chart Giò Diani 2025-01-09 18:49:09 +01:00
  • 3b935a4d20 Nachbaren in Popup Giò Diani 2025-01-09 18:34:20 +01:00
  • 638d835d3b closes #5 mmaurostoffel 2025-01-09 18:26:01 +01:00
  • cb6935b60c updated the output of the etl_property_neighbour.py mmaurostoffel 2025-01-09 18:22:55 +01:00
  • 60a3d7d9b3 Little fixes for weekdays mmaurostoffel 2025-01-09 17:40:58 +01:00
  • 65b63d1326 Sortierung für etl_property_capacities_monthly eingefügt mmaurostoffel 2025-01-09 15:59:16 +01:00
  • a6cbe3bc29 update des etl_capacities_weekdays.py mmaurostoffel 2025-01-09 15:07:38 +01:00
  • 2508b34ceb bugfix: falscher name mmaurostoffel 2025-01-09 14:49:03 +01:00
  • cc71cbba2d Endpoint für etl_property_neighbours hinzugefügt mmaurostoffel 2025-01-09 14:48:33 +01:00
  • 258f1e4df6 Anzeige Auslastung p. Monat bei Properties im Dashboard. Giò Diani 2025-01-08 22:02:33 +01:00
  • 7884febe53 issue 5 resolved mmaurostoffel 2025-01-07 20:20:48 +01:00
  • 42dc14021f etl_Property_capacities_weekdays.py eingefügt mmaurostoffel 2025-01-06 19:42:49 +01:00
  • f5a2b16721 Fehlende Anführungszeichen hinzugefügt resolves #3 Giò Diani 2025-01-05 21:45:23 +01:00
  • d9cae3d0ab Issue 3 fast fertig mmaurostoffel 2025-01-05 21:23:10 +01:00
  • 8bcc1c57b5 Gitea Issue 1 Beispiel 2 mmaurostoffel 2025-01-05 17:25:29 +01:00
  • 03e78a4105 Issue 1 Beispiel 1 resolved mmaurostoffel 2025-01-05 16:12:16 +01:00
  • 2a9ef9d991 Merge branch 'main' of https://gitea.fhgr.ch/stoffelmauro/ConsultancyProject_2_ETL mmaurostoffel 2025-01-05 15:51:27 +01:00
  • 8fcaf2a6f7 Gitea Issue 2 resolved mmaurostoffel 2025-01-05 15:51:19 +01:00
  • 8655255782 info button, dashboard startseite Giò Diani 2025-01-05 13:26:51 +01:00
  • 281d9d3f5a Merge branch 'main' of https://gitea.fhgr.ch/stoffelmauro/ConsultancyProject_2_ETL mmaurostoffel 2025-01-05 13:19:45 +01:00
  • c68e6f54bd cleanup commit mmaurostoffel 2025-01-05 13:19:43 +01:00
  • 32d162c7c5 Überarbeitung Detailansicht. Giò Diani 2025-01-04 18:16:12 +01:00
  • 466d3168c4 Added caching (adjust setting in .env accordingly; CACHE_STORE=file) Giò Diani 2025-01-03 16:44:17 +01:00
  • 5a2cc96a95 Achsenbeschrftungen, Farben Giò Diani 2025-01-03 16:25:30 +01:00
  • 640a5b2f9e Implement region capacity as test Giò Diani 2024-12-20 21:46:54 +01:00
  • f585a7a2aa fix fehlender import Giò Diani 2024-12-20 21:36:47 +01:00
  • 818d6fb5ec Merge branch 'main' of https://gitea.fhgr.ch/stoffelmauro/ConsultancyProject_2_ETL mmaurostoffel 2024-12-20 20:57:20 +01:00
  • a8b856b714 etl_region_capacities erstellt + database und api/main Anpassungen dafür mmaurostoffel 2024-12-20 20:57:10 +01:00
  • 0aa0f2345c documentation folder, c4 diagram Giò Diani 2024-12-20 17:38:08 +01:00
  • eb362d78ad Vorbereitung heatmap Giò Diani 2024-12-20 15:25:33 +01:00
  • 5f61911a69 More sensible default in env, more documentation how to install and run. Giò Diani 2024-12-20 15:03:22 +01:00
  • 66d048c70e Enhance coordinated view of property. Giò Diani 2024-12-20 12:20:49 +01:00
  • 63590d69ab fix wrong import path. Giò Diani 2024-12-20 10:56:10 +01:00
  • 47a5035787 dashboard einzelansicht trend auslastung. Giò Diani 2024-12-19 19:22:09 +01:00
  • 4b7067fb63 Merge branch 'main' of https://gitea.fhgr.ch/stoffelmauro/ConsultancyProject_2_ETL mmaurostoffel 2024-12-19 18:11:17 +01:00
  • eba2f0a265 Data Quality updated to include Regions and more information mmaurostoffel 2024-12-19 18:11:15 +01:00
  • ce46655003 Add some more description. Giò Diani 2024-12-18 20:10:11 +01:00
  • 233f3c475a Added README Giò Diani 2024-12-18 19:55:42 +01:00
  • a8543d619f Further dashboard development. Giò Diani 2024-12-18 19:52:06 +01:00
  • 1574edea88 First steps Dashboard. Giò Diani 2024-12-18 15:14:13 +01:00
  • a03ce3d647 Änderungen von bevor Monorepo übernommen mmaurostoffel 2024-12-18 15:11:23 +01:00
  • f4a927e125 refactor to monorepo, install laravel. Giò Diani 2024-12-18 10:14:56 +01:00
  • 125250a665 data_quality.py erstellt zur Visualisierung der Datenqualität mmaurostoffel 2024-12-11 01:01:52 +01:00
  • 479feba6c2 refactoring to monorepo refactor-to-mono Giò Diani 2024-11-28 16:38:18 +01:00
  • 338d3e9cc2 Untersuchung Vorbuchungszeit abgeschlossen mmaurostoffel 2024-11-28 16:10:53 +01:00
  • 1e0b9f1233 2 ETL Pipelines hinzugefügt, Untersuchung Vorbuchungszeit begonnen mmaurostoffel 2024-11-27 01:00:17 +01:00
  • d15664df43 Some queries and really low res prototype for visual analytics dashboard. Giò Diani 2024-11-18 22:40:26 +01:00
  • e2734a3db5 Pakete polars und fastAPI hinzugefügt, Database Klasse verbessert, FastAPI route erstellt. Giò Diani 2024-11-04 21:36:34 +01:00
  • 219ad57a35 SQL-Abfrage Distanz Geokoordinaten hinzugefügt. Giò Diani 2024-11-02 16:33:19 +01:00
  • 30ca9d7452 fullOccupancy.csv added mmaurostoffel 2024-10-28 21:21:00 +01:00
  • 62fa63d0f5 add .env Giò Diani 2024-10-27 16:10:49 +01:00
  • d5f8f21308 some more queries from consultancy 1 Giò Diani 2024-10-26 18:02:53 +02:00
  • 00ee0c5847 some queries from consultancy 1 Giò Diani 2024-10-26 17:31:46 +02:00
  • 094f51b3b4 rudimentary class for database interactions (download db from switchdrive: https://drive.switch.ch/index.php/apps/files/?dir=/Consultancy&fileid=7499599646#). Giò Diani 2024-10-26 17:21:52 +02:00
  • 7b979997ad pixi https://pixi.sh/v0.27.1/ide_integration/pycharm/ Giò Diani 2024-10-25 15:32:55 +02:00
  • e8830c32e6 PropertiesPerScrape erstellt und ein paar Edits mmaurostoffel 2024-10-24 20:04:22 +02:00
  • f7b62f4e4c Ortsvergleich eingefügt mmaurostoffel 2024-10-21 23:56:10 +02:00
  • c7d58c2b23 ETL update mmaurostoffel 2024-10-19 20:25:30 +02:00
  • fde2f7ffb7 Angepasst an neue DataDump mmaurostoffel 2024-10-05 16:47:19 +02:00
  • a39f0e8bd1 Requirements geupdated mmaurostoffel 2024-10-05 14:53:49 +02:00
  • 63ba3c8a8b base + old mmaurostoffel 2024-10-05 14:46:03 +02:00
  • bfae03cf5f delete All mmaurostoffel 2024-10-05 14:36:25 +02:00
  • db4319e7d6 Repository created, old data ported mmaurostoffel 2024-10-05 13:44:23 +02:00