R Notebook

This is an R Markdown Notebook. When you execute code within the notebook, the results appear beneath the code.

Try executing this chunk by clicking the Run button within the chunk or by placing your cursor inside it and pressing Ctrl+Shift+Enter.

plot(cars)

Add a new chunk by clicking the Insert Chunk button on the toolbar or by pressing Ctrl+Alt+I.

library(tidyverse)
library(eurostat)
library(dplyr)
gas_raw_data <- get_eurostat("nrg_cb_gas")

Dataset query already saved in cache_list.json...
Reading cache file C:\Users\Admin\AppData\Local\Temp\RtmpMrh3Mh/eurostat/fef0fcc7b02b76ab0517737bcb769e94.rds
Table  nrg_cb_gas  read from cache file:  C:\Users\Admin\AppData\Local\Temp\RtmpMrh3Mh/eurostat/fef0fcc7b02b76ab0517737bcb769e94.rds

str(gas_raw_data)

tibble [659,464 × 7] (S3: tbl_df/tbl/data.frame)
 $ freq       : chr [1:659464] "A" "A" "A" "A" ...
 $ nrg_bal    : chr [1:659464] "DL" "DL" "DL" "DL" ...
 $ siec       : chr [1:659464] "C0350" "C0350" "C0350" "C0350" ...
 $ unit       : chr [1:659464] "TJ_GCV" "TJ_GCV" "TJ_GCV" "TJ_GCV" ...
 $ geo        : chr [1:659464] "AL" "AL" "AL" "AL" ...
 $ TIME_PERIOD: Date[1:659464], format: "1990-01-01" "1991-01-01" ...
 $ values     : num [1:659464] 0 0 0 0 0 0 0 0 0 0 ...

# 2. Завантажуємо дані
gas_raw <- get_eurostat("nrg_cb_gas")

Dataset query already saved in cache_list.json...
Reading cache file C:\Users\Admin\AppData\Local\Temp\RtmpMrh3Mh/eurostat/fef0fcc7b02b76ab0517737bcb769e94.rds
Table  nrg_cb_gas  read from cache file:  C:\Users\Admin\AppData\Local\Temp\RtmpMrh3Mh/eurostat/fef0fcc7b02b76ab0517737bcb769e94.rds

# 3. Обробка через пайп (%>%)
gas_clean <- gas_raw %>%
  filter(geo == "NL") %>%                    # Тільки Нідерланди
  filter(unit == "TJ_GCV") %>%               # Тільки певна одиниця виміру
  filter(nrg_bal %in% c("IPRD", "EXP")) %>%  # Тільки Виробництво та Експорт
  filter(siec == "G3000")                    # Тільки природний газ

production <- gas_raw %>%
  filter(geo == "NL") %>%                    # Тільки Нідерланди
  filter(unit == "TJ_GCV") %>%               # Тільки певна одиниця виміру
  filter(nrg_bal %in% c("IPRD", "EXP")) %>%  # Тільки Виробництво та Експорт
  filter(siec == "G3000")                    # Тільки природний газ

plot(production$TIME_PERIOD, production$values,     
     type = "l", col = "blue", lwd = 2,
     xaxt = "n", 
     xlab = "Year", ylab = "Gas Volume", 
     main = "Gas Production vs Exports in the Netherlands")
caption = "Source: Eurostat [nrg_cb_gas]"


#lines(exports$TIME_PERIOD, exports$values, col = "red", lwd = 2)
lines(production$TIME_PERIOD, production$values, col = "red", lwd = 2)

seq(1990, 2023, by = 10)

[1] 1990 2000 2010 2020

axis.Date(1, at = seq(min(production$TIME_PERIOD), max(production$TIME_PERIOD), by = "5 years"), format = "%Y")
legend("topright", 
       legend = c("Production", "Exports"), 
       col = c("blue", "red"), 
       lty = 1, lwd = 2, cex = 0.7)

grid()

When you save the notebook, an HTML file containing the code and output will be saved alongside it (click the Preview button or press Ctrl+Shift+K to preview the HTML file).

The preview shows you a rendered HTML copy of the contents of the editor. Consequently, unlike Knit, Preview does not run any R code chunks. Instead, the output of the chunk when it was last run in the editor is displayed.