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