Dataset Open Access

Socioeconomic dataset collected from open access sources for analysing demand prediction of weekend markets in the city of Hamburg

Asthana,Shivanshi; Hölzl, Ferdinand; Shuyue, Qu; Sojung, Oh; Vergara Lopez, Leidy Gicela; Rodriguez Lopez, Juan Miguel

Socioeconomic dataset for analysing  demand prediction of weekend markets in the city of Hamburg, Germany  

In this DDLitlab funded Data Literacy student project, our goal was to predict weekend markets in the city of Hamburg and using open-source data and OpenStreetMaps in conjunction with Machine Learning Algorithms. You can find a brief article about the initial grant and our approach here : https://www.cliccs.uni-hamburg.de/about-cliccs/news/2023-news/2023-08-24-ddlitlab-event.html

 

Github repository: https://gitlab.rrz.uni-hamburg.de/exploring-avenues-for-the-deployment-of-machine-learning-algorithms-for-sustainable-small-agricultural-business-information-using-openstreetmap/main-project-v-3  

This repository is intended to make our codes and visualisations openly available to the University of Hamburg students for further research. This is not to be used without citation under any circumstances and the University/authors deserve the right to withdraw consent at any time.  

Please do not forget to cite our work in the event of fair use. 

Organisation of our Github repository

Codes: contains the codes for the different methods deployed for data preparation,variable selection,visualisations showing the spatial characteristics of our variables, calculating indices such as correlation coefficients and machine learning methods in increasing order of complexity. City-district (Stadtteil) as the unit of analysis.  

Data (uploaded datasets) : The open source data obtained for the project has been obtained from OpenStreetMaps (https://wiki.openstreetmap.org/wiki/Use_OpenStreetMap ) and Statistik Nord (https://www.statistik-nord.de/ ) . Each variable contains values for all stadtteils (city-districts) of Hamburg. The filenames are self explanatory.

The Hamburg shapefile has been obtained from Geofabrik https://www.geofabrik.de/de/data/shapefiles.html In addition to the original data uploaded in the section, we have also laid down the final data we have deployed with the algorithms, in the final final_data.csv  

Our repository contains the following additional sections:

Results: This section contains results from the codes processed in the first section. It includes the final 10 variables selected for the study, the results from the VIF analysis, correlation matrix, and some model output statistics.  

Visualisations: This section is dedicated to visualisations of the variables used for the study and the results from deployment of various methods. In case of any questions, please do not hesitate to contact us at our official student IDs : first.lastname@studium.uni-hamburg.de. We are also available on LinkedIn for professional networking in case of other queries.  

Data curators /DDLitLab data literacy project team 

Ferdinand Hölzl 

Leidy Gicela Vergara Lopez 

Shivanshi Asthana 

Shuyue Qu 

Sojung Oh 

Juan Miguel Rodriguez Lopez 

Files (236.8 kB)
Name Size
farms.csv
md5:ffdf62e5c91437306ddbc67b480502b7
6.3 kB Download
final_data.csv
md5:9a87afcaa3e8eb9881240102d20ccb47
25.6 kB Download
greengrocer.csv
md5:623a36af72f1637ab21cfbe1b838b108
4.1 kB Download
Organic_Restaurants.csv
md5:1ddc2bfade40aac7e4a298a650e44956
2.4 kB Download
restauraurants.csv
md5:2295517d62b315b0f598ae655bd99084
121.9 kB Download
stadtteilprofile2023.csv
md5:ab09aa547f44df217873aa1c6bad3370
35.9 kB Download
Supermarkets.csv
md5:658e0a968f3790d2fc7f113099c32bda
26.0 kB Download
tax_data_excel.csv
md5:2afe0802012ffbb3fda0b74c56812d4e
5.4 kB Download
vegan_restaurants.csv
md5:9519f469325681978c33138ce7048059
4.8 kB Download
weekendmarkets.csv
md5:cf5826db3f912d3eac3d73861e41c677
4.4 kB Download
  • https://gitlab.rrz.uni-hamburg.de/incorporating-ml-models-for-spatial-demand-prediction-of-weekend-markets-in-the-city-of-hamburg-germany/incorporating-ml-models-for-spatial-demand-prediction-of-weekend-markets-in-the-city-of-hamburg-germany
  • https://www.cliccs.uni-hamburg.de/about-cliccs/news/2023-news/2023-08-24-ddlitlab-event.html

Cite record as