Home > About > News >

Data Organization with Spreadsheets

September 14th, 2017

in African Studies Library, Astronomy Library, Mugar Memorial Library, Music Library, Pickering Educational Resources Library, Science and Engineering Library, Stone Science Library

Good data organization is the foundation of any research project. We organize data in spreadsheets in the ways that we as humans want to work with the data, but computers require that data be organized in particular ways. In order to use tools that make computation more efficient, such as programming languages like R or Python, we need to structure our data the way that computers can read. In this lesson, you will learn:

+ Good data entry practices – formatting data tables in spreadsheets
+ How to avoid common formatting mistakes
+ Approaches for handling dates in spreadsheets
+ Basic quality control and data manipulation in spreadsheets
+ Exporting data from spreadsheets.

Attendees will need to bring their own laptop in order to fully participate.

Date: Sept. 21, 2017
Location: Mugar Library Estin Room (302)
Time: 12:30-1:30


For more information visit the Data Services Website