Comments for Mohamed by Arlene

[ArleneHohl]

Hi @DrMohamedElsherif ,

I really like your project idea, as it sounds quite interesting and also provides meaningful insights into the cycling patterns in Tübingen. Especially the Background and Bikes Dataset paragraphs were easily understandable.

However, I have a few suggestions for your projects:

• [ ] Where exactly can you datasets be found online? On the linked website I can see the differents data points and overviews over the last hours, days, months and years. But where are the 4 tables? It would be great if you could also link this webpage.
• [ ] You provided a zip file with the data, it would be great if you could also link it in your markdown document.
• [ ] You could also add the head of the tables in your markdown and describe the different variables briefly.
• [ ] Is there a codebook for the datasets? If yes, you might provide it as well, that would make it easier to understand the dataset.
• [ ] Also in your description, I was a little confused as you said there were 4 datasets but you ony mentioned weather, holiday and cyclist count.
• [ ] In you data mining paragraph, you could be a little more precise: What exactly do you want to see at the end of the projects? What should be achieved? Then you could name the differents steps that have to be done more a little closer.
• [ ] Same with the visual data exploration paragraph: It would be easier to have a (or multiple) concrete goal(s) for which you create visuals. You could also provide examplatory graphs.
• [ ] One idea I have for visualization would be a graph that displays weather and count of cyclists or direction of cyclists over the course of a few days (maybe in spring, where the weather changes a lot every day). I think that would be interesting to see.

All in all I like the dataset you chose and think this is a very interesting project. However, I am not really sure what your project goals is, yet. A little more clarification would help!

Best, Arlene

[DrMohamedElsherif]

Rebuttal

First of all, Thank you for your encouraging words and insightful suggestions for my project.

Addressing your concerns step by step: Response to Points 1-5: The dataset is neither found on the website nor online. It was a part of a Data science project management project of a past course and has no available cookbook. The dataset set is composed of 4 excel sheets that together represent all information needed to analyze and correlate the data: a) a Bike count sheet: This has the count of bike over each hour for each day starting from January 2018 and till January 2024 across different channels (stations along each of the three paths where counter devices are installed) indicated by channel_id for each of the three counter sites, indicated by counter_id. b) a Counter Site sheet that has the names and the ids of the three counter sites; c) a Weather sheet: That has weather information including temperature, wind, humidity, rain, etc. for each day of the years 2011 and 2012. d) Finally the Holidays sheet: That shows the federal and state holidays for years 2018 till 2024. This sheet is important for correlating the bike traffic across sites with regular workdays versus holidays. Nonetheless, I will include the head of the tables in my markdown.

Response to Points 6-8: By the end the project, there shall be clear idea about: 1- The traffic load across each counter site (possible visualization using bar charts or scatter plots) 2- The temporal variation of bike traffic across the three sites. (possible visualization using bar charts or scatter plots) 3- Correlation between bike traffic and a) Hours of the day; b) Days of the week; c) Seasons of the year; and location of the counter site. (possible visualization using heat maps). To achieve those goals, joining between tables would be required to link the weather data for each day to the bike count data for each day for example. To filter holidays, the bike count data needed to be joined with the holidays data first, and so on. Another issue is the missing data, which is left to the researcher to decide which method is the best the deal with this problem; a skill to learn by doing this project.

I hope project idea and goals are now clearer. For further concerns, please do not hesitate to provide further valuable comments.