delete first column when exported excel or csv file in python

Question

let's say, I exported my file in excel

statement Export

ln[] = writer = pd.ExcelWriter("df2018.xlsx")
writer = pd.ExcelWriter("df2018.xlsx", index = false)
df2018.to_excel(writer)
writer.save()

out[] = 
row0  (blank)  kanwil     jan 2018  feb 2018   janfeb 2018 
row1    0      sunarto    45878     545458     5454878
row2    1      hartanto   123456    545454     4444549
row3    2      pemabuk    9547      787896     4579798

(if data frame is df2018)

my expected :

row0  kanwil     jan 2018  feb 2018   janfeb 2018 
row1  sunarto    45878     545458     5454878
row2  hartanto   123456    545454     4444549
row3  pemabuk    9547      787896     4579798

i wanna delete first column

i've tried

pd.ExcelWriter("df2018.xlsx", index = false)

but it doesn't work

what should i do if i want to delete first column when i exported csv or excel

in a fact, i get info from my data frame (df2018) below:

<class 'pandas.core.frame.DataFrame'>
Int64Index: 154 entries, 2 to 155
Data columns (total 5 columns):
Kanwil                 149 non-null object
Cabang                 137 non-null object
Income Januari 2018    151 non-null object
Income Febuari 2018    151 non-null object
Income Jan-Feb 2018    151 non-null object
dtypes: object(5)
memory usage: 4.2+ KB
None

@jezrael <class 'pandas.core.frame.DataFrame'> Int64Index: 154 entries, 2 to 155 Data columns (total 5 columns): Kanwil 149 non-null object Cabang 137 non-null object Income Januari 2018 151 non-null object Income Febuari 2018 151 non-null object Income Jan-Feb 2018 151 non-null object dtypes: object(5) memory usage: 4.2+ KB None — Charisma Bathara
– Charisma Bathara, Commented May 18, 2019 at 12:01

jezrael · Accepted Answer · 2019-05-18 12:12:30Z

5

I believe you need specify parameter index=False in DataFrame.to_excel:

pd.ExcelWriter("df2018.xlsx")
df.to_excel(writer, index = False)

edited May 18, 2019 at 12:12

answered May 18, 2019 at 12:05

jezrael

868k103 gold badges1.4k silver badges1.3k bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

sandeep P Over a year ago

If you are using multiindex then this won't work.

Sankar guru · Accepted Answer · 2019-05-18 12:15:16Z

0

Try to like these Reference pandas Excel writer:

https://pbpython.com/improve-pandas-excel-output.html https://xlsxwriter.readthedocs.io/working_with_pandas.html

answered May 18, 2019 at 12:15

Sankar guru

1,0151 gold badge8 silver badges16 bronze badges

Collectives™ on Stack Overflow

delete first column when exported excel or csv file in python

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related