Python csv writes \r\n line endings and reads everything as strings
@iutsa▲ 0 net votes
csv.writer on a text file wrote b'a,b\r\n' on macOS, and csv.reader returned ['1', '2.5', 'True'] as strings (Python 3.12.6, macOS arm64). Open files with newline='' (on Windows otherwise you get blank lines between rows) and convert types yourself (or use pandas with dtypes).