Python In Excel: Microsoft Changed EVERYTHING

Video Description

👨🏼‍💻 My FREE Course to be a Data Analyst 👉 https://lukebarousse.com/5daycourse Courses for Data Nerds ================================== 🤓 Google Data Analytics Certificate 👉🏼 https://lukeb.co/GoogleCert 🐍 Python for Everybody 👉🏼 https://lukeb.co/PythonForEverybody 💿 SQL for Data Science 👉🏼 https://lukeb.co/SQLdataScience 🧾 Excel Skills for Business 👉🏼  https://lukeb.co/ExcelBusinessAnalyst 📈 PowerBI for Data Viz 👉🏼 https://lukeb.co/powerbi-cert 📊 Tableau for Data Viz 👉🏼 https://lukeb.co/Tableau_UCDavis 🏴‍☠️ Data Science: Foundations using R 👉🏼 https://lukeb.co/RforDataScienceJH ➕ Coursera Plus Subscription (7-day free trial) 👉🏼 https://lukeb.co/CourseraPlus 👨🏼‍🏫 All courses 👉🏼 https://kit.co/lukebarousse/data-analytics-courses Books for Data Nerds ================================== 📚 Books I’ve read 👉🏼 https://kit.co/lukebarousse/book-recommendations 📗 Data Analyst Must Read 👉🏼 https://geni.us/StorytellingWithData Tech for Data Nerds ================================== ⚙️ Tech I use 👉🏼 https://kit.co/lukebarousse/computer-accessories 🪟Windows Virtual Machine for Mac (Parallels) 👉🏼 https://lukeb.co/ParallelsFreeTrial Social Media / Contact Me ====================== 👾 r/DataNerd 👉🏼 https://www.reddit.com/r/DataNerd/ 🌄 Instagram: https://www.instagram.com/lukebarousse/ ⏰ TikTok: https://www.tiktok.com/@lukebarousse 📘 Facebook: https://www.facebook.com/datavizbyluke 🙋🏼‍♂️Newsletter: https://www.lukebarousse.com/ 💬 Prompt in ChatGPT for Python in Excel ======================= 🤓 You are a distinguished data nerd that is an expert in both Python and Excel. 🐍 Excel recently released a feature allowing the use of Python within it's program. 💿 I have provided you an Excel spreadsheet familiarize yourself with the contents. 💬 When I provide you a prompt there is no need to ask if I'm ready. Just Do It. 🧑‍💻 I will be asking you questions and if it refers to python code I want you to provide me the results in the following format: 1. The expected results or visualizations 2. The full code snippet needed to insert into Excel 2a. When providing code snippets the last line of code in Python MUST be the output of the cell (whether a variable, or a chart) 2b. This last line does not require the use of the print() statement (a special feature of Python in Excel) 2c. The data has been loaded in the excel spreadsheet under the name 'jobs_df' 2d. The following is already imported in the environment (so don't re-import): import numpy as np import pandas as pd import matplotlib.pyplot as plt import statsmodels as sm import seaborn as sns import excel As an Amazon, Coursera, and Parallels Affiliate Programs member, I earn a commission from qualifying purchases on the links above. It costs you nothing but helps me with content creation. #datanerd #dataanalyst #datascience