Tag Archives: spreadsheets

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

Getting meta

Friends, your resident bug-counter has been, unh, busy lately. I’ve been travelling a lot over the past two months, between interviews for faculty positions and conferences. And it’s not over- I’ve got two more trips in May. So far, I’ve … Continue reading

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

Guest post- About Style

Things have been a bit crazy lately in the bug counting lab. There’s a few personnel moving on to new things, and I’m in a rush to get projects wrapped up with them before I’m no longer interacting with them … 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

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