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 6 months 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 About 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 About 1 year ago

Posted Image

Preview after datacleaning hpallam
Small hpallam hpallam About 1 year 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 About 1 year ago

Before Screenshot

Preview before datacleaning hpallam
Small hpallam hpallam About 1 year ago

Posted Image

Preview data cleaning
Small 3e43cad1aa70d4ba82dbeb55172a774c kengodson About 1 year ago

Posted Image

Preview establishmentscleanview
Small img 0561 kaforski Over 1 year ago

Posted Image

Preview establishmentstable
Small img 0561 kaforski Over 1 year 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 Over 1 year ago

After the data is cleaned.

Preview data cleaning after
Small dante head shot2 dstgermain Over 1 year ago

Before the data is cleaned.

Preview data cleaning before
Small dante head shot2 dstgermain Over 1 year ago