Remove index Dataframe pandas

Question

I need to remove the dfA index because when I print dfA i have:

      Este Mes  Subastas
0   01/01/2018  39

And I need:

Este Mes  Subastas
01/01/2018  39

How can I do that? Because I know if I read the csv file and I write index=False but the problem is I convert my original csv and in the first time I need the index to operate and have dfA. I can´t give a name to index and del the column after because this is a restriction I will use again the dfA to paste it in a xls but without the index

import pandas as pd

df = pd.read_csv('este_mes.csv', sep=',')
df1 = df.groupby(['Fecha'])['Subastas'].sum()
df2 = df1.to_frame().reset_index()

dfA = df2
dfA.columns = ['Este Mes', 'Subastas']
df2 = df2.Subastas
df2.to_csv('este_mes_subastas2.csv', index=False)

SOLUTION:

I can do it without remove the index because I need to paste the dfA on a xlsx so when I did it I set index=Falseand I had the results I was looking for!

import pandas as pd

df = pd.read_csv('este_mes.csv', sep=',')
df1 = df.groupby(['Fecha'])['Subastas'].sum()
df2 = df1.to_frame().reset_index()

dfA = df2
dfA.columns = ['Este Mes', 'Subastas']
df2 = df2.Subastas
df2.to_csv('este_mes_subastas2.csv', index=False)


writer = pd.ExcelWriter('test.xlsx', engine='xlsxwriter')

dfA.to_excel(writer, sheet_name='Este Mes x Dia',index=False)

piRSquared · Accepted Answer · 2018-01-24 22:00:52Z

1

You want to use the pd.DataFrame.to_string method with an argument of index=False

print(df.to_string(index=False))

Este Mes  Subastas
01/01/2018        39

Note: I'm not a fan of the resulting formatting.

answered Jan 24, 2018 at 22:00

piRSquared

296k68 gold badges509 silver badges654 bronze badges

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

2 Comments

Martin Bouhier Over a year ago

yes but i don't want to change the dataframe to a string

Martin Bouhier Over a year ago

the other way is add headers to df1but I don´t know how I can do it

Collectives™ on Stack Overflow

Remove index Dataframe pandas

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related