Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

we are supposed to change the format of challange2.txt, to the format in the box

ID: 3857578 • Letter: W

Question

we are supposed to change the format of challange2.txt, to the format in the box, using R studio. we are not supposed to use "RESHAPE". we are to use for loops and if loops. please add comments so i can understand

e can't conne COM 337_AI COM] 13Ap Assignment COM31 3Ap COM337-RE COM337 Ri COM337 Ri Assignment Protege wl COM13: × file://cusers/Aisi fil///CsUsers/AISH e,Google, Apple, M1C2050tt 01/03/2017, 829,143, 65 01/02/2017, 023,136, 63 03 01/2017, 79e,120, 4 01/12/2016,771,115,1 01/11/2016, 758,110, 59 03 10/2016, 704,112,59 01/09/2016,777,111,56 01/08/2016,767,105,56 01/07/2016, 768,102,55 01/06/2016, 692,94,50 02 05/2016, 735, 98,52 04/04/2016, 693, 91,48 You may have to wrangle with the date using a Text editor to remove the characters before input into R Read this file into a script named Challenge#24R Convert this file content to the format as data frame SP SYMBOL DATE GOOG 201703 829 APPL MSFT Where G00G-Gcople APPL-Apple MSFT: Microsoft 201703143 201703 65 SP- stock Price Using the following format, write this data frame to a file named inputChallenge#2Btx replace use write. table to suppres auto column generation write. table(subcriberDataFrame, "subscriberCount. txt row.names-FALSE, ncol.names-FALSE quote-FALSE sep-",") 3. Now in s script named Challenge#28,R, read this file and produce a line chart that shows the performance of the stock price for GOOG, APPL, MSFT in the period shown in the DATE column. Never say die until you are 6 feet 1607/20177

Explanation / Answer

you can dot that by just using replace("/","",columname) and substr(columname, 1, 7)