Automate the opening of Excel files in R

How to automate the reading and opening of Excel file (or csv or other) in R

Marie Vaugoyeau

6 minutes read

It can happen that you have a folder full of data files (Excel or other) and you need to import several or even all of them into R.
Doing it by hand can be long, time-consuming and error-prone… so let R works.

Principal Component Analysis

How I do Principal Component Analysis and choice of n factors

Marie Vaugoyeau

10 minutes read

With article about correlations, we saw data from airquality were correlated.
Sometimes it is need to use Principal Component Analysis (PCA) to determine non correlated variables in order to analyze data.
It is the subject of this blog article and especially, how many new variables were needed.