Tutorials

• 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. (Highly recommended if you ever want to publish your data.)
• 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.
• Modern Plain Text Computing - A short seminar taught at Duke, aimed at students and researchers, covering how to think about and use computers, file systems, the shell, text editors, version control, and build systems. The philosophy is that these is essential knowledge for doing lots of research and making that research reproducible.
  • A Mastodon thread discussing similar classes and resources
• 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.