A Eureka Moment-Scrubbing Data

It’s back to school time.  Today there’s a fleet of yellow school buses on the road and the newspapers have been filled with stories of how to pack nutritious lunches and how to encourage conversations with your children and so on.  Under the banner then of the well-known phrase “And what did you learn today” and as a testimony to lifelong learning, here goes my true story.  

I am not a researcher but I have worked with many a talented person who was.  I would hear them speak of ‘scrubbing data’ or ‘cleaning data’.  My understanding of what it means is meagre but I get the concept.  You take a bunch of information that is stored in a database and through some mysterious process you separate the wheat from the chaff as a farmer would put it, or you remove the extraneous bits and keep the solid data that can be used in your research.  

I have discovered a new method for scrubbing data and am putting it out there for researchers to comment upon.  Perhaps this eureka moment will save a lot of time for those who toil in the details of data. 

Step one:  You are the secretary.  Using your laptop and a memory stick, take minutes at the Annual General Meeting of a local organization.  No paper back up is needed.  Good for the environment and efficient too.  Save the minutes, the only record of the meeting, on your memory stick.

Step two: Stick the memory stick in your pocket after the meeting (you don’t want to lose it).

Step three: Do laundry.  Washer and dryer.  Find memory stick in drum of dryer after cycle is complete.  

Step four:  Sweat.  Insert memory stick and find out….ta da!!  It works!

Moral of the story, well actually two morals:

1.  There is more than one way to scrub data.

2. Those high-efficiency (HE) front loading washers really are gentle on your belongings.

A true story.

7 thoughts on “A Eureka Moment-Scrubbing Data

    1. I know you have done research and as part of that community, your comment tells me my method of scrubbing data is unlikely to make any waves in that world. Particularly any waves where the water has had Tide added to it.

      1. Maybe we could do a multi-centred trial. We could make it double blind (i.e. closing both eyes when we put the drive in the washer) and then report the outcomes to a centralized database. Of course we would try to get published and that would mean using citations and references and bibliographies and well, don’t get me started for I have work to do and I am going to save it on my flash drive.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s