Page Comparison

...

• Chroma.js– Javascript library for dealing with colors
• D3.js– Javascript library with modules for dealing with colors
• HCL Wizard– Tool for viewing, manipulating, and choosing HCL color palettes
• I Want Hue– Tool for generating and refining palettes of optimally distinct colors
• Colorbrewer– Tool for finding sequential, diverging, and qualitative color palettes
• Color Picker for Data– Tool for picking color palettes
• Accessible Color Matrix– Tool for building accessible color palettes
• Contrast Finder– Tool for finding good contrasts between two colors
• Chromaticity– Guidance for accessible visualization color design
• Color Oracle– Free color blindness simulator for Window, Mac and Linux

Data Literacy Resources (Fall semester 2019)

Slides

...

• Theory Part I

General / good reads

• «The world’s most valuable resource is no longer oil, but data» vs. «Data is not the new oil»

• Data Scientist: The Sexiest Job of the 21st Century

...

• 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

KEV

Kontext:

https://www.srf.ch/news/schweiz/abstimmungen/abstimmungen/energiestrategie/die-profiteure-der-energiewende

...

• )

...

• .

...

Sind folgende Auswertungen / Applikationen mit dem Datensatz möglich?

• Falls ja, wie würdet Ihr vorgehen?
• Falls nein, wieso nicht?

1. Durchschnittliche Vertragslänge (Inbetriebnahme bis Vertragsende)
2. Gesamtstromproduktion nach Kanton
3. Gesamtsumme der Geldbezüge für einerseits Herren, andererseits Frauen
4. Durchschnittliche Länge der Strassennamen nach Kanton
5. Karte mit Standorten der KEV-Bezüger (= ein Punkt-Symbol für jeden genauen Standort, ähnlich wie in diesem Artikel)

Exercise solutions day 1

...

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

...

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

...