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

ajgraham Over 2 years 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.

a_rich485 About 3 years 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.

a_rich485 About 3 years ago

Posted Image

hpallam About 3 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.

hpallam About 3 years ago

Before Screenshot

hpallam About 3 years ago

Posted Image

kengodson About 3 years ago

Posted Image

kaforski Over 3 years ago

Posted Image

kaforski Over 3 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. 
kaforski Over 3 years ago

After the data is cleaned.

dstgermain Over 3 years ago

Before the data is cleaned.

dstgermain Over 3 years ago