Medium badge Data Cleaning

Before and after screenshots

Only editable by group admins

  • Last updated October 18, 2017 at 1:50 PM
  • Evidence visible to public
Upload screenshots of the data before and after it has been cleaned.

All posted evidence

Posted Image

Preview presentation1
Small 20180718 120207  2 ajgraham About 1 year ago

This above image shows the cleaned up Trip Card data. Before I can continue to route study I had to clean up so of the errors in the data. For instance, date/time fields containing words as seen in first image.

Preview trip card snip cleaned
Small richardson a_rich485 Over 1 year ago

I am in the process of doing a study on our Waste Collection routes. The above screen shot shows errors in our Trip Card database which will be used for this study.

Preview trip card snip
Small richardson a_rich485 Over 1 year ago

Posted Image

Preview after datacleaning hpallam
Small hpallam hpallam Almost 2 years ago

From FDA's SNAP retailers list I have created list of facilities selling fresh produce and added Louisville farmers markets accepting SNAP

Original list contains 370 facilities that included gas stations, hookah bars, fast food places, corner stores and many more. The new list is down to 96 facilities.

Small hpallam hpallam Almost 2 years ago

Before Screenshot

Preview before datacleaning hpallam
Small hpallam hpallam Almost 2 years ago

Posted Image

Preview data cleaning
Small 3e43cad1aa70d4ba82dbeb55172a774c kengodson Almost 2 years ago

Posted Image

Preview establishmentscleanview
Small img 0561 kaforski Almost 2 years ago

Posted Image

Preview establishmentstable
Small img 0561 kaforski Almost 2 years ago

Environmental Establishments Table Cleaned to Establishments_Clean View

I took a raw table downloaded from our State Vendor , cleaned the data, and ensured that all referenced fields were filled with plain english data. 
Small img 0561 kaforski Almost 2 years ago

After the data is cleaned.

Preview data cleaning after
Small dante head shot2 dstgermain About 2 years ago

Before the data is cleaned.

Preview data cleaning before
Small dante head shot2 dstgermain About 2 years ago