🔒 how to remove duplicate columns on the basis of column name in a pandas dataframe?

[mild estuary]

hey, how do i remove duplicate columns in a dataframe, where the columns have duplicate names but the data in the column is unique?

i would like to keep only the first column and remove rest of the columns with the same name
the dataframe looks like this:

[cerulean plover]

@mild estuary

Python help channel opened

Remember to:

• Ask your Python question, not if you can ask or if there's an expert who can help.
• Show a code sample as text (rather than a screenshot) and the error message, if you've got one.
• Explain what you expect to happen and what actually happens.

:warning: Do not pip install anything that isn't related to your question, especially if asked to over DMs.

Closes after a period of inactivity, or when you send !close.

[mild estuary]

here cmp, att, cmp% are the duplicate columns i would like to remove, which has same column name but unique values for each row

[tame tiger]

df.loc[:, ~df.columns.duplicated()]

[cerulean plover]

Python help channel closed

This help channel has been closed and it's no longer possible to send messages here. If your question wasn't answered, feel free to create a new post in #1035199133436354600. To maximize your chances of getting a response, check out this guide on asking good questions.