Upload screenshots of the data before and after it has been cleaned.
All posted evidence
Posted Image
ajgraham
Almost 5 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
Over 5 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
Over 5 years ago
Posted Image
hpallam
Over 5 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
Over 5 years ago
Before Screenshot
hpallam
Over 5 years ago
Posted Image
kengodson
Over 5 years ago
Posted Image
kaforski
Over 5 years ago
Posted Image
kaforski
Over 5 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.