library(readxl)
## Warning: package 'readxl' was built under R version 4.6.2
library(tidyverse)
## Warning: package 'tidyverse' was built under R version 4.6.2
## Warning: package 'ggplot2' was built under R version 4.6.2
## Warning: package 'tidyr' was built under R version 4.6.2
## Warning: package 'readr' was built under R version 4.6.2
## Warning: package 'purrr' was built under R version 4.6.2
## Warning: package 'stringr' was built under R version 4.6.2
## Warning: package 'forcats' was built under R version 4.6.2
## Warning: package 'lubridate' was built under R version 4.6.2
## ── Attaching core tidyverse packages ──────────────────────── tidyverse 2.0.0 ──
## ✔ dplyr 1.2.1 ✔ readr 2.2.0
## ✔ forcats 1.0.1 ✔ stringr 1.6.0
## ✔ ggplot2 4.0.4 ✔ tibble 3.3.1
## ✔ lubridate 1.9.5 ✔ tidyr 1.3.2
## ✔ purrr 1.2.2
## ── Conflicts ────────────────────────────────────────── tidyverse_conflicts() ──
## ✖ dplyr::filter() masks stats::filter()
## ✖ dplyr::lag() masks stats::lag()
## ℹ Use the conflicted package (<http://conflicted.r-lib.org/>) to force all conflicts to become errors
file_path <- "C:/Users/Lenovo/Downloads/Tugas data 15 Negara_Rianti palombu.xlsx"
data_mentah <- read_excel(file_path, sheet = "Data")
head(data_mentah)
## # A tibble: 6 × 29
## `Country Name` `Country Code` `Series Name` `Series Code` `2001 [YR2001]`
## <chr> <chr> <chr> <chr> <dbl>
## 1 Indonesia IDN Merchandise trade… TG.VAL.TOTL.… 59.1
## 2 Indonesia IDN Agriculture, fore… NV.AGR.TOTL.… 16.0
## 3 Indonesia IDN Industry (includi… NV.IND.TOTL.… 47.9
## 4 Indonesia IDN GDP growth (annua… NY.GDP.MKTP.… 3.64
## 5 Malaysia MYS Merchandise trade… TG.VAL.TOTL.… 174.
## 6 Malaysia MYS Agriculture, fore… NV.AGR.TOTL.… 8.01
## # ℹ 24 more variables: `2002 [YR2002]` <dbl>, `2003 [YR2003]` <dbl>,
## # `2004 [YR2004]` <dbl>, `2005 [YR2005]` <dbl>, `2006 [YR2006]` <dbl>,
## # `2007 [YR2007]` <dbl>, `2008 [YR2008]` <dbl>, `2009 [YR2009]` <dbl>,
## # `2010 [YR2010]` <dbl>, `2011 [YR2011]` <dbl>, `2012 [YR2012]` <dbl>,
## # `2013 [YR2013]` <dbl>, `2014 [YR2014]` <dbl>, `2015 [YR2015]` <dbl>,
## # `2016 [YR2016]` <dbl>, `2017 [YR2017]` <dbl>, `2018 [YR2018]` <dbl>,
## # `2019 [YR2019]` <dbl>, `2020 [YR2020]` <dbl>, `2021 [YR2021]` <dbl>, …
data_mentah <- read_excel("C:/Users/Lenovo/Downloads/Tugas data 15 Negara_Rianti palombu.xlsx")
data_2023 <- data_mentah %>%
filter(`Series Name` == "GDP growth (annual %)") %>%
select(`Country Name`, `2023 [YR2023]`) %>%
drop_na()
data_2023$`2023 [YR2023]` <- as.numeric(data_2023$`2023 [YR2023]`)
barplot(data_2023$`2023 [YR2023]`,
names.arg = data_2023$`Country Name`,
las = 2,
col = "steelblue",
main = "Pertumbuhan PDB (GDP Growth) Tahun 2023",
ylab = "Persen (%)",
cex.names = 0.7)
abline(h = 0, col = "red", lty = 2)
data_pertanian <- data_mentah %>%
filter(`Series Name` == "Agriculture, forestry, and fishing, value added (% of GDP)") %>%
select(`Country Name`, `2023 [YR2023]`) %>%
drop_na()
data_pertanian$`2023 [YR2023]` <- as.numeric(data_pertanian$`2023 [YR2023]`)
barplot(data_pertanian$`2023 [YR2023]`,
names.arg = data_pertanian$`Country Name`,
las = 2,
col = "forestgreen",
main = "Nilai Tambah Sektor Pertanian (% PDB) Tahun 2023",
ylab = "Persen (%)",
cex.names = 0.7)
data_industri <- data_mentah %>%
filter(`Series Name` == "Industry (including construction), value added (% of GDP)") %>%
select(`Country Name`, `2023 [YR2023]`) %>%
drop_na()
barplot(data_industri$`2023 [YR2023]`,
names.arg = data_industri$`Country Name`,
las = 2,
col = "darkorange",
main = "Nilai Tambah Sektor Industri (% PDB) Tahun 2023",
ylab = "Persen (%)",
cex.names = 0.7)
data_perdagangan <- data_mentah %>%
filter(`Series Name` == "Merchandise trade (% of GDP)") %>%
select(`Country Name`, `2023 [YR2023]`) %>%
drop_na()
data_perdagangan$`2023 [YR2023]` <- as.numeric(data_perdagangan$`2023 [YR2023]`)
barplot(data_perdagangan$`2023 [YR2023]`,
names.arg = data_perdagangan$`Country Name`,
las = 2,
col = "purple",
main = "Perdagangan Barang (% PDB) Tahun 2023",
ylab = "Persen (%)",
cex.names = 0.7)
## R Markdown
This is an R Markdown document. Markdown is a simple formatting syntax for authoring HTML, PDF, and MS Word documents. For more details on using R Markdown see <http://rmarkdown.rstudio.com>.
When you click the **Knit** button a document will be generated that includes both content as well as the output of any embedded R code chunks within the document. You can embed an R code chunk like this:
``` r
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.