[SOLVED] DATA607 Assignment 4-Tidying and Transforming Data

Tidying and Transforming Data

The chart above describes arrival delays for two airlines across five destinations. Your task is to:

(1) Create a .CSV file (or optionally, a MySQL database!) that includes all of the information above. You’re encouraged to use a “wide” structure similar to how the information appears above, so that you can practice tidying and transformations as described below.

(2)Readtheinformationfromyour.CSVfileintoR,andusetidyrand dplyr asneededtotidy and transform your data.

3. (3)  Perform analysis to compare the arrival delays for the two airlines.
4. (4)  Your code should be in an R Markdown file, posted to rpubs.com, and should include narrative

   descriptions of your data cleanup work, analysis, and conclusions. Please include in your homework submission:

    The URL to the .Rmd file in your GitHub repository. and  The URL for your rpubs.com web page.