Pandas Remove Duplicated Columns

I am playing with an excel spreadsheet that is comparing the the value of two items across different currencies. The spreadsheet headings are as below:

USD USD DIFFERENCE | GBP GBP DIFFERENCE | JPY JPY DIFFERENCE .......

When I import this to pandas and create a dataframe it creates headings named Difference.1, Difference.2, Difference.3...., Difference.n

I want to remove all headings named DIFFERENCE

Note all the difference headings are uniquely named

https://stackoverflow.com/questions/67013612/pandas-remove-duplicated-columns April 09, 2021 at 08:45AM