The FANG data set ships with tidyquant and represents the ouput of the tq_get(c("FB", "AMZN", "NFLX", "GOOG")) from 2013 to 2016. Let’s try it out.įirst, let’s get some raw data.
Start with a raw table in “long” format where each row is a unique observation.Excel Pivot Tableįor those that may have never used the Excel Pivot Table before, the process goes something like this. Honestly, when I came to R, one of the biggest things I lost was the Pivot Table - A tool used for quickly summarizing data into a digestable table. The Pivot Table is one of Excel’s most powerful features. library ( tidyverse ) library ( tidyquant ) library ( knitr ) ✅ Pivot Tables # devtools::install_github("business-science/tidyquant") install.packages ( "tidyquant" ) Please use tidyquant (>= 1.0.0), which is now available on CRAN. Register for New Learning Labs Here Replication Requirements Shiny App with Pivot Table using tidyquant Register Here for new Learning Labs (Free) - I go through real business examples where I showcase packages like using Shiny and tidyquant together (did this in Learning Lab 30). I’ll showcase a small portion of the new features in this post. ✅ NEW API Integrations (Implementation scheduled for March) To make the transition to R easier for Excel Users In tidyquant version 1.0.0, I have added the following features to support new useRs transitioning from an Excel background. Pivot Tables, VLOOKUPs, Sum-Ifs, and more Let’s demo several of the new Excel features! Articles in SeriesĮxcel to R, Part 1 - The 10X Productivity BoostĮxcel to R, Part 2 - Speed Up Exploratory Data Analysis 100XĮxcel to R, Part 3 - NEW Pivot Tables, VLOOKUPS in R! (You’re here) Read the updated ‘R for Excel Users’ on Business Science. This is the problem I aim to begin solving with the release of tidyquant v1.0.0.
You need to learn data structures, algorithms, data science, machine learning, web applications with Shiny and more to be able to accomplish a basic dashboard. They have ample domain experience in functions like finance, marketing, and business, but their tool of choice is Excel (or more recently Tableau & PowerBI). Most of these new userRs (R users) are coming from a non-programming background. New business and financial analysts are finding R every day. Written by Matt Dancho on February 26, 2020 R for Excel Users: Pivot Tables, VLOOKUPs in R