R for Excel Users #3 – Data frames and special R values

I have just released the third video tutorial of the series “R for Excel Users”. In this episode, we are getting to know data frames and learning how to use the special data values in R, namely NA (Not Assigned), NaN (Not a Number) and +Inf/-Inf (positive and negative Infinite).
If you like this video series, please let me know by leaving a comment to my blog or my YouTube channel. Thanks!
Have fun with R!
Ciao,
Marco.

Continue Reading

R for Excel Users #2 – Data manipulation

I have just released the second video of the series “R for Excel Users”. In it we will be focusing on data manipulation. If you enjoy this series or you have recommendations to improve it, please feel free to let me know. Leave a comment here on YouTube or contact me through the contact form on my blog. Thanks!

Ciao,
Marco.

Continue Reading

R for Excel Users #1 – Basic data

Hello! I have started a new series of videos dedicated to those who are already familiar with Excel and are seeking to learn R the easy way. Through a side by side comparison with Excel, you will learn how R works until you master it! Here is Episode #1. Let me know if you like the series and if I should keep it going.
Ciao,
Marco.

 

Continue Reading

Pivot Tables in R with melt and cast

If you are making the transition from Excel to R and still can’t figure out how to quickly obtain pivot tables like Excel has, this article is for you!

Actually it is pretty easy to produce Pivot Tables in R. All you need is a package called reshape by Hadley Wickham (yes, the same prolific author of plyr and ggplot2) and some understanding of how reshape “thinks” and works.

Continue Reading