Detect sentinel values, recode factor variables, replace missing values: a tutorial on various steps in data preparation using R.
A live class for beginners: learn the basics of R, and get an overview on methods for data import, data manipulation, data visualization and data analysis.
A method to gather data from different sources, sort them and keep a reference to the origin of each subset, plus some efficiency considerations
XLConnect allows to create a formatted spreadsheet usable as a dynamic report of the R analysis. Discover how to link R and Excel with just a few steps
R is a powerful system for statistical analysis and data visualization. However, it’s not exactly user-friendly for data storage, so, still for several time your data will be archived using Excel, SPSS or similar programs.
How to open into R a file stored using the SPSS (.sav) format? There are some packages as
foreign which allow to perform this operation. The package foreign is already present in the base distribution of R system and you just need to activate it using the function
Many people still save their data into Microsoft Excel files. This is an unhappy choice for many reasons but many was already written about this topic. Furthermore, unfortunately Excel become a de facto standard in many business environment and this routine seems to be difficult to strike out.
Many solutions have been implemented to read Excel files from R: each one has advantages and disadvantages, so an universal solution is not available. Get an overview of all the solutions, allows the choice of the best solution case-by-case.