library(readxl)
data <- read_excel("D:/TUGAS/TUGAS APLIKASI KOMPUTER.xlsx")
View(data)
head(data)
## # A tibble: 6 × 30
## NEGARA `NEGARA Code` `Series Name` `Series Code` `1998` `1999` `2000` `2001`
## <chr> <chr> <chr> <chr> <chr> <chr> <chr> <chr>
## 1 United … ARE Access to cl… EG.CFT.ACCS.… .. .. 99 99
## 2 United … ARE Access to cl… EG.CFT.ACCS.… .. .. 99 99
## 3 United … ARE Access to cl… EG.CFT.ACCS.… .. .. 99 100
## 4 United … ARE Access to el… EG.ELC.ACCS.… 100 100 100 100
## 5 United … ARE Access to el… EG.ELC.ACCS.… 100 100 100 100
## 6 Singapo… SGP S+C7ingapore EG.CFT.ACCS.… .. .. 100 100
## # ℹ 22 more variables: `2002` <chr>, `2003` <chr>, `2004` <chr>, `2005` <chr>,
## # `2006` <chr>, `2007` <chr>, `2008` <chr>, `2009` <chr>, `2010` <chr>,
## # `2011` <chr>, `2012` <chr>, `2013` <chr>, `2014` <chr>, `2015` <chr>,
## # `2016` <chr>, `2017` <chr>, `2018` <chr>, `2019` <chr>, `2020` <chr>,
## # `2021` <chr>, `2022` <chr>, `2023` <chr>
names(data)
## [1] "NEGARA" "NEGARA Code" "Series Name" "Series Code" "1998"
## [6] "1999" "2000" "2001" "2002" "2003"
## [11] "2004" "2005" "2006" "2007" "2008"
## [16] "2009" "2010" "2011" "2012" "2013"
## [21] "2014" "2015" "2016" "2017" "2018"
## [26] "2019" "2020" "2021" "2022" "2023"
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:
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.
library(readxl)