My Account

Data Cleaning & Preparation

Undergraduates, have your say! Complete a 10-minute survey and enter to win Hospitality gift cards.
Today's Hours: 8am - 10pm - All service hours

We help students and researchers learn how to get their data ready for analysis and visualization. Whether you’re working with data you collected yourself or found somewhere else, we can help you format the data so that is usable. This is called “cleaning and preparing” or “wrangling” data.

We can help you:

  • Understand the steps for cleaning and preparing data.
  • Process your data using tools such as Microsoft Excel, Open Refine, Exploratory, R and SPSS.

Get assistance

Appointments

Connect with us to ask a question or to book an appointment.

Services for faculty & instructors

We can support your teaching with:

  • In-class instruction on data cleaning and preparation.
  • Demonstrate cleaning and preparing data using tools such as Microsoft Excel, Open Refine, Exploratory, R and SPSS.

Resources

Upcoming workshops

We offer a variety of workshops to support your scholarship through the Data Skills workshop series.

    There are no upcoming workshops at the moment. Check back soon for more, or browse our full workshop calendar to see the other workshops we offer.

    CalendarWorkshop descriptions
    The library is committed to ensuring that members of our user community with disabilities have equal access to our services and resources and that their dignity and independence is always respected. If you encounter a barrier and/or need an alternate format, please fill out our Library Print and Multimedia Alternate-Format Request Form. Contact us if you’d like to provide feedback: lib.a11y@uoguelph.ca