Hey guys, welcome back to my R-tips newsletter. In today’s video, I’m sharing the cheat code to making an R shiny web app that automatically analyzes your company’s Excel Files. Plus, I’m sharing exactly how I made it in under 15 minutes. AND how you can do it for ANY company. Let’s go!
🌎 ***LIVE*** CHATGPT FOR DATA SCIENTIST WORKSHOP
HURRY, SEATS ARE LIMITED:
https://learn.business-science.io/registration-chatgpt-2?el=youtube
GET THE CODE SHOWN IN THE VIDEO:
📰 Free R-Tips Newsletter (FREE R GitHub Code Access):
https://learn.business-science.io/r-tips-newsletter
📺 SET UP YOUR R-TIPS CODE (GitHub Setup Video):
✨FREE R-TRACK MASTERCLASS (10-SECRETS THAT HELPED ME BECOME A DATA SCIENTIST):
https://learn.business-science.io/free-rtrack-masterclass
📚The 5-Course R-Track Program (Become The Data Scientist You Were Meant To Be)
https://university.business-science.io/p/5-course-bundle-machine-learning-web-apps-time-series/
Table of Contents:
00:00 Automatic Excel Analyzer R Shiny App (ChatGPT)
00:26 Get the R Code
01:01 R Shiny: Auto Excel Analyzer App
01:43 Basic Shiny App with ChatGPT
03:10 Prompt 1: Excel Uploader
04:18 Prompt 2: Add Visualization
04:53 Prompt 3: Include Sample Data in App
05:32 Prompt 4: Preview Sample Data
07:04 Prompt 5: Skipped – ChatGPT took care of this!
07:15 Prompt 6: Adding an Optional Facet Column
07:37 Prompt 7: Skipped – ChatGPT took care of this!
08:45 Prompt 8: Skipped – ChatGPT took care of this!
08:53 Prompt 9: Professionalize the Plot Appearance
11:14 LIVE ChatGPT Workshop
#chatgpt #r #excel #shiny
