Page Comparison

...

• Data Analysis with R: Recent and good introduction, no prior knowledge needed
• rddj.info: Resources for doing data journalism with R
• Datacamp.com: Good, beginner-friendly and interactive courses on R (and Python). Very recommended - also check out my own course :-)

Exercises

Exercise solutions day 1

1. Manillio:
1. Browse https://developer.spotify.com/console/get-search-item/ to get his ID: 7uxtLjuqkJ3cnjQQuW6Cul
2. Browse https://developer.spotify.com/console/get-artist-top-tracks/, fill in values and get JSON data
3. Copy and paste into https://json-csv.com/
4. Download as Excel - do the math (36.60705 min)
5. Take-Aways:
1. Sometimes, data is accessible via an API
2. The preferred data format of APIs is JSON
3. JSON can be converted into CSV
4. The preferred way of talking to an API is with code
2. Wasserstation Tiefenbrunnen
1. First approach: Scraping data
1. Browse https://www.tecson-data.ch/zurich/tiefenbrunnen/index.php (as probably shown on Google)
2. Select “windchill”, 2.11.2018/7.11.2018 and “all values” at the very bottom
3. Copy stuff into Excel by hand and calculate median
2. Second approach: Open Data Zürich / API:
1. Browse https://tecdottir.herokuapp.com/docs/#/measurements
2. Enter parameters
3. Copy curl string and pipe into a file
4. Upload JSON and paste into  https://json-csv.com/ (bonus: use matrix style)
5. Download CSV, open in Excel and calculate median (don’t forget to filter unneeded dates)
3. Take-Aways:
1. Copying and pasting stuff from HTML tables should be avoided
2. Always look out for an API
3. Try out different settings of your tools - they might bring you better results (“matrix style”)
4. Get to know the terminal
5. Excel / LibreOffice / OpenOffice have some good filters: get to know how to use them
6. If you run out of queries, delete cookies
3. Schlichtungsverfahren
1. Google it and go to https://www.bwo.admin.ch/bwo/de/home/mietrecht/schlichtungsbehoerden/statistik-der-schlichtungsverfahren.html
2. Download first PDF
3. Download Tabula and launch, upload PDF (or use Adobe Reader DC)
4. Select last table, lattice extraction format
5. Download as CSV
6. Open in LibreOffice and make chart
7. Take-Aways:
1. Many interesting data are buried in PDFs
2. Use proprietary software or Tabula to extract the data