Load csv with duplicate columns in pandas
please tell me.
I'm trying to read a csv file with pandas.
Suppose you have a completely duplicate column name in a csv file, and one of the lines has a value in it
.s3.ap-northeast-1.amazonaws.com/0/426068/7b357270-5a95-83fc-8eb6-2f2f88b6a531.png)
If you read it with pandas as it is, it will be "weight", "weight.1".
This is a simple example, but in reality there are dozens of duplicate column names, and it is very annoying to read each column name with panndas and then access each column name. Please tell me how to unify these columns into one and create a new data frame.
Only one row is listed in a column with the same name.