Data Dojo Würzburg 24

DataDojo@Lunch - hybrid

October 2023

• Image Not Showing Possible Reasons

  • The image file may be corrupted
  • The server hosting the image is unavailable
  • The image path is incorrect
  • The image format is not supported

  Learn More →
  we have a summer break, so the next Dojo is in October
• When: Wednesday, October 11^th, 2023 at 11:00am until 12:30pm (90 minutes)
• Where: CCTB or online (CCTB Seminar Zoom Link)
• Info: DataDojo Website, Repo

Dataset

German Electricity Data

Image Not Showing Possible Reasons

• The image file may be corrupted
• The server hosting the image is unavailable
• The image path is incorrect
• The image format is not supported

Learn More →

• Data Source: SMARD Web Portal
• Task: forecasting (using the past to predict the future)
• Language: julia or python or R

First steps:

• load the data
  Image Not Showing Possible Reasons

  • The image file may be corrupted
  • The server hosting the image is unavailable
  • The image path is incorrect
  • The image format is not supported

  Learn More →
• split the data into train/val/test sets
  Image Not Showing Possible Reasons

  • The image file may be corrupted
  • The server hosting the image is unavailable
  • The image path is incorrect
  • The image format is not supported

  Learn More →
• plot the time series (at different temporal resolution)
  Image Not Showing Possible Reasons

  • The image file may be corrupted
  • The server hosting the image is unavailable
  • The image path is incorrect
  • The image format is not supported

  Learn More →
• calculate the mean production per month
  Image Not Showing Possible Reasons

  • The image file may be corrupted
  • The server hosting the image is unavailable
  • The image path is incorrect
  • The image format is not supported

  Learn More →
• is there a seasonal pattern (what kinds of seasonalities)
• make a prediction for the validation set
• evaluate the quality of the prediction

Collaborative Tools and Workflow

For Notebooks (R, python, julia, js, …) with real time collaboration CoCalc seems to be the best option right now. It worked great the last couple of times so we'll stick to it for now. You need to register an account there (it is free).

Future Suggestions

Add your suggestions to the list and

Image Not Showing Possible Reasons

• The image file may be corrupted
• The server hosting the image is unavailable
• The image path is incorrect
• The image format is not supported

Learn More →

to the end of a line you are interested in

Data Sets

• Extract structured data from pdfs (Example: population statistics in Leinach from Gemeindeblatt)
• Würzburg Baumkataster, Würzburger Klimabäume
• Bee Varroa Image Classification
  Image Not Showing Possible Reasons

  • The image file may be corrupted
  • The server hosting the image is unavailable
  • The image path is incorrect
  • The image format is not supported

  Learn More →
• German Electricity Data
  Image Not Showing Possible Reasons

  • The image file may be corrupted
  • The server hosting the image is unavailable
  • The image path is incorrect
  • The image format is not supported

  Learn More →
• Mattermost Chat History - e.g. analyze the messages and reactions from the lunch channel
• Wordbank - data of children learning to talk
• All Birds
  Image Not Showing Possible Reasons

  • The image file may be corrupted
  • The server hosting the image is unavailable
  • The image path is incorrect
  • The image format is not supported

  Learn More →
• Results of the Bundestagswahl 2021
• Weather data throughout Germany over time (incl. temperature, precipitation, …): https://www.dwd.de/DE/leistungen/cdc_portal/cdc_portal.html
• German Mikrozensus
• Kaggle Titanic or Tabular Playground or Meta Kaggle
• World Trade Data (Open Trade Statistics)
• Open Citation Data
• Top 100 charts + Audio Features
• Emoji Usage
  Image Not Showing Possible Reasons

  • The image file may be corrupted
  • The server hosting the image is unavailable
  • The image path is incorrect
  • The image format is not supported

  Learn More →
  Image Not Showing Possible Reasons

  • The image file may be corrupted
  • The server hosting the image is unavailable
  • The image path is incorrect
  • The image format is not supported

  Learn More →
  Image Not Showing Possible Reasons

  • The image file may be corrupted
  • The server hosting the image is unavailable
  • The image path is incorrect
  • The image format is not supported

  Learn More →
• Observable Curated Datasets
• Abgeordnetenwatch - Data on German elected officials in EU-Parlament, Bundes- and Landtag (Election History, Ausschusszugehörigkeit, Side jobs, etc)
• Button Men Game Results

Tools/Languages

• R/tidyverse
• python
• Power BI
• Tableau
• KNIME
• javascript
• julia
• visidata

Skills

• interactive maps
• dashboards
• animations

Data Sources

all data types are welcome, including tables, images, videos, sounds, DNA, …

• OpenData Bayern
• TidyTuesday
• Our World in Data (R package: owidR), Sustainable Development Goals
• Open Data Initiatives (Würzburg, Germany, Statistisches Bundesamt, Europe, APIs)
• Data is plural
• Awesome Public Datasets
• Kaggle Datasets or Competitions, e.g. SLICED
• tsibbledata: Time Series Datasets
• R-text-data: Text Datasets, ready to use in R
• data.world
• Statista - the University of Würzburg has a campus license
• Open Legal Data
• Bundestag Data (e.g. poll results, deputies, wahl-o-mat, inspirational blog post)
• Deutsche Digitale Bibliothek (API, old newspapers from Germany)
• Earth Observation: Satellite Image Time Series
• Machine Learning Datasets
• Internation (Student) Assessment Data (TIMSS, PIRLS, PISA, …)
• (Medical) Imaging Datasets, MedMNIST
• Inspirational Notebooks on Observable
• Ski resort statistics
  Image Not Showing Possible Reasons

  • The image file may be corrupted
  • The server hosting the image is unavailable
  • The image path is incorrect
  • The image format is not supported

  Learn More →

Cross Links

• previous pad
• next pad