How To drop Column Name From Pandas Data frame using regexp in Column Names?

Question

I have to load excel file with few column to pandas data frame. In That Excel file some times data use come with column names "Unnamed 1" ,"Unnamed 2", "Unnamed 3" . I want to delete all the columns where column names start with "Unnamed" . How to do this ? Suppose my data frame name is df .

Yes will save to CSV . Before that I want to drop the columns with column name starting with "Unnamed" . — Gyanaranjan Nayak, Oct 28 '20 at 08:40

score 1 · Accepted Answer · answered Oct 28 '20 at 08:40

1

The easiest way to use this with regex is:

df.drop(list(df.filter(regex = 'Unnamed')), axis = 1, inplace = True)

answered Oct 28 '20 at 08:40

Rohit Kewalramani

408
5
15

How To drop Column Name From Pandas Data frame using regexp in Column Names?

1 Answers1