Read Excel files from R

R blog By July 22, 2013 Tags: , , , , , , , , , 13 Comments

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.


A possibility for use R and Hadoop together

R blog By July 9, 2013 Tags: , , , , , 1 Comment

As mentioned in the previous article, a possibility for dealing with some Big Data problems is to integrate R within the Hadoop ecosystem. Therefore, it's necessary to have a bridge between the two environments. It means that R should be capable of handling data the are stored through the Hadoop Distributed File System (HDFS). In order to process the distributed data, all the algorithms must follow the MapReduce model. This allows to handle the data and to parallelize the jobs. Another requirement is to have an unique analysis procedure, so there must be a connection between in-memory and HDFS places.


A Big Data introduction

R blog By June 5, 2013 Tags: , , , , No Comments

Since R uses the computer RAM, it may handle only rather small sets of data. Nevertheless, there are some packages that allow to treat larger volumes and the best solution is to connect R with a Big Data environment. This post introduces some Big Data concepts that are fundamental to understand how R can work in this environment. Afterwards, some other posts will explain in detail how R can be connected with Hadoop.


Operating on files with R: copy and rename

R blog By May 22, 2013 Tags: , , 3 Comments

Nowadays, routinary operations on files, such as renaming or copying, are performed with some mouse clicks. Sometimes, it is useful perform this operations in batch. Linux users perform this operations through the shell. Also Windows users can use the shell, but there are also a lot of utilities that simplify these operations.

Why someone should use R to copy or rename a (lot of) file(s)?


Presentations of the third Milano R net meeting

3rd MilanoR meeting, Downloads By April 19, 2013 No Comments
  • Welcome presentation
    Nicola Sturaro, Consultant at Quantide
    (download PDF, 0.5 MB)
  • Machine learning
    A case of digit recognition based on a shallow neural network implemented in R.
    Michele Vitali, Statistical consultant
    (download PDF, 0.2 MB)
  • Chess betting odds
    How to develop a shining web app, scraping the web and building a model to calculate the odds for the chess team events, in no time with R, RStudio and Shiny.
    Alberto Santini, Banca Monte dei Paschi di Siena
    (download PDF, 0.2 MB)