>>To load data:
RMySQL, RPostgresSQL & RSQLite – To read data form database.
XLConnect & xlsx – To read and write Excel files from R.
Foreign – To load data files from other programs(SAS, SPSS etc) to R.
>>To manipulate data:
dplyr – Essential shortcuts for subsetting, summarizing, rearranging, and joining together data sets. dplyr is our go to package for fast data manipulation.
tidyr – Tools for changing the layout of your data sets. Use the gather and spread functions to convert your data into the tidy format, the layout R likes best.
stringr – Easy to learn tools for regular expressions and character strings.
lubridate – Tools that make working with dates and times easier.
>>To visualize data:
ggplot2 – R’s famous package for making beautiful graphics. ggplot2 lets you use the grammar of graphics to build layered, customizable plots.
ggvis – Interactive, web based graphics built with the grammar of graphics.
rgl – Interactive 3D visualizations with R
htmlwidgets – A fast way to build interactive (javascript based) visualizations with R. Packages that implement htmlwidgets include:
leaflet (maps), dygraphs (time series),
DT (tables), diagrammeR (diagrams)
network3D (network graphs) &
threeJS (3D scatterplots and globes).
googleVis – Let’s you use Google Chart tools to visualize data in R. Google Chart tools used to be called Gapminder, the graphing software Hans Rosling made famous in his TED talk.