IniziaInizia gratis

Aggiungere più parametri al report

In precedenza, hai aggiunto un parametro per country per creare nuovi report che riassumono le informazioni sui progetti di investimento per qualsiasi paese incluso nei dati investment_services_projects. Ora aggiungerai i parametri per l'anno fiscale e modificherai il codice esistente in modo da poter creare nuovi report sui progetti di investimento per qualsiasi paese e anno fiscale a partire dai dati investment_services_projects.

Questo esercizio fa parte del corso

Reportistica con R Markdown

Visualizza il corso

Istruzioni dell'esercizio

  • Aggiungi un parametro fy per l'anno fiscale e indica 2018 come anno fiscale.
  • Aggiungi i parametri per le date year_start e year_end, usando 2017-07-01 per year_start e 2018-06-30 per year_end dell'anno fiscale 2018.
  • Sostituisci i riferimenti alle date nel filter() alle righe 64 e 65 con i riferimenti ai parametri year_start e year_end.
  • Nel chunk di codice country-investment-projects-2018, rinomina il chunk in country-annual-investment-projects e il nome dell'oggetto e i riferimenti al nome dell'oggetto nel testo in country_annual_investment_projects.

Esercizio pratico interattivo

Prova a risolvere questo esercizio completando il codice di esempio.

{"investment_report.Rmd":"---\ntitle: \"Investment Report for Projects in `r params$country`\"\noutput: \n  html_document:\n    toc: true\n    toc_float: true\ndate: \"`r format(Sys.time(), '%d %B %Y')`\"\nparams:\n  country: Brazil\n---\n\n```{r setup, include = FALSE}\nknitr::opts_chunk$set(fig.align = 'center', echo = TRUE)\n```\n\n```{r data, include = FALSE}\nlibrary(readr)\nlibrary(dplyr)\nlibrary(ggplot2)\n\ninvestment_annual_summary <- read_csv(\"https://assets.datacamp.com/production/repositories/5756/datasets/d0251f26117bbcf0ea96ac276555b9003f4f7372/investment_annual_summary.csv\")\ninvestment_services_projects <- read_csv(\"https://assets.datacamp.com/production/repositories/5756/datasets/bcb2e39ecbe521f4b414a21e35f7b8b5c50aec64/investment_services_projects.csv\")\n```\n\n\n## Datasets \n\n### Investment Annual Summary\nThe `investment_annual_summary` dataset provides a summary of the dollars in millions provided to each region for each fiscal year, from 2012 to 2018.\n```{r investment-annual-summary}\nggplot(investment_annual_summary, aes(x = fiscal_year, y = dollars_in_millions, color = region)) +\n  geom_line() +\n  labs(\n    title = \"Investment Annual Summary\",\n    x = \"Fiscal Year\",\n    y = \"Dollars in Millions\"\n  )\n```\n\n### Investment Projects in `r params$country`\nThe `investment_services_projects` dataset provides information about each investment project from 2012 to 2018. Information listed includes the project name, company name, sector, project status, and investment amounts. Projects that do not have an associated investment amount are excluded from the plot.\n\n```{r country-investment-projects}\ncountry_investment_projects <- investment_services_projects %>%\n  filter(country == params$country) \n\nggplot(country_investment_projects, aes(x = date_disclosed, y = total_investment, color = status)) +\n  geom_point() +\n  labs(\n    title = \"Investment Services Projects\",\n    x = \"Date Disclosed\",\n    y = \"Total IFC Investment in Dollars in Millions\"\n  )\n```\n\n### Investment Projects in `r params$country` in 2018\nThe `investment_services_projects` dataset was filtered below to focus on information about each investment project from the 2018 fiscal year, and is referred to as `country_investment_projects_2018`. Projects that do not have an associated investment amount are excluded from the plot.\n```{r country-investment-projects-2018}\ncountry_investment_projects_2018 <- investment_services_projects %>%\n  filter(country == params$country,\n         date_disclosed >= \"2017-07-01\",\n         date_disclosed <= \"2018-06-30\") \n\nggplot(country_investment_projects_2018, aes(x = date_disclosed, y = total_investment, color = status)) +\n  geom_point() +\n  labs(\n    title = \"Investment Services Projects\",\n    x = \"Date Disclosed\",\n    y = \"Total IFC Investment in Dollars in Millions\"\n  ) \n```\n\n\n"}
Modifica ed esegui il codice