Difference between revisions of "Tutorials"
Jump to navigation
Jump to search
(Add talk on creating plots and tables and add a link to the data-cleaning entry) |
|||
| Line 1: | Line 1: | ||
* [https://kbroman.org/dataorg/ Organizing Data in Spreadsheets] - Tips on how to store data in a spreadsheet in a way that will make it easiest to sustainably work with. | * [https://kbroman.org/dataorg/ Organizing Data in Spreadsheets] - Tips on how to store data in a spreadsheet in a way that will make it easiest to sustainably work with. | ||
* [https://www.youtube.com/watch?v=7Ma8WIDinDc Data Cleaning Principles] - A video of a talk from csv,conf6 on how to approach and think about cleaning data. The slides, annotated with notes, are [https://kbroman.org/Talk_DataCleaning/data_cleaning_notes.pdf here]. | * [https://www.youtube.com/watch?v=7Ma8WIDinDc Data Cleaning Principles] - A video of a talk from csv,conf6 on how to approach and think about cleaning data. The slides, annotated with notes, are [https://kbroman.org/Talk_DataCleaning/data_cleaning_notes.pdf here] and the corresponding GitHub repo is [https://github.com/kbroman/dataorg here]. | ||
* [https://www.youtube.com/watch?v=Ssso_5X1UPs Creating Effective Figures and Tables] - A video of a talk about how to communicate data clearly with graphs and tables. [https://www.biostat.wisc.edu/~kbroman/presentations/graphs2018.pdf A PDF of the slides] and [https://github.com/kbroman/Talk_Graphs the GitHub repo] are also available. | |||
* [https://missing.csail.mit.edu/ The Missing Semester] - A series of MIT class videos teaching a lot of practical things that developers need to know. | * [https://missing.csail.mit.edu/ The Missing Semester] - A series of MIT class videos teaching a lot of practical things that developers need to know. | ||
Revision as of 02:23, 6 June 2022
- Organizing Data in Spreadsheets - Tips on how to store data in a spreadsheet in a way that will make it easiest to sustainably work with.
- Data Cleaning Principles - A video of a talk from csv,conf6 on how to approach and think about cleaning data. The slides, annotated with notes, are here and the corresponding GitHub repo is here.
- Creating Effective Figures and Tables - A video of a talk about how to communicate data clearly with graphs and tables. A PDF of the slides and the GitHub repo are also available.
- The Missing Semester - A series of MIT class videos teaching a lot of practical things that developers need to know.
- bashcrawl - A text adventure to teach shell skills.
- SQL Murder Mystery - "The SQL Murder Mystery is designed to be both a self-directed lesson to learn SQL concepts and commands and a fun game for experienced SQL users to solve an intriguing crime."
- "... If you really want to learn a lot about SQL, you may prefer a complete tutorial like Select Star SQL."
- An Introduction to VisiData - One way to learn the best power tool for exploring and analyzing CSV files, SQLite databases, Excel files, and many other file formats. VisiData is also handy for editing, manipulating, and joining CSV files. Click here to install it.