Data cleaning · Marietta, GA
Marietta data cleaning for Square vendors and Cobb shops
The Marietta Square hosts a market on Saturdays and again on Sundays, and sellers who work both keep two sets of notes. We join them into one clean sheet, with each change shown.
Marietta cleaning for two market days
The Marietta Square Farmers Market runs Saturdays 9 am to noon year-round, with a break around Christmas, and Sundays noon to 3 pm from April to late fall, at 50 Park Square. A vendor who works both days tends to keep a Saturday sheet and a Sunday sheet, in different layouts, with different spellings of the same products.
We lay them side by side, agree on one set of labels with you, and apply it to both. The weekend total then comes from rows that mean the same thing.
Veterans Day and other Square crowds
The City of Marietta's site lists an annual Veterans Day Parade and Ceremony on the Square, set for November 14. Crowds like that bring one-day sales that get typed into the main file in a hurry, often with prices as text and customer names split across two columns.
We turn prices into numbers, put the names back together by a rule you approve, and show you the cells we touched.
Customers tied to campuses, hospitals and bases
Kennesaw State University runs a campus at 1100 South Marietta Pkwy, Life University offers programs in Marietta, and the city's top employers in a 2021 report were WellStar Kennestone Hospital, Dobbins Air Reserve Base and Cobb County Public Safety. A shop or service near any of them hears customers name their workplace, and the answer lands in a notes column as WellStar, Wellstar, Well Star and Kennestone.
If you track that, we settle it to one label per workplace of your choosing.
Cleaning for Cobb County owners generally
The Cobb Chamber of Commerce says it drives economic growth, and it gives a Small Business of the Year Award. Owners who compete for that kind of recognition tend to bring numbers about customers and repeat sales. Ours are better when a repeat buyer is one row and every sale sits under it.
Questions from Marietta owners
I use one sheet for Saturday and a notebook for Sunday. Where do I start?
Typing the notebook in is mining, the stage before cleaning, and we can talk through it on a call. After that, we bring both into one set of rules.
How do you treat a customer who gave two different names?
As two rows until you tell us otherwise. A script cannot know a nickname from a second person. We list the likely pairs and you decide.
Do you change my originals?
No. We work on a copy and give you a before and after list, so any row can be compared with its source.
Sources for the facts on this page: Marietta, Georgia, Wikipedia · Marietta Square Farmers Market, marietta.com · City of Marietta · About Us, Cobb Chamber of Commerce
Bring us the Marietta sheet from the busiest Saturday
Pick a 15 or 30 minute free call on the contact page and tell us what the sheet should answer.