Filtering for a specific country
Previously, you learned how to filter the data to find out more information about projects that occurred in Indonesia. Now, you'll build a report that provides this information for another country that's included in the investment_services_project data. In this exercise, you'll begin filtering the data to gather information about projects that occurred in Brazil.
This exercise is part of the course
Reporting with R Markdown
Exercise instructions
- Load the
dplyrpackage in the first code chunk on line9right after thereadrpackage on line8. - In the third code chunk, filter the
investment_services_projectsdata to determine which projects occurred in Brazil. - Save the result as
brazil_investment_projects. - Label the code chunk
brazil-investment-projects.
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)\n\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}\ninvestment_annual_summary\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}\n___ <- investment_services_projects %>%\n ___\n\nbrazil_investment_projects\n```\n\n\n"}