Tag Archives: excel

Teaching students how to data- some reflections

So, I survived my first time as a Data Carpentry instructor. Yes, it was a month ago, but I thought it would be good to take some time to reflect. Also, I’ve been busy. And travelling. And [excuses]. It was … Continue reading

Posted in Uncategorized | Tagged , , , , , , | 2 Comments

Practical data management takes its show on the road

This title should really read “Practical data management takes its show ACROSS the road” because that’s what I’m actually doing. Next week, I’ll be a co-instructor for the second Data Carpentry bootcamp at MSU’s BEACON Center, which is right across … Continue reading

Posted in Uncategorized | Tagged , , , , , | 5 Comments

Dealing with dates as data in Excel

This post is not about dating, as in romantic entanglements, although lots of scientists I know collect data on the dates they go on.* But like dates of the human variety, dealing with dates, as in those pesky things that … Continue reading

Posted in Uncategorized | Tagged , , , , , , , , , | 5 Comments

Git and the n00b

Do people still say n00b? Well, I do.* I am not entirely a n00b to open source living. Back in my physics undergrad days, I was, exclusively, a Linux person. Windows was my enemy, because Windows was The Man.** Using … Continue reading

Posted in Uncategorized | Tagged , , , , , , , , , , , , , | 6 Comments

Help me, I’m covered in bees -or- using OpenRefine to clean specimen data

It’s probably time I got to this- I did promise it over three months ago. Yesterday, I finally sat down to revisit a dataset which was created in 2008-2009, but then orphaned when staff moved on to other positions. It’s … Continue reading

Posted in Uncategorized | Tagged , , , , , , , , , , | 1 Comment

Cleaning up your act: simple ways to find errors in your raw data

It’s been an interesting week. We had a massive ice storm in the eastern Great Lakes area, trees and power lines were totaled, power was out everywhere- I didn’t have electricity for four days. Things, basically, are a disordered mess, … Continue reading

Posted in Uncategorized | Tagged , , , , , , , , , , , | 9 Comments

Formatting your data tables for storage and re-use

If you follow me on twitter, you probably know I’m compiling a huge dataset. I’ve used a variety of tools to work on these data (most notably reshape and OpenRefine), and now the data is in its cleanest form- a … Continue reading

Posted in Uncategorized | Tagged , , , , , , , , , | 5 Comments