Looking for guidance in how to obtain factors associated with actual hours worked, and hours demanded for projects? It is more of a predictive analysis. I have a large excel file that seems to take a while to open up. Should I convert it to a csv file?
For large datasets, I suggest you look into the fread() function, which is inside the data.table package.
You can also look into the vroom() function, which is inside the vroom package.
Both functions help in loading large datasets fairly quickly.
For very very big datasets, the sparklyrpackage is what you should use: https://sparkfromr.com/