I need help to understand the dataset?

Question

1.00/5 (2 votes)

See more:

, +

-1 i need to know how can i calculate how much energy in kiloWatt hour (kWh) has Singapore saved per year by recycling, by using this data?



waste_type: The type of waste recycled.
waste_disposed_of_tonne: The amount of waste that could not be recycled (in metric tonnes).
total_waste_recycle_tonne: The amount of waste that could be recycled (in metric tonnes).
total_waste_generated: The total amount of waste collected before recycling (in metric tonnes).
recycling_rate: The amount of waste recycled per tonne of waste generated.
year: The recycling year.

What I have tried:

i did it by using the "total_waste_generated","total_waste_recycle" but was also wrong ..

Posted 29-Apr-21 17:55pm

Amr Mahmoud 2021

Updated 10-May-21 4:54am

Add a Solution

Comments

Richard MacCutchan 30-Apr-21 3:43am

Your program needs to use the correct formula to calculate the answer.

trong tung vu 4-Aug-21 11:01am

What is the correct formula ?

Richard MacCutchan 4-Aug-21 11:40am

Sorry, no idea. Ask the person who posted the question.

2 solutions

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Member 15192276 · Answer 1 · 2021-05-10T04:54:00

Solution 1

Use just the recycled_waste feature and the energy_saved in the energy dataset to get the energy saved for each waste type and the total sum.

Posted 10-May-21 4:54am

Member 15192276

Comments

Kotchakorn Phianphungart 11-May-21 22:26pm

I want to know recycled_waste is a total_waste_recycle_tonne or recycling_rate and then what should it doing with the energy saved (Such as + * etc.) I don't understand on dataset

Dharit Sura 31-Jul-21 20:19pm

Hi, Was anyone able to solve this? I am getting the below output. I need help in solving this.
Can someone share out they got the correct answer?
total_energy_saved
year
2015 334350400 kWh
2016 344170400 kWh
2017 299614000 kWh
2018 2698130000 kWh
2019 2765440000 kWh

Chitresh Kaushik 10-Aug-21 11:36am

Did yu get the answer?

Thawatchai Phakwithoonchai 5-Sep-21 5:54am

Use total_waste_recycle and energy_saved to get the total_energy_saved by waste_type and year. Don't forget to check the words (with/without 's', capital letters, etc.) in waste_type columns of each dataset before grouping by year.

Member 15307080 · Answer 2 · 2021-07-30T07:48:00

Solution 2

so for the first data set(2015,2016,2017) you have to just divide the recycle_rate/Enery_saved for the particular waste type.
for the second data set(2018,2019) you have to calculate the recycle_rate by doing total_waste_recycle/total_waste_generated and then do recycle_rate/Energy_saved for the particular waste_type provided in the third data set.

Then you can accumulate the answer for the years and save it in total_energy_saved

Posted 30-Jul-21 7:48am

Member 15307080

Updated 30-Jul-21 8:06am

Comments

Chitresh Kaushik 10-Aug-21 11:35am

Hi can you please explain why we should use this approach and why not multiplying the metric ton recycled waste with enerdy saved per ton will give the correct answer.

Thanks

I need help to understand the dataset?

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

I need help to understand the dataset?

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us