Dec 15 & 16 2014
9:00 am - 4:00 pm
Instructors: Cam MacDonell, Vicky Varga
Helpers: Cody Moorhouse, Katie Thompson
Software Carpentry's mission is to help scientists, engineers and librarians become more productive by teaching them basic lab skills for computing like program design, version control, data management, and task automation. This two-day hands-on workshop will cover basic concepts and tools; 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 librarians with an interest in using programming to improve their workflow.
Requirements: Participants must bring a laptop with a few specific software packages installed (listed below). They are also required to abide by Software Carpentry's Code of Conduct.
Contact: Please mail email@example.com for more information.
|09:00||Bash and python review|
|13:00||Getting started with SQL|
|16:00||Wrap-up, poll for next day's content|
|09:00||Regular expressions and cleaning data with Open Refine OR further work with SQL|
|13:00||Programming with python and SQL|
To participate in a Software Carpentry workshop, you will need working copies of the software described below. Please make sure to install everything (or at least to download the installers) before the start of your workshop.
Bash is a commonly-used shell. Using a shell gives you more power to do more tasks more quickly with your computer.
Python is becoming very popular in scientific computing, and it's a great language for teaching general programming concepts due to its easy-to-read syntax. We teach with Python version 2.7, since it is still the most widely used. Installing all the scientific packages for Python individually can be a bit difficult, so we recommend an all-in-one installer.
SQL is a specialized programming language used with databases. We use a simple database manager called SQLite, either directly or through a browser plugin.
The default shell in all versions of Mac OS X is bash,
so no need to install anything. You access bash from
the Terminal (found
/Applications/Utilities). You may want
to keep Terminal in your dock for this workshop.
The default shell is usually
but if your machine is set up differently
you can run it by opening a terminal and typing
There is no need to install anything.
sqlite3 comes pre-installed on Linux.
you may install the Firefox SQLite browser plugin described below.
Download Wing 101
We recommend the all-in-one scientific Python installer Anaconda. (Installation requires using the shell and if you aren't comfortable doing the installation yourself just download the installer and we'll help you at the boot camp.)
bash Anaconda-and then press tab. The name of the file you just downloaded should appear.
yesand press enter to approve the license. Press enter to approve the default location for the files. Type
yesand press enter to prepend Anaconda to your
PATH(this makes the Anaconda distribution the default Python).
Instead of using
sqlite3 from the command line,
you may use this plugin
for Firefox instead.
To install it:
In newer versions of Firefox, the menu bar isn't always displayed. To make
it appear, use the
Alt key next to the space bar on your
keyboard, or consult
page from Firefox for additional help.