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

Including Plots

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.