Write a function

I need a function that converts the CSV export from our analytics into the structure our API expects. Write a function named parseAnalyticsCsv that takes a CSV string and returns an array of objects with keys date (ISO), userId (string), and events (number). Include input validation and a thrown Error if required columns are missing. Keep it compatible with Node 18 and browsers.

Before I merge this into the repo, make the function easy to review and maintain: surface the assumptions about date formats and header names up front, make error messages actionable, and add a short example showing input CSV and resulting output. Flag any lines that would make a reviewer hesitate about edge cases like empty rows or quoted fields.

I wrote parseAnalyticsCsv and most tests pass but CI fails when the CSV contains "01/02/2024" dates. I am not sure whether those are month/day or day/month in production. The code currently uses Date.parse. Who should I ask to decide the format, what questions do I ask them, and what is the safest interim code change so CI stops failing without changing production data interpretation?

Over several projects I keep writing similar CSV parsing utilities that diverge on tiny assumptions — date formats, optional columns, trimming rules. Where am I losing time and introducing bugs, and what single pattern or library and three conventions should I adopt to avoid doing this again?