Categories

See More
Popular Forum

MBA (4887) B.Tech (1769) Engineering (1486) Class 12 (1030) Study Abroad (1004) Computer Science and Engineering (988) Business Management Studies (865) BBA (846) Diploma (746) CAT (651) B.Com (648) B.Sc (643) JEE Mains (618) Mechanical Engineering (574) Exam (525) India (462) Career (452) All Time Q&A (439) Mass Communication (427) BCA (417) Science (384) Computers & IT (Non-Engg) (383) Medicine & Health Sciences (381) Hotel Management (373) Civil Engineering (353) MCA (349) Tuteehub Top Questions (348) Distance (340) Colleges in India (334)
See More

get the sum of one column and average of the other with grouping

General Tech Technology & Software

Max. 2000 characters
Tuteehub
Replies

usr_profile.png

User

( 3 months ago )

 

I have a dataframe which looks like this:

    Year Iteration Production Technology
    2015     1     200        Gas
    2015     1     305        Gas
    2016     1     150        Gas
    2016     1     200        Gas
    2015     2     200        Gas 

The Technology column states the type of power plants. Therefore, for each year and each iteration there can be multiple plants in the Technology column.

I would like to aggregate the data so that I have one value for the year, the mean of all the iterations, and the sum of all the power plants for that specific technology.

In this example it would be:

    Year Iteration Production Technology 
    2015 1.5       705        Gas
    2016 1.5       350        Gas

I have tried various approaches with the aggregate function, but failed due to the fact that it would also aggregate the Technology column (dividing the total production by the amount of power plants).

what's your interest


forum_ban8_5d8c5fd7cf6f7.gif