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.