How to make RIDICULOUS Tables in R (from Excel)

Hey guys, welcome back to my R-tips newsletter. In today's video, I'm sharing a RIDICULOUS R tip on how to quickly make AMAZING tables in R. We'll take a complicated Financial Cash Flow Statement, AND show you how to convert the table from Excel to R. Let's go!
💻GET THE CODE SHOWN IN THE VIDEO:
Join Free R-Tips Newsletter (To Unlock Code Access):
learn.business-science.io/r-tips-newsletter?el=youtube
📺 SET UP YOUR R-TIPS CODE (GitHub Setup Video):
kzbin.info/www/bejne/fGjEiolmh7WsepI
✨FREE R-TRACK MASTERCLASS (10-SECRETS THAT HELPED ME BECOME A DATA SCIENTIST):
learn.business-science.io/free-rtrack-masterclass?el=youtube
📚The 5-Course R-Track Program (Become The Data Scientist You Were Meant To Be)
university.business-science.io/p/5-course-bundle-machine-learning-web-apps-time-series?el=youtube
Table of Contents:
00:00 Welcome to the tutorial
00:28 Get the R Code Shown In The Video
1:08 Load the libraries & get the marketing data
1:47 Data Import into R from Excel
2:25 Data Cleaning & Data Preprocessing
4:22 Make the Table (gt & gtExtras)
9:22 Final Report Table
9:46 Learning More (Free R Masterclass)
#datascience #excel #rstats

[@jamesmoore2737]

Great Video on formatting with GT. A follow -up showing data manipulation from a raw data set would be very helpful. (I.e group and summarize, pivot wide, add rowwise and column wise subtotals and totals.) I often find myself doing the grouping and summarizing and pivoting steps in R and then exporting to excel to manually add all of the row and column subtotals and totals. Love to see how to do it all in R. For example, when creating an income statement, I can easily get to a pivoted wide view of the “input” lines ( I.e. the rows to be totaled), and then add the subtotals ( I.e total revenue, total cost of goods sold, gross margin, G&A, net income) manually in excel. Also a follow up with lubridate showing how to add year to date, fiscal year( Jan-Dec) , Trailing 12 Month totals ( and delta columns for the changes between these ) would be great

[@Matt-me2yh]

Outstanding video, I find the GT package very intuitive and visually stunning. Thank you for sharing your knowledge.

[@pabloramireziubini7361]

Can u show how to get the highlighted columns as a sum of the others?

[@mflc1105]

The data in excel was in millions, not billions! But if we still wanted it in billions, how would you add/remove decimal points to this table?

[@BusinessScience]

You are right. You can do the fmt_number() to adjust