General Information

Data Carpentry workshops are designed for any researcher who has data they want to analyze, and no prior computational experience is required. This hands-on workshop teaches basic concepts, skills and tools for working more effectively with data. We will cover data organization in spreadsheets, data cleaning, basic SQL syntax, the Shell command line, and Python for data analysis and visualization using examples from biology. Participants should bring their laptops and plan to participate actively. By the end of the workshop learners should be able to more effectively manage and analyze data and be able to apply the tools and approaches directly to their ongoing research.

Data Carpentry's aim is to teach researchers basic concepts, skills, and tools for working with data so that they can get more done in less time, and with less pain.

Please visit Our Workshop Etherpad for the links and materials being used and shared during the workshop and to interact with workshop participants.

Tentative Schedule:

DAY ONE

• 8:30-10:30: Setup, Intro to Data Carpentry, Intro to Python / Pandas
• 10:45-12:30: Python - working with data, Index, slice, subset
• 12:30-1:30: LUNCH
• 1:30-3:30: Introduction to Shell

DAY TWO

• 8:30-10:30: SQL Introduction to databases, combining and querying data using SQL, Accessing SQL using Python
• 10:45-12:30: Merging DataFrames in Python, Automations - loops and functions
• 1:30-3:15: Automating Workflows -- Functions and Loops in Python
• 3:30-4:30: Wrap Up Python activity - Data Ingest, automation, visualzation workflows in Python

Links to Materials:

Please note that we may or may not get to all of the materials below depending upon the pace of the workshop.

• Python Ecology Materials
• Shell Materials
• Sql Materials

Instructors: Leah Wasser, Mariela Perignon

Assistants:

Who: The course is aimed at faculty, research staff, postdocs, graduate students, advanced undergraduates, and other researchers in any field. No prior computational experience is required.

Where: 3450 Mitchell Lane, Boulder, Colorado 80301. Get directions with OpenStreetMap or Google Maps.

Requirements: Data Carpentry's teaching is hands-on, so participants are encouraged to bring in and use their own laptops to insure the proper setup of tools for an efficient workflow once you leave the workshop. (We will provide instructions on setting up the required software several days in advance, and the classroom will have computers with the software installed). There are no pre-requisites, and we will assume no prior knowledge about the tools. Participants are required to abide by Software Carpentry's Code of Conduct.

Contact: Please email lwasser@neoninc.org for questions and information not covered here.

Twitter: #datacarpentry

@datacarpentry

Acknowledgements & Support

Data Carpentry is supported by the Gordon and Betty Moore Foundation and a partnership of several NSF-funded BIO Centers (NESCent, iPlant, iDigBio, BEACON and SESYNC) and Software Carpentry, and is sponsored by the Data Observation Network for Earth (DataONE). The structure and objectives of the curriculum as well as the teaching style are informed by Software Carpentry.

---

Setup

To participate in a Data Carpentry workshop, you will need access to the software described below. In addition, you will need an up-to-date web browser. Once you are done installing the software listed below, please go to this page, which has instructions on how to test that everything was installed correctly.