I am stuck on CSV files from five vendors. I need to reconcile schemas, units, missing values, and duplicates across vendor exports, but my current attempt is getting vague and too big. What would you check first?
I needed a usable answer on CSV files from five vendors
This started as a messy question about CSV files from five vendors. The follow-up made the answer practical.
First, shrink the decision. Do not solve the whole subject at once.
- Fix the grain before calculating.
- Keep assumptions next to the metric.
- Show uncertainty in the output.
Write down the result you need by the end of this session. Then choose one input you trust and make a first pass that can be checked. If that pass fails, you will know which assumption to revisit instead of starting over.
The smaller decision was the missing piece. I was asking for the whole system at once.
4 comments
Sign in to join the conversation.