Tag Archives: data formatting

Spreading the open science love like it’s my job because it is my job.

So, this happened. Apparently, yelling into the void about data management and reproducibility is a very good way to get yourself onto a rag-tag team of open-science proto-superheroes.1 Yes, that’s right, I’m a Mozilla Science fellow, and together, baby, we’re … Continue reading

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

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 , , , , , , , , , | 4 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

Bridging the data style gap- Part 1- different disciplines, different data formats

This post is first in a series where I will essentially be live-blogging on working on an #otherpeoplesdata dataset. These data are associated with a project examining bee diversity in bioenergy cropping systems. I’ve already done a little bit of … Continue reading

Posted in Uncategorized | Tagged , , , , , , , , , , , , | 4 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

Excel is not your lab notebook

Almost every entomologist I know uses excel for data storage. I’m not going to turn this into a rant about why that’s wrong, in fact, I’m going to confess something that may seriously impair my street cred* as a data … Continue reading

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