A couple of months ago I wrote a short blog post about a new library I discovered: openxlsx. Here’s a very short blog post as a followup.
To read in Excel files in R using the openxlsx library, I use the following function:
However, one day, I ran into the following error.
Error in file(con, “r”) : invalid ‘description’ argument
I lost half an hour trying to solve this error, so I’m gonna save you the troubles: if you have the file opened in Microsoft Excel or a free alternative, just close it ;-).
By the way, if you’re having trouble understanding some of the code and concepts, I can highly recommend “An Introduction to Statistical Learning: with Applications in R”, which is the must-have data science bible. If you simply need an introduction into R, and less into the Data Science part, I can absolutely recommend this book by Richard Cotton. Hope it helps!