Data cleaning · Decatur, GA
Decatur data cleaning around the Square
Decatur's shops cluster near the Square, and its calendar runs on festivals and a Wednesday market. Sellers collect sales in bursts, and the bursts leave uneven records. We even them out.
Decatur cleaning for Wednesday market sellers
The Decatur Farmers Market runs Wednesday afternoons, 4 to 7 pm, rain or shine, on the front lawn of First Baptist Church Decatur at 308 Clairemont Ave. A weekly seller logs each sale in a three-hour window, and quick entries are often inconsistent. Sourdough, sour dough and Sourdough loaf all appear in the same column.
We list the variants, you choose the winner, and every row follows. Weekly totals per product then agree with each other, and a slow Wednesday looks slow for a real reason.
Festival weekends: books, art, beer and makers
The Decatur Book Festival listed its 2026 edition for October 2-3, with a street fair on the Saturday. Decatur also hosts the Decatur Arts Festival each May, plus a Craft Beer Festival, a Wine Festival and a Maker's Faire. A bookseller, brewer or craftsperson who sells at several of these ends up with festival names spelled in many ways.
We give each festival one label, so you can compare what each event brought in, and we convert prices typed as text into numbers.
Customers who live near the Square and study nearby
Agnes Scott College is at 141 E. College Ave., Georgia State University's Perimeter College has a campus in Decatur, and Columbia Theological Seminary is here too. A cafe or print shop that serves those campuses gets sign-ups with school addresses and home addresses for the same person.
We match those rows by a rule you approve and show you every pair before merging.
Mixed-use districts and transit-minded customers
Decatur has regained economic vigor as a mixed-use district with transit access to downtown Atlanta. Customers from both places buy from the same shops, so the city column collects Decatur, decatur, Decatur GA and Atlanta. We settle the spellings, and where a row names Atlanta, we leave it Atlanta. Your reports then show where buyers say they are from, in labels that match.
Questions from Decatur owners
I sell at three or four festivals a year. Can you compare them?
Once each festival has one label across your rows, yes. That comparison belongs to the analysis stage, which comes right after cleaning.
Our sign-up sheet has school and home emails for the same person. Do you merge those?
Only if you approve a rule that links them, such as a matching name and phone number. Emails alone will not tell us.
What if I cannot say which spelling is right?
Pick the one you would want on a printed report. We apply it everywhere and keep the list of old spellings, so you can change your mind.
Sources for the facts on this page: Decatur Farmers Market, Community Farmers Markets · Decatur Book Festival · Decatur, Georgia, Wikipedia · About, Agnes Scott College · About, Perimeter College at Georgia State University
Send us the Decatur sheet from your last festival
Book a free call on the contact page. Tell us what you want counted and we will say where we would start.