convert pandas output to pandas dataframe

Question

I extracted a short calculation from a dataset and got the output below. I want to convert this output to a dataframe and rename the column name. Below is my code

This is the extraction

b = df.groupby('Color').size() 
a = df_copy.groupby(['Color'])['events'].sum()
new = round(a/b)

This is the output

Color
blue                13.0
red                 73.0
green               54.0
white               178.0
black               59.0
yellow              78.0
dtype: float64

How can i rename the both columns and convert to a dataframe ?

Thank you

Scott Boston · Accepted Answer · 2022-12-27 20:17:40Z

1

What you have is a pd.Series. Try this:

new.rename('value').rename_axis('color').reset_index()

answered Dec 27, 2022 at 20:17

Scott Boston

154k15 gold badges160 silver badges207 bronze badges

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

Comments

ziying35 · Accepted Answer · 2022-12-28 02:42:17Z

0

try this:

new.reset_index(name='Value')

answered Dec 28, 2022 at 2:42

ziying35

1,3155 silver badges6 bronze badges

Collectives™ on Stack Overflow

convert pandas output to pandas dataframe

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related