library(ggplot2)
padi <- read.csv("D:/kuliah/Data Mining/dataset/ProduksiPadiSumatra.csv", sep = "\t") 
head(padi)
##   Provinsi Tahun Produksi Luas.Panen Curah.hujan Kelembapan Suhu.rata.rata
## 1     Aceh  1993  1329536     323589        1627      82.00          26.06
## 2     Aceh  1994  1299699     329041        1521      82.12          26.92
## 3     Aceh  1995  1382905     339253        1476      82.72          26.27
## 4     Aceh  1996  1419128     348223        1557      83.00          26.08
## 5     Aceh  1997  1368074     337561        1339      82.46          26.31
## 6     Aceh  1998  1404580     365892        1465      82.60          26.84
padi_matrix <- data.matrix(padi[c("Luas.Panen", "Curah.hujan", "Kelembapan")])
padi_matrix
##        Luas.Panen Curah.hujan Kelembapan
##   [1,]  323589.00     1627.00      82.00
##   [2,]  329041.00     1521.00      82.12
##   [3,]  339253.00     1476.00      82.72
##   [4,]  348223.00     1557.00      83.00
##   [5,]  337561.00     1339.00      82.46
##   [6,]  365892.00     1465.00      82.60
##   [7,]  359817.00     1778.00      82.79
##   [8,]  336765.00     1974.70      90.60
##   [9,]  295212.00     1688.70      69.48
##  [10,]  315131.00     1296.80      68.75
##  [11,]  367636.00     1507.20      70.66
##  [12,]  370966.00     1097.00      80.84
##  [13,]  337893.00      710.50      79.50
##  [14,]  320789.00      506.50      80.80
##  [15,]  360717.00     1414.00      81.50
##  [16,]  329109.00     1270.40      78.50
##  [17,]  359375.00     1577.00      78.70
##  [18,]  352281.00     1986.00      81.40
##  [19,]  380686.00     1268.00      79.40
##  [20,]  387803.00     1098.00      79.60
##  [21,]  419183.00     1623.60      80.70
##  [22,]  376137.00     2264.40      78.30
##  [23,]  461060.00     1575.00      80.00
##  [24,]  293067.00     1096.00      83.32
##  [25,]  294483.00     1905.90      85.57
##  [26,]  329515.78     1427.80      83.98
##  [27,]  310012.46     1931.40      83.90
##  [28,]  317869.41     1619.20      80.82
##  [29,]  754569.00     2549.40      83.80
##  [30,]  792534.00     2166.50      83.79
##  [31,]  795183.00     2917.10      81.68
##  [32,]  790051.00     2326.50      81.31
##  [33,]  797545.00     1865.00      81.81
##  [34,]  823749.00     2496.90      83.53
##  [35,]  838626.00     3087.30      84.56
##  [36,]  847610.00     1289.50      82.94
##  [37,]  801948.00     3595.30      72.78
##  [38,]  765161.00     1944.90      72.31
##  [39,]  825188.00     3140.20      72.08
##  [40,]  826091.00     2406.90      80.79
##  [41,]  822073.00      776.70      83.80
##  [42,]  705023.00      222.50      81.00
##  [43,]  750232.00     2513.00      82.00
##  [44,]  748540.00     2442.00      81.40
##  [45,]  768407.00     2184.00      86.00
##  [46,]  754674.00     1903.30      78.55
##  [47,]  757547.00     2042.00      79.00
##  [48,]  765099.00     3175.00      76.00
##  [49,]  742968.00     2627.00      78.67
##  [50,]  717318.00     2148.00      79.00
##  [51,]  781769.00      975.90      86.90
##  [52,]  423029.00     2384.00      82.00
##  [53,]  415675.00     3190.00      84.00
##  [54,]  408176.45     2431.00      80.00
##  [55,]  413141.24     1401.60      86.53
##  [56,]  388591.22     1648.30      83.76
##  [57,]  394412.00     5110.00      89.77
##  [58,]  382740.00     4869.50      75.22
##  [59,]  400627.00     5022.00      87.68
##  [60,]  430343.00     3866.00      87.29
##  [61,]  395728.00     2945.10      87.97
##  [62,]  412810.00     5522.00      87.39
##  [63,]  432254.00     4327.50      80.89
##  [64,]  396919.00     3040.60      86.01
##  [65,]  376710.00     2811.00      71.08
##  [66,]  424253.00     4241.20      71.28
##  [67,]  411860.00     4927.20      71.91
##  [68,]  422582.00     4584.20      78.50
##  [69,]  426950.00     1533.60      78.00
##  [70,]  417846.00      776.00      79.00
##  [71,]  423655.00     4329.00      85.30
##  [72,]  421902.00     2552.50      86.20
##  [73,]  439542.00     4691.00      86.20
##  [74,]  460497.00     5228.00      87.20
##  [75,]  461709.00     4959.50      54.20
##  [76,]  476422.00     4339.00      87.00
##  [77,]  487820.00     4627.90      86.91
##  [78,]  503198.00     2838.40      85.35
##  [79,]  507545.00     3548.00      84.00
##  [80,]  222482.00     4205.20      76.49
##  [81,]  222021.00     4553.00      75.11
##  [82,]  313050.82      327.33      82.71
##  [83,]  311671.23     4757.50      87.73
##  [84,]  295664.47     4072.70      85.22
##  [85,]  146133.00     2738.40      86.37
##  [86,]  146177.00     1991.30      84.90
##  [87,]  152204.00     3099.90      85.02
##  [88,]  150354.00     2259.50      84.26
##  [89,]  137953.00     1510.40      83.82
##  [90,]  126280.00     2233.00      84.26
##  [91,]  155683.00     2045.30      84.59
##  [92,]  141640.00     2478.20      84.60
##  [93,]  132507.00     2441.70      70.79
##  [94,]  129025.00     3123.80      71.73
##  [95,]  132887.00     3822.80      72.92
##  [96,]  145239.00     2540.10      83.70
##  [97,]  134418.00     1996.30      83.93
##  [98,]  136177.00      537.60      79.60
##  [99,]  147167.00     3216.30      85.30
## [100,]  147796.00     3026.20      80.20
## [101,]  149423.00     3390.00      76.20
## [102,]  156088.00     3390.00      76.20
## [103,]  145242.00     2405.00      74.50
## [104,]  144015.00     2636.00      76.10
## [105,]  118518.00     2628.00      76.00
## [106,]  106037.00     2343.00      78.10
## [107,]  107546.00     2048.30      80.50
## [108,]   72151.00     2105.60      83.72
## [109,]   70016.00     2982.90      84.76
## [110,]   71448.08     1837.10      71.22
## [111,]   63142.04     1608.30      83.77
## [112,]   64733.13     2584.90      81.80
## [113,]  199431.00     1954.00      83.81
## [114,]  184029.00     1824.00      81.25
## [115,]  193666.00     2290.10      83.96
## [116,]  215975.00     2309.10      83.60
## [117,]  190608.00     1030.10      80.64
## [118,]  178766.00     2383.80      83.47
## [119,]  178307.00     2429.30      83.25
## [120,]  171395.00      840.30      84.85
## [121,]  164826.00     2515.20      72.40
## [122,]  165729.00     2044.50      70.77
## [123,]  159463.00     2508.10      71.28
## [124,]  156803.00     2561.00      82.74
## [125,]  154941.00     1015.70      84.80
## [126,]  140613.00      424.70      85.00
## [127,]  149888.00     2394.00      86.00
## [128,]  143034.00     2230.00      83.70
## [129,]  155802.00     2299.00      83.80
## [130,]  153897.00     3207.00      84.60
## [131,]  157441.00     2295.00      82.50
## [132,]  149369.00     1874.00      81.40
## [133,]  153243.00     2093.00      83.42
## [134,]  145990.00     1781.00      82.80
## [135,]  122214.00     1694.90      82.10
## [136,]   96588.00     1502.40      83.84
## [137,]   97690.00     2193.20      83.69
## [138,]   86202.68     2182.30      82.23
## [139,]   69536.06     1773.40      81.44
## [140,]   84772.93     2303.80      78.24
## [141,]  439895.00     2815.00      82.78
## [142,]  422109.00     1800.00      79.89
## [143,]  492448.00     2800.00      82.71
## [144,]  495958.00     2614.00      82.45
## [145,]  469670.00     1558.30      78.47
## [146,]  621829.00     2539.30      82.58
## [147,]  530692.00     2704.70      81.01
## [148,]  555427.00     2632.50      83.26
## [149,]  511928.00     2837.50      72.06
## [150,]  561724.00     2368.20      70.36
## [151,]  570010.00     2674.00      69.59
## [152,]  625013.00     2182.60      80.96
## [153,]  626849.00     1356.90      82.50
## [154,]  646927.00     1442.00      80.00
## [155,]  691467.00     2364.70      83.50
## [156,]  718797.00     2685.70      84.80
## [157,]  746465.00     2389.00      82.30
## [158,]  769478.00     3396.00      85.25
## [159,]  784820.00     2593.00      84.80
## [160,]  769725.00     3083.00      83.00
## [161,]  800036.00     3409.00      84.00
## [162,]  810900.00     1668.30      81.00
## [163,]  872737.00     1947.20      79.50
## [164,]  615184.00     3477.90      82.22
## [165,]  621903.00     2489.50      81.08
## [166,]  581574.61     2252.40      77.66
## [167,]  539316.52     1655.50      85.13
## [168,]  551320.76     2300.20      81.10
## [169,]  109807.00     4150.00      85.50
## [170,]  104747.00     2043.00      85.32
## [171,]  115914.00     4478.00      85.49
## [172,]  121929.00     3931.00      85.96
## [173,]  113915.00     1167.00      84.00
## [174,]  111158.00     4114.00      85.34
## [175,]  114788.00     3084.00      84.72
## [176,]  108751.00     3254.00      84.73
## [177,]  105212.00     3010.00      70.15
## [178,]  109519.00     3076.00      67.98
## [179,]  110550.00     3030.00      70.30
## [180,]  110929.00     3277.00      84.28
## [181,]  116818.00     3375.20      84.70
## [182,]  100991.00     2313.80      83.30
## [183,]  123853.00     3150.00      84.20
## [184,]  127506.00     3396.00      84.20
## [185,]  132975.00     3850.00      84.10
## [186,]  133629.00     3822.00      84.00
## [187,]  127934.00     2465.70      82.52
## [188,]  144448.00     2545.00      82.00
## [189,]  147680.00     3980.90      83.93
## [190,]  147572.00     3323.00      83.70
## [191,]  128833.00     2668.90      83.20
## [192,]   83449.00     3350.10      83.38
## [193,]   82429.00     3949.80      84.20
## [194,]   65891.16     3649.90      83.79
## [195,]   64406.86     1786.20      83.26
## [196,]   64137.28     4144.00      80.18
## [197,]  433078.00     2306.70      84.82
## [198,]  425940.00     2034.20      77.51
## [199,]  514363.00     3039.40      82.81
## [200,]  515192.00     1934.90      82.61
## [201,]  454087.00     1253.30      78.46
## [202,]  521575.00     2584.90      84.07
## [203,]  476899.00     2364.70      83.46
## [204,]  496879.00     1488.50      82.86
## [205,]  501119.00     2013.10      77.83
## [206,]  475461.00     2143.50      75.84
## [207,]  472635.00     1682.20      68.71
## [208,]  495519.00     2042.90      81.47
## [209,]  496538.00     1612.80      79.60
## [210,]  494102.00      560.30      74.60
## [211,]  524955.00     1941.40      75.90
## [212,]  506547.00     1940.10      79.00
## [213,]  570417.00     1789.00      79.10
## [214,]  590608.00     2710.00      82.30
## [215,]  606973.00     1568.00      77.80
## [216,]  641876.00     1685.00      79.20
## [217,]  638090.00     2456.70      81.00
## [218,]  648731.00     1682.50      79.90
## [219,]  707266.00     1628.10      78.90
## [220,]  390799.00     2317.60      79.40
## [221,]  396559.00     1825.10      77.04
## [222,]  511940.93     1385.80      76.05
## [223,]  464103.42     1706.40      78.03
## [224,]  545149.05     2211.30      75.80
padi2 <- data.frame(padi, padi_matrix)
padi2
##             Provinsi Tahun  Produksi Luas.Panen Curah.hujan Kelembapan
## 1               Aceh  1993 1329536.0  323589.00     1627.00      82.00
## 2               Aceh  1994 1299699.0  329041.00     1521.00      82.12
## 3               Aceh  1995 1382905.0  339253.00     1476.00      82.72
## 4               Aceh  1996 1419128.0  348223.00     1557.00      83.00
## 5               Aceh  1997 1368074.0  337561.00     1339.00      82.46
## 6               Aceh  1998 1404580.0  365892.00     1465.00      82.60
## 7               Aceh  1999 1478712.0  359817.00     1778.00      82.79
## 8               Aceh  2000 1486909.0  336765.00     1974.70      90.60
## 9               Aceh  2001 1547499.0  295212.00     1688.70      69.48
## 10              Aceh  2002 1314165.0  315131.00     1296.80      68.75
## 11              Aceh  2003 1246614.0  367636.00     1507.20      70.66
## 12              Aceh  2004 1350748.0  370966.00     1097.00      80.84
## 13              Aceh  2005 1411650.0  337893.00      710.50      79.50
## 14              Aceh  2006 1552078.0  320789.00      506.50      80.80
## 15              Aceh  2007 1556858.0  360717.00     1414.00      81.50
## 16              Aceh  2008 1402287.0  329109.00     1270.40      78.50
## 17              Aceh  2009 1533369.0  359375.00     1577.00      78.70
## 18              Aceh  2010 1788738.0  352281.00     1986.00      81.40
## 19              Aceh  2011 1772962.0  380686.00     1268.00      79.40
## 20              Aceh  2012 1582393.0  387803.00     1098.00      79.60
## 21              Aceh  2013 2331046.0  419183.00     1623.60      80.70
## 22              Aceh  2014 1820062.0  376137.00     2264.40      78.30
## 23              Aceh  2015 1956940.0  461060.00     1575.00      80.00
## 24              Aceh  2016 2180754.0  293067.00     1096.00      83.32
## 25              Aceh  2017 2478922.0  294483.00     1905.90      85.57
## 26              Aceh  2018 1751996.9  329515.78     1427.80      83.98
## 27              Aceh  2019 1714437.6  310012.46     1931.40      83.90
## 28              Aceh  2020 1861567.1  317869.41     1619.20      80.82
## 29    Sumatera Utara  1993 2918152.0  754569.00     2549.40      83.80
## 30    Sumatera Utara  1994 3079960.0  792534.00     2166.50      83.79
## 31    Sumatera Utara  1995 3134533.0  795183.00     2917.10      81.68
## 32    Sumatera Utara  1996 3136760.0  790051.00     2326.50      81.31
## 33    Sumatera Utara  1997 3212208.0  797545.00     1865.00      81.81
## 34    Sumatera Utara  1998 3321049.0  823749.00     2496.90      83.53
## 35    Sumatera Utara  1999 3451430.0  838626.00     3087.30      84.56
## 36    Sumatera Utara  2000 3514253.0  847610.00     1289.50      82.94
## 37    Sumatera Utara  2001 3291515.0  801948.00     3595.30      72.78
## 38    Sumatera Utara  2002 3153305.0  765161.00     1944.90      72.31
## 39    Sumatera Utara  2003 3403075.0  825188.00     3140.20      72.08
## 40    Sumatera Utara  2004 3418782.0  826091.00     2406.90      80.79
## 41    Sumatera Utara  2005 3447394.0  822073.00      776.70      83.80
## 42    Sumatera Utara  2006 3007636.0  705023.00      222.50      81.00
## 43    Sumatera Utara  2007 3265834.0  750232.00     2513.00      82.00
## 44    Sumatera Utara  2008 3340794.0  748540.00     2442.00      81.40
## 45    Sumatera Utara  2009 3527899.0  768407.00     2184.00      86.00
## 46    Sumatera Utara  2010 3582302.0  754674.00     1903.30      78.55
## 47    Sumatera Utara  2011 3607403.0  757547.00     2042.00      79.00
## 48    Sumatera Utara  2012 3715514.0  765099.00     3175.00      76.00
## 49    Sumatera Utara  2013 3727249.0  742968.00     2627.00      78.67
## 50    Sumatera Utara  2014 3631039.0  717318.00     2148.00      79.00
## 51    Sumatera Utara  2015 4044829.0  781769.00      975.90      86.90
## 52    Sumatera Utara  2016 4387035.9  423029.00     2384.00      82.00
## 53    Sumatera Utara  2017 4669777.5  415675.00     3190.00      84.00
## 54    Sumatera Utara  2018 2108284.7  408176.45     2431.00      80.00
## 55    Sumatera Utara  2019 2078901.6  413141.24     1401.60      86.53
## 56    Sumatera Utara  2020 2076280.0  388591.22     1648.30      83.76
## 57    Sumatera Barat  1993 1806424.0  394412.00     5110.00      89.77
## 58    Sumatera Barat  1994 1747543.0  382740.00     4869.50      75.22
## 59    Sumatera Barat  1995 1829192.0  400627.00     5022.00      87.68
## 60    Sumatera Barat  1996 1971180.0  430343.00     3866.00      87.29
## 61    Sumatera Barat  1997 1787719.0  395728.00     2945.10      87.97
## 62    Sumatera Barat  1998 1807622.0  412810.00     5522.00      87.39
## 63    Sumatera Barat  1999 1897678.0  432254.00     4327.50      80.89
## 64    Sumatera Barat  2000 1759059.0  396919.00     3040.60      86.01
## 65    Sumatera Barat  2001 1668955.0  376710.00     2811.00      71.08
## 66    Sumatera Barat  2002 1875834.0  424253.00     4241.20      71.28
## 67    Sumatera Barat  2003 1823739.0  411860.00     4927.20      71.91
## 68    Sumatera Barat  2004 1875188.0  422582.00     4584.20      78.50
## 69    Sumatera Barat  2005 1907390.0  426950.00     1533.60      78.00
## 70    Sumatera Barat  2006 1889489.0  417846.00      776.00      79.00
## 71    Sumatera Barat  2007 1938120.0  423655.00     4329.00      85.30
## 72    Sumatera Barat  2008 1965634.0  421902.00     2552.50      86.20
## 73    Sumatera Barat  2009 2105790.0  439542.00     4691.00      86.20
## 74    Sumatera Barat  2010 2211248.0  460497.00     5228.00      87.20
## 75    Sumatera Barat  2011 2279602.0  461709.00     4959.50      54.20
## 76    Sumatera Barat  2012 2368390.0  476422.00     4339.00      87.00
## 77    Sumatera Barat  2013 2430384.0  487820.00     4627.90      86.91
## 78    Sumatera Barat  2014 2519020.0  503198.00     2838.40      85.35
## 79    Sumatera Barat  2015 2550609.0  507545.00     3548.00      84.00
## 80    Sumatera Barat  2016 2487929.0  222482.00     4205.20      76.49
## 81    Sumatera Barat  2017 2810425.0  222021.00     4553.00      75.11
## 82    Sumatera Barat  2018 1483076.5  313050.82      327.33      82.71
## 83    Sumatera Barat  2019 1482996.0  311671.23     4757.50      87.73
## 84    Sumatera Barat  2020 1450839.7  295664.47     4072.70      85.22
## 85              Riau  1993  436297.0  146133.00     2738.40      86.37
## 86              Riau  1994  445361.0  146177.00     1991.30      84.90
## 87              Riau  1995  458756.0  152204.00     3099.90      85.02
## 88              Riau  1996  461905.0  150354.00     2259.50      84.26
## 89              Riau  1997  416135.0  137953.00     1510.40      83.82
## 90              Riau  1998  370124.0  126280.00     2233.00      84.26
## 91              Riau  1999  461630.0  155683.00     2045.30      84.59
## 92              Riau  2000  431351.0  141640.00     2478.20      84.60
## 93              Riau  2001  413391.0  132507.00     2441.70      70.79
## 94              Riau  2002  396644.0  129025.00     3123.80      71.73
## 95              Riau  2003  414237.0  132887.00     3822.80      72.92
## 96              Riau  2004  454186.0  145239.00     2540.10      83.70
## 97              Riau  2005  424095.0  134418.00     1996.30      83.93
## 98              Riau  2006   42938.0  136177.00      537.60      79.60
## 99              Riau  2007  490087.0  147167.00     3216.30      85.30
## 100             Riau  2008  494260.0  147796.00     3026.20      80.20
## 101             Riau  2009  531429.0  149423.00     3390.00      76.20
## 102             Riau  2010  574864.0  156088.00     3390.00      76.20
## 103             Riau  2011  535788.0  145242.00     2405.00      74.50
## 104             Riau  2012  512152.0  144015.00     2636.00      76.10
## 105             Riau  2013  434144.0  118518.00     2628.00      76.00
## 106             Riau  2014  385475.0  106037.00     2343.00      78.10
## 107             Riau  2015  393917.0  107546.00     2048.30      80.50
## 108             Riau  2016  325826.0   72151.00     2105.60      83.72
## 109             Riau  2017  337421.0   70016.00     2982.90      84.76
## 110             Riau  2018  266375.5   71448.08     1837.10      71.22
## 111             Riau  2019  230874.0   63142.04     1608.30      83.77
## 112             Riau  2020  269344.0   64733.13     2584.90      81.80
## 113            Jambi  1993  607529.0  199431.00     1954.00      83.81
## 114            Jambi  1994  564722.0  184029.00     1824.00      81.25
## 115            Jambi  1995  593502.0  193666.00     2290.10      83.96
## 116            Jambi  1996  657650.0  215975.00     2309.10      83.60
## 117            Jambi  1997  572269.0  190608.00     1030.10      80.64
## 118            Jambi  1998  550277.0  178766.00     2383.80      83.47
## 119            Jambi  1999  553641.0  178307.00     2429.30      83.25
## 120            Jambi  2000  536779.0  171395.00      840.30      84.85
## 121            Jambi  2001  556564.0  164826.00     2515.20      72.40
## 122            Jambi  2002  561007.0  165729.00     2044.50      70.77
## 123            Jambi  2003  578346.0  159463.00     2508.10      71.28
## 124            Jambi  2004  579404.0  156803.00     2561.00      82.74
## 125            Jambi  2005  579635.0  154941.00     1015.70      84.80
## 126            Jambi  2006  544597.0  140613.00      424.70      85.00
## 127            Jambi  2007   58663.0  149888.00     2394.00      86.00
## 128            Jambi  2008  581704.0  143034.00     2230.00      83.70
## 129            Jambi  2009  644947.0  155802.00     2299.00      83.80
## 130            Jambi  2010  628828.0  153897.00     3207.00      84.60
## 131            Jambi  2011  646641.0  157441.00     2295.00      82.50
## 132            Jambi  2012  625164.0  149369.00     1874.00      81.40
## 133            Jambi  2013  664535.0  153243.00     2093.00      83.42
## 134            Jambi  2014  664720.0  145990.00     1781.00      82.80
## 135            Jambi  2015  541486.0  122214.00     1694.90      82.10
## 136            Jambi  2016  642095.0   96588.00     1502.40      83.84
## 137            Jambi  2017  678127.0   97690.00     2193.20      83.69
## 138            Jambi  2018  383045.7   86202.68     2182.30      82.23
## 139            Jambi  2019  309932.7   69536.06     1773.40      81.44
## 140            Jambi  2020  374376.3   84772.93     2303.80      78.24
## 141 Sumatera Selatan  1993 1409559.0  439895.00     2815.00      82.78
## 142 Sumatera Selatan  1994 1347611.0  422109.00     1800.00      79.89
## 143 Sumatera Selatan  1995 1557944.0  492448.00     2800.00      82.71
## 144 Sumatera Selatan  1996 1666591.0  495958.00     2614.00      82.45
## 145 Sumatera Selatan  1997 1577398.0  469670.00     1558.30      78.47
## 146 Sumatera Selatan  1998 1931505.0  621829.00     2539.30      82.58
## 147 Sumatera Selatan  1999 1789961.0  530692.00     2704.70      81.01
## 148 Sumatera Selatan  2000 1863643.0  555427.00     2632.50      83.26
## 149 Sumatera Selatan  2001 1723433.0  511928.00     2837.50      72.06
## 150 Sumatera Selatan  2002 1899849.0  561724.00     2368.20      70.36
## 151 Sumatera Selatan  2003 1977345.0  570010.00     2674.00      69.59
## 152 Sumatera Selatan  2004 2260794.0  625013.00     2182.60      80.96
## 153 Sumatera Selatan  2005 2320110.0  626849.00     1356.90      82.50
## 154 Sumatera Selatan  2006 2456251.0  646927.00     1442.00      80.00
## 155 Sumatera Selatan  2007 2753044.0  691467.00     2364.70      83.50
## 156 Sumatera Selatan  2008 2971286.0  718797.00     2685.70      84.80
## 157 Sumatera Selatan  2009 3125236.0  746465.00     2389.00      82.30
## 158 Sumatera Selatan  2010 3272451.0  769478.00     3396.00      85.25
## 159 Sumatera Selatan  2011 3384670.0  784820.00     2593.00      84.80
## 160 Sumatera Selatan  2012 3295247.0  769725.00     3083.00      83.00
## 161 Sumatera Selatan  2013 3676723.0  800036.00     3409.00      84.00
## 162 Sumatera Selatan  2014 3670435.0  810900.00     1668.30      81.00
## 163 Sumatera Selatan  2015 4247922.0  872737.00     1947.20      79.50
## 164 Sumatera Selatan  2016 4881089.0  615184.00     3477.90      82.22
## 165 Sumatera Selatan  2017 4807430.0  621903.00     2489.50      81.08
## 166 Sumatera Selatan  2018 2994191.8  581574.61     2252.40      77.66
## 167 Sumatera Selatan  2019 2603396.2  539316.52     1655.50      85.13
## 168 Sumatera Selatan  2020 2696877.5  551320.76     2300.20      81.10
## 169         Bengkulu  1993  356709.0  109807.00     4150.00      85.50
## 170         Bengkulu  1994  334232.0  104747.00     2043.00      85.32
## 171         Bengkulu  1995  377337.0  115914.00     4478.00      85.49
## 172         Bengkulu  1996  396977.0  121929.00     3931.00      85.96
## 173         Bengkulu  1997  382123.0  113915.00     1167.00      84.00
## 174         Bengkulu  1998  375533.0  111158.00     4114.00      85.34
## 175         Bengkulu  1999  381577.0  114788.00     3084.00      84.72
## 176         Bengkulu  2000  362979.0  108751.00     3254.00      84.73
## 177         Bengkulu  2001  376973.0  105212.00     3010.00      70.15
## 178         Bengkulu  2002  379818.0  109519.00     3076.00      67.98
## 179         Bengkulu  2003  413375.0  110550.00     3030.00      70.30
## 180         Bengkulu  2004  414741.0  110929.00     3277.00      84.28
## 181         Bengkulu  2005  441276.0  116818.00     3375.20      84.70
## 182         Bengkulu  2006  378377.0  100991.00     2313.80      83.30
## 183         Bengkulu  2007  470469.0  123853.00     3150.00      84.20
## 184         Bengkulu  2008  484900.0  127506.00     3396.00      84.20
## 185         Bengkulu  2009  510160.0  132975.00     3850.00      84.10
## 186         Bengkulu  2010  516869.0  133629.00     3822.00      84.00
## 187         Bengkulu  2011  502552.0  127934.00     2465.70      82.52
## 188         Bengkulu  2012  581910.0  144448.00     2545.00      82.00
## 189         Bengkulu  2013  622832.0  147680.00     3980.90      83.93
## 190         Bengkulu  2014  593194.0  147572.00     3323.00      83.70
## 191         Bengkulu  2015  578654.0  128833.00     2668.90      83.20
## 192         Bengkulu  2016  629224.0   83449.00     3350.10      83.38
## 193         Bengkulu  2017  714017.0   82429.00     3949.80      84.20
## 194         Bengkulu  2018  288810.5   65891.16     3649.90      83.79
## 195         Bengkulu  2019  296472.1   64406.86     1786.20      83.26
## 196         Bengkulu  2020  296925.2   64137.28     4144.00      80.18
## 197          Lampung  1993 1646900.0  433078.00     2306.70      84.82
## 198          Lampung  1994 1615751.0  425940.00     2034.20      77.51
## 199          Lampung  1995 1943709.0  514363.00     3039.40      82.81
## 200          Lampung  1996 1971740.0  515192.00     1934.90      82.61
## 201          Lampung  1997 1753656.0  454087.00     1253.30      78.46
## 202          Lampung  1998 1975700.0  521575.00     2584.90      84.07
## 203          Lampung  1999 1801422.0  476899.00     2364.70      83.46
## 204          Lampung  2000 1946406.0  496879.00     1488.50      82.86
## 205          Lampung  2001 1992726.0  501119.00     2013.10      77.83
## 206          Lampung  2002 1951109.0  475461.00     2143.50      75.84
## 207          Lampung  2003 1966293.0  472635.00     1682.20      68.71
## 208          Lampung  2004 2091996.0  495519.00     2042.90      81.47
## 209          Lampung  2005 2124144.0  496538.00     1612.80      79.60
## 210          Lampung  2006 2129914.0  494102.00      560.30      74.60
## 211          Lampung  2007 2308404.0  524955.00     1941.40      75.90
## 212          Lampung  2008 2341075.0  506547.00     1940.10      79.00
## 213          Lampung  2009 2673844.0  570417.00     1789.00      79.10
## 214          Lampung  2010 2807676.0  590608.00     2710.00      82.30
## 215          Lampung  2011 2940795.0  606973.00     1568.00      77.80
## 216          Lampung  2012 3101455.0  641876.00     1685.00      79.20
## 217          Lampung  2013 3207002.0  638090.00     2456.70      81.00
## 218          Lampung  2014 3320064.0  648731.00     1682.50      79.90
## 219          Lampung  2015 3641895.0  707266.00     1628.10      78.90
## 220          Lampung  2016 3831923.0  390799.00     2317.60      79.40
## 221          Lampung  2017 4090654.0  396559.00     1825.10      77.04
## 222          Lampung  2018 2488641.9  511940.93     1385.80      76.05
## 223          Lampung  2019 2164089.3  464103.42     1706.40      78.03
## 224          Lampung  2020 2604913.3  545149.05     2211.30      75.80
##     Suhu.rata.rata Luas.Panen.1 Curah.hujan.1 Kelembapan.1
## 1            26.06    323589.00       1627.00        82.00
## 2            26.92    329041.00       1521.00        82.12
## 3            26.27    339253.00       1476.00        82.72
## 4            26.08    348223.00       1557.00        83.00
## 5            26.31    337561.00       1339.00        82.46
## 6            26.84    365892.00       1465.00        82.60
## 7            26.14    359817.00       1778.00        82.79
## 8            27.10    336765.00       1974.70        90.60
## 9            28.90    295212.00       1688.70        69.48
## 10           29.20    315131.00       1296.80        68.75
## 11           29.40    367636.00       1507.20        70.66
## 12           29.40    370966.00       1097.00        80.84
## 13           26.80    337893.00        710.50        79.50
## 14           26.73    320789.00        506.50        80.80
## 15           26.38    360717.00       1414.00        81.50
## 16           27.00    329109.00       1270.40        78.50
## 17           26.90    359375.00       1577.00        78.70
## 18           27.10    352281.00       1986.00        81.40
## 19           27.10    380686.00       1268.00        79.40
## 20           26.90    387803.00       1098.00        79.60
## 21           27.00    419183.00       1623.60        80.70
## 22           27.10    376137.00       2264.40        78.30
## 23           27.10    461060.00       1575.00        80.00
## 24           27.12    293067.00       1096.00        83.32
## 25           26.51    294483.00       1905.90        85.57
## 26           26.48    329515.78       1427.80        83.98
## 27           26.65    310012.46       1931.40        83.90
## 28           25.41    317869.41       1619.20        80.82
## 29           26.45    754569.00       2549.40        83.80
## 30           26.40    792534.00       2166.50        83.79
## 31           26.58    795183.00       2917.10        81.68
## 32           26.33    790051.00       2326.50        81.31
## 33           26.40    797545.00       1865.00        81.81
## 34           27.16    823749.00       2496.90        83.53
## 35           26.45    838626.00       3087.30        84.56
## 36           27.70    847610.00       1289.50        82.94
## 37           28.03    801948.00       3595.30        72.78
## 38           28.45    765161.00       1944.90        72.31
## 39           29.59    825188.00       3140.20        72.08
## 40           29.27    826091.00       2406.90        80.79
## 41           27.00    822073.00        776.70        83.80
## 42           27.80    705023.00        222.50        81.00
## 43           27.00    750232.00       2513.00        82.00
## 44           26.90    748540.00       2442.00        81.40
## 45           27.10    768407.00       2184.00        86.00
## 46           27.18    754674.00       1903.30        78.55
## 47           27.20    757547.00       2042.00        79.00
## 48           27.30    765099.00       3175.00        76.00
## 49           28.80    742968.00       2627.00        78.67
## 50           27.90    717318.00       2148.00        79.00
## 51           27.40    781769.00        975.90        86.90
## 52           27.65    423029.00       2384.00        82.00
## 53           27.50    415675.00       3190.00        84.00
## 54           26.41    408176.45       2431.00        80.00
## 55           27.03    413141.24       1401.60        86.53
## 56           25.79    388591.22       1648.30        83.76
## 57           24.70    394412.00       5110.00        89.77
## 58           24.49    382740.00       4869.50        75.22
## 59           24.82    400627.00       5022.00        87.68
## 60           24.52    430343.00       3866.00        87.29
## 61           24.69    395728.00       2945.10        87.97
## 62           25.04    412810.00       5522.00        87.39
## 63           22.48    432254.00       4327.50        80.89
## 64           25.86    396919.00       3040.60        86.01
## 65           28.17    376710.00       2811.00        71.08
## 66           28.19    424253.00       4241.20        71.28
## 67           29.17    411860.00       4927.20        71.91
## 68           29.02    422582.00       4584.20        78.50
## 69           25.90    426950.00       1533.60        78.00
## 70           26.05    417846.00        776.00        79.00
## 71           25.70    423655.00       4329.00        85.30
## 72           25.40    421902.00       2552.50        86.20
## 73           25.50    439542.00       4691.00        86.20
## 74           25.80    460497.00       5228.00        87.20
## 75           26.00    461709.00       4959.50        54.20
## 76           25.20    476422.00       4339.00        87.00
## 77           25.10    487820.00       4627.90        86.91
## 78           25.70    503198.00       2838.40        85.35
## 79           26.50    507545.00       3548.00        84.00
## 80           23.26    222482.00       4205.20        76.49
## 81           22.19    222021.00       4553.00        75.11
## 82           26.91    313050.82        327.33        82.71
## 83           25.61    311671.23       4757.50        87.73
## 84           26.26    295664.47       4072.70        85.22
## 85           26.00    146133.00       2738.40        86.37
## 86           26.10    146177.00       1991.30        84.90
## 87           26.17    152204.00       3099.90        85.02
## 88           25.94    150354.00       2259.50        84.26
## 89           26.26    137953.00       1510.40        83.82
## 90           26.73    126280.00       2233.00        84.26
## 91           26.08    155683.00       2045.30        84.59
## 92           25.98    141640.00       2478.20        84.60
## 93           29.05    132507.00       2441.70        70.79
## 94           28.20    129025.00       3123.80        71.73
## 95           29.64    132887.00       3822.80        72.92
## 96           29.85    145239.00       2540.10        83.70
## 97           26.58    134418.00       1996.30        83.93
## 98           27.70    136177.00        537.60        79.60
## 99           27.10    147167.00       3216.30        85.30
## 100          27.40    147796.00       3026.20        80.20
## 101          27.70    149423.00       3390.00        76.20
## 102          27.70    156088.00       3390.00        76.20
## 103          27.00    145242.00       2405.00        74.50
## 104          27.30    144015.00       2636.00        76.10
## 105          26.00    118518.00       2628.00        76.00
## 106          27.20    106037.00       2343.00        78.10
## 107          27.20    107546.00       2048.30        80.50
## 108          27.00     72151.00       2105.60        83.72
## 109          26.70     70016.00       2982.90        84.76
## 110          25.00     71448.08       1837.10        71.22
## 111          26.91     63142.04       1608.30        83.77
## 112          25.93     64733.13       2584.90        81.80
## 113          26.29    199431.00       1954.00        83.81
## 114          25.51    184029.00       1824.00        81.25
## 115          26.22    193666.00       2290.10        83.96
## 116          26.00    215975.00       2309.10        83.60
## 117          26.50    190608.00       1030.10        80.64
## 118          26.78    178766.00       2383.80        83.47
## 119          26.34    178307.00       2429.30        83.25
## 120          27.76    171395.00        840.30        84.85
## 121          28.12    164826.00       2515.20        72.40
## 122          28.82    165729.00       2044.50        70.77
## 123          29.39    159463.00       2508.10        71.28
## 124          28.95    156803.00       2561.00        82.74
## 125          26.80    154941.00       1015.70        84.80
## 126          26.77    140613.00        424.70        85.00
## 127          26.60    149888.00       2394.00        86.00
## 128          26.50    143034.00       2230.00        83.70
## 129          27.10    155802.00       2299.00        83.80
## 130          27.10    153897.00       3207.00        84.60
## 131          26.90    157441.00       2295.00        82.50
## 132          26.70    149369.00       1874.00        81.40
## 133          26.80    153243.00       2093.00        83.42
## 134          27.20    145990.00       1781.00        82.80
## 135          27.00    122214.00       1694.90        82.10
## 136          26.84     96588.00       1502.40        83.84
## 137          26.62     97690.00       2193.20        83.69
## 138          26.62     86202.68       2182.30        82.23
## 139          26.94     69536.06       1773.40        81.44
## 140          25.85     84772.93       2303.80        78.24
## 141          26.38    439895.00       2815.00        82.78
## 142          26.53    422109.00       1800.00        79.89
## 143          26.54    492448.00       2800.00        82.71
## 144          26.34    495958.00       2614.00        82.45
## 145          26.75    469670.00       1558.30        78.47
## 146          26.19    621829.00       2539.30        82.58
## 147          25.67    530692.00       2704.70        81.01
## 148          25.32    555427.00       2632.50        83.26
## 149          28.83    511928.00       2837.50        72.06
## 150          28.23    561724.00       2368.20        70.36
## 151          29.64    570010.00       2674.00        69.59
## 152          28.70    625013.00       2182.60        80.96
## 153          27.10    626849.00       1356.90        82.50
## 154          27.10    646927.00       1442.00        80.00
## 155          27.00    691467.00       2364.70        83.50
## 156          26.90    718797.00       2685.70        84.80
## 157          27.40    746465.00       2389.00        82.30
## 158          27.08    769478.00       3396.00        85.25
## 159          27.30    784820.00       2593.00        84.80
## 160          27.40    769725.00       3083.00        83.00
## 161          27.30    800036.00       3409.00        84.00
## 162          26.00    810900.00       1668.30        81.00
## 163          27.70    872737.00       1947.20        79.50
## 164          27.31    615184.00       3477.90        82.22
## 165          26.75    621903.00       2489.50        81.08
## 166          27.00    581574.61       2252.40        77.66
## 167          27.60    539316.52       1655.50        85.13
## 168          26.14    551320.76       2300.20        81.10
## 169          25.95    109807.00       4150.00        85.50
## 170          25.68    104747.00       2043.00        85.32
## 171          26.12    115914.00       4478.00        85.49
## 172          25.66    121929.00       3931.00        85.96
## 173          25.84    113915.00       1167.00        84.00
## 174          26.40    111158.00       4114.00        85.34
## 175          25.81    114788.00       3084.00        84.72
## 176          24.22    108751.00       3254.00        84.73
## 177          26.80    105212.00       3010.00        70.15
## 178          28.50    109519.00       3076.00        67.98
## 179          29.50    110550.00       3030.00        70.30
## 180          29.70    110929.00       3277.00        84.28
## 181          25.70    116818.00       3375.20        84.70
## 182          26.10    100991.00       2313.80        83.30
## 183          26.40    123853.00       3150.00        84.20
## 184          26.30    127506.00       3396.00        84.20
## 185          26.50    132975.00       3850.00        84.10
## 186          26.80    133629.00       3822.00        84.00
## 187          26.35    127934.00       2465.70        82.52
## 188          26.90    144448.00       2545.00        82.00
## 189          26.70    147680.00       3980.90        83.93
## 190          26.90    147572.00       3323.00        83.70
## 191          27.00    128833.00       2668.90        83.20
## 192          26.77     83449.00       3350.10        83.38
## 193          26.52     82429.00       3949.80        84.20
## 194          26.64     65891.16       3649.90        83.79
## 195          26.56     64406.86       1786.20        83.26
## 196          25.84     64137.28       4144.00        80.18
## 197          26.41    433078.00       2306.70        84.82
## 198          25.73    425940.00       2034.20        77.51
## 199          26.43    514363.00       3039.40        82.81
## 200          26.27    515192.00       1934.90        82.61
## 201          26.68    454087.00       1253.30        78.46
## 202          26.95    521575.00       2584.90        84.07
## 203          26.24    476899.00       2364.70        83.46
## 204          28.20    496879.00       1488.50        82.86
## 205          26.71    501119.00       2013.10        77.83
## 206          27.50    475461.00       2143.50        75.84
## 207          29.67    472635.00       1682.20        68.71
## 208          29.66    495519.00       2042.90        81.47
## 209          26.59    496538.00       1612.80        79.60
## 210          26.18    494102.00        560.30        74.60
## 211          27.60    524955.00       1941.40        75.90
## 212          26.40    506547.00       1940.10        79.00
## 213          26.70    570417.00       1789.00        79.10
## 214          26.70    590608.00       2710.00        82.30
## 215          26.80    606973.00       1568.00        77.80
## 216          26.80    641876.00       1685.00        79.20
## 217          26.70    638090.00       2456.70        81.00
## 218          25.80    648731.00       1682.50        79.90
## 219          27.10    707266.00       1628.10        78.90
## 220          26.45    390799.00       2317.60        79.40
## 221          26.36    396559.00       1825.10        77.04
## 222          25.50    511940.93       1385.80        76.05
## 223          27.23    464103.42       1706.40        78.03
## 224          24.58    545149.05       2211.30        75.80
padi2$Produksi <- padi$Produksi / 1000000
padi2
##             Provinsi Tahun  Produksi Luas.Panen Curah.hujan Kelembapan
## 1               Aceh  1993 1.3295360  323589.00     1627.00      82.00
## 2               Aceh  1994 1.2996990  329041.00     1521.00      82.12
## 3               Aceh  1995 1.3829050  339253.00     1476.00      82.72
## 4               Aceh  1996 1.4191280  348223.00     1557.00      83.00
## 5               Aceh  1997 1.3680740  337561.00     1339.00      82.46
## 6               Aceh  1998 1.4045800  365892.00     1465.00      82.60
## 7               Aceh  1999 1.4787120  359817.00     1778.00      82.79
## 8               Aceh  2000 1.4869090  336765.00     1974.70      90.60
## 9               Aceh  2001 1.5474990  295212.00     1688.70      69.48
## 10              Aceh  2002 1.3141650  315131.00     1296.80      68.75
## 11              Aceh  2003 1.2466140  367636.00     1507.20      70.66
## 12              Aceh  2004 1.3507480  370966.00     1097.00      80.84
## 13              Aceh  2005 1.4116500  337893.00      710.50      79.50
## 14              Aceh  2006 1.5520780  320789.00      506.50      80.80
## 15              Aceh  2007 1.5568580  360717.00     1414.00      81.50
## 16              Aceh  2008 1.4022870  329109.00     1270.40      78.50
## 17              Aceh  2009 1.5333690  359375.00     1577.00      78.70
## 18              Aceh  2010 1.7887380  352281.00     1986.00      81.40
## 19              Aceh  2011 1.7729620  380686.00     1268.00      79.40
## 20              Aceh  2012 1.5823930  387803.00     1098.00      79.60
## 21              Aceh  2013 2.3310460  419183.00     1623.60      80.70
## 22              Aceh  2014 1.8200620  376137.00     2264.40      78.30
## 23              Aceh  2015 1.9569400  461060.00     1575.00      80.00
## 24              Aceh  2016 2.1807540  293067.00     1096.00      83.32
## 25              Aceh  2017 2.4789220  294483.00     1905.90      85.57
## 26              Aceh  2018 1.7519969  329515.78     1427.80      83.98
## 27              Aceh  2019 1.7144376  310012.46     1931.40      83.90
## 28              Aceh  2020 1.8615671  317869.41     1619.20      80.82
## 29    Sumatera Utara  1993 2.9181520  754569.00     2549.40      83.80
## 30    Sumatera Utara  1994 3.0799600  792534.00     2166.50      83.79
## 31    Sumatera Utara  1995 3.1345330  795183.00     2917.10      81.68
## 32    Sumatera Utara  1996 3.1367600  790051.00     2326.50      81.31
## 33    Sumatera Utara  1997 3.2122080  797545.00     1865.00      81.81
## 34    Sumatera Utara  1998 3.3210490  823749.00     2496.90      83.53
## 35    Sumatera Utara  1999 3.4514300  838626.00     3087.30      84.56
## 36    Sumatera Utara  2000 3.5142530  847610.00     1289.50      82.94
## 37    Sumatera Utara  2001 3.2915150  801948.00     3595.30      72.78
## 38    Sumatera Utara  2002 3.1533050  765161.00     1944.90      72.31
## 39    Sumatera Utara  2003 3.4030750  825188.00     3140.20      72.08
## 40    Sumatera Utara  2004 3.4187820  826091.00     2406.90      80.79
## 41    Sumatera Utara  2005 3.4473940  822073.00      776.70      83.80
## 42    Sumatera Utara  2006 3.0076360  705023.00      222.50      81.00
## 43    Sumatera Utara  2007 3.2658340  750232.00     2513.00      82.00
## 44    Sumatera Utara  2008 3.3407940  748540.00     2442.00      81.40
## 45    Sumatera Utara  2009 3.5278990  768407.00     2184.00      86.00
## 46    Sumatera Utara  2010 3.5823020  754674.00     1903.30      78.55
## 47    Sumatera Utara  2011 3.6074030  757547.00     2042.00      79.00
## 48    Sumatera Utara  2012 3.7155140  765099.00     3175.00      76.00
## 49    Sumatera Utara  2013 3.7272490  742968.00     2627.00      78.67
## 50    Sumatera Utara  2014 3.6310390  717318.00     2148.00      79.00
## 51    Sumatera Utara  2015 4.0448290  781769.00      975.90      86.90
## 52    Sumatera Utara  2016 4.3870359  423029.00     2384.00      82.00
## 53    Sumatera Utara  2017 4.6697775  415675.00     3190.00      84.00
## 54    Sumatera Utara  2018 2.1082847  408176.45     2431.00      80.00
## 55    Sumatera Utara  2019 2.0789016  413141.24     1401.60      86.53
## 56    Sumatera Utara  2020 2.0762800  388591.22     1648.30      83.76
## 57    Sumatera Barat  1993 1.8064240  394412.00     5110.00      89.77
## 58    Sumatera Barat  1994 1.7475430  382740.00     4869.50      75.22
## 59    Sumatera Barat  1995 1.8291920  400627.00     5022.00      87.68
## 60    Sumatera Barat  1996 1.9711800  430343.00     3866.00      87.29
## 61    Sumatera Barat  1997 1.7877190  395728.00     2945.10      87.97
## 62    Sumatera Barat  1998 1.8076220  412810.00     5522.00      87.39
## 63    Sumatera Barat  1999 1.8976780  432254.00     4327.50      80.89
## 64    Sumatera Barat  2000 1.7590590  396919.00     3040.60      86.01
## 65    Sumatera Barat  2001 1.6689550  376710.00     2811.00      71.08
## 66    Sumatera Barat  2002 1.8758340  424253.00     4241.20      71.28
## 67    Sumatera Barat  2003 1.8237390  411860.00     4927.20      71.91
## 68    Sumatera Barat  2004 1.8751880  422582.00     4584.20      78.50
## 69    Sumatera Barat  2005 1.9073900  426950.00     1533.60      78.00
## 70    Sumatera Barat  2006 1.8894890  417846.00      776.00      79.00
## 71    Sumatera Barat  2007 1.9381200  423655.00     4329.00      85.30
## 72    Sumatera Barat  2008 1.9656340  421902.00     2552.50      86.20
## 73    Sumatera Barat  2009 2.1057900  439542.00     4691.00      86.20
## 74    Sumatera Barat  2010 2.2112480  460497.00     5228.00      87.20
## 75    Sumatera Barat  2011 2.2796020  461709.00     4959.50      54.20
## 76    Sumatera Barat  2012 2.3683900  476422.00     4339.00      87.00
## 77    Sumatera Barat  2013 2.4303840  487820.00     4627.90      86.91
## 78    Sumatera Barat  2014 2.5190200  503198.00     2838.40      85.35
## 79    Sumatera Barat  2015 2.5506090  507545.00     3548.00      84.00
## 80    Sumatera Barat  2016 2.4879290  222482.00     4205.20      76.49
## 81    Sumatera Barat  2017 2.8104250  222021.00     4553.00      75.11
## 82    Sumatera Barat  2018 1.4830765  313050.82      327.33      82.71
## 83    Sumatera Barat  2019 1.4829960  311671.23     4757.50      87.73
## 84    Sumatera Barat  2020 1.4508397  295664.47     4072.70      85.22
## 85              Riau  1993 0.4362970  146133.00     2738.40      86.37
## 86              Riau  1994 0.4453610  146177.00     1991.30      84.90
## 87              Riau  1995 0.4587560  152204.00     3099.90      85.02
## 88              Riau  1996 0.4619050  150354.00     2259.50      84.26
## 89              Riau  1997 0.4161350  137953.00     1510.40      83.82
## 90              Riau  1998 0.3701240  126280.00     2233.00      84.26
## 91              Riau  1999 0.4616300  155683.00     2045.30      84.59
## 92              Riau  2000 0.4313510  141640.00     2478.20      84.60
## 93              Riau  2001 0.4133910  132507.00     2441.70      70.79
## 94              Riau  2002 0.3966440  129025.00     3123.80      71.73
## 95              Riau  2003 0.4142370  132887.00     3822.80      72.92
## 96              Riau  2004 0.4541860  145239.00     2540.10      83.70
## 97              Riau  2005 0.4240950  134418.00     1996.30      83.93
## 98              Riau  2006 0.0429380  136177.00      537.60      79.60
## 99              Riau  2007 0.4900870  147167.00     3216.30      85.30
## 100             Riau  2008 0.4942600  147796.00     3026.20      80.20
## 101             Riau  2009 0.5314290  149423.00     3390.00      76.20
## 102             Riau  2010 0.5748640  156088.00     3390.00      76.20
## 103             Riau  2011 0.5357880  145242.00     2405.00      74.50
## 104             Riau  2012 0.5121520  144015.00     2636.00      76.10
## 105             Riau  2013 0.4341440  118518.00     2628.00      76.00
## 106             Riau  2014 0.3854750  106037.00     2343.00      78.10
## 107             Riau  2015 0.3939170  107546.00     2048.30      80.50
## 108             Riau  2016 0.3258260   72151.00     2105.60      83.72
## 109             Riau  2017 0.3374210   70016.00     2982.90      84.76
## 110             Riau  2018 0.2663755   71448.08     1837.10      71.22
## 111             Riau  2019 0.2308740   63142.04     1608.30      83.77
## 112             Riau  2020 0.2693441   64733.13     2584.90      81.80
## 113            Jambi  1993 0.6075290  199431.00     1954.00      83.81
## 114            Jambi  1994 0.5647220  184029.00     1824.00      81.25
## 115            Jambi  1995 0.5935020  193666.00     2290.10      83.96
## 116            Jambi  1996 0.6576500  215975.00     2309.10      83.60
## 117            Jambi  1997 0.5722690  190608.00     1030.10      80.64
## 118            Jambi  1998 0.5502770  178766.00     2383.80      83.47
## 119            Jambi  1999 0.5536410  178307.00     2429.30      83.25
## 120            Jambi  2000 0.5367790  171395.00      840.30      84.85
## 121            Jambi  2001 0.5565640  164826.00     2515.20      72.40
## 122            Jambi  2002 0.5610070  165729.00     2044.50      70.77
## 123            Jambi  2003 0.5783460  159463.00     2508.10      71.28
## 124            Jambi  2004 0.5794040  156803.00     2561.00      82.74
## 125            Jambi  2005 0.5796350  154941.00     1015.70      84.80
## 126            Jambi  2006 0.5445970  140613.00      424.70      85.00
## 127            Jambi  2007 0.0586630  149888.00     2394.00      86.00
## 128            Jambi  2008 0.5817040  143034.00     2230.00      83.70
## 129            Jambi  2009 0.6449470  155802.00     2299.00      83.80
## 130            Jambi  2010 0.6288280  153897.00     3207.00      84.60
## 131            Jambi  2011 0.6466410  157441.00     2295.00      82.50
## 132            Jambi  2012 0.6251640  149369.00     1874.00      81.40
## 133            Jambi  2013 0.6645350  153243.00     2093.00      83.42
## 134            Jambi  2014 0.6647200  145990.00     1781.00      82.80
## 135            Jambi  2015 0.5414860  122214.00     1694.90      82.10
## 136            Jambi  2016 0.6420950   96588.00     1502.40      83.84
## 137            Jambi  2017 0.6781270   97690.00     2193.20      83.69
## 138            Jambi  2018 0.3830457   86202.68     2182.30      82.23
## 139            Jambi  2019 0.3099327   69536.06     1773.40      81.44
## 140            Jambi  2020 0.3743763   84772.93     2303.80      78.24
## 141 Sumatera Selatan  1993 1.4095590  439895.00     2815.00      82.78
## 142 Sumatera Selatan  1994 1.3476110  422109.00     1800.00      79.89
## 143 Sumatera Selatan  1995 1.5579440  492448.00     2800.00      82.71
## 144 Sumatera Selatan  1996 1.6665910  495958.00     2614.00      82.45
## 145 Sumatera Selatan  1997 1.5773980  469670.00     1558.30      78.47
## 146 Sumatera Selatan  1998 1.9315050  621829.00     2539.30      82.58
## 147 Sumatera Selatan  1999 1.7899610  530692.00     2704.70      81.01
## 148 Sumatera Selatan  2000 1.8636430  555427.00     2632.50      83.26
## 149 Sumatera Selatan  2001 1.7234330  511928.00     2837.50      72.06
## 150 Sumatera Selatan  2002 1.8998490  561724.00     2368.20      70.36
## 151 Sumatera Selatan  2003 1.9773450  570010.00     2674.00      69.59
## 152 Sumatera Selatan  2004 2.2607940  625013.00     2182.60      80.96
## 153 Sumatera Selatan  2005 2.3201100  626849.00     1356.90      82.50
## 154 Sumatera Selatan  2006 2.4562510  646927.00     1442.00      80.00
## 155 Sumatera Selatan  2007 2.7530440  691467.00     2364.70      83.50
## 156 Sumatera Selatan  2008 2.9712860  718797.00     2685.70      84.80
## 157 Sumatera Selatan  2009 3.1252360  746465.00     2389.00      82.30
## 158 Sumatera Selatan  2010 3.2724510  769478.00     3396.00      85.25
## 159 Sumatera Selatan  2011 3.3846700  784820.00     2593.00      84.80
## 160 Sumatera Selatan  2012 3.2952470  769725.00     3083.00      83.00
## 161 Sumatera Selatan  2013 3.6767230  800036.00     3409.00      84.00
## 162 Sumatera Selatan  2014 3.6704350  810900.00     1668.30      81.00
## 163 Sumatera Selatan  2015 4.2479220  872737.00     1947.20      79.50
## 164 Sumatera Selatan  2016 4.8810890  615184.00     3477.90      82.22
## 165 Sumatera Selatan  2017 4.8074300  621903.00     2489.50      81.08
## 166 Sumatera Selatan  2018 2.9941918  581574.61     2252.40      77.66
## 167 Sumatera Selatan  2019 2.6033962  539316.52     1655.50      85.13
## 168 Sumatera Selatan  2020 2.6968775  551320.76     2300.20      81.10
## 169         Bengkulu  1993 0.3567090  109807.00     4150.00      85.50
## 170         Bengkulu  1994 0.3342320  104747.00     2043.00      85.32
## 171         Bengkulu  1995 0.3773370  115914.00     4478.00      85.49
## 172         Bengkulu  1996 0.3969770  121929.00     3931.00      85.96
## 173         Bengkulu  1997 0.3821230  113915.00     1167.00      84.00
## 174         Bengkulu  1998 0.3755330  111158.00     4114.00      85.34
## 175         Bengkulu  1999 0.3815770  114788.00     3084.00      84.72
## 176         Bengkulu  2000 0.3629790  108751.00     3254.00      84.73
## 177         Bengkulu  2001 0.3769730  105212.00     3010.00      70.15
## 178         Bengkulu  2002 0.3798180  109519.00     3076.00      67.98
## 179         Bengkulu  2003 0.4133750  110550.00     3030.00      70.30
## 180         Bengkulu  2004 0.4147410  110929.00     3277.00      84.28
## 181         Bengkulu  2005 0.4412760  116818.00     3375.20      84.70
## 182         Bengkulu  2006 0.3783770  100991.00     2313.80      83.30
## 183         Bengkulu  2007 0.4704690  123853.00     3150.00      84.20
## 184         Bengkulu  2008 0.4849000  127506.00     3396.00      84.20
## 185         Bengkulu  2009 0.5101600  132975.00     3850.00      84.10
## 186         Bengkulu  2010 0.5168690  133629.00     3822.00      84.00
## 187         Bengkulu  2011 0.5025520  127934.00     2465.70      82.52
## 188         Bengkulu  2012 0.5819100  144448.00     2545.00      82.00
## 189         Bengkulu  2013 0.6228320  147680.00     3980.90      83.93
## 190         Bengkulu  2014 0.5931940  147572.00     3323.00      83.70
## 191         Bengkulu  2015 0.5786540  128833.00     2668.90      83.20
## 192         Bengkulu  2016 0.6292240   83449.00     3350.10      83.38
## 193         Bengkulu  2017 0.7140170   82429.00     3949.80      84.20
## 194         Bengkulu  2018 0.2888105   65891.16     3649.90      83.79
## 195         Bengkulu  2019 0.2964721   64406.86     1786.20      83.26
## 196         Bengkulu  2020 0.2969252   64137.28     4144.00      80.18
## 197          Lampung  1993 1.6469000  433078.00     2306.70      84.82
## 198          Lampung  1994 1.6157510  425940.00     2034.20      77.51
## 199          Lampung  1995 1.9437090  514363.00     3039.40      82.81
## 200          Lampung  1996 1.9717400  515192.00     1934.90      82.61
## 201          Lampung  1997 1.7536560  454087.00     1253.30      78.46
## 202          Lampung  1998 1.9757000  521575.00     2584.90      84.07
## 203          Lampung  1999 1.8014220  476899.00     2364.70      83.46
## 204          Lampung  2000 1.9464060  496879.00     1488.50      82.86
## 205          Lampung  2001 1.9927260  501119.00     2013.10      77.83
## 206          Lampung  2002 1.9511090  475461.00     2143.50      75.84
## 207          Lampung  2003 1.9662930  472635.00     1682.20      68.71
## 208          Lampung  2004 2.0919960  495519.00     2042.90      81.47
## 209          Lampung  2005 2.1241440  496538.00     1612.80      79.60
## 210          Lampung  2006 2.1299140  494102.00      560.30      74.60
## 211          Lampung  2007 2.3084040  524955.00     1941.40      75.90
## 212          Lampung  2008 2.3410750  506547.00     1940.10      79.00
## 213          Lampung  2009 2.6738440  570417.00     1789.00      79.10
## 214          Lampung  2010 2.8076760  590608.00     2710.00      82.30
## 215          Lampung  2011 2.9407950  606973.00     1568.00      77.80
## 216          Lampung  2012 3.1014550  641876.00     1685.00      79.20
## 217          Lampung  2013 3.2070020  638090.00     2456.70      81.00
## 218          Lampung  2014 3.3200640  648731.00     1682.50      79.90
## 219          Lampung  2015 3.6418950  707266.00     1628.10      78.90
## 220          Lampung  2016 3.8319230  390799.00     2317.60      79.40
## 221          Lampung  2017 4.0906540  396559.00     1825.10      77.04
## 222          Lampung  2018 2.4886419  511940.93     1385.80      76.05
## 223          Lampung  2019 2.1640893  464103.42     1706.40      78.03
## 224          Lampung  2020 2.6049133  545149.05     2211.30      75.80
##     Suhu.rata.rata Luas.Panen.1 Curah.hujan.1 Kelembapan.1
## 1            26.06    323589.00       1627.00        82.00
## 2            26.92    329041.00       1521.00        82.12
## 3            26.27    339253.00       1476.00        82.72
## 4            26.08    348223.00       1557.00        83.00
## 5            26.31    337561.00       1339.00        82.46
## 6            26.84    365892.00       1465.00        82.60
## 7            26.14    359817.00       1778.00        82.79
## 8            27.10    336765.00       1974.70        90.60
## 9            28.90    295212.00       1688.70        69.48
## 10           29.20    315131.00       1296.80        68.75
## 11           29.40    367636.00       1507.20        70.66
## 12           29.40    370966.00       1097.00        80.84
## 13           26.80    337893.00        710.50        79.50
## 14           26.73    320789.00        506.50        80.80
## 15           26.38    360717.00       1414.00        81.50
## 16           27.00    329109.00       1270.40        78.50
## 17           26.90    359375.00       1577.00        78.70
## 18           27.10    352281.00       1986.00        81.40
## 19           27.10    380686.00       1268.00        79.40
## 20           26.90    387803.00       1098.00        79.60
## 21           27.00    419183.00       1623.60        80.70
## 22           27.10    376137.00       2264.40        78.30
## 23           27.10    461060.00       1575.00        80.00
## 24           27.12    293067.00       1096.00        83.32
## 25           26.51    294483.00       1905.90        85.57
## 26           26.48    329515.78       1427.80        83.98
## 27           26.65    310012.46       1931.40        83.90
## 28           25.41    317869.41       1619.20        80.82
## 29           26.45    754569.00       2549.40        83.80
## 30           26.40    792534.00       2166.50        83.79
## 31           26.58    795183.00       2917.10        81.68
## 32           26.33    790051.00       2326.50        81.31
## 33           26.40    797545.00       1865.00        81.81
## 34           27.16    823749.00       2496.90        83.53
## 35           26.45    838626.00       3087.30        84.56
## 36           27.70    847610.00       1289.50        82.94
## 37           28.03    801948.00       3595.30        72.78
## 38           28.45    765161.00       1944.90        72.31
## 39           29.59    825188.00       3140.20        72.08
## 40           29.27    826091.00       2406.90        80.79
## 41           27.00    822073.00        776.70        83.80
## 42           27.80    705023.00        222.50        81.00
## 43           27.00    750232.00       2513.00        82.00
## 44           26.90    748540.00       2442.00        81.40
## 45           27.10    768407.00       2184.00        86.00
## 46           27.18    754674.00       1903.30        78.55
## 47           27.20    757547.00       2042.00        79.00
## 48           27.30    765099.00       3175.00        76.00
## 49           28.80    742968.00       2627.00        78.67
## 50           27.90    717318.00       2148.00        79.00
## 51           27.40    781769.00        975.90        86.90
## 52           27.65    423029.00       2384.00        82.00
## 53           27.50    415675.00       3190.00        84.00
## 54           26.41    408176.45       2431.00        80.00
## 55           27.03    413141.24       1401.60        86.53
## 56           25.79    388591.22       1648.30        83.76
## 57           24.70    394412.00       5110.00        89.77
## 58           24.49    382740.00       4869.50        75.22
## 59           24.82    400627.00       5022.00        87.68
## 60           24.52    430343.00       3866.00        87.29
## 61           24.69    395728.00       2945.10        87.97
## 62           25.04    412810.00       5522.00        87.39
## 63           22.48    432254.00       4327.50        80.89
## 64           25.86    396919.00       3040.60        86.01
## 65           28.17    376710.00       2811.00        71.08
## 66           28.19    424253.00       4241.20        71.28
## 67           29.17    411860.00       4927.20        71.91
## 68           29.02    422582.00       4584.20        78.50
## 69           25.90    426950.00       1533.60        78.00
## 70           26.05    417846.00        776.00        79.00
## 71           25.70    423655.00       4329.00        85.30
## 72           25.40    421902.00       2552.50        86.20
## 73           25.50    439542.00       4691.00        86.20
## 74           25.80    460497.00       5228.00        87.20
## 75           26.00    461709.00       4959.50        54.20
## 76           25.20    476422.00       4339.00        87.00
## 77           25.10    487820.00       4627.90        86.91
## 78           25.70    503198.00       2838.40        85.35
## 79           26.50    507545.00       3548.00        84.00
## 80           23.26    222482.00       4205.20        76.49
## 81           22.19    222021.00       4553.00        75.11
## 82           26.91    313050.82        327.33        82.71
## 83           25.61    311671.23       4757.50        87.73
## 84           26.26    295664.47       4072.70        85.22
## 85           26.00    146133.00       2738.40        86.37
## 86           26.10    146177.00       1991.30        84.90
## 87           26.17    152204.00       3099.90        85.02
## 88           25.94    150354.00       2259.50        84.26
## 89           26.26    137953.00       1510.40        83.82
## 90           26.73    126280.00       2233.00        84.26
## 91           26.08    155683.00       2045.30        84.59
## 92           25.98    141640.00       2478.20        84.60
## 93           29.05    132507.00       2441.70        70.79
## 94           28.20    129025.00       3123.80        71.73
## 95           29.64    132887.00       3822.80        72.92
## 96           29.85    145239.00       2540.10        83.70
## 97           26.58    134418.00       1996.30        83.93
## 98           27.70    136177.00        537.60        79.60
## 99           27.10    147167.00       3216.30        85.30
## 100          27.40    147796.00       3026.20        80.20
## 101          27.70    149423.00       3390.00        76.20
## 102          27.70    156088.00       3390.00        76.20
## 103          27.00    145242.00       2405.00        74.50
## 104          27.30    144015.00       2636.00        76.10
## 105          26.00    118518.00       2628.00        76.00
## 106          27.20    106037.00       2343.00        78.10
## 107          27.20    107546.00       2048.30        80.50
## 108          27.00     72151.00       2105.60        83.72
## 109          26.70     70016.00       2982.90        84.76
## 110          25.00     71448.08       1837.10        71.22
## 111          26.91     63142.04       1608.30        83.77
## 112          25.93     64733.13       2584.90        81.80
## 113          26.29    199431.00       1954.00        83.81
## 114          25.51    184029.00       1824.00        81.25
## 115          26.22    193666.00       2290.10        83.96
## 116          26.00    215975.00       2309.10        83.60
## 117          26.50    190608.00       1030.10        80.64
## 118          26.78    178766.00       2383.80        83.47
## 119          26.34    178307.00       2429.30        83.25
## 120          27.76    171395.00        840.30        84.85
## 121          28.12    164826.00       2515.20        72.40
## 122          28.82    165729.00       2044.50        70.77
## 123          29.39    159463.00       2508.10        71.28
## 124          28.95    156803.00       2561.00        82.74
## 125          26.80    154941.00       1015.70        84.80
## 126          26.77    140613.00        424.70        85.00
## 127          26.60    149888.00       2394.00        86.00
## 128          26.50    143034.00       2230.00        83.70
## 129          27.10    155802.00       2299.00        83.80
## 130          27.10    153897.00       3207.00        84.60
## 131          26.90    157441.00       2295.00        82.50
## 132          26.70    149369.00       1874.00        81.40
## 133          26.80    153243.00       2093.00        83.42
## 134          27.20    145990.00       1781.00        82.80
## 135          27.00    122214.00       1694.90        82.10
## 136          26.84     96588.00       1502.40        83.84
## 137          26.62     97690.00       2193.20        83.69
## 138          26.62     86202.68       2182.30        82.23
## 139          26.94     69536.06       1773.40        81.44
## 140          25.85     84772.93       2303.80        78.24
## 141          26.38    439895.00       2815.00        82.78
## 142          26.53    422109.00       1800.00        79.89
## 143          26.54    492448.00       2800.00        82.71
## 144          26.34    495958.00       2614.00        82.45
## 145          26.75    469670.00       1558.30        78.47
## 146          26.19    621829.00       2539.30        82.58
## 147          25.67    530692.00       2704.70        81.01
## 148          25.32    555427.00       2632.50        83.26
## 149          28.83    511928.00       2837.50        72.06
## 150          28.23    561724.00       2368.20        70.36
## 151          29.64    570010.00       2674.00        69.59
## 152          28.70    625013.00       2182.60        80.96
## 153          27.10    626849.00       1356.90        82.50
## 154          27.10    646927.00       1442.00        80.00
## 155          27.00    691467.00       2364.70        83.50
## 156          26.90    718797.00       2685.70        84.80
## 157          27.40    746465.00       2389.00        82.30
## 158          27.08    769478.00       3396.00        85.25
## 159          27.30    784820.00       2593.00        84.80
## 160          27.40    769725.00       3083.00        83.00
## 161          27.30    800036.00       3409.00        84.00
## 162          26.00    810900.00       1668.30        81.00
## 163          27.70    872737.00       1947.20        79.50
## 164          27.31    615184.00       3477.90        82.22
## 165          26.75    621903.00       2489.50        81.08
## 166          27.00    581574.61       2252.40        77.66
## 167          27.60    539316.52       1655.50        85.13
## 168          26.14    551320.76       2300.20        81.10
## 169          25.95    109807.00       4150.00        85.50
## 170          25.68    104747.00       2043.00        85.32
## 171          26.12    115914.00       4478.00        85.49
## 172          25.66    121929.00       3931.00        85.96
## 173          25.84    113915.00       1167.00        84.00
## 174          26.40    111158.00       4114.00        85.34
## 175          25.81    114788.00       3084.00        84.72
## 176          24.22    108751.00       3254.00        84.73
## 177          26.80    105212.00       3010.00        70.15
## 178          28.50    109519.00       3076.00        67.98
## 179          29.50    110550.00       3030.00        70.30
## 180          29.70    110929.00       3277.00        84.28
## 181          25.70    116818.00       3375.20        84.70
## 182          26.10    100991.00       2313.80        83.30
## 183          26.40    123853.00       3150.00        84.20
## 184          26.30    127506.00       3396.00        84.20
## 185          26.50    132975.00       3850.00        84.10
## 186          26.80    133629.00       3822.00        84.00
## 187          26.35    127934.00       2465.70        82.52
## 188          26.90    144448.00       2545.00        82.00
## 189          26.70    147680.00       3980.90        83.93
## 190          26.90    147572.00       3323.00        83.70
## 191          27.00    128833.00       2668.90        83.20
## 192          26.77     83449.00       3350.10        83.38
## 193          26.52     82429.00       3949.80        84.20
## 194          26.64     65891.16       3649.90        83.79
## 195          26.56     64406.86       1786.20        83.26
## 196          25.84     64137.28       4144.00        80.18
## 197          26.41    433078.00       2306.70        84.82
## 198          25.73    425940.00       2034.20        77.51
## 199          26.43    514363.00       3039.40        82.81
## 200          26.27    515192.00       1934.90        82.61
## 201          26.68    454087.00       1253.30        78.46
## 202          26.95    521575.00       2584.90        84.07
## 203          26.24    476899.00       2364.70        83.46
## 204          28.20    496879.00       1488.50        82.86
## 205          26.71    501119.00       2013.10        77.83
## 206          27.50    475461.00       2143.50        75.84
## 207          29.67    472635.00       1682.20        68.71
## 208          29.66    495519.00       2042.90        81.47
## 209          26.59    496538.00       1612.80        79.60
## 210          26.18    494102.00        560.30        74.60
## 211          27.60    524955.00       1941.40        75.90
## 212          26.40    506547.00       1940.10        79.00
## 213          26.70    570417.00       1789.00        79.10
## 214          26.70    590608.00       2710.00        82.30
## 215          26.80    606973.00       1568.00        77.80
## 216          26.80    641876.00       1685.00        79.20
## 217          26.70    638090.00       2456.70        81.00
## 218          25.80    648731.00       1682.50        79.90
## 219          27.10    707266.00       1628.10        78.90
## 220          26.45    390799.00       2317.60        79.40
## 221          26.36    396559.00       1825.10        77.04
## 222          25.50    511940.93       1385.80        76.05
## 223          27.23    464103.42       1706.40        78.03
## 224          24.58    545149.05       2211.30        75.80
Luas.Panen <- unique(padi2[c("Luas.Panen","Luas.Panen.1")])
Curah.hujan <- unique(padi2[c("Curah.hujan","Curah.hujan.1")])
Kelembapan <- unique(padi2[c("Kelembapan","Kelembapan.1")])
Luas.Panen
##     Luas.Panen Luas.Panen.1
## 1    323589.00    323589.00
## 2    329041.00    329041.00
## 3    339253.00    339253.00
## 4    348223.00    348223.00
## 5    337561.00    337561.00
## 6    365892.00    365892.00
## 7    359817.00    359817.00
## 8    336765.00    336765.00
## 9    295212.00    295212.00
## 10   315131.00    315131.00
## 11   367636.00    367636.00
## 12   370966.00    370966.00
## 13   337893.00    337893.00
## 14   320789.00    320789.00
## 15   360717.00    360717.00
## 16   329109.00    329109.00
## 17   359375.00    359375.00
## 18   352281.00    352281.00
## 19   380686.00    380686.00
## 20   387803.00    387803.00
## 21   419183.00    419183.00
## 22   376137.00    376137.00
## 23   461060.00    461060.00
## 24   293067.00    293067.00
## 25   294483.00    294483.00
## 26   329515.78    329515.78
## 27   310012.46    310012.46
## 28   317869.41    317869.41
## 29   754569.00    754569.00
## 30   792534.00    792534.00
## 31   795183.00    795183.00
## 32   790051.00    790051.00
## 33   797545.00    797545.00
## 34   823749.00    823749.00
## 35   838626.00    838626.00
## 36   847610.00    847610.00
## 37   801948.00    801948.00
## 38   765161.00    765161.00
## 39   825188.00    825188.00
## 40   826091.00    826091.00
## 41   822073.00    822073.00
## 42   705023.00    705023.00
## 43   750232.00    750232.00
## 44   748540.00    748540.00
## 45   768407.00    768407.00
## 46   754674.00    754674.00
## 47   757547.00    757547.00
## 48   765099.00    765099.00
## 49   742968.00    742968.00
## 50   717318.00    717318.00
## 51   781769.00    781769.00
## 52   423029.00    423029.00
## 53   415675.00    415675.00
## 54   408176.45    408176.45
## 55   413141.24    413141.24
## 56   388591.22    388591.22
## 57   394412.00    394412.00
## 58   382740.00    382740.00
## 59   400627.00    400627.00
## 60   430343.00    430343.00
## 61   395728.00    395728.00
## 62   412810.00    412810.00
## 63   432254.00    432254.00
## 64   396919.00    396919.00
## 65   376710.00    376710.00
## 66   424253.00    424253.00
## 67   411860.00    411860.00
## 68   422582.00    422582.00
## 69   426950.00    426950.00
## 70   417846.00    417846.00
## 71   423655.00    423655.00
## 72   421902.00    421902.00
## 73   439542.00    439542.00
## 74   460497.00    460497.00
## 75   461709.00    461709.00
## 76   476422.00    476422.00
## 77   487820.00    487820.00
## 78   503198.00    503198.00
## 79   507545.00    507545.00
## 80   222482.00    222482.00
## 81   222021.00    222021.00
## 82   313050.82    313050.82
## 83   311671.23    311671.23
## 84   295664.47    295664.47
## 85   146133.00    146133.00
## 86   146177.00    146177.00
## 87   152204.00    152204.00
## 88   150354.00    150354.00
## 89   137953.00    137953.00
## 90   126280.00    126280.00
## 91   155683.00    155683.00
## 92   141640.00    141640.00
## 93   132507.00    132507.00
## 94   129025.00    129025.00
## 95   132887.00    132887.00
## 96   145239.00    145239.00
## 97   134418.00    134418.00
## 98   136177.00    136177.00
## 99   147167.00    147167.00
## 100  147796.00    147796.00
## 101  149423.00    149423.00
## 102  156088.00    156088.00
## 103  145242.00    145242.00
## 104  144015.00    144015.00
## 105  118518.00    118518.00
## 106  106037.00    106037.00
## 107  107546.00    107546.00
## 108   72151.00     72151.00
## 109   70016.00     70016.00
## 110   71448.08     71448.08
## 111   63142.04     63142.04
## 112   64733.13     64733.13
## 113  199431.00    199431.00
## 114  184029.00    184029.00
## 115  193666.00    193666.00
## 116  215975.00    215975.00
## 117  190608.00    190608.00
## 118  178766.00    178766.00
## 119  178307.00    178307.00
## 120  171395.00    171395.00
## 121  164826.00    164826.00
## 122  165729.00    165729.00
## 123  159463.00    159463.00
## 124  156803.00    156803.00
## 125  154941.00    154941.00
## 126  140613.00    140613.00
## 127  149888.00    149888.00
## 128  143034.00    143034.00
## 129  155802.00    155802.00
## 130  153897.00    153897.00
## 131  157441.00    157441.00
## 132  149369.00    149369.00
## 133  153243.00    153243.00
## 134  145990.00    145990.00
## 135  122214.00    122214.00
## 136   96588.00     96588.00
## 137   97690.00     97690.00
## 138   86202.68     86202.68
## 139   69536.06     69536.06
## 140   84772.93     84772.93
## 141  439895.00    439895.00
## 142  422109.00    422109.00
## 143  492448.00    492448.00
## 144  495958.00    495958.00
## 145  469670.00    469670.00
## 146  621829.00    621829.00
## 147  530692.00    530692.00
## 148  555427.00    555427.00
## 149  511928.00    511928.00
## 150  561724.00    561724.00
## 151  570010.00    570010.00
## 152  625013.00    625013.00
## 153  626849.00    626849.00
## 154  646927.00    646927.00
## 155  691467.00    691467.00
## 156  718797.00    718797.00
## 157  746465.00    746465.00
## 158  769478.00    769478.00
## 159  784820.00    784820.00
## 160  769725.00    769725.00
## 161  800036.00    800036.00
## 162  810900.00    810900.00
## 163  872737.00    872737.00
## 164  615184.00    615184.00
## 165  621903.00    621903.00
## 166  581574.61    581574.61
## 167  539316.52    539316.52
## 168  551320.76    551320.76
## 169  109807.00    109807.00
## 170  104747.00    104747.00
## 171  115914.00    115914.00
## 172  121929.00    121929.00
## 173  113915.00    113915.00
## 174  111158.00    111158.00
## 175  114788.00    114788.00
## 176  108751.00    108751.00
## 177  105212.00    105212.00
## 178  109519.00    109519.00
## 179  110550.00    110550.00
## 180  110929.00    110929.00
## 181  116818.00    116818.00
## 182  100991.00    100991.00
## 183  123853.00    123853.00
## 184  127506.00    127506.00
## 185  132975.00    132975.00
## 186  133629.00    133629.00
## 187  127934.00    127934.00
## 188  144448.00    144448.00
## 189  147680.00    147680.00
## 190  147572.00    147572.00
## 191  128833.00    128833.00
## 192   83449.00     83449.00
## 193   82429.00     82429.00
## 194   65891.16     65891.16
## 195   64406.86     64406.86
## 196   64137.28     64137.28
## 197  433078.00    433078.00
## 198  425940.00    425940.00
## 199  514363.00    514363.00
## 200  515192.00    515192.00
## 201  454087.00    454087.00
## 202  521575.00    521575.00
## 203  476899.00    476899.00
## 204  496879.00    496879.00
## 205  501119.00    501119.00
## 206  475461.00    475461.00
## 207  472635.00    472635.00
## 208  495519.00    495519.00
## 209  496538.00    496538.00
## 210  494102.00    494102.00
## 211  524955.00    524955.00
## 212  506547.00    506547.00
## 213  570417.00    570417.00
## 214  590608.00    590608.00
## 215  606973.00    606973.00
## 216  641876.00    641876.00
## 217  638090.00    638090.00
## 218  648731.00    648731.00
## 219  707266.00    707266.00
## 220  390799.00    390799.00
## 221  396559.00    396559.00
## 222  511940.93    511940.93
## 223  464103.42    464103.42
## 224  545149.05    545149.05
Curah.hujan
##     Curah.hujan Curah.hujan.1
## 1       1627.00       1627.00
## 2       1521.00       1521.00
## 3       1476.00       1476.00
## 4       1557.00       1557.00
## 5       1339.00       1339.00
## 6       1465.00       1465.00
## 7       1778.00       1778.00
## 8       1974.70       1974.70
## 9       1688.70       1688.70
## 10      1296.80       1296.80
## 11      1507.20       1507.20
## 12      1097.00       1097.00
## 13       710.50        710.50
## 14       506.50        506.50
## 15      1414.00       1414.00
## 16      1270.40       1270.40
## 17      1577.00       1577.00
## 18      1986.00       1986.00
## 19      1268.00       1268.00
## 20      1098.00       1098.00
## 21      1623.60       1623.60
## 22      2264.40       2264.40
## 23      1575.00       1575.00
## 24      1096.00       1096.00
## 25      1905.90       1905.90
## 26      1427.80       1427.80
## 27      1931.40       1931.40
## 28      1619.20       1619.20
## 29      2549.40       2549.40
## 30      2166.50       2166.50
## 31      2917.10       2917.10
## 32      2326.50       2326.50
## 33      1865.00       1865.00
## 34      2496.90       2496.90
## 35      3087.30       3087.30
## 36      1289.50       1289.50
## 37      3595.30       3595.30
## 38      1944.90       1944.90
## 39      3140.20       3140.20
## 40      2406.90       2406.90
## 41       776.70        776.70
## 42       222.50        222.50
## 43      2513.00       2513.00
## 44      2442.00       2442.00
## 45      2184.00       2184.00
## 46      1903.30       1903.30
## 47      2042.00       2042.00
## 48      3175.00       3175.00
## 49      2627.00       2627.00
## 50      2148.00       2148.00
## 51       975.90        975.90
## 52      2384.00       2384.00
## 53      3190.00       3190.00
## 54      2431.00       2431.00
## 55      1401.60       1401.60
## 56      1648.30       1648.30
## 57      5110.00       5110.00
## 58      4869.50       4869.50
## 59      5022.00       5022.00
## 60      3866.00       3866.00
## 61      2945.10       2945.10
## 62      5522.00       5522.00
## 63      4327.50       4327.50
## 64      3040.60       3040.60
## 65      2811.00       2811.00
## 66      4241.20       4241.20
## 67      4927.20       4927.20
## 68      4584.20       4584.20
## 69      1533.60       1533.60
## 70       776.00        776.00
## 71      4329.00       4329.00
## 72      2552.50       2552.50
## 73      4691.00       4691.00
## 74      5228.00       5228.00
## 75      4959.50       4959.50
## 76      4339.00       4339.00
## 77      4627.90       4627.90
## 78      2838.40       2838.40
## 79      3548.00       3548.00
## 80      4205.20       4205.20
## 81      4553.00       4553.00
## 82       327.33        327.33
## 83      4757.50       4757.50
## 84      4072.70       4072.70
## 85      2738.40       2738.40
## 86      1991.30       1991.30
## 87      3099.90       3099.90
## 88      2259.50       2259.50
## 89      1510.40       1510.40
## 90      2233.00       2233.00
## 91      2045.30       2045.30
## 92      2478.20       2478.20
## 93      2441.70       2441.70
## 94      3123.80       3123.80
## 95      3822.80       3822.80
## 96      2540.10       2540.10
## 97      1996.30       1996.30
## 98       537.60        537.60
## 99      3216.30       3216.30
## 100     3026.20       3026.20
## 101     3390.00       3390.00
## 103     2405.00       2405.00
## 104     2636.00       2636.00
## 105     2628.00       2628.00
## 106     2343.00       2343.00
## 107     2048.30       2048.30
## 108     2105.60       2105.60
## 109     2982.90       2982.90
## 110     1837.10       1837.10
## 111     1608.30       1608.30
## 112     2584.90       2584.90
## 113     1954.00       1954.00
## 114     1824.00       1824.00
## 115     2290.10       2290.10
## 116     2309.10       2309.10
## 117     1030.10       1030.10
## 118     2383.80       2383.80
## 119     2429.30       2429.30
## 120      840.30        840.30
## 121     2515.20       2515.20
## 122     2044.50       2044.50
## 123     2508.10       2508.10
## 124     2561.00       2561.00
## 125     1015.70       1015.70
## 126      424.70        424.70
## 127     2394.00       2394.00
## 128     2230.00       2230.00
## 129     2299.00       2299.00
## 130     3207.00       3207.00
## 131     2295.00       2295.00
## 132     1874.00       1874.00
## 133     2093.00       2093.00
## 134     1781.00       1781.00
## 135     1694.90       1694.90
## 136     1502.40       1502.40
## 137     2193.20       2193.20
## 138     2182.30       2182.30
## 139     1773.40       1773.40
## 140     2303.80       2303.80
## 141     2815.00       2815.00
## 142     1800.00       1800.00
## 143     2800.00       2800.00
## 144     2614.00       2614.00
## 145     1558.30       1558.30
## 146     2539.30       2539.30
## 147     2704.70       2704.70
## 148     2632.50       2632.50
## 149     2837.50       2837.50
## 150     2368.20       2368.20
## 151     2674.00       2674.00
## 152     2182.60       2182.60
## 153     1356.90       1356.90
## 154     1442.00       1442.00
## 155     2364.70       2364.70
## 156     2685.70       2685.70
## 157     2389.00       2389.00
## 158     3396.00       3396.00
## 159     2593.00       2593.00
## 160     3083.00       3083.00
## 161     3409.00       3409.00
## 162     1668.30       1668.30
## 163     1947.20       1947.20
## 164     3477.90       3477.90
## 165     2489.50       2489.50
## 166     2252.40       2252.40
## 167     1655.50       1655.50
## 168     2300.20       2300.20
## 169     4150.00       4150.00
## 170     2043.00       2043.00
## 171     4478.00       4478.00
## 172     3931.00       3931.00
## 173     1167.00       1167.00
## 174     4114.00       4114.00
## 175     3084.00       3084.00
## 176     3254.00       3254.00
## 177     3010.00       3010.00
## 178     3076.00       3076.00
## 179     3030.00       3030.00
## 180     3277.00       3277.00
## 181     3375.20       3375.20
## 182     2313.80       2313.80
## 183     3150.00       3150.00
## 185     3850.00       3850.00
## 186     3822.00       3822.00
## 187     2465.70       2465.70
## 188     2545.00       2545.00
## 189     3980.90       3980.90
## 190     3323.00       3323.00
## 191     2668.90       2668.90
## 192     3350.10       3350.10
## 193     3949.80       3949.80
## 194     3649.90       3649.90
## 195     1786.20       1786.20
## 196     4144.00       4144.00
## 197     2306.70       2306.70
## 198     2034.20       2034.20
## 199     3039.40       3039.40
## 200     1934.90       1934.90
## 201     1253.30       1253.30
## 204     1488.50       1488.50
## 205     2013.10       2013.10
## 206     2143.50       2143.50
## 207     1682.20       1682.20
## 208     2042.90       2042.90
## 209     1612.80       1612.80
## 210      560.30        560.30
## 211     1941.40       1941.40
## 212     1940.10       1940.10
## 213     1789.00       1789.00
## 214     2710.00       2710.00
## 215     1568.00       1568.00
## 216     1685.00       1685.00
## 217     2456.70       2456.70
## 218     1682.50       1682.50
## 219     1628.10       1628.10
## 220     2317.60       2317.60
## 221     1825.10       1825.10
## 222     1385.80       1385.80
## 223     1706.40       1706.40
## 224     2211.30       2211.30
Kelembapan
##     Kelembapan Kelembapan.1
## 1        82.00        82.00
## 2        82.12        82.12
## 3        82.72        82.72
## 4        83.00        83.00
## 5        82.46        82.46
## 6        82.60        82.60
## 7        82.79        82.79
## 8        90.60        90.60
## 9        69.48        69.48
## 10       68.75        68.75
## 11       70.66        70.66
## 12       80.84        80.84
## 13       79.50        79.50
## 14       80.80        80.80
## 15       81.50        81.50
## 16       78.50        78.50
## 17       78.70        78.70
## 18       81.40        81.40
## 19       79.40        79.40
## 20       79.60        79.60
## 21       80.70        80.70
## 22       78.30        78.30
## 23       80.00        80.00
## 24       83.32        83.32
## 25       85.57        85.57
## 26       83.98        83.98
## 27       83.90        83.90
## 28       80.82        80.82
## 29       83.80        83.80
## 30       83.79        83.79
## 31       81.68        81.68
## 32       81.31        81.31
## 33       81.81        81.81
## 34       83.53        83.53
## 35       84.56        84.56
## 36       82.94        82.94
## 37       72.78        72.78
## 38       72.31        72.31
## 39       72.08        72.08
## 40       80.79        80.79
## 42       81.00        81.00
## 45       86.00        86.00
## 46       78.55        78.55
## 47       79.00        79.00
## 48       76.00        76.00
## 49       78.67        78.67
## 51       86.90        86.90
## 53       84.00        84.00
## 55       86.53        86.53
## 56       83.76        83.76
## 57       89.77        89.77
## 58       75.22        75.22
## 59       87.68        87.68
## 60       87.29        87.29
## 61       87.97        87.97
## 62       87.39        87.39
## 63       80.89        80.89
## 64       86.01        86.01
## 65       71.08        71.08
## 66       71.28        71.28
## 67       71.91        71.91
## 69       78.00        78.00
## 71       85.30        85.30
## 72       86.20        86.20
## 74       87.20        87.20
## 75       54.20        54.20
## 76       87.00        87.00
## 77       86.91        86.91
## 78       85.35        85.35
## 80       76.49        76.49
## 81       75.11        75.11
## 82       82.71        82.71
## 83       87.73        87.73
## 84       85.22        85.22
## 85       86.37        86.37
## 86       84.90        84.90
## 87       85.02        85.02
## 88       84.26        84.26
## 89       83.82        83.82
## 91       84.59        84.59
## 92       84.60        84.60
## 93       70.79        70.79
## 94       71.73        71.73
## 95       72.92        72.92
## 96       83.70        83.70
## 97       83.93        83.93
## 100      80.20        80.20
## 101      76.20        76.20
## 103      74.50        74.50
## 104      76.10        76.10
## 106      78.10        78.10
## 107      80.50        80.50
## 108      83.72        83.72
## 109      84.76        84.76
## 110      71.22        71.22
## 111      83.77        83.77
## 112      81.80        81.80
## 113      83.81        83.81
## 114      81.25        81.25
## 115      83.96        83.96
## 116      83.60        83.60
## 117      80.64        80.64
## 118      83.47        83.47
## 119      83.25        83.25
## 120      84.85        84.85
## 121      72.40        72.40
## 122      70.77        70.77
## 124      82.74        82.74
## 125      84.80        84.80
## 126      85.00        85.00
## 131      82.50        82.50
## 133      83.42        83.42
## 134      82.80        82.80
## 135      82.10        82.10
## 136      83.84        83.84
## 137      83.69        83.69
## 138      82.23        82.23
## 139      81.44        81.44
## 140      78.24        78.24
## 141      82.78        82.78
## 142      79.89        79.89
## 144      82.45        82.45
## 145      78.47        78.47
## 146      82.58        82.58
## 147      81.01        81.01
## 148      83.26        83.26
## 149      72.06        72.06
## 150      70.36        70.36
## 151      69.59        69.59
## 152      80.96        80.96
## 155      83.50        83.50
## 157      82.30        82.30
## 158      85.25        85.25
## 164      82.22        82.22
## 165      81.08        81.08
## 166      77.66        77.66
## 167      85.13        85.13
## 168      81.10        81.10
## 169      85.50        85.50
## 170      85.32        85.32
## 171      85.49        85.49
## 172      85.96        85.96
## 174      85.34        85.34
## 175      84.72        84.72
## 176      84.73        84.73
## 177      70.15        70.15
## 178      67.98        67.98
## 179      70.30        70.30
## 180      84.28        84.28
## 181      84.70        84.70
## 182      83.30        83.30
## 183      84.20        84.20
## 185      84.10        84.10
## 187      82.52        82.52
## 191      83.20        83.20
## 192      83.38        83.38
## 196      80.18        80.18
## 197      84.82        84.82
## 198      77.51        77.51
## 199      82.81        82.81
## 200      82.61        82.61
## 201      78.46        78.46
## 202      84.07        84.07
## 203      83.46        83.46
## 204      82.86        82.86
## 205      77.83        77.83
## 206      75.84        75.84
## 207      68.71        68.71
## 208      81.47        81.47
## 210      74.60        74.60
## 211      75.90        75.90
## 213      79.10        79.10
## 215      77.80        77.80
## 216      79.20        79.20
## 218      79.90        79.90
## 219      78.90        78.90
## 221      77.04        77.04
## 222      76.05        76.05
## 223      78.03        78.03
## 224      75.80        75.80
set.seed(100)
 field_yang_digunakan = c("Tahun", "Produksi", "Luas.Panen.1", "Curah.hujan.1","Kelembapan.1")
 segmentasi <- kmeans(x=padi2[field_yang_digunakan], centers=5, nstart=25)
 segmentasi
## K-means clustering with 5 clusters of sizes 20, 33, 47, 86, 38
## 
## Cluster means:
##      Tahun  Produksi Luas.Panen.1 Curah.hujan.1 Kelembapan.1
## 1 2009.800 2.7569096     594480.7      2208.910     79.62750
## 2 2006.242 3.3930856     777078.7      2301.785     81.23485
## 3 2004.915 2.0945769     462008.4      2722.470     80.25191
## 4 2006.733 0.5191461     131680.2      2605.994     81.40081
## 5 2006.421 1.7381922     349534.1      2030.243     81.23421
## 
## Clustering vector:
##   [1] 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 3 5 3 5 5 5 5 5 2 2 2 2 2 2 2 2 2
##  [38] 2 2 2 2 2 2 2 2 2 2 2 2 2 2 3 3 3 3 5 5 5 5 3 5 3 3 5 5 3 3 3 3 3 3 3 3 3
##  [75] 3 3 3 3 3 4 4 5 5 5 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4
## [112] 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 3 3 3 3 3 1 1 1
## [149] 3 1 1 1 1 1 2 2 2 2 2 2 2 2 2 1 1 1 1 1 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4
## [186] 4 4 4 4 4 4 4 4 4 4 4 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 1 1 1 1 1 1 2 5 5 3
## [223] 3 1
## 
## Within cluster sum of squares by cluster:
## [1]  29277980038  60238349720  65156344033 113002443927  42743881493
##  (between_SS / total_SS =  97.4 %)
## 
## Available components:
## 
## [1] "cluster"      "centers"      "totss"        "withinss"     "tot.withinss"
## [6] "betweenss"    "size"         "iter"         "ifault"
padi2$cluster <- segmentasi$cluster
str(padi2)
## 'data.frame':    224 obs. of  11 variables:
##  $ Provinsi      : chr  "Aceh" "Aceh" "Aceh" "Aceh" ...
##  $ Tahun         : int  1993 1994 1995 1996 1997 1998 1999 2000 2001 2002 ...
##  $ Produksi      : num  1.33 1.3 1.38 1.42 1.37 ...
##  $ Luas.Panen    : num  323589 329041 339253 348223 337561 ...
##  $ Curah.hujan   : num  1627 1521 1476 1557 1339 ...
##  $ Kelembapan    : num  82 82.1 82.7 83 82.5 ...
##  $ Suhu.rata.rata: num  26.1 26.9 26.3 26.1 26.3 ...
##  $ Luas.Panen.1  : num  323589 329041 339253 348223 337561 ...
##  $ Curah.hujan.1 : num  1627 1521 1476 1557 1339 ...
##  $ Kelembapan.1  : num  82 82.1 82.7 83 82.5 ...
##  $ cluster       : int  5 5 5 5 5 5 5 5 5 5 ...
which(padi2$cluster == 1)
##  [1] 146 147 148 150 151 152 153 154 164 165 166 167 168 213 214 215 216 217 218
## [20] 224
padi[which(padi2$cluster == 1),]
##             Provinsi Tahun Produksi Luas.Panen Curah.hujan Kelembapan
## 146 Sumatera Selatan  1998  1931505   621829.0      2539.3      82.58
## 147 Sumatera Selatan  1999  1789961   530692.0      2704.7      81.01
## 148 Sumatera Selatan  2000  1863643   555427.0      2632.5      83.26
## 150 Sumatera Selatan  2002  1899849   561724.0      2368.2      70.36
## 151 Sumatera Selatan  2003  1977345   570010.0      2674.0      69.59
## 152 Sumatera Selatan  2004  2260794   625013.0      2182.6      80.96
## 153 Sumatera Selatan  2005  2320110   626849.0      1356.9      82.50
## 154 Sumatera Selatan  2006  2456251   646927.0      1442.0      80.00
## 164 Sumatera Selatan  2016  4881089   615184.0      3477.9      82.22
## 165 Sumatera Selatan  2017  4807430   621903.0      2489.5      81.08
## 166 Sumatera Selatan  2018  2994192   581574.6      2252.4      77.66
## 167 Sumatera Selatan  2019  2603396   539316.5      1655.5      85.13
## 168 Sumatera Selatan  2020  2696877   551320.8      2300.2      81.10
## 213          Lampung  2009  2673844   570417.0      1789.0      79.10
## 214          Lampung  2010  2807676   590608.0      2710.0      82.30
## 215          Lampung  2011  2940795   606973.0      1568.0      77.80
## 216          Lampung  2012  3101455   641876.0      1685.0      79.20
## 217          Lampung  2013  3207002   638090.0      2456.7      81.00
## 218          Lampung  2014  3320064   648731.0      1682.5      79.90
## 224          Lampung  2020  2604913   545149.1      2211.3      75.80
##     Suhu.rata.rata
## 146          26.19
## 147          25.67
## 148          25.32
## 150          28.23
## 151          29.64
## 152          28.70
## 153          27.10
## 154          27.10
## 164          27.31
## 165          26.75
## 166          27.00
## 167          27.60
## 168          26.14
## 213          26.70
## 214          26.70
## 215          26.80
## 216          26.80
## 217          26.70
## 218          25.80
## 224          24.58
padi[which(padi2$cluster == 2),]
##             Provinsi Tahun Produksi Luas.Panen Curah.hujan Kelembapan
## 29    Sumatera Utara  1993  2918152     754569      2549.4      83.80
## 30    Sumatera Utara  1994  3079960     792534      2166.5      83.79
## 31    Sumatera Utara  1995  3134533     795183      2917.1      81.68
## 32    Sumatera Utara  1996  3136760     790051      2326.5      81.31
## 33    Sumatera Utara  1997  3212208     797545      1865.0      81.81
## 34    Sumatera Utara  1998  3321049     823749      2496.9      83.53
## 35    Sumatera Utara  1999  3451430     838626      3087.3      84.56
## 36    Sumatera Utara  2000  3514253     847610      1289.5      82.94
## 37    Sumatera Utara  2001  3291515     801948      3595.3      72.78
## 38    Sumatera Utara  2002  3153305     765161      1944.9      72.31
## 39    Sumatera Utara  2003  3403075     825188      3140.2      72.08
## 40    Sumatera Utara  2004  3418782     826091      2406.9      80.79
## 41    Sumatera Utara  2005  3447394     822073       776.7      83.80
## 42    Sumatera Utara  2006  3007636     705023       222.5      81.00
## 43    Sumatera Utara  2007  3265834     750232      2513.0      82.00
## 44    Sumatera Utara  2008  3340794     748540      2442.0      81.40
## 45    Sumatera Utara  2009  3527899     768407      2184.0      86.00
## 46    Sumatera Utara  2010  3582302     754674      1903.3      78.55
## 47    Sumatera Utara  2011  3607403     757547      2042.0      79.00
## 48    Sumatera Utara  2012  3715514     765099      3175.0      76.00
## 49    Sumatera Utara  2013  3727249     742968      2627.0      78.67
## 50    Sumatera Utara  2014  3631039     717318      2148.0      79.00
## 51    Sumatera Utara  2015  4044829     781769       975.9      86.90
## 155 Sumatera Selatan  2007  2753044     691467      2364.7      83.50
## 156 Sumatera Selatan  2008  2971286     718797      2685.7      84.80
## 157 Sumatera Selatan  2009  3125236     746465      2389.0      82.30
## 158 Sumatera Selatan  2010  3272451     769478      3396.0      85.25
## 159 Sumatera Selatan  2011  3384670     784820      2593.0      84.80
## 160 Sumatera Selatan  2012  3295247     769725      3083.0      83.00
## 161 Sumatera Selatan  2013  3676723     800036      3409.0      84.00
## 162 Sumatera Selatan  2014  3670435     810900      1668.3      81.00
## 163 Sumatera Selatan  2015  4247922     872737      1947.2      79.50
## 219          Lampung  2015  3641895     707266      1628.1      78.90
##     Suhu.rata.rata
## 29           26.45
## 30           26.40
## 31           26.58
## 32           26.33
## 33           26.40
## 34           27.16
## 35           26.45
## 36           27.70
## 37           28.03
## 38           28.45
## 39           29.59
## 40           29.27
## 41           27.00
## 42           27.80
## 43           27.00
## 44           26.90
## 45           27.10
## 46           27.18
## 47           27.20
## 48           27.30
## 49           28.80
## 50           27.90
## 51           27.40
## 155          27.00
## 156          26.90
## 157          27.40
## 158          27.08
## 159          27.30
## 160          27.40
## 161          27.30
## 162          26.00
## 163          27.70
## 219          27.10
padi[which(padi2$cluster == 3),]
##             Provinsi Tahun Produksi Luas.Panen Curah.hujan Kelembapan
## 21              Aceh  2013  2331046   419183.0      1623.6      80.70
## 23              Aceh  2015  1956940   461060.0      1575.0      80.00
## 52    Sumatera Utara  2016  4387036   423029.0      2384.0      82.00
## 53    Sumatera Utara  2017  4669778   415675.0      3190.0      84.00
## 54    Sumatera Utara  2018  2108285   408176.5      2431.0      80.00
## 55    Sumatera Utara  2019  2078902   413141.2      1401.6      86.53
## 60    Sumatera Barat  1996  1971180   430343.0      3866.0      87.29
## 62    Sumatera Barat  1998  1807622   412810.0      5522.0      87.39
## 63    Sumatera Barat  1999  1897678   432254.0      4327.5      80.89
## 66    Sumatera Barat  2002  1875834   424253.0      4241.2      71.28
## 67    Sumatera Barat  2003  1823739   411860.0      4927.2      71.91
## 68    Sumatera Barat  2004  1875188   422582.0      4584.2      78.50
## 69    Sumatera Barat  2005  1907390   426950.0      1533.6      78.00
## 70    Sumatera Barat  2006  1889489   417846.0       776.0      79.00
## 71    Sumatera Barat  2007  1938120   423655.0      4329.0      85.30
## 72    Sumatera Barat  2008  1965634   421902.0      2552.5      86.20
## 73    Sumatera Barat  2009  2105790   439542.0      4691.0      86.20
## 74    Sumatera Barat  2010  2211248   460497.0      5228.0      87.20
## 75    Sumatera Barat  2011  2279602   461709.0      4959.5      54.20
## 76    Sumatera Barat  2012  2368390   476422.0      4339.0      87.00
## 77    Sumatera Barat  2013  2430384   487820.0      4627.9      86.91
## 78    Sumatera Barat  2014  2519020   503198.0      2838.4      85.35
## 79    Sumatera Barat  2015  2550609   507545.0      3548.0      84.00
## 141 Sumatera Selatan  1993  1409559   439895.0      2815.0      82.78
## 142 Sumatera Selatan  1994  1347611   422109.0      1800.0      79.89
## 143 Sumatera Selatan  1995  1557944   492448.0      2800.0      82.71
## 144 Sumatera Selatan  1996  1666591   495958.0      2614.0      82.45
## 145 Sumatera Selatan  1997  1577398   469670.0      1558.3      78.47
## 149 Sumatera Selatan  2001  1723433   511928.0      2837.5      72.06
## 197          Lampung  1993  1646900   433078.0      2306.7      84.82
## 198          Lampung  1994  1615751   425940.0      2034.2      77.51
## 199          Lampung  1995  1943709   514363.0      3039.4      82.81
## 200          Lampung  1996  1971740   515192.0      1934.9      82.61
## 201          Lampung  1997  1753656   454087.0      1253.3      78.46
## 202          Lampung  1998  1975700   521575.0      2584.9      84.07
## 203          Lampung  1999  1801422   476899.0      2364.7      83.46
## 204          Lampung  2000  1946406   496879.0      1488.5      82.86
## 205          Lampung  2001  1992726   501119.0      2013.1      77.83
## 206          Lampung  2002  1951109   475461.0      2143.5      75.84
## 207          Lampung  2003  1966293   472635.0      1682.2      68.71
## 208          Lampung  2004  2091996   495519.0      2042.9      81.47
## 209          Lampung  2005  2124144   496538.0      1612.8      79.60
## 210          Lampung  2006  2129914   494102.0       560.3      74.60
## 211          Lampung  2007  2308404   524955.0      1941.4      75.90
## 212          Lampung  2008  2341075   506547.0      1940.1      79.00
## 222          Lampung  2018  2488642   511940.9      1385.8      76.05
## 223          Lampung  2019  2164089   464103.4      1706.4      78.03
##     Suhu.rata.rata
## 21           27.00
## 23           27.10
## 52           27.65
## 53           27.50
## 54           26.41
## 55           27.03
## 60           24.52
## 62           25.04
## 63           22.48
## 66           28.19
## 67           29.17
## 68           29.02
## 69           25.90
## 70           26.05
## 71           25.70
## 72           25.40
## 73           25.50
## 74           25.80
## 75           26.00
## 76           25.20
## 77           25.10
## 78           25.70
## 79           26.50
## 141          26.38
## 142          26.53
## 143          26.54
## 144          26.34
## 145          26.75
## 149          28.83
## 197          26.41
## 198          25.73
## 199          26.43
## 200          26.27
## 201          26.68
## 202          26.95
## 203          26.24
## 204          28.20
## 205          26.71
## 206          27.50
## 207          29.67
## 208          29.66
## 209          26.59
## 210          26.18
## 211          27.60
## 212          26.40
## 222          25.50
## 223          27.23
padi[which(padi2$cluster == 4),]
##           Provinsi Tahun  Produksi Luas.Panen Curah.hujan Kelembapan
## 80  Sumatera Barat  2016 2487929.0  222482.00      4205.2      76.49
## 81  Sumatera Barat  2017 2810425.0  222021.00      4553.0      75.11
## 85            Riau  1993  436297.0  146133.00      2738.4      86.37
## 86            Riau  1994  445361.0  146177.00      1991.3      84.90
## 87            Riau  1995  458756.0  152204.00      3099.9      85.02
## 88            Riau  1996  461905.0  150354.00      2259.5      84.26
## 89            Riau  1997  416135.0  137953.00      1510.4      83.82
## 90            Riau  1998  370124.0  126280.00      2233.0      84.26
## 91            Riau  1999  461630.0  155683.00      2045.3      84.59
## 92            Riau  2000  431351.0  141640.00      2478.2      84.60
## 93            Riau  2001  413391.0  132507.00      2441.7      70.79
## 94            Riau  2002  396644.0  129025.00      3123.8      71.73
## 95            Riau  2003  414237.0  132887.00      3822.8      72.92
## 96            Riau  2004  454186.0  145239.00      2540.1      83.70
## 97            Riau  2005  424095.0  134418.00      1996.3      83.93
## 98            Riau  2006   42938.0  136177.00       537.6      79.60
## 99            Riau  2007  490087.0  147167.00      3216.3      85.30
## 100           Riau  2008  494260.0  147796.00      3026.2      80.20
## 101           Riau  2009  531429.0  149423.00      3390.0      76.20
## 102           Riau  2010  574864.0  156088.00      3390.0      76.20
## 103           Riau  2011  535788.0  145242.00      2405.0      74.50
## 104           Riau  2012  512152.0  144015.00      2636.0      76.10
## 105           Riau  2013  434144.0  118518.00      2628.0      76.00
## 106           Riau  2014  385475.0  106037.00      2343.0      78.10
## 107           Riau  2015  393917.0  107546.00      2048.3      80.50
## 108           Riau  2016  325826.0   72151.00      2105.6      83.72
## 109           Riau  2017  337421.0   70016.00      2982.9      84.76
## 110           Riau  2018  266375.5   71448.08      1837.1      71.22
## 111           Riau  2019  230874.0   63142.04      1608.3      83.77
## 112           Riau  2020  269344.0   64733.13      2584.9      81.80
## 113          Jambi  1993  607529.0  199431.00      1954.0      83.81
## 114          Jambi  1994  564722.0  184029.00      1824.0      81.25
## 115          Jambi  1995  593502.0  193666.00      2290.1      83.96
## 116          Jambi  1996  657650.0  215975.00      2309.1      83.60
## 117          Jambi  1997  572269.0  190608.00      1030.1      80.64
## 118          Jambi  1998  550277.0  178766.00      2383.8      83.47
## 119          Jambi  1999  553641.0  178307.00      2429.3      83.25
## 120          Jambi  2000  536779.0  171395.00       840.3      84.85
## 121          Jambi  2001  556564.0  164826.00      2515.2      72.40
## 122          Jambi  2002  561007.0  165729.00      2044.5      70.77
## 123          Jambi  2003  578346.0  159463.00      2508.1      71.28
## 124          Jambi  2004  579404.0  156803.00      2561.0      82.74
## 125          Jambi  2005  579635.0  154941.00      1015.7      84.80
## 126          Jambi  2006  544597.0  140613.00       424.7      85.00
## 127          Jambi  2007   58663.0  149888.00      2394.0      86.00
## 128          Jambi  2008  581704.0  143034.00      2230.0      83.70
## 129          Jambi  2009  644947.0  155802.00      2299.0      83.80
## 130          Jambi  2010  628828.0  153897.00      3207.0      84.60
## 131          Jambi  2011  646641.0  157441.00      2295.0      82.50
## 132          Jambi  2012  625164.0  149369.00      1874.0      81.40
## 133          Jambi  2013  664535.0  153243.00      2093.0      83.42
## 134          Jambi  2014  664720.0  145990.00      1781.0      82.80
## 135          Jambi  2015  541486.0  122214.00      1694.9      82.10
## 136          Jambi  2016  642095.0   96588.00      1502.4      83.84
## 137          Jambi  2017  678127.0   97690.00      2193.2      83.69
## 138          Jambi  2018  383045.7   86202.68      2182.3      82.23
## 139          Jambi  2019  309932.7   69536.06      1773.4      81.44
## 140          Jambi  2020  374376.3   84772.93      2303.8      78.24
## 169       Bengkulu  1993  356709.0  109807.00      4150.0      85.50
## 170       Bengkulu  1994  334232.0  104747.00      2043.0      85.32
## 171       Bengkulu  1995  377337.0  115914.00      4478.0      85.49
## 172       Bengkulu  1996  396977.0  121929.00      3931.0      85.96
## 173       Bengkulu  1997  382123.0  113915.00      1167.0      84.00
## 174       Bengkulu  1998  375533.0  111158.00      4114.0      85.34
## 175       Bengkulu  1999  381577.0  114788.00      3084.0      84.72
## 176       Bengkulu  2000  362979.0  108751.00      3254.0      84.73
## 177       Bengkulu  2001  376973.0  105212.00      3010.0      70.15
## 178       Bengkulu  2002  379818.0  109519.00      3076.0      67.98
## 179       Bengkulu  2003  413375.0  110550.00      3030.0      70.30
## 180       Bengkulu  2004  414741.0  110929.00      3277.0      84.28
## 181       Bengkulu  2005  441276.0  116818.00      3375.2      84.70
## 182       Bengkulu  2006  378377.0  100991.00      2313.8      83.30
## 183       Bengkulu  2007  470469.0  123853.00      3150.0      84.20
## 184       Bengkulu  2008  484900.0  127506.00      3396.0      84.20
## 185       Bengkulu  2009  510160.0  132975.00      3850.0      84.10
## 186       Bengkulu  2010  516869.0  133629.00      3822.0      84.00
## 187       Bengkulu  2011  502552.0  127934.00      2465.7      82.52
## 188       Bengkulu  2012  581910.0  144448.00      2545.0      82.00
## 189       Bengkulu  2013  622832.0  147680.00      3980.9      83.93
## 190       Bengkulu  2014  593194.0  147572.00      3323.0      83.70
## 191       Bengkulu  2015  578654.0  128833.00      2668.9      83.20
## 192       Bengkulu  2016  629224.0   83449.00      3350.1      83.38
## 193       Bengkulu  2017  714017.0   82429.00      3949.8      84.20
## 194       Bengkulu  2018  288810.5   65891.16      3649.9      83.79
## 195       Bengkulu  2019  296472.1   64406.86      1786.2      83.26
## 196       Bengkulu  2020  296925.2   64137.28      4144.0      80.18
##     Suhu.rata.rata
## 80           23.26
## 81           22.19
## 85           26.00
## 86           26.10
## 87           26.17
## 88           25.94
## 89           26.26
## 90           26.73
## 91           26.08
## 92           25.98
## 93           29.05
## 94           28.20
## 95           29.64
## 96           29.85
## 97           26.58
## 98           27.70
## 99           27.10
## 100          27.40
## 101          27.70
## 102          27.70
## 103          27.00
## 104          27.30
## 105          26.00
## 106          27.20
## 107          27.20
## 108          27.00
## 109          26.70
## 110          25.00
## 111          26.91
## 112          25.93
## 113          26.29
## 114          25.51
## 115          26.22
## 116          26.00
## 117          26.50
## 118          26.78
## 119          26.34
## 120          27.76
## 121          28.12
## 122          28.82
## 123          29.39
## 124          28.95
## 125          26.80
## 126          26.77
## 127          26.60
## 128          26.50
## 129          27.10
## 130          27.10
## 131          26.90
## 132          26.70
## 133          26.80
## 134          27.20
## 135          27.00
## 136          26.84
## 137          26.62
## 138          26.62
## 139          26.94
## 140          25.85
## 169          25.95
## 170          25.68
## 171          26.12
## 172          25.66
## 173          25.84
## 174          26.40
## 175          25.81
## 176          24.22
## 177          26.80
## 178          28.50
## 179          29.50
## 180          29.70
## 181          25.70
## 182          26.10
## 183          26.40
## 184          26.30
## 185          26.50
## 186          26.80
## 187          26.35
## 188          26.90
## 189          26.70
## 190          26.90
## 191          27.00
## 192          26.77
## 193          26.52
## 194          26.64
## 195          26.56
## 196          25.84
padi[which(padi2$cluster == 5),]
##           Provinsi Tahun Produksi Luas.Panen Curah.hujan Kelembapan
## 1             Aceh  1993  1329536   323589.0     1627.00      82.00
## 2             Aceh  1994  1299699   329041.0     1521.00      82.12
## 3             Aceh  1995  1382905   339253.0     1476.00      82.72
## 4             Aceh  1996  1419128   348223.0     1557.00      83.00
## 5             Aceh  1997  1368074   337561.0     1339.00      82.46
## 6             Aceh  1998  1404580   365892.0     1465.00      82.60
## 7             Aceh  1999  1478712   359817.0     1778.00      82.79
## 8             Aceh  2000  1486909   336765.0     1974.70      90.60
## 9             Aceh  2001  1547499   295212.0     1688.70      69.48
## 10            Aceh  2002  1314165   315131.0     1296.80      68.75
## 11            Aceh  2003  1246614   367636.0     1507.20      70.66
## 12            Aceh  2004  1350748   370966.0     1097.00      80.84
## 13            Aceh  2005  1411650   337893.0      710.50      79.50
## 14            Aceh  2006  1552078   320789.0      506.50      80.80
## 15            Aceh  2007  1556858   360717.0     1414.00      81.50
## 16            Aceh  2008  1402287   329109.0     1270.40      78.50
## 17            Aceh  2009  1533369   359375.0     1577.00      78.70
## 18            Aceh  2010  1788738   352281.0     1986.00      81.40
## 19            Aceh  2011  1772962   380686.0     1268.00      79.40
## 20            Aceh  2012  1582393   387803.0     1098.00      79.60
## 22            Aceh  2014  1820062   376137.0     2264.40      78.30
## 24            Aceh  2016  2180754   293067.0     1096.00      83.32
## 25            Aceh  2017  2478922   294483.0     1905.90      85.57
## 26            Aceh  2018  1751997   329515.8     1427.80      83.98
## 27            Aceh  2019  1714438   310012.5     1931.40      83.90
## 28            Aceh  2020  1861567   317869.4     1619.20      80.82
## 56  Sumatera Utara  2020  2076280   388591.2     1648.30      83.76
## 57  Sumatera Barat  1993  1806424   394412.0     5110.00      89.77
## 58  Sumatera Barat  1994  1747543   382740.0     4869.50      75.22
## 59  Sumatera Barat  1995  1829192   400627.0     5022.00      87.68
## 61  Sumatera Barat  1997  1787719   395728.0     2945.10      87.97
## 64  Sumatera Barat  2000  1759059   396919.0     3040.60      86.01
## 65  Sumatera Barat  2001  1668955   376710.0     2811.00      71.08
## 82  Sumatera Barat  2018  1483076   313050.8      327.33      82.71
## 83  Sumatera Barat  2019  1482996   311671.2     4757.50      87.73
## 84  Sumatera Barat  2020  1450840   295664.5     4072.70      85.22
## 220        Lampung  2016  3831923   390799.0     2317.60      79.40
## 221        Lampung  2017  4090654   396559.0     1825.10      77.04
##     Suhu.rata.rata
## 1            26.06
## 2            26.92
## 3            26.27
## 4            26.08
## 5            26.31
## 6            26.84
## 7            26.14
## 8            27.10
## 9            28.90
## 10           29.20
## 11           29.40
## 12           29.40
## 13           26.80
## 14           26.73
## 15           26.38
## 16           27.00
## 17           26.90
## 18           27.10
## 19           27.10
## 20           26.90
## 22           27.10
## 24           27.12
## 25           26.51
## 26           26.48
## 27           26.65
## 28           25.41
## 56           25.79
## 57           24.70
## 58           24.49
## 59           24.82
## 61           24.69
## 64           25.86
## 65           28.17
## 82           26.91
## 83           25.61
## 84           26.26
## 220          26.45
## 221          26.36
segmentasi$centers
##      Tahun  Produksi Luas.Panen.1 Curah.hujan.1 Kelembapan.1
## 1 2009.800 2.7569096     594480.7      2208.910     79.62750
## 2 2006.242 3.3930856     777078.7      2301.785     81.23485
## 3 2004.915 2.0945769     462008.4      2722.470     80.25191
## 4 2006.733 0.5191461     131680.2      2605.994     81.40081
## 5 2006.421 1.7381922     349534.1      2030.243     81.23421
segmentasi$size
## [1] 20 33 47 86 38
segmentasi$withinss
## [1]  29277980038  60238349720  65156344033 113002443927  42743881493
sse <- sapply(1:10, function(param_k) {kmeans(padi2[field_yang_digunakan], param_k, nstart = 25)$tot.withinss})
sse_formatted <- format(round(sse, 1), scientific = FALSE)
sse_formatted
##  [1] "12080839567632" " 3447314009253" "  910531270278" "  452275724698"
##  [5] "  310418999209" "  233132900634" "  162227132124" "  123020864248"
##  [9] "  101531179120" "   82086297118"
library(ggplot2)
jumlah_cluster_max <- 10
ssdata = data.frame(cluster=c(1:jumlah_cluster_max),sse)
ggplot(ssdata, aes(x=cluster,y=sse)) +
  geom_line(color="red") + geom_point() +
  ylab("Within Cluster Sum of Squares") + xlab("Jumlah Cluster") +
  geom_text(aes(label=format(round(sse,2),scientific = FALSE, nsmall = 2)),hjust=-0.2, vjust=-0.5) +
  scale_x_discrete(limits=c(1:jumlah_cluster_max))
## Warning in scale_x_discrete(limits = c(1:jumlah_cluster_max)): Continuous limits supplied to discrete scale.
## ℹ Did you mean `limits = factor(...)` or `scale_*_continuous()`?

segmentasi$centers
##      Tahun  Produksi Luas.Panen.1 Curah.hujan.1 Kelembapan.1
## 1 2009.800 2.7569096     594480.7      2208.910     79.62750
## 2 2006.242 3.3930856     777078.7      2301.785     81.23485
## 3 2004.915 2.0945769     462008.4      2722.470     80.25191
## 4 2006.733 0.5191461     131680.2      2605.994     81.40081
## 5 2006.421 1.7381922     349534.1      2030.243     81.23421