Here is a new episode of the series “R for Excel Users”. In it we are looking into how Factors work in R and how to make the most out of them. Enjoy!
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.
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.
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.
Pivot Tables in R with aggregate
I noted that a previous post about Pivot Tables in R with melt and cast has gained quite some popularity, so I thought to write on the same topic but using this time a different R function: aggregate. While aggregate is not as powerful as melt and cast from the reshape package, it may result sometimes simpler and more intuitive to use, so it is worth to learn how it works.