alessiopassalacqua / r_googletrends_italy

R Shiny + flexdashboard

R Shiny + flexdashboard with code

Motivation

This demo app demonstrates how it is possible to combine the best of modern R 📦 packages to create interactive web applications at zero cost and without HTML, CSS, or JavaScript knowledge.

The App: Google Trends Italy/US

Based on search term, the app takes data from google trends and shows results about Italy or US depending on the user selection.

These are the two main pages:

Dashboard

• Trends over the time and forecasting
• Interest by city (top ten)
• Regional Interest

Download Forecast Data

Link

• 🐱 github repository
• ✨ live app

History Version

1. Google trends Italy
2. Added google trends US
3. Added Download Forecast Data

R Packages

• ✨ {Shiny} provides an elegant and powerful web framework for building web applications using R.

• 📊 {highcharter} is a rich R interface to the popular Highcharts JavaScript graphics library.

• 💻 {flexdashboard} helps construct flexible, attractive, interactive dashboards.

• 🔧 {dplyr} contains a set of functions (or “verbs”) that perform common data manipulation operations such as filtering for rows, selecting specific columns, re-ordering rows, adding new columns and summarizing data.

• 🔮 {forecast} contains function for automatic forecasting determining an appropriate time series model, estimate the parameters and compute the forecasts.

• 📑 {stringr} contains functions for manipulating strings in R.

• 📅 {lubridate} facilitates working with dates and times.

• 📈 {gtrendsR} provides an interface for retrieving and displaying Google Trends information.

• 📝 {DT} provides a R interface to the JavaScript library DataTables. R data objects (matrices or data frames) can be displayed as tables on HTML pages, and DataTables provides filtering, pagination, sorting, and many other features in the tables.

Numbers

• 📄 1 file
• 🕚 1 day of work (starting from tutorials of one of my courses)
• ✍ 200 lines of code
• 🚿 30 %>% pipe
• 🤹 100% fun

Reference

• Sales Report with Highcharter
• Highcharter Italy Map
• Using Action Buttons
• Forecasting: Principles and Practice
• Pimp my RMD: a few tips for R Markdown