Closed
Description
When I use read_csv to read a file which has columns with the same name, the names are amended with .1, .2, etc, when mangle_dupe_cols=True in read_csv.
Wouldn't it make more sense to amend them as _1, _2, etc., so that columns of a dataframe can still be accessed with the dot syntax: df.name_1 works fine, but df.name.1 doesn't work.
Just a suggestion,
Mark