Part 2: Importing, Cleaning, and Transformation Steps for Case 1 (4 points)

The text file you will use,ETL_Case1.txt, is a comma-separated file. It contains balance sheet data extracted for several different companies. A screen shot of this comma-separated file is shown below.

Ticker, Name, Year, Cash, Accounts Receivables, Inventories, Total Current Assets, Total Depreciation, AAL, American Airlines Group Inc. , 2016, 3220000000, "1, 600,000,000", 1094000000, 10300, (14200000eee), AAL, American Airlines Group Inc. , 2017, 2950000000, "1, 800,000,000", 1359000000, 9100, (15600080eee), AAL, American Airlines Group Inc. , 2018, 2750000000, "1, 700,000,000", 1522000000, 8600, (17400000800), AAPL, "Apple, Inc.", 2016, 20500 M, "15,800,000,000", 2100000000, 106900, -34200000000 AAPL, "Apple, Inc.", 2017, 20300 M, "17,900,000,000", 4900000000, 128600, -41300000000 AAPL, "Apple, Inc.", 2018, 25900 M, "23, 200,000,000", 4000000000, 131300, -49100000000 ACY, Aerocentury Corp. , 2016, 2200000, 4000000,0,6,-23000000, ACY, Aerocentury Corp. , 2017, 8700000, 3800000, - ,12, -14600000, ACY, Aerocentury Corp. , 2018, 1500000, 4000000,0,5, -14700000, AEHR, Aehr Test Systems, 2016,900 K, "500,000" , 700000e, 9, -5700000, AEHR, Aehr Test Systems, 2017, 17800 K, "4,000,060", 6600000, 29, -6000000, AEHR, Aehr Test Systems, 2018, 16800 K, "2,900,060", 900eeee, 29, -6400000, AHH, Armada Hoffler Properties Inc., 2016, 21900000, "15, 100,000", ,0, -139600000, AHH, Armada Hoffler Properties Inc. , 2017, 19900eee, "15,700,080", ,0, -164500060, AHH, Armada Hoffler Properties Inc. , 2018, 21300000, "19, 100,080", ,0, -188800000, AMZN, Amazon. com Inc. , 2016, 19330000000, 8340000eee, 11500008000, 45780, -13330000000, A M Z N, Amazon . com Inc. , 2017, 31750000000, 166800060ee, 17170008000, 162650, -33970000000, AM ZN, Amazon. com Inc ., 2018, 20520000000, 131600600ee, 16050800080, 60200, -23790000000, APVO, Aptevo Therapeutics Inc. , 2016, 9700 K, 4300080, 6600080, 71, (66000ee), "(woooosz) 's6 'ooooootooeeetz'x Betz'Ltez OUI stinadevaul onandy'OAdv "(eemee48) '61 "weeeesteeeeezs'> eegee 'stez buI spranadevaul onandy'oAdv APVO, Aptevo Therapeutics Inc. , 2018, 30600 K, 5200000, 1808080, 49, (8700800)