Explore

Tagged #etl

All AI & Prompt Engineering324 Engineering176 Data & Analytics89 Product4 Design28 Sales2 Marketing4 Finance24 Strategy31 Operations4 Customer Success3 People & Recruiting4 Security & Compliance8 Legal2 Other Professional1

#etlClear filters

Finn Sato@finnsato·3mo ago

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.

Finn Sato

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?

Geminigemini-2.5-pro

First, shrink the decision. Do not solve the whole subject at once. 1. Fix the grain before calculating. 2. Keep assumptions next to the metric. 3. 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.

Show all 3 messages

3403.8k

Finn Sato@finnsato·4mo ago

CSV files from five vendors, minus the vague advice

Sharing the wording because it gave me something I could check instead of a confident wall of text.

Finn Sato

Give me a short checklist for CSV files from five vendors. I want something I can run before I call the work done.

Geminigemini-2.5-pro

Use this pass: - [ ] The goal is one sentence and names the user or decision - [ ] Inputs are current, relevant, and traceable - [ ] Assumptions are visible - [ ] Fix the grain before calculating - [ ] Keep assumptions next to the metric - [ ] Show uncertainty in the output - [ ] One failure case has been tested - [ ] The next owner and next action are clear If you cannot check an item, mark it unknown. Do not quietly treat unknown as done.

Show all 3 messages

3303.8k

Finn Sato@finnsato·2mo ago

The question that cleaned up CSV files from five vendors

Sharing the wording because it gave me something I could check instead of a confident wall of text.

Finn Sato

Help me reconcile schemas, units, missing values, and duplicates across vendor exports. Context: - Goal: [what a good result lets me do] - Current situation: [paste notes, draft, data, or constraints] - Audience: [who will use the result] - Deadline or limit: [time, budget, tools, length] Before answering, ask up to three questions only if the answers would materially change your recommendation. O

Claudeclaude-opus-4.5

This is usable as written. The important parts are the definition of done, the instruction to expose assumptions, and the request for a smallest test. For CSV files from five vendors, I would start with these checks: - Fix the grain before calculating - Keep assumptions next to the metric - Show uncertainty in the output If you share real material, remove anything private first and replace bracketed fields with concrete details.

Show all 3 messages

330968

Finn Sato@finnsato·2mo ago

I stopped guessing about CSV files from five vendors

A compact prompt and the response it produced. Replace the bracketed parts with your own details.

Finn Sato

For CSV files from five vendors, should I build a complete plan first or test one small slice? I have limited time and I do not want throwaway work.

Claudeclaude-opus-4.5

Test one slice, but choose a slice that crosses the riskiest part of the problem. A tiny easy demo will only prove the easy part. Use this decision rule: - If reversing the choice is cheap, try it. - If the choice locks in data, money, or other people’s time, write the full decision first. - If uncertainty is concentrated in one step, test that step before planning around it. For CSV files from five vendors, make the first test produce evidence you can compare, not just something that looks complete.

Show all 3 messages

3401k

Finn Sato@finnsato·4mo ago

ChatGPT was overcomplicating CSV files from five vendors, so I reset the question

The useful bit was asking for trade-offs and a smallest test before committing to a full plan.

Finn Sato

Be blunt about my plan for CSV files from five vendors. I am going to collect everything, ask for a polished answer, and fix details later. What is likely to go wrong?

ChatGPTgpt-5

Three things. - “Everything” has no boundary, so weak inputs and strong inputs will be treated alike. - A polished answer can hide missing evidence. Ask for gaps and assumptions before prose. - “Fix details later” means there is no acceptance test now. A safer sequence is: define the decision, choose the minimum trusted inputs, make an ugly first pass, check it, then polish. For this task, keep assumptions next to the metric.

Show all 3 messages

3302.4k