Data Set

Given a set of data, prepare the data set by removing errors, validate the data, and standardize the data. Download a data set from the Federal Aviation Administration (found here: http://av-info.faa.gov/dd_sublevel.asp?Folder=\AID (Links to an external site.)Links to an external site.) or from one of the following repositories of data: http://www.datasciencecentral.com/profiles/blogs/20-big-data-repositories-you-should-check-out-1 (Links to an external site.)Links to an external site. Use either Excel or Open Refine (http://openrefine.org/ (Links to an external site.)Links to an external site.) to clean up the data set. Be sure that all of the text within each column is consistent. Save the dataset as an .xml, .cvs, and .xls formats.