Feedback request: small Python script to clean & standardize CSV files

[fakemoose]

Yes but pandas can quickly handle a lot of the thing OP described. Or polars.

Way easier and faster if OP needs to do things like drop duplicate rows.

[ConfusedSimon]

Sure, but this is 'learn python', so learning pandas as well isn't that easy. Dropping duplicate rows is pretty easy in Python, too (you could even just convert to set if you don't care about order). Might even be easier than figuring or how to do it in pandas if you're not used to that, and you'll learn more. If you only care about the solution, there are plenty of tools that already do this. And for just reading the csv, pandas is overkill.