Final Exam: Working with Datasets in R

WHAT YOU WILL LEARN

• 

  Install and set up the r programming language on macos
  

  download and set up the rstudio ide on macos
  

  install and set up the r programming language on windows
  

  download and set up the rstudio ide on windows
  

  run commands on the rstudio console
  

  recall the use of the different panes available in rstudio
  

  connect to an in-memory sqlite database and create tables
  

  query database tables with dbgetquery() and dbsendquery()
  

  perform create, read, update, and delete operations on tables
  

  delete and rename columns in an r data frame
• 

  change data types for variables in a data frame
  

  use the transform() function to transform data in data frames
  

  use apply() to iterate over and perform operations on data frames
  

  edit data frame columns to be of the right data type
  

  select variables from data frames
  

  filter data using relational operators
  

  use the order() function to sort data frames
  

  use the arrange() function to sort data frames
  

  perform joins on data frames using the merge() function
  

  create histograms and kde curves using plot() and ggplot2