Finance
Clean finance CSV data with computer tools
Prepare a supplied financial CSV for analysis. Review dates, currencies, missing values and duplicate rows before calculating totals.
Start with the right context.
Reliable analysis begins with consistent rows. A date ambiguity or a currency mixed into the same amount column can change totals. Keep the source file intact and agree on how ambiguous records will be handled before editing.
Prepare a result you can use.
During a computer-enabled session, ask the chief to inspect column types and report anomalies. Produce a separate cleaned CSV and an audit note listing transformations, excluded records and unresolved questions. Python can help check row counts and totals.
Review before the next step.
Compare source and output record counts. Confirm that suspected duplicates were not silently removed and missing amounts were not replaced with invented values. Read a sample of transformed rows before using the cleaned file.
What to bring to your chief
- The CSV and a description of its columns
- Currency and expected date format
- Rules for refunds, duplicates and missing entries
Try this task
Inspect the finance CSV I supply. Keep the original unchanged, report missing values, date ambiguities and suspected duplicates, and ask before resolving uncertain records. Save a cleaned copy plus an audit note and verify both files.
Sign in for a written first result before payment setup. Computer work needs an active trial or paid plan and remaining allowance.
Common questions
What will I get from this task?
Start with the written draft described in the prompt. Ask for missing facts and review the result before requesting a saved file or further action.
Can this task use my chief’s computer?
An active computer trial or paid plan and remaining allowance are needed for browser, code and saved-file work. A written first preview is available before payment setup, subject to preview limits.