Difference between revisions of "Tutorials"
Jump to navigation
Jump to search
(Add tutorials on data organization and data cleaning) |
|||
| 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 are [https://kbroman.org/Talk_DataCleaning/ | * [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://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:10, 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.
- 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.