R for Excel Users #5 – Manipulating Data Frames

Hello,
I just uploaded to YouTube a new episode of the series “R for Excel Users”. Today we will be looking at how to manipulate Data Frames in a proper and effective way. If you like this series and would like to be informed when new episodes are posted, you can subscribe to this blog through the subscription button on the right. Enjoy!
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

ggplot2 to PowerPoint in RStudio

R with ggplot2 is capable of producing visually appealing charts and is definitely more versatile than Excel for what concerns graphical representation of data. When it comes to presenting the results of an analysis though, PowerPoint is still the most widely used application, at least in the business environment.

This article shows a workflow to bring your ggplot2 charts to PowerPoint automatically, so you can build your analysis presentation directly from an R script within RStudio.

Continue Reading

World population infographic with R

R is not just for statistical analysis and data mining, it can also be employed to prepare nice infographics. Here is a quick example of infographic with R.

With few lines of R code we can create, starting from commonly available data, an infographic showing the relative magnitude of the population for the different countries around the world, with the country name placed on the country centroid (like it would be on a map) and the font size proportional to the population size. Simple but impactful!

Continue Reading

Interactive map of world population with R

Recently I have been experimenting with R’s data visualization capabilities and I wanted to test how the maps plotted with rworldmap could be made interactive through the manipulate package, part of RStudio. Interactivity can add a lot to our understanding of complex data sets, where variations happens along multiple dimensions. To get inspired on the topic you can watch this great Ted Talk  by Hans Rosling: Stats that reshape your world-view.

Continue Reading