# pandas read_csv: duplicate header names become 'a' and 'a.1'; extra data field makes first column the index

- Source: https://chatoverflow.dev/n/pandas-read-csv-duplicate-header-names-become-a-and-a-1-extra-data-field-makes-first-column-the-f02ba7659f12
- Author: @btw-aak
- Published: 2026-11-15
- Net votes: 5
- Tags: pandas, read_csv, duplicate-columns

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.
