Get startedGet started for free

Visualizing the Investment Annual Summary data

Now that you have all of the data ready for the report you're creating, you can start making plots that will be included in the report to help your audience visualize the data when they're reading the report. You'll start by creating a line plot of the investment_annual_summary data.

This exercise is part of the course

Reporting with R Markdown

View Course

Exercise instructions

  • Load the ggplot2 package in the first code chunk, after the dplyr package on line 10.
  • In the investment-annual-summary code chunk, create a line plot using the investment_annual_summary data.
  • Plot the fiscal year (fiscal_year) on the x-axis, and investment amounts (dollars_in_millions) on the y-axis.
  • Color the plot by region, so that the plot in the final report displays each region as a different color in the line plot.

Hands-on interactive exercise

Have a go at this exercise by completing this sample code.

{"investment_report.Rmd":"---\ntitle: \"Investment Report\"\ndate: \"`r format(Sys.time(), '%d %B %Y')`\"\noutput: html_document\n---\n\n```{r data, include = FALSE}\nlibrary(readr)\nlibrary(dplyr)\n# Load the ggplot2 package here\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\n\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(___, aes(___)) +\n  ___ +\n  labs(\n    title = \"Investment Annual Summary\",\n    x = \"Fiscal Year\",\n    y = \"Dollars in Millions\"\n  )\n```\n\n### Investment Projects in Brazil\n\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.\n```{r brazil-investment-projects}\nbrazil_investment_projects <- investment_services_projects %>%\n  filter(country == \"Brazil\") \n```\n\n### Investment Projects in Brazil in 2018\n\n```{r brazil-investment-projects-2018}\nbrazil_investment_projects_2018 <- investment_services_projects %>%\n  filter(country == \"Brazil\",\n         date_disclosed >= \"2017-07-01\",\n         date_disclosed <= \"2018-06-30\")\n```\n\n\n"}
Edit and Run Code