Spreadsheets – THATCamp Sydney 2013 http://sydney2013.thatcamp.org Thu, 31 Oct 2013 02:22:49 +0000 en-US hourly 1 https://wordpress.org/?v=4.9.12 Cleaning Data http://sydney2013.thatcamp.org/2013/10/28/cleaning-data/ http://sydney2013.thatcamp.org/2013/10/28/cleaning-data/#comments Sun, 27 Oct 2013 20:25:20 +0000 http://sydney2013.thatcamp.org/?p=244 Continue reading →]]>

Digital humanities data is generally messy. Sometimes it looks like the floor of a teenage bedroom. Before we can analyse the data we need to clean it up and organise it. There are many ways of doing this. One important tool to use is a spreadsheet.

In this session I will run through some basic techniques in Excel that are often used for cleaning up data. This session should be useful for those who are starting out in digital humanities.

It would be good if someone who is proficient with OpenRefine (formerly known as Google Refine) could share this session so participants can get a taste for that tool as well.

I”ve put some simple Excel tips in a document which you can access here.

]]> http://sydney2013.thatcamp.org/2013/10/28/cleaning-data/feed/ 3