The Carpentries project comprises the Software Carpentry, Data Carpentry, and
Library Carpentry communities of Instructors, Trainers, Maintainers,
helpers, and supporters who share a mission to teach foundational computational and data science
skills to researchers.
Want to learn more and stay engaged with The Carpentries? Carpentries Clippings is The Carpentries' biweekly newsletter, where we share community news, community job postings, and more.
Sign up to receive future editions and read our full archive: https://carpentries.org/newsletter/
Software Carpentry
aims to help researchers get their work done
in less time and with less pain
by teaching them basic research computing skills.
This hands-on workshop will cover basic concepts and tools,
including program design, version control, data management,
and task automation.
Participants will be encouraged to help one another
and to apply what they have learned to their own research problems.
Who:
The course is aimed at graduate students and other researchers.
You don't need to have any previous knowledge of the tools
that will be presented at the workshop.
Requirements:
Participants must bring a laptop with a
Mac, Linux, or Windows operating system (not a tablet, Chromebook, etc.) that they have administrative privileges on.
They should have a few specific software packages installed (listed below).
Accessibility:
We are committed to making this workshop
accessible to everybody. For workshops at a physical location, the workshop organizers have checked that:
The room is wheelchair / scooter accessible.
Accessible restrooms are available.
Materials will be provided in advance of the workshop and
large-print handouts are available if needed by notifying the
organizers in advance. If we can help making learning easier for
you (e.g. sign-language interpreters, lactation facilities) please
get in touch (using contact details below) and we will
attempt to provide them.
Roles:
To learn more about the roles at the workshop (who will be doing what),
refer to our Workshop FAQ.
Code of Conduct
Everyone who participates in Carpentries activities is required to conform to the Code of Conduct. This document also outlines how to report an incident if needed.
Collaborative Notes
We will use this collaborative document for chatting, taking notes, and sharing URLs and bits of code.
Surveys
Please be sure to complete these surveys before and after the workshop.
Intro, Selecting Data, Sorting and Removing Duplicates
10:30
Coffee
10:45
Filtering, Calculating new values
12:00
Lunch break
13:00
Missing Data, Aggregation
14:30
Coffee
14:45
Combining Data, Data Hygiene, Creating and Modifying Data
16:00
Wrap-up
Setup
To participate in a
Software Carpentry
workshop,
you will need access to software as described below.
In addition, you will need an up-to-date web browser.
SQL is a specialized programming language used with databases. We use the database manager called SQLite in our lessons.
We will use a database called Survey.db for the workshop. Download it from here: https://swcarpentry.github.io/sql-novice-survey/files/survey.db
and place it somewhere easily accessible on your computer, such as your document folder or desktop. It will download directly, check your downloads folder.
If you have issues downloading the file, copy and paste the url in a new browser window.
The program we will use to interact with the SQLite database is a GUI called DB Browser - see below for operating system instructions.
Note that you will require a laptop to participate in the workshop, so do the setup on a laptop you are familiar with, if you can.
It will download directly, check your downloads folder and install it on your laptop.
NOTE: If you are unable to get admin rights on your laptop, you can download a
"portable" version of DB browser that does not require admin to install.
But please do install the regular version of DB Browser if you can.