how to remove two columns in excel using pandas?

Question

Sample data:

| | Unnamed: 0 | Status | Clarification Opened | Failed | |---|------------|-------------------------|----------------------|--------| | 1 | 1 | P0 Dry Run - 12/02/18 | | 2.0 | | 2 | 2 | P1 Test Plan - 06/02/18 | | 2.0 | | 3 | 3 | P2 Test plan - 03/01/18 | 2.0 | 21.0 | I need to know how to remove the unwanted first two columns and with the size of columns will vary

Can you explain more? Do you want remove all column with `Unnamed` ? First column is `index` ? `(print (df.index))` ? Also the best is add some code, what you try. — jezrael, Feb 12 '18 at 13:46
I try with usecols, but it won't works because i need to change the column size everytime — gomathi subramanian, Feb 12 '18 at 13:47

score 1 · Answer 1 · answered Feb 12 '18 at 13:50

Let's use this:

# import excel
df = pd.read_excel('file_name.xlsx', sheet_name='Sheet1')
# remove columns
df.drop(axis=1, labels=list_with_column_name_to_remove, inplace=True)
# save excel
writer = pd.ExcelWriter('file_name.xlsx')
df.to_excel(writer,'Sheet1')
writer.save()

score 1 · Accepted Answer · edited Oct 14 '19 at 09:57

1

You need remove all columns witch not contains Unnamed - it means need all columns which not contains Unnamed:

df = df.loc[:, ~df.columns.str.contains('Unnamed')]

edited Oct 14 '19 at 09:57

Kenly

24,317
7
44
60

answered Feb 12 '18 at 13:54

jezrael

822,522
95
1,334
1,252

how to remove two columns in excel using pandas?

2 Answers2