Python In Excel: Microsoft Changed EVERYTHING
👨🏼💻 ChatGPT Tutorial 👉 https://youtu.be/uhyMqbZI6rM
🆇 X/Twitter 👉 https://twitter.com/LukeBarousse
🔗 LinkedIn 👉 https://www.linkedin.com/in/luke-b//
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
📊 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
Видео Python In Excel: Microsoft Changed EVERYTHING канала Luke Barousse
🆇 X/Twitter 👉 https://twitter.com/LukeBarousse
🔗 LinkedIn 👉 https://www.linkedin.com/in/luke-b//
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
📊 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
Видео Python In Excel: Microsoft Changed EVERYTHING канала Luke Barousse
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
Python If Statements for Data Science / Data Analysis - P.2Python List Comprehension for Data Science / Data Analysis - P.4How To Use Tableau Desktop Controls - Tableau Tutorial P.2Dimensions Vs Measures (Blue Vs Green Data) - Tableau Tutorial P.3What is Business Intelligence (BI)? 📊😅The BIGGEST MISTAKE when starting a data project!Use THIS to showcase EXPERIENCE in Data SciencePython for Data Analytics - Full Course for BeginnersPython for Data Science / Analysis ft. 'The Office' Dataset - P.0Google’s BI vs. Advanced Data Analytics CertificatesGet NOTICED in Data Science!!! (3 types of GREAT projects)Staying Motivated in Data ScienceTop Apps I Use as a Data AnalystHow I Learn Faster with THIS 😴Python Objects frequently used in Data Science / Data Analysis - P.1Google vs IBM Data Analyst Certificate - BEST Certificate for Data AnalystsRejection is never easy 😔PROJECTS that landed Data Jobs for my SubscribersTop Jobs in Data ScienceSQL for Data Analytics - Learn SQL in 4 HoursTHEY became Data Analysts with NO degree