kkale25
commented
5 years ago Updated Friday 9/21
Session 3:
- Transpose MSD from wide to long for purpose of importing into Tableau
- Transpose MSD from long to wide to create calculate indicators
- Create calculated indicator using a loop (?)
- Recap Session 1 and 2 specifically for summarize, filter
- Merging MSD with external dataset
- Intro to ICPI Utilities (ex: calculated indicators)
Session 4
- Spend brief period to review some data wrangling beforehand (for vis purposes)
- Leaflet (50%) - because you can't map in Excel, people may not have ArcGIS software, etc. and easy for new users to pick-up
- ggplot2, plotly (50%) - Can create bar graphs that are interactive and can be exported into HTML format that you can open in a webpage; interaction offline; portable
- Create single visual and export it into html file
- Culminating exercise at the end of Sessions 3 and 4 - submit and turn in for your certificate!
Proposed Dates
- 1.5 day training: Thursday 9/18 and Friday 9/19
PLANNING NOTES:
- Documenting the functions we use (laundry list) and organizing it various categories (for planners on which ones they want to teach)
- Do all of this in Tidyverse
- Creating calculated indicator: go through loops (purrr); could Aaron/Anu support?
- Intro to ICPI utilities (don't have much to do with these competencies, but use this at the end to cap off the presentation, 15-20 min)
- Pulling utilities is still difficult pulling from GitHub
- Office Hours
- Homework: Session 1 and 2 recordings; recap cumulative exercise from Session 1 and 2
- Output from Session 3 that could feed into Session 4
anu87
From Shazad....
Session 3: Advanced data manipulation methods • Transposing (wide to long, long to wide) • Creating calculated indicators (ex: proxy testing to tx linkage, yield) • Merging on a primary key (joins) • Iterating: intro to functions.
Session 4: Data visualization, graphs, tables, maps • ggplot2 package? • Line graphs • Bar graphs • Scatter plot • Maps