library(readxl)
## Warning: package 'readxl' was built under R version 4.6.2
# Impor data
data <- read_excel("C:/Users/valem/Downloads/DATA_15_NEGARA_CLEANED.xlsx")
# Cek hasil impor
head(data)
## # A tibble: 6 × 27
## NEGARA INDIKATOR `2001` `2002` `2003` `2004` `2005` `2006` `2007`
## <chr> <chr> <dbl> <dbl> <dbl> <dbl> <dbl> <dbl> <dbl>
## 1 INDONES… Foreign … -1.86e+0 7.42e-2 -2.54e-1 7.38e-1 2.92e0 1.35e0 1.60e0
## 2 INDONES… Poverty … 1.84e+1 1.82e+1 1.74e+1 1.67e+1 1.6 e1 1.78e1 1.66e1
## 3 INDONES… Trade (%… 6.98e+1 5.91e+1 5.36e+1 5.98e+1 6.40e1 5.67e1 5.48e1
## 4 INDONES… Populati… 2.19e+8 2.22e+8 2.25e+8 2.28e+8 2.31e8 2.34e8 2.37e8
## 5 MALAYSIA Foreign … 5.97e-1 3.17e+0 2.92e+0 3.51e+0 2.73e0 4.73e0 4.69e0
## 6 MALAYSIA Poverty … NA NA NA NA NA NA NA
## # ℹ 18 more variables: `2008` <dbl>, `2009` <dbl>, `2010` <dbl>, `2011` <dbl>,
## # `2012` <dbl>, `2013` <dbl>, `2014` <dbl>, `2015` <dbl>, `2016` <dbl>,
## # `2017` <dbl>, `2018` <dbl>, `2019` <dbl>, `2020` <dbl>, `2021` <dbl>,
## # `2022` <dbl>, `2023` <dbl>, `2024` <dbl>, `2025` <dbl>
str(data)
## tibble [60 × 27] (S3: tbl_df/tbl/data.frame)
## $ NEGARA : chr [1:60] "INDONESIA" "INDONESIA" "INDONESIA" "INDONESIA" ...
## $ INDIKATOR: chr [1:60] "Foreign direct investment, net inflows (% of GDP)" "Poverty headcount ratio at national poverty lines (% of population)" "Trade (% of GDP)" "Population, total" ...
## $ 2001 : num [1:60] -1.86 1.84e+01 6.98e+01 2.19e+08 5.97e-01 ...
## $ 2002 : num [1:60] 7.42e-02 1.82e+01 5.91e+01 2.22e+08 3.17 ...
## $ 2003 : num [1:60] -2.54e-01 1.74e+01 5.36e+01 2.25e+08 2.92 ...
## $ 2004 : num [1:60] 7.38e-01 1.67e+01 5.98e+01 2.28e+08 3.51 ...
## $ 2005 : num [1:60] 2.92 1.60e+01 6.40e+01 2.31e+08 2.73 ...
## $ 2006 : num [1:60] 1.35 1.78e+01 5.67e+01 2.34e+08 4.73 ...
## $ 2007 : num [1:60] 1.60 1.66e+01 5.48e+01 2.37e+08 4.69 ...
## $ 2008 : num [1:60] 1.83 1.54e+01 5.86e+01 2.40e+08 3.28 ...
## $ 2009 : num [1:60] 9.04e-01 1.42e+01 4.55e+01 2.43e+08 5.67e-02 ...
## $ 2010 : num [1:60] 2.03 1.33e+01 4.67e+01 2.46e+08 4.27 ...
## $ 2011 : num [1:60] 2.30 1.25e+01 5.02e+01 2.49e+08 5.07 ...
## $ 2012 : num [1:60] 2.31 1.20e+01 4.96e+01 2.53e+08 2.83 ...
## $ 2013 : num [1:60] 2.55 1.14e+01 4.86e+01 2.56e+08 3.49 ...
## $ 2014 : num [1:60] 2.82 1.13e+01 4.81e+01 2.59e+08 3.14 ...
## $ 2015 : num [1:60] 2.30 1.12e+01 4.19e+01 2.62e+08 3.27 ...
## $ 2016 : num [1:60] 4.87e-01 1.09e+01 3.74e+01 2.65e+08 4.47 ...
## $ 2017 : num [1:60] 2.02 1.06e+01 3.94e+01 2.67e+08 2.94 ...
## $ 2018 : num [1:60] 1.81 9.80 4.31e+01 2.70e+08 2.31 ...
## $ 2019 : num [1:60] 2.23 9.40 3.76e+01 2.72e+08 2.51 ...
## $ 2020 : num [1:60] 1.81 9.80 3.30e+01 2.75e+08 1.20 ...
## $ 2021 : num [1:60] 1.79 1.01e+01 4.02e+01 2.77e+08 5.42 ...
## $ 2022 : num [1:60] 1.87 9.50 4.55e+01 2.79e+08 3.68 ...
## $ 2023 : num [1:60] 1.57 9.40 4.15e+01 2.81e+08 2.41 ...
## $ 2024 : num [1:60] 1.74 9.00 4.28e+01 2.83e+08 4.20 ...
## $ 2025 : num [1:60] 1.57 8.50 4.34e+01 2.86e+08 4.58 ...
summary(cars)
## speed dist
## Min. : 4.0 Min. : 2.00
## 1st Qu.:12.0 1st Qu.: 26.00
## Median :15.0 Median : 36.00
## Mean :15.4 Mean : 42.98
## 3rd Qu.:19.0 3rd Qu.: 56.00
## Max. :25.0 Max. :120.00
You can also embed plots, for example:
Note that the echo = FALSE parameter was added to the
code chunk to prevent printing of the R code that generated the
plot.