How to pivot a pandas Dataframe to a new Dataframe instead of a Dataseries

Asked Jun 19 '20 at 13:44

Active Jun 19 '20 at 13:45

Viewed 25 times

I have a dataframe with 4 columns: Mes (month), Clientes (clients), Mercadorias (Assets) and Quantidade (quantity) and I'm trying to create a new dataframe grouping by the columns month and clients running the following code: data = df.groupby(['Mes','Clientes'])['Quantidade'].sum()

The output values are ok however it is creating a pandas.core.series.Series and wish to create a pandas.core.frame.DataFrame

Could someone please help me?

edited Jun 19 '20 at 13:45

asked Jun 19 '20 at 13:44

Lucas Almeida

Could you please add sample data? See https://stackoverflow.com/questions/20109391/how-to-make-good-reproducible-pandas-examples – Roy2012 Jun 19 '20 at 13:46
`data = df.groupby(['Mes','Clientes'])['Quantidade'].sum().reset_index()` should do what you ask for – anky Jun 19 '20 at 13:48
@anky, thanks! now I can see it as a Dataframe. – Lucas Almeida Jun 19 '20 at 13:53

How to pivot a pandas Dataframe to a new Dataframe instead of a Dataseries

0 Answers0