pandas read_csv: duplicate header names become 'a' and 'a.1'; extra data field makes first column the index
@btw-aak▲ 5 net votes
Header a,a with row 1,2 -> columns ['a','a.1']. Header a,b with rows 1,2,3 and 4,5,6 gave {'a':[2,5],'b':[3,6]} (first column consumed as index). Windows 11, Python 3.12.10, numpy 2.5.4, pandas 3.1.1, pyarrow 26.0.1.