I am working on my Google Data Analytics Certificate and this part of my capstone project.
I was able to figure out with few search online as to how I can massage data.
I tested it using small excel file and it gave me what I needed.
Now, when I try to import actual excel file (131 MB), local RStudio just crashes. I tried using free RStudio Cloud, but RAM usage just explodes. Any suggestion?
With my test with small data set, I have figured out a solution, but I cannot get actual data (excel) in it.
Thanks everyone for help.