Use dataset of Global renewable energy production with tidyverse

Load Datasts

library(dplyr)
## 
## Attaching package: 'dplyr'
## The following objects are masked from 'package:stats':
## 
##     filter, lag
## The following objects are masked from 'package:base':
## 
##     intersect, setdiff, setequal, union
library(tidyverse)
## ── Attaching core tidyverse packages ──────────────────────── tidyverse 2.0.0 ──
## ✔ forcats   1.0.0     ✔ readr     2.1.5
## ✔ ggplot2   3.5.1     ✔ stringr   1.5.1
## ✔ lubridate 1.9.3     ✔ tibble    3.2.1
## ✔ purrr     1.0.2     ✔ tidyr     1.3.1
## ── Conflicts ────────────────────────────────────────── tidyverse_conflicts() ──
## ✖ dplyr::filter() masks stats::filter()
## ✖ dplyr::lag()    masks stats::lag()
## ℹ Use the conflicted package (<http://conflicted.r-lib.org/>) to force all conflicts to become errors
library(readr)

File_path

data <- read.csv("C:/Users/Bharati Paranjape/Desktop/Datasets for R/global_renewable_energy_production.csv")

Rename your data

Global_REP <- rename(data)

Use tidyverse for Global_REP dataset

Global_REP %>%
  filter(Year == 2006)
##    Year   Country SolarEnergy WindEnergy HydroEnergy OtherRenewableEnergy
## 1  2006       USA    510.4630  1220.7287    639.4454            281.40550
## 2  2006     China    826.6961  1364.9187    840.6059             99.52337
## 3  2006     India    392.8597  1170.4388   1404.3759            432.15053
## 4  2006   Germany    122.8157  1451.4429   1721.1662            363.18839
## 5  2006        UK    914.8438   318.6727    842.8332            477.52789
## 6  2006    France    716.2581   411.4020   1848.5762            420.14176
## 7  2006    Brazil    252.0416   562.1674    600.9178             89.91614
## 8  2006    Canada    359.7675   955.6097    562.4166            266.51305
## 9  2006 Australia    555.2998   994.8905    330.7873            442.45576
## 10 2006     Japan    189.4973   516.1238   1527.8538            435.06341
##    TotalRenewableEnergy
## 1              2652.043
## 2              3131.744
## 3              3399.825
## 4              3658.613
## 5              2553.878
## 6              3396.378
## 7              1505.043
## 8              2144.307
## 9              2323.433
## 10             2668.538

Look at India’s Renewable Energy Production from 2000 to 2023

Global_REP %>% 
  filter(Country == "India")
##    Year Country SolarEnergy WindEnergy HydroEnergy OtherRenewableEnergy
## 1  2000   India    910.3763  1023.0319    876.3506            207.14431
## 2  2001   India    753.3601  1366.2433   1808.0469            400.94400
## 3  2002   India    677.8285   309.3820    574.7688            454.34938
## 4  2003   India    645.7862   211.9562    472.5016            348.57580
## 5  2004   India    104.5554   409.0505   1232.8474            361.35284
## 6  2005   India    686.7651   491.5501   1510.7047            156.76209
## 7  2006   India    392.8597  1170.4388   1404.3759            432.15053
## 8  2007   India    691.8516   938.8012    459.2471            215.47211
## 9  2008   India    338.6821   517.1865   1954.1179            226.89398
## 10 2009   India    902.8419  1020.4802   1651.1792            276.18669
## 11 2010   India    619.2135   840.2730    631.9131            375.10345
## 12 2011   India    352.6951   231.6108   1397.3029            129.69981
## 13 2012   India    946.4127  1440.1072   1855.2695            216.57142
## 14 2013   India    113.9110  1406.8141   1027.9131            484.99467
## 15 2014   India    967.2580  1308.9123    800.5631            223.29398
## 16 2015   India    866.0230   611.9986    588.1377            300.56057
## 17 2016   India    942.5393  1104.8387   1269.1040             93.72942
## 18 2017   India    653.5065  1487.0700    538.1428            283.24834
## 19 2018   India    889.6358  1162.9992   1484.9268            366.11784
## 20 2019   India    423.5420   581.6694   1675.9140            414.55103
## 21 2020   India    880.3651  1387.2127   1169.2821            275.68233
## 22 2021   India    818.4657  1044.9531   1493.3437            408.10670
## 23 2022   India    901.0048   639.3937    938.4910             92.29187
## 24 2023   India    620.4521   246.7250   1091.5166            294.19009
##    TotalRenewableEnergy
## 1              3016.903
## 2              4328.594
## 3              2016.329
## 4              1678.820
## 5              2107.806
## 6              2845.782
## 7              3399.825
## 8              2305.372
## 9              3036.881
## 10             3850.688
## 11             2466.503
## 12             2111.309
## 13             4458.361
## 14             3033.633
## 15             3300.027
## 16             2366.720
## 17             3410.211
## 18             2961.968
## 19             3903.680
## 20             3095.676
## 21             3712.542
## 22             3764.869
## 23             2571.181
## 24             2252.884

use arrange fuction to understand the trend in data

Global_REP %>%
  arrange(SolarEnergy)
##     Year   Country SolarEnergy WindEnergy HydroEnergy OtherRenewableEnergy
## 1   2004     India    104.5554   409.0505   1232.8474            361.35284
## 2   2018       USA    104.9699  1260.0999   1501.6575            378.05323
## 3   2008     China    106.2569   863.9715   1009.5987            149.94851
## 4   2018        UK    110.2183   809.2588    395.7156            103.46806
## 5   2018 Australia    111.7850  1062.5986    602.6611            482.48164
## 6   2011   Germany    112.9541   350.8944    378.2045             68.32796
## 7   2013     India    113.9110  1406.8141   1027.9131            484.99467
## 8   2018     Japan    116.5516  1388.5884    500.1768            309.43241
## 9   2016    Brazil    118.0641   618.7029    659.4616            197.37381
## 10  2006   Germany    122.8157  1451.4429   1721.1662            363.18839
## 11  2017   Germany    123.8602   961.5083   1898.3914            308.96338
## 12  2001     China    128.2863  1027.3335    834.4052            278.85681
## 13  2023    Canada    130.1792   940.8566   1596.1798            444.54454
## 14  2022 Australia    132.8947   813.6870   1260.2299             79.56889
## 15  2013    Brazil    133.0149   528.1680   1512.6943            452.84308
## 16  2018     China    136.6976   968.1608   1451.8594             57.46452
## 17  2022        UK    138.8439  1358.4860   1197.0919            496.83416
## 18  2013     China    146.3309   562.2404   1844.0520            157.80285
## 19  2003   Germany    146.5135   890.7610   1219.0797            336.84346
## 20  2012    France    150.7379  1324.1391   1681.9317            499.87295
## 21  2010        UK    151.8029   914.3875   1050.6019            449.46688
## 22  2010    Brazil    154.9702   559.9409   1670.5422            386.71686
## 23  2008    Canada    157.0375  1486.9483    848.0015            414.44350
## 24  2008       USA    158.5464  1433.5512   1941.5745            413.77881
## 25  2013        UK    165.4867  1268.4181   1500.6118             86.60695
## 26  2023        UK    166.4169   920.0106   1947.8143            285.39403
## 27  2017       USA    167.0956  1482.9530   1612.8161            139.42206
## 28  2000    Canada    172.2104   881.8648    997.6746            492.07038
## 29  2014        UK    176.3539  1482.6315    936.2604            216.78897
## 30  2014       USA    179.6433   454.7777    376.8864            196.39865
## 31  2017     China    181.2608  1285.8932    845.3261            133.93333
## 32  2021   Germany    184.9987  1087.9088    421.0207            193.53903
## 33  2006     Japan    189.4973   516.1238   1527.8538            435.06341
## 34  2022    Brazil    191.6042   398.7169    718.1281            122.30662
## 35  2004        UK    192.8115  1373.3188   1158.9290            421.90586
## 36  2001    Canada    200.8350   717.2123   1948.0997            439.47821
## 37  2019        UK    205.7736  1043.9734   1568.2763            312.51594
## 38  2023   Germany    206.3483  1105.7583   1369.2028            444.86241
## 39  2017    Brazil    207.7859  1357.6855   1309.1072            355.59604
## 40  2009     China    207.8788   638.8997   1902.9465            195.44132
## 41  2007    Brazil    208.5723   799.0124    650.7673            213.92144
## 42  2010       USA    209.8344   843.7300    358.4605            459.19418
## 43  2011 Australia    212.1964  1397.0944   1778.8238            283.47713
## 44  2001 Australia    214.7398   716.4735   1655.4021            117.46284
## 45  2003    Brazil    215.2413   397.4735    536.0062            338.39364
## 46  2019    France    220.6137   237.4175   1583.7333            329.13930
## 47  2016 Australia    226.7713   429.3031   1147.2252            238.51645
## 48  2014     China    230.4054   836.2886   1975.6058            158.92487
## 49  2000    Brazil    232.3661  1404.5639   1136.5977            166.20997
## 50  2019 Australia    233.7965   739.0114    445.0944            498.59341
## 51  2022    Canada    236.5074   605.2387    722.4315            384.77583
## 52  2001       USA    240.4168   402.7929    398.7421            439.77927
## 53  2006    Brazil    252.0416   562.1674    600.9178             89.91614
## 54  2022     Japan    257.8342  1388.7355   1011.9099            222.41234
## 55  2004 Australia    263.4379  1380.9857   1291.7661            230.38314
## 56  2004    Brazil    263.6921   649.3675   1824.5403            263.28274
## 57  2011    Brazil    266.0689   472.1541    929.8026            268.03534
## 58  2023    Brazil    267.9103   570.6237    594.7351            453.54444
## 59  2020   Germany    276.2120   290.1697    471.3226             58.19982
## 60  2014    Canada    281.4646   412.7527    579.2519            416.55862
## 61  2020     Japan    285.7791   214.2946    532.7056            455.00839
## 62  2009     Japan    287.0976   234.4919    608.4402            312.36870
## 63  2021 Australia    288.9150  1367.4706    648.7374            135.80947
## 64  2021        UK    301.2363  1452.1893    320.6626            486.44547
## 65  2007     China    305.1416   755.2401   1690.6251            437.32876
## 66  2003     China    305.9183   300.0739    792.5775            122.54958
## 67  2002 Australia    306.3263  1138.9283   1524.0621            338.51643
## 68  2004     Japan    307.9673  1073.4606    333.5079             96.84886
## 69  2018    Canada    308.9914  1369.4469    952.6151            294.59879
## 70  2009    Canada    329.1766  1085.9535   1592.3874            318.03743
## 71  2022     China    332.1475  1057.9793   1689.2777            299.84037
## 72  2011       USA    332.9020  1061.2790    829.9088            284.03061
## 73  2011     Japan    333.4811   693.6001   1303.5014            170.62864
## 74  2008     India    338.6821   517.1865   1954.1179            226.89398
## 75  2019     Japan    346.6497   920.4314   1407.4147            423.38381
## 76  2003    France    349.6431   444.5575   1088.2873            209.00850
## 77  2011     India    352.6951   231.6108   1397.3029            129.69981
## 78  2016       USA    352.8411   905.5049    539.5712            410.98864
## 79  2020    Brazil    355.3983   672.0070   1398.0593            306.85024
## 80  2012     China    356.3564   247.9530   1336.2594            276.20556
## 81  2000   Germany    357.8871   968.0832    351.8504             66.80668
## 82  2006    Canada    359.7675   955.6097    562.4166            266.51305
## 83  2008     Japan    363.8330  1365.2366    322.1033             88.47884
## 84  2008        UK    363.8897   627.2639   1443.2814            388.56854
## 85  2013     Japan    365.0192  1432.9893   1598.1299            113.05093
## 86  2004       USA    373.8180   882.1834   1034.3065            181.05311
## 87  2009       USA    374.1524   326.9737   1463.1961            248.06862
## 88  2021       USA    379.8841   622.7383   1540.3305            336.90086
## 89  2005        UK    388.0446  1364.1802    961.6429             54.87694
## 90  2006     India    392.8597  1170.4388   1404.3759            432.15053
## 91  2021     China    406.9597   347.5156   1871.9792            444.80271
## 92  2000 Australia    407.8736  1267.6345    488.0740            430.90353
## 93  2021    France    415.5288   966.8930    966.8149            246.86371
## 94  2011        UK    415.8235   352.1871    543.0859            392.67978
## 95  2021    Brazil    420.4871  1482.4698   1329.8172            156.75206
## 96  2019     India    423.5420   581.6694   1675.9140            414.55103
## 97  2016     China    431.0048  1021.9976   1377.0005            291.09861
## 98  2002        UK    434.8163  1209.3368    879.3660            468.84080
## 99  2000       USA    437.0861  1435.9286   1544.3897            319.39632
## 100 2015   Germany    437.1514  1013.6179   1155.3316            435.42043
## 101 2016        UK    438.6336   308.5509   1621.1498            301.28191
## 102 2009    France    438.8170  1253.7193   1978.3694            117.68760
## 103 2018   Germany    449.3529  1036.2747   1079.0299            295.52756
## 104 2015       USA    449.8096   552.7537   1708.8538            210.53900
## 105 2016    Canada    453.2006  1261.5793   1046.5293            219.62499
## 106 2023    France    456.8885  1008.7127   1766.0183            477.28428
## 107 2014   Germany    458.6543  1000.6051   1379.6592             70.38680
## 108 2000     Japan    460.6868   927.5324    563.9084            131.86766
## 109 2007   Germany    468.0576   425.2826    565.9430            162.60930
## 110 2010   Germany    477.6401   522.0503    905.1536            391.03075
## 111 2010     Japan    479.2821  1360.4732   1689.6541            203.81781
## 112 2009 Australia    481.7176  1157.3775   1888.4239            466.50583
## 113 2017        UK    481.7998  1378.2607    489.0357            271.68130
## 114 2015     Japan    482.6922   229.2101    756.7515            293.73540
## 115 2010 Australia    505.7554   347.2095   1974.2300            427.50414
## 116 2006       USA    510.4630  1220.7287    639.4454            281.40550
## 117 2001    Brazil    513.2222  1474.0423   1137.4508            197.93822
## 118 2005 Australia    515.8052  1431.4683    560.6974            313.80342
## 119 2017    Canada    516.4118   591.7912   1570.9359            276.22418
## 120 2010    Canada    524.4186   735.3932    893.0761            468.28811
## 121 2013   Germany    542.4543   815.5133    594.4432            245.23324
## 122 2020 Australia    551.9755   974.0005    414.0300            387.48221
## 123 2008    Brazil    553.0755  1097.5133    366.8306            409.73468
## 124 2006 Australia    555.2998   994.8905    330.7873            442.45576
## 125 2005    Canada    556.8493   515.1327    495.2226            324.77902
## 126 2014    Brazil    560.5097   891.7475    482.1924            251.33557
## 127 2019     China    560.8838   494.4445   1396.7937            128.46489
## 128 2010     China    566.9116  1113.9246    918.1703            487.30194
## 129 2023     Japan    567.0259   261.0558    582.6817            382.11513
## 130 2017    France    568.2769  1204.0139   1184.2780            433.48168
## 131 2000     China    570.4595   755.8033    343.2125             98.55114
## 132 2023     China    576.6855   514.4080    458.2747            453.74709
## 133 2007    Canada    579.3305   267.3706    872.2273            110.48660
## 134 2015    Brazil    579.3555   515.2117    757.7135            219.77787
## 135 2014 Australia    583.6560  1395.8123    888.7882            206.12894
## 136 2012       USA    592.0393   440.3108   1948.2939            398.80977
## 137 2008   Germany    594.3040  1128.9747   1422.3355            175.97025
## 138 2018    France    596.7162   929.2194   1790.3111            231.56729
## 139 2013    Canada    617.0258  1294.3774    537.6130            407.87029
## 140 2010     India    619.2135   840.2730    631.9131            375.10345
## 141 2023     India    620.4521   246.7250   1091.5166            294.19009
## 142 2004    France    625.2905   301.0550   1956.4712            493.79484
## 143 2001    France    625.8829  1371.5054    377.2588            176.43344
## 144 2019    Brazil    628.1570  1169.0713   1033.8212            107.41114
## 145 2012 Australia    632.1479   718.7035    393.0948            200.83876
## 146 2007       USA    633.1731   260.3855   1332.8262            126.73586
## 147 2010    France    634.7176   695.1581   1948.8545            428.95352
## 148 2002       USA    641.0035  1120.4944    334.9936            486.45943
## 149 2003     India    645.7862   211.9562    472.5016            348.57580
## 150 2005       USA    650.6676   381.3420    796.6459            214.86283
## 151 2017     India    653.5065  1487.0700    538.1428            283.24834
## 152 2016    France    656.3154   665.6115    493.0479            352.20794
## 153 2012        UK    656.3963   331.4595    442.9816            365.43611
## 154 2012    Brazil    656.4293   679.5877   1086.3090            386.36192
## 155 2021    Canada    658.0655   893.4994   1819.6174            404.86875
## 156 2012     Japan    661.7340   732.2351   1238.4802            246.25694
## 157 2020    Canada    664.9372   635.3773    536.7625            407.31134
## 158 2009    Brazil    665.1104   306.2867   1785.0837            464.39258
## 159 2000    France    666.4588  1104.4733   1072.7198            332.40114
## 160 2002    Brazil    670.0608   512.1893    428.9677            107.99587
## 161 2016     Japan    670.1304   535.2540    536.9053            425.71861
## 162 2002     India    677.8285   309.3820    574.7688            454.34938
## 163 2002     Japan    679.5996   731.3544    343.1568            120.26867
## 164 2005     India    686.7651   491.5501   1510.7047            156.76209
## 165 2007     India    691.8516   938.8012    459.2471            215.47211
## 166 2016   Germany    692.8243   411.8148    419.9669            339.08868
## 167 2015    Canada    698.6775   879.9851    910.0118            444.74024
## 168 2005    Brazil    700.8020   424.0158    626.8913             68.39088
## 169 2015     China    704.9220  1190.1055    703.9838            377.69736
## 170 2006    France    716.2581   411.4020   1848.5762            420.14176
## 171 2020     China    721.8440   702.7560   1892.4410            111.88442
## 172 2003 Australia    724.5536   905.5418    728.0584            205.56320
## 173 2005    France    728.3455   896.9253    826.1969            416.20776
## 174 2020    France    733.6718   476.8534    531.8315             56.54510
## 175 2008 Australia    736.5148   398.3008   1279.6902            323.02177
## 176 2003     Japan    744.3750  1056.6011    346.0632            149.88747
## 177 2001     India    753.3601  1366.2433   1808.0469            400.94400
## 178 2004   Germany    753.4822  1468.6077   1177.7106            195.33041
## 179 2000        UK    761.5639  1244.5252    779.4588            129.84779
## 180 2015 Australia    763.7511   787.8833    681.8282            253.59778
## 181 2001        UK    775.5533  1248.8852   1983.8587            235.67795
## 182 2023       USA    784.7065   929.6604   1610.6442            272.20802
## 183 2004    Canada    792.5436   443.1569    850.2547            241.44640
## 184 2002   Germany    792.9942   480.5673   1358.9138             88.40636
## 185 2019       USA    794.1433   296.2580    909.3917            102.14108
## 186 2023 Australia    797.9749   789.2755   1191.4635            248.34324
## 187 2018    Brazil    810.2541   847.9749    447.7645            291.69794
## 188 2009        UK    812.4211  1226.5036    455.0504            272.48914
## 189 2005   Germany    815.6676   552.0819   1046.2514             85.30537
## 190 2021     India    818.4657  1044.9531   1493.3437            408.10670
## 191 2005     Japan    819.9245   432.1081   1409.6684            157.18225
## 192 2013 Australia    822.5681   206.0216    866.9486            229.17591
## 193 2005     China    823.3049   442.5411   1817.3503            292.70401
## 194 2006     China    826.6961  1364.9187    840.6059             99.52337
## 195 2015        UK    831.5196  1431.4232   1976.2018            389.02018
## 196 2002    Canada    835.3649   535.2737    590.5089            350.88945
## 197 2001   Germany    840.3405   668.2478    516.0029            285.00947
## 198 2007     Japan    847.1979   716.3386   1435.7447            142.24293
## 199 2011    Canada    847.5575  1454.5350    511.3053            378.89036
## 200 2003       USA    849.1984   476.0408    609.1024            132.53203
## 201 2011    France    854.4958   809.3011   1005.1932            173.03318
## 202 2022   Germany    860.3878   230.2535   1684.5964            176.83465
## 203 2014    France    864.6827   521.5525   1065.9250            108.12174
## 204 2015     India    866.0230   611.9986    588.1377            300.56057
## 205 2012   Germany    869.9145  1114.7552   1106.0955             94.02537
## 206 2003        UK    872.5715   757.6922   1576.4808            389.54429
## 207 2001     Japan    875.6071  1429.9501    934.6258            171.83510
## 208 2020       USA    876.7931  1010.2876    862.5266             78.60126
## 209 2020     India    880.3651  1387.2127   1169.2821            275.68233
## 210 2014     Japan    881.6212   833.6606   1820.7388            409.93487
## 211 2021     Japan    886.5011   976.6370   1320.8787            349.26650
## 212 2018     India    889.6358  1162.9992   1484.9268            366.11784
## 213 2022       USA    898.4915   813.8794    503.3102            370.96015
## 214 2022     India    901.0048   639.3937    938.4910             92.29187
## 215 2009     India    902.8419  1020.4802   1651.1792            276.18669
## 216 2000     India    910.3763  1023.0319    876.3506            207.14431
## 217 2022    France    913.7428   652.7321   1173.7821            402.64386
## 218 2006        UK    914.8438   318.6727    842.8332            477.52789
## 219 2019    Canada    915.8249  1011.5094    498.7267            472.92446
## 220 2002     China    916.8098   524.0799    997.6510            389.99801
## 221 2017 Australia    923.3613   671.1121   1287.0002            334.51893
## 222 2003    Canada    936.4384   923.7918   1271.7416            175.99059
## 223 2004     China    936.7279  1250.5565   1376.7864            442.15727
## 224 2007 Australia    938.9065   934.6731   1484.3064            465.12472
## 225 2008    France    939.4556  1325.8831    376.8717             61.86514
## 226 2016     India    942.5393  1104.8387   1269.1040             93.72942
## 227 2012    Canada    944.5064   435.6030    413.0437            383.50429
## 228 2013       USA    945.5490  1363.2756   1316.4300            464.84341
## 229 2012     India    946.4127  1440.1072   1855.2695            216.57142
## 230 2019   Germany    947.3183   701.9334   1934.0240            457.40779
## 231 2007    France    954.8199  1143.4354   1342.8058            238.20937
## 232 2002    France    955.3703  1357.3429   1074.6165            329.05967
## 233 2007        UK    955.5464   945.4693   1374.1233            251.80048
## 234 2015    France    958.6459   988.0270    688.6928            352.26531
## 235 2009   Germany    959.3788  1159.2660   1242.4019            325.27434
## 236 2020        UK    965.9553   687.3318    785.7105            440.86961
## 237 2011     China    966.2026   527.3170   1145.3225            185.39524
## 238 2014     India    967.2580  1308.9123    800.5631            223.29398
## 239 2017     Japan    985.9620   883.3972    591.8548            172.53830
## 240 2013    France    996.9732   922.0612   1607.2786            475.14458
##     TotalRenewableEnergy
## 1               2107.806
## 2               3244.780
## 3               2129.776
## 4               1418.661
## 5               2259.526
## 6                910.381
## 7               3033.633
## 8               2314.749
## 9               1593.602
## 10              3658.613
## 11              3292.723
## 12              2268.882
## 13              3111.760
## 14              2286.381
## 15              2626.720
## 16              2614.182
## 17              3191.256
## 18              2710.426
## 19              2593.198
## 20              3656.682
## 21              2566.259
## 22              2772.170
## 23              2906.431
## 24              3947.451
## 25              3021.124
## 26              3319.636
## 27              3402.287
## 28              2543.820
## 29              2812.035
## 30              1207.706
## 31              2446.413
## 32              1887.467
## 33              2668.538
## 34              1430.756
## 35              3146.965
## 36              3305.625
## 37              3130.539
## 38              3126.172
## 39              3230.175
## 40              2945.166
## 41              1872.273
## 42              1871.219
## 43              3671.592
## 44              2704.078
## 45              1487.115
## 46              2370.904
## 47              2041.816
## 48              3201.225
## 49              2939.738
## 50              1916.496
## 51              1948.953
## 52              1481.731
## 53              1505.043
## 54              2880.892
## 55              3166.573
## 56              3000.883
## 57              1936.061
## 58              1886.814
## 59              1095.904
## 60              1690.028
## 61              1487.788
## 62              1442.398
## 63              2440.932
## 64              2560.534
## 65              3188.336
## 66              1521.119
## 67              3307.833
## 68              1811.785
## 69              2925.652
## 70              3325.555
## 71              3379.245
## 72              2508.120
## 73              2501.211
## 74              3036.881
## 75              3097.880
## 76              2091.496
## 77              2111.309
## 78              2208.906
## 79              2732.315
## 80              2216.774
## 81              1744.627
## 82              2144.307
## 83              2139.652
## 84              2823.004
## 85              3509.189
## 86              2471.361
## 87              2412.391
## 88              2879.854
## 89              2768.745
## 90              3399.825
## 91              3071.257
## 92              2594.486
## 93              2596.100
## 94              1703.776
## 95              3389.526
## 96              3095.676
## 97              3121.102
## 98              2992.360
## 99              3736.801
## 100             3041.521
## 101             2669.616
## 102             3788.593
## 103             2860.185
## 104             2921.956
## 105             2980.934
## 106             3708.904
## 107             2909.305
## 108             2083.995
## 109             1621.893
## 110             2295.875
## 111             3733.227
## 112             3994.025
## 113             2620.778
## 114             1762.389
## 115             3254.699
## 116             2652.043
## 117             3322.654
## 118             2821.774
## 119             2955.363
## 120             2621.176
## 121             2197.644
## 122             2327.488
## 123             2427.154
## 124             2323.433
## 125             1891.984
## 126             2185.785
## 127             2580.587
## 128             3086.308
## 129             1792.879
## 130             3390.050
## 131             1768.027
## 132             2003.115
## 133             1829.415
## 134             2072.059
## 135             3074.385
## 136             3379.454
## 137             3321.584
## 138             3547.814
## 139             2856.887
## 140             2466.503
## 141             2252.884
## 142             3376.612
## 143             2551.081
## 144             2938.461
## 145             1944.785
## 146             2353.121
## 147             3707.684
## 148             2582.951
## 149             1678.820
## 150             2043.518
## 151             2961.968
## 152             2167.183
## 153             1796.273
## 154             2808.688
## 155             3776.051
## 156             2878.706
## 157             2244.388
## 158             3220.873
## 159             3176.053
## 160             1719.214
## 161             2168.008
## 162             2016.329
## 163             1874.379
## 164             2845.782
## 165             2305.372
## 166             1863.695
## 167             2933.415
## 168             1820.100
## 169             2976.709
## 170             3396.378
## 171             3428.925
## 172             2563.717
## 173             2867.676
## 174             1798.902
## 175             2737.528
## 176             2296.927
## 177             4328.594
## 178             3595.131
## 179             2915.396
## 180             2487.060
## 181             4243.975
## 182             3597.219
## 183             2327.402
## 184             2720.882
## 185             2101.934
## 186             3027.057
## 187             2397.691
## 188             2766.464
## 189             2499.306
## 190             3764.869
## 191             2818.883
## 192             2124.714
## 193             3375.900
## 194             3131.744
## 195             4628.165
## 196             2312.037
## 197             2309.601
## 198             3141.524
## 199             3192.288
## 200             2066.874
## 201             2842.023
## 202             2952.072
## 203             2560.282
## 204             2366.720
## 205             3184.791
## 206             3596.289
## 207             3412.018
## 208             2828.209
## 209             3712.542
## 210             3945.955
## 211             3533.283
## 212             3903.680
## 213             2586.641
## 214             2571.181
## 215             3850.688
## 216             3016.903
## 217             3142.901
## 218             2553.878
## 219             2898.985
## 220             2828.539
## 221             3215.993
## 222             3307.962
## 223             4006.228
## 224             3823.011
## 225             2704.076
## 226             3410.211
## 227             2176.657
## 228             4090.098
## 229             4458.361
## 230             4040.684
## 231             3679.270
## 232             3716.389
## 233             3526.939
## 234             2987.631
## 235             3686.321
## 236             2879.867
## 237             2824.237
## 238             3300.027
## 239             2633.752
## 240             4001.458

use arrange with desc oder

Global_REP %>%
  arrange(desc(SolarEnergy))
##     Year   Country SolarEnergy WindEnergy HydroEnergy OtherRenewableEnergy
## 1   2013    France    996.9732   922.0612   1607.2786            475.14458
## 2   2017     Japan    985.9620   883.3972    591.8548            172.53830
## 3   2014     India    967.2580  1308.9123    800.5631            223.29398
## 4   2011     China    966.2026   527.3170   1145.3225            185.39524
## 5   2020        UK    965.9553   687.3318    785.7105            440.86961
## 6   2009   Germany    959.3788  1159.2660   1242.4019            325.27434
## 7   2015    France    958.6459   988.0270    688.6928            352.26531
## 8   2007        UK    955.5464   945.4693   1374.1233            251.80048
## 9   2002    France    955.3703  1357.3429   1074.6165            329.05967
## 10  2007    France    954.8199  1143.4354   1342.8058            238.20937
## 11  2019   Germany    947.3183   701.9334   1934.0240            457.40779
## 12  2012     India    946.4127  1440.1072   1855.2695            216.57142
## 13  2013       USA    945.5490  1363.2756   1316.4300            464.84341
## 14  2012    Canada    944.5064   435.6030    413.0437            383.50429
## 15  2016     India    942.5393  1104.8387   1269.1040             93.72942
## 16  2008    France    939.4556  1325.8831    376.8717             61.86514
## 17  2007 Australia    938.9065   934.6731   1484.3064            465.12472
## 18  2004     China    936.7279  1250.5565   1376.7864            442.15727
## 19  2003    Canada    936.4384   923.7918   1271.7416            175.99059
## 20  2017 Australia    923.3613   671.1121   1287.0002            334.51893
## 21  2002     China    916.8098   524.0799    997.6510            389.99801
## 22  2019    Canada    915.8249  1011.5094    498.7267            472.92446
## 23  2006        UK    914.8438   318.6727    842.8332            477.52789
## 24  2022    France    913.7428   652.7321   1173.7821            402.64386
## 25  2000     India    910.3763  1023.0319    876.3506            207.14431
## 26  2009     India    902.8419  1020.4802   1651.1792            276.18669
## 27  2022     India    901.0048   639.3937    938.4910             92.29187
## 28  2022       USA    898.4915   813.8794    503.3102            370.96015
## 29  2018     India    889.6358  1162.9992   1484.9268            366.11784
## 30  2021     Japan    886.5011   976.6370   1320.8787            349.26650
## 31  2014     Japan    881.6212   833.6606   1820.7388            409.93487
## 32  2020     India    880.3651  1387.2127   1169.2821            275.68233
## 33  2020       USA    876.7931  1010.2876    862.5266             78.60126
## 34  2001     Japan    875.6071  1429.9501    934.6258            171.83510
## 35  2003        UK    872.5715   757.6922   1576.4808            389.54429
## 36  2012   Germany    869.9145  1114.7552   1106.0955             94.02537
## 37  2015     India    866.0230   611.9986    588.1377            300.56057
## 38  2014    France    864.6827   521.5525   1065.9250            108.12174
## 39  2022   Germany    860.3878   230.2535   1684.5964            176.83465
## 40  2011    France    854.4958   809.3011   1005.1932            173.03318
## 41  2003       USA    849.1984   476.0408    609.1024            132.53203
## 42  2011    Canada    847.5575  1454.5350    511.3053            378.89036
## 43  2007     Japan    847.1979   716.3386   1435.7447            142.24293
## 44  2001   Germany    840.3405   668.2478    516.0029            285.00947
## 45  2002    Canada    835.3649   535.2737    590.5089            350.88945
## 46  2015        UK    831.5196  1431.4232   1976.2018            389.02018
## 47  2006     China    826.6961  1364.9187    840.6059             99.52337
## 48  2005     China    823.3049   442.5411   1817.3503            292.70401
## 49  2013 Australia    822.5681   206.0216    866.9486            229.17591
## 50  2005     Japan    819.9245   432.1081   1409.6684            157.18225
## 51  2021     India    818.4657  1044.9531   1493.3437            408.10670
## 52  2005   Germany    815.6676   552.0819   1046.2514             85.30537
## 53  2009        UK    812.4211  1226.5036    455.0504            272.48914
## 54  2018    Brazil    810.2541   847.9749    447.7645            291.69794
## 55  2023 Australia    797.9749   789.2755   1191.4635            248.34324
## 56  2019       USA    794.1433   296.2580    909.3917            102.14108
## 57  2002   Germany    792.9942   480.5673   1358.9138             88.40636
## 58  2004    Canada    792.5436   443.1569    850.2547            241.44640
## 59  2023       USA    784.7065   929.6604   1610.6442            272.20802
## 60  2001        UK    775.5533  1248.8852   1983.8587            235.67795
## 61  2015 Australia    763.7511   787.8833    681.8282            253.59778
## 62  2000        UK    761.5639  1244.5252    779.4588            129.84779
## 63  2004   Germany    753.4822  1468.6077   1177.7106            195.33041
## 64  2001     India    753.3601  1366.2433   1808.0469            400.94400
## 65  2003     Japan    744.3750  1056.6011    346.0632            149.88747
## 66  2008 Australia    736.5148   398.3008   1279.6902            323.02177
## 67  2020    France    733.6718   476.8534    531.8315             56.54510
## 68  2005    France    728.3455   896.9253    826.1969            416.20776
## 69  2003 Australia    724.5536   905.5418    728.0584            205.56320
## 70  2020     China    721.8440   702.7560   1892.4410            111.88442
## 71  2006    France    716.2581   411.4020   1848.5762            420.14176
## 72  2015     China    704.9220  1190.1055    703.9838            377.69736
## 73  2005    Brazil    700.8020   424.0158    626.8913             68.39088
## 74  2015    Canada    698.6775   879.9851    910.0118            444.74024
## 75  2016   Germany    692.8243   411.8148    419.9669            339.08868
## 76  2007     India    691.8516   938.8012    459.2471            215.47211
## 77  2005     India    686.7651   491.5501   1510.7047            156.76209
## 78  2002     Japan    679.5996   731.3544    343.1568            120.26867
## 79  2002     India    677.8285   309.3820    574.7688            454.34938
## 80  2016     Japan    670.1304   535.2540    536.9053            425.71861
## 81  2002    Brazil    670.0608   512.1893    428.9677            107.99587
## 82  2000    France    666.4588  1104.4733   1072.7198            332.40114
## 83  2009    Brazil    665.1104   306.2867   1785.0837            464.39258
## 84  2020    Canada    664.9372   635.3773    536.7625            407.31134
## 85  2012     Japan    661.7340   732.2351   1238.4802            246.25694
## 86  2021    Canada    658.0655   893.4994   1819.6174            404.86875
## 87  2012    Brazil    656.4293   679.5877   1086.3090            386.36192
## 88  2012        UK    656.3963   331.4595    442.9816            365.43611
## 89  2016    France    656.3154   665.6115    493.0479            352.20794
## 90  2017     India    653.5065  1487.0700    538.1428            283.24834
## 91  2005       USA    650.6676   381.3420    796.6459            214.86283
## 92  2003     India    645.7862   211.9562    472.5016            348.57580
## 93  2002       USA    641.0035  1120.4944    334.9936            486.45943
## 94  2010    France    634.7176   695.1581   1948.8545            428.95352
## 95  2007       USA    633.1731   260.3855   1332.8262            126.73586
## 96  2012 Australia    632.1479   718.7035    393.0948            200.83876
## 97  2019    Brazil    628.1570  1169.0713   1033.8212            107.41114
## 98  2001    France    625.8829  1371.5054    377.2588            176.43344
## 99  2004    France    625.2905   301.0550   1956.4712            493.79484
## 100 2023     India    620.4521   246.7250   1091.5166            294.19009
## 101 2010     India    619.2135   840.2730    631.9131            375.10345
## 102 2013    Canada    617.0258  1294.3774    537.6130            407.87029
## 103 2018    France    596.7162   929.2194   1790.3111            231.56729
## 104 2008   Germany    594.3040  1128.9747   1422.3355            175.97025
## 105 2012       USA    592.0393   440.3108   1948.2939            398.80977
## 106 2014 Australia    583.6560  1395.8123    888.7882            206.12894
## 107 2015    Brazil    579.3555   515.2117    757.7135            219.77787
## 108 2007    Canada    579.3305   267.3706    872.2273            110.48660
## 109 2023     China    576.6855   514.4080    458.2747            453.74709
## 110 2000     China    570.4595   755.8033    343.2125             98.55114
## 111 2017    France    568.2769  1204.0139   1184.2780            433.48168
## 112 2023     Japan    567.0259   261.0558    582.6817            382.11513
## 113 2010     China    566.9116  1113.9246    918.1703            487.30194
## 114 2019     China    560.8838   494.4445   1396.7937            128.46489
## 115 2014    Brazil    560.5097   891.7475    482.1924            251.33557
## 116 2005    Canada    556.8493   515.1327    495.2226            324.77902
## 117 2006 Australia    555.2998   994.8905    330.7873            442.45576
## 118 2008    Brazil    553.0755  1097.5133    366.8306            409.73468
## 119 2020 Australia    551.9755   974.0005    414.0300            387.48221
## 120 2013   Germany    542.4543   815.5133    594.4432            245.23324
## 121 2010    Canada    524.4186   735.3932    893.0761            468.28811
## 122 2017    Canada    516.4118   591.7912   1570.9359            276.22418
## 123 2005 Australia    515.8052  1431.4683    560.6974            313.80342
## 124 2001    Brazil    513.2222  1474.0423   1137.4508            197.93822
## 125 2006       USA    510.4630  1220.7287    639.4454            281.40550
## 126 2010 Australia    505.7554   347.2095   1974.2300            427.50414
## 127 2015     Japan    482.6922   229.2101    756.7515            293.73540
## 128 2017        UK    481.7998  1378.2607    489.0357            271.68130
## 129 2009 Australia    481.7176  1157.3775   1888.4239            466.50583
## 130 2010     Japan    479.2821  1360.4732   1689.6541            203.81781
## 131 2010   Germany    477.6401   522.0503    905.1536            391.03075
## 132 2007   Germany    468.0576   425.2826    565.9430            162.60930
## 133 2000     Japan    460.6868   927.5324    563.9084            131.86766
## 134 2014   Germany    458.6543  1000.6051   1379.6592             70.38680
## 135 2023    France    456.8885  1008.7127   1766.0183            477.28428
## 136 2016    Canada    453.2006  1261.5793   1046.5293            219.62499
## 137 2015       USA    449.8096   552.7537   1708.8538            210.53900
## 138 2018   Germany    449.3529  1036.2747   1079.0299            295.52756
## 139 2009    France    438.8170  1253.7193   1978.3694            117.68760
## 140 2016        UK    438.6336   308.5509   1621.1498            301.28191
## 141 2015   Germany    437.1514  1013.6179   1155.3316            435.42043
## 142 2000       USA    437.0861  1435.9286   1544.3897            319.39632
## 143 2002        UK    434.8163  1209.3368    879.3660            468.84080
## 144 2016     China    431.0048  1021.9976   1377.0005            291.09861
## 145 2019     India    423.5420   581.6694   1675.9140            414.55103
## 146 2021    Brazil    420.4871  1482.4698   1329.8172            156.75206
## 147 2011        UK    415.8235   352.1871    543.0859            392.67978
## 148 2021    France    415.5288   966.8930    966.8149            246.86371
## 149 2000 Australia    407.8736  1267.6345    488.0740            430.90353
## 150 2021     China    406.9597   347.5156   1871.9792            444.80271
## 151 2006     India    392.8597  1170.4388   1404.3759            432.15053
## 152 2005        UK    388.0446  1364.1802    961.6429             54.87694
## 153 2021       USA    379.8841   622.7383   1540.3305            336.90086
## 154 2009       USA    374.1524   326.9737   1463.1961            248.06862
## 155 2004       USA    373.8180   882.1834   1034.3065            181.05311
## 156 2013     Japan    365.0192  1432.9893   1598.1299            113.05093
## 157 2008        UK    363.8897   627.2639   1443.2814            388.56854
## 158 2008     Japan    363.8330  1365.2366    322.1033             88.47884
## 159 2006    Canada    359.7675   955.6097    562.4166            266.51305
## 160 2000   Germany    357.8871   968.0832    351.8504             66.80668
## 161 2012     China    356.3564   247.9530   1336.2594            276.20556
## 162 2020    Brazil    355.3983   672.0070   1398.0593            306.85024
## 163 2016       USA    352.8411   905.5049    539.5712            410.98864
## 164 2011     India    352.6951   231.6108   1397.3029            129.69981
## 165 2003    France    349.6431   444.5575   1088.2873            209.00850
## 166 2019     Japan    346.6497   920.4314   1407.4147            423.38381
## 167 2008     India    338.6821   517.1865   1954.1179            226.89398
## 168 2011     Japan    333.4811   693.6001   1303.5014            170.62864
## 169 2011       USA    332.9020  1061.2790    829.9088            284.03061
## 170 2022     China    332.1475  1057.9793   1689.2777            299.84037
## 171 2009    Canada    329.1766  1085.9535   1592.3874            318.03743
## 172 2018    Canada    308.9914  1369.4469    952.6151            294.59879
## 173 2004     Japan    307.9673  1073.4606    333.5079             96.84886
## 174 2002 Australia    306.3263  1138.9283   1524.0621            338.51643
## 175 2003     China    305.9183   300.0739    792.5775            122.54958
## 176 2007     China    305.1416   755.2401   1690.6251            437.32876
## 177 2021        UK    301.2363  1452.1893    320.6626            486.44547
## 178 2021 Australia    288.9150  1367.4706    648.7374            135.80947
## 179 2009     Japan    287.0976   234.4919    608.4402            312.36870
## 180 2020     Japan    285.7791   214.2946    532.7056            455.00839
## 181 2014    Canada    281.4646   412.7527    579.2519            416.55862
## 182 2020   Germany    276.2120   290.1697    471.3226             58.19982
## 183 2023    Brazil    267.9103   570.6237    594.7351            453.54444
## 184 2011    Brazil    266.0689   472.1541    929.8026            268.03534
## 185 2004    Brazil    263.6921   649.3675   1824.5403            263.28274
## 186 2004 Australia    263.4379  1380.9857   1291.7661            230.38314
## 187 2022     Japan    257.8342  1388.7355   1011.9099            222.41234
## 188 2006    Brazil    252.0416   562.1674    600.9178             89.91614
## 189 2001       USA    240.4168   402.7929    398.7421            439.77927
## 190 2022    Canada    236.5074   605.2387    722.4315            384.77583
## 191 2019 Australia    233.7965   739.0114    445.0944            498.59341
## 192 2000    Brazil    232.3661  1404.5639   1136.5977            166.20997
## 193 2014     China    230.4054   836.2886   1975.6058            158.92487
## 194 2016 Australia    226.7713   429.3031   1147.2252            238.51645
## 195 2019    France    220.6137   237.4175   1583.7333            329.13930
## 196 2003    Brazil    215.2413   397.4735    536.0062            338.39364
## 197 2001 Australia    214.7398   716.4735   1655.4021            117.46284
## 198 2011 Australia    212.1964  1397.0944   1778.8238            283.47713
## 199 2010       USA    209.8344   843.7300    358.4605            459.19418
## 200 2007    Brazil    208.5723   799.0124    650.7673            213.92144
## 201 2009     China    207.8788   638.8997   1902.9465            195.44132
## 202 2017    Brazil    207.7859  1357.6855   1309.1072            355.59604
## 203 2023   Germany    206.3483  1105.7583   1369.2028            444.86241
## 204 2019        UK    205.7736  1043.9734   1568.2763            312.51594
## 205 2001    Canada    200.8350   717.2123   1948.0997            439.47821
## 206 2004        UK    192.8115  1373.3188   1158.9290            421.90586
## 207 2022    Brazil    191.6042   398.7169    718.1281            122.30662
## 208 2006     Japan    189.4973   516.1238   1527.8538            435.06341
## 209 2021   Germany    184.9987  1087.9088    421.0207            193.53903
## 210 2017     China    181.2608  1285.8932    845.3261            133.93333
## 211 2014       USA    179.6433   454.7777    376.8864            196.39865
## 212 2014        UK    176.3539  1482.6315    936.2604            216.78897
## 213 2000    Canada    172.2104   881.8648    997.6746            492.07038
## 214 2017       USA    167.0956  1482.9530   1612.8161            139.42206
## 215 2023        UK    166.4169   920.0106   1947.8143            285.39403
## 216 2013        UK    165.4867  1268.4181   1500.6118             86.60695
## 217 2008       USA    158.5464  1433.5512   1941.5745            413.77881
## 218 2008    Canada    157.0375  1486.9483    848.0015            414.44350
## 219 2010    Brazil    154.9702   559.9409   1670.5422            386.71686
## 220 2010        UK    151.8029   914.3875   1050.6019            449.46688
## 221 2012    France    150.7379  1324.1391   1681.9317            499.87295
## 222 2003   Germany    146.5135   890.7610   1219.0797            336.84346
## 223 2013     China    146.3309   562.2404   1844.0520            157.80285
## 224 2022        UK    138.8439  1358.4860   1197.0919            496.83416
## 225 2018     China    136.6976   968.1608   1451.8594             57.46452
## 226 2013    Brazil    133.0149   528.1680   1512.6943            452.84308
## 227 2022 Australia    132.8947   813.6870   1260.2299             79.56889
## 228 2023    Canada    130.1792   940.8566   1596.1798            444.54454
## 229 2001     China    128.2863  1027.3335    834.4052            278.85681
## 230 2017   Germany    123.8602   961.5083   1898.3914            308.96338
## 231 2006   Germany    122.8157  1451.4429   1721.1662            363.18839
## 232 2016    Brazil    118.0641   618.7029    659.4616            197.37381
## 233 2018     Japan    116.5516  1388.5884    500.1768            309.43241
## 234 2013     India    113.9110  1406.8141   1027.9131            484.99467
## 235 2011   Germany    112.9541   350.8944    378.2045             68.32796
## 236 2018 Australia    111.7850  1062.5986    602.6611            482.48164
## 237 2018        UK    110.2183   809.2588    395.7156            103.46806
## 238 2008     China    106.2569   863.9715   1009.5987            149.94851
## 239 2018       USA    104.9699  1260.0999   1501.6575            378.05323
## 240 2004     India    104.5554   409.0505   1232.8474            361.35284
##     TotalRenewableEnergy
## 1               4001.458
## 2               2633.752
## 3               3300.027
## 4               2824.237
## 5               2879.867
## 6               3686.321
## 7               2987.631
## 8               3526.939
## 9               3716.389
## 10              3679.270
## 11              4040.684
## 12              4458.361
## 13              4090.098
## 14              2176.657
## 15              3410.211
## 16              2704.076
## 17              3823.011
## 18              4006.228
## 19              3307.962
## 20              3215.993
## 21              2828.539
## 22              2898.985
## 23              2553.878
## 24              3142.901
## 25              3016.903
## 26              3850.688
## 27              2571.181
## 28              2586.641
## 29              3903.680
## 30              3533.283
## 31              3945.955
## 32              3712.542
## 33              2828.209
## 34              3412.018
## 35              3596.289
## 36              3184.791
## 37              2366.720
## 38              2560.282
## 39              2952.072
## 40              2842.023
## 41              2066.874
## 42              3192.288
## 43              3141.524
## 44              2309.601
## 45              2312.037
## 46              4628.165
## 47              3131.744
## 48              3375.900
## 49              2124.714
## 50              2818.883
## 51              3764.869
## 52              2499.306
## 53              2766.464
## 54              2397.691
## 55              3027.057
## 56              2101.934
## 57              2720.882
## 58              2327.402
## 59              3597.219
## 60              4243.975
## 61              2487.060
## 62              2915.396
## 63              3595.131
## 64              4328.594
## 65              2296.927
## 66              2737.528
## 67              1798.902
## 68              2867.676
## 69              2563.717
## 70              3428.925
## 71              3396.378
## 72              2976.709
## 73              1820.100
## 74              2933.415
## 75              1863.695
## 76              2305.372
## 77              2845.782
## 78              1874.379
## 79              2016.329
## 80              2168.008
## 81              1719.214
## 82              3176.053
## 83              3220.873
## 84              2244.388
## 85              2878.706
## 86              3776.051
## 87              2808.688
## 88              1796.273
## 89              2167.183
## 90              2961.968
## 91              2043.518
## 92              1678.820
## 93              2582.951
## 94              3707.684
## 95              2353.121
## 96              1944.785
## 97              2938.461
## 98              2551.081
## 99              3376.612
## 100             2252.884
## 101             2466.503
## 102             2856.887
## 103             3547.814
## 104             3321.584
## 105             3379.454
## 106             3074.385
## 107             2072.059
## 108             1829.415
## 109             2003.115
## 110             1768.027
## 111             3390.050
## 112             1792.879
## 113             3086.308
## 114             2580.587
## 115             2185.785
## 116             1891.984
## 117             2323.433
## 118             2427.154
## 119             2327.488
## 120             2197.644
## 121             2621.176
## 122             2955.363
## 123             2821.774
## 124             3322.654
## 125             2652.043
## 126             3254.699
## 127             1762.389
## 128             2620.778
## 129             3994.025
## 130             3733.227
## 131             2295.875
## 132             1621.893
## 133             2083.995
## 134             2909.305
## 135             3708.904
## 136             2980.934
## 137             2921.956
## 138             2860.185
## 139             3788.593
## 140             2669.616
## 141             3041.521
## 142             3736.801
## 143             2992.360
## 144             3121.102
## 145             3095.676
## 146             3389.526
## 147             1703.776
## 148             2596.100
## 149             2594.486
## 150             3071.257
## 151             3399.825
## 152             2768.745
## 153             2879.854
## 154             2412.391
## 155             2471.361
## 156             3509.189
## 157             2823.004
## 158             2139.652
## 159             2144.307
## 160             1744.627
## 161             2216.774
## 162             2732.315
## 163             2208.906
## 164             2111.309
## 165             2091.496
## 166             3097.880
## 167             3036.881
## 168             2501.211
## 169             2508.120
## 170             3379.245
## 171             3325.555
## 172             2925.652
## 173             1811.785
## 174             3307.833
## 175             1521.119
## 176             3188.336
## 177             2560.534
## 178             2440.932
## 179             1442.398
## 180             1487.788
## 181             1690.028
## 182             1095.904
## 183             1886.814
## 184             1936.061
## 185             3000.883
## 186             3166.573
## 187             2880.892
## 188             1505.043
## 189             1481.731
## 190             1948.953
## 191             1916.496
## 192             2939.738
## 193             3201.225
## 194             2041.816
## 195             2370.904
## 196             1487.115
## 197             2704.078
## 198             3671.592
## 199             1871.219
## 200             1872.273
## 201             2945.166
## 202             3230.175
## 203             3126.172
## 204             3130.539
## 205             3305.625
## 206             3146.965
## 207             1430.756
## 208             2668.538
## 209             1887.467
## 210             2446.413
## 211             1207.706
## 212             2812.035
## 213             2543.820
## 214             3402.287
## 215             3319.636
## 216             3021.124
## 217             3947.451
## 218             2906.431
## 219             2772.170
## 220             2566.259
## 221             3656.682
## 222             2593.198
## 223             2710.426
## 224             3191.256
## 225             2614.182
## 226             2626.720
## 227             2286.381
## 228             3111.760
## 229             2268.882
## 230             3292.723
## 231             3658.613
## 232             1593.602
## 233             2314.749
## 234             3033.633
## 235              910.381
## 236             2259.526
## 237             1418.661
## 238             2129.776
## 239             3244.780
## 240             2107.806

Combine arrange and filter function

Global_REP %>%
  filter(Year == 2023, Country == "India") %>%
  arrange(TotalRenewableEnergy)
##   Year Country SolarEnergy WindEnergy HydroEnergy OtherRenewableEnergy
## 1 2023   India    620.4521    246.725    1091.517             294.1901
##   TotalRenewableEnergy
## 1             2252.884

Summarize

Global_REP %>%
  summarise(medianSE = median(SolarEnergy))
##   medianSE
## 1 533.4364
Global_REP %>%
  filter(Country == "India") %>%
  summarise(medianSE = median(SolarEnergy))
##   medianSE
## 1 689.3084

use group_by()

Global_REP %>%
  group_by(Country) %>%
  summarise(medianWE = median(WindEnergy), 
            maxWE = max(WindEnergy))
## # A tibble: 10 × 3
##    Country   medianWE maxWE
##    <chr>        <dbl> <dbl>
##  1 Australia     920. 1431.
##  2 Brazil        634. 1482.
##  3 Canada        881. 1487.
##  4 China         756. 1365.
##  5 France        926. 1372.
##  6 Germany       926. 1469.
##  7 India         980. 1487.
##  8 Japan         859. 1433.
##  9 UK           1127. 1483.
## 10 USA           863. 1483.
Global_REP %>%
  filter(Year > 2010) %>%
  summarise(medianTRE = median(TotalRenewableEnergy), 
            maxTRE = max(TotalRenewableEnergy))
##   medianTRE   maxTRE
## 1  2849.455 4628.165

use ggplot2

#color

ggplot(Global_REP, aes(x = TotalRenewableEnergy, 
                       y = SolarEnergy, color = Country)) +
  geom_point()

ggplot(Global_REP, aes(x = TotalRenewableEnergy, 
                       y = SolarEnergy, 
                       color = Country,
                       size = WindEnergy)) +
  geom_point()

use facet_wrap

ggplot(Global_REP, aes(x = TotalRenewableEnergy, 
                       y = SolarEnergy)) +
  geom_point() +
  facet_wrap(~ Country) + 
  labs(title = "Production of Solar Energy of Total Renewable Energy by Top Some of the Countries in the World")

create line plots

by_year <- Global_REP %>%
  group_by(Year) %>%
  summarise(medianSE = median(SolarEnergy))

create a plot

ggplot(by_year, aes(x = Year, y = medianSE)) +
         geom_line() +
         expand_limits(y = 0) +
  labs( title = "Median Solar Energy by Year", 
        x = "Year",
        y = "Median Solar Energy")

create Bar Plots

by_country <- Global_REP %>%
  group_by(Country) %>%
  summarise(medianHE = median(HydroEnergy))

ggplot(by_country, aes(x =  Country, 
                       y = medianHE)) +
  geom_col() + 
  labs(title = "Meidan of Hydro Energy by Country From 2000 to 2023",
       x = "Country", 
       y = "Median of Hydro Energy")

create Histograms

ggplot(Global_REP, aes(x = WindEnergy)) +
  geom_histogram()
## `stat_bin()` using `bins = 30`. Pick better value with `binwidth`.

create Box plot

ggplot(Global_REP, aes(Country, WindEnergy)) +
  geom_boxplot() +
  labs(title = "Production of Wind Energy by Country in Box Plot")