The worth of the small island of Guadeloupe, along with most…

The worth of the small island of Guadeloupe, along with most of the islands in the Caribbean, was much greater than any of the much larger colonies in North America, primarily because of this one crop and natural resource, which became the primary reason for the enlargement of the West African Slave Trade and territorial fighting between European nations.

The file below contains 5-year check out history data of Chi…

The file below contains 5-year check out history data of Children’s Book/Disc at a local library.   Data file: Check Out History for 5 Years by Holdings Code.xlsx Please prepare the data file for further analysis using Microsoft Excel, Tableau Prep, or BOTH (hint: Use Excel for #1 below and Tableau Prep for the rest) At the minimum, the clean data file should have the following characteristics: The final data file should… include column headings on the first row not include totals and report footer not include merged cells (Row 127-128 must be corrected) Title column – use all uppercase letters for the title data Publication Year (008/07-10) column – should be renamed to Publication Year Author column Separate author’s first name and last name on two different columns called Author First and Author Last Separate the DLC number into a new column called DLC.  Try your best to keep only the numbers. For example,  Author DLC Pearson, Ridley, author. (DLC)n 84199915 84199915 Include only the following columns in the final, clean data file in this order: Item Barcode Title  Author Last Author First DLC Status Publication Year Last Circulation Date 2019 2018 2017 2016 2015 Prepare the final data file in a CSV format and upload to this question.  Note: this is an actual data file and is quite messy.  Please try your best.  Upload the cleaned data file in a CSV file format to this question.  You will explain the process utilized when cleaning this data file in the next question.