task-09

Task 9: Same Data Different Format

Background

Data formats are varied and differ by domains and software. We could spend weeks on the different formats and file types that companies and governments use to store their data. We will practice with a few standard formats that are often used for storing data. In the future, you will most likely have to do some research to figure out other formats (but you can do it with R or Python). We have a challenge to read in the five formats of the DOW data and checking that they are all identical using all.equal(). One final note, your R script should do all the work. That is your script should download the files and/or read directly from the web location of the file.

• Course Website

Reading

This reading will help you complete the tasks below.

• o Chapter 11: R for Data Science - Data Import
• o haven R Package
• o readxl R Package
• o downloader R Package

Tasks

• Take notes on your reading of the specified ‘R for Data Science’ chapter in the README.md or in a ‘.R’ script in the class task folder
• Use the appropriate functions in library(readr), library(haven), library(readxl) to read in the five files found on GitHub
  • Use read_rds(url("WEBLOCATION.rds")) to download and read the .rds file type
  • Use the library(downloader) R package and use the download(mode = "wb") function to download the xlsx data as read_xlsx() cannot read files from the web path
  • Use tempfile() function to download and save the file.
• Check that all five files you have imported into R are in fact the same with all.equal()
• Use one of the files to make a graphic showing the performance of the Dart, DJIA, and Pro stock selections
  • Include a boxplot, the jittered returns, and the average return in your graphic
• Save your .R script and your image to your repository and be ready to share your code that built your graphic in class
• Schedule a mid-semester 15-minute interview to discuss your progress in the class.