Uploaded September 2023 | Updated September 2026, 15 hours ago
ðšðŒâð» My FREE Course to be a Data Analyst ð lukebarousse.com/5daycourse
Courses for Data Nerds
==================================
ð€ Google Data Analytics Certificate ððŒ lukeb.co/GoogleCert
ð Python for Everybody ððŒ lukeb.co/PythonForEverybody
ð¿ SQL for Data Science ððŒ lukeb.co/SQLdataScience
𧟠Excel Skills for Business ððŒÂ lukeb.co/ExcelBusinessAnalyst
ð PowerBI for Data Viz ððŒ lukeb.co/powerbi-cert
ð Tableau for Data Viz ððŒÂ lukeb.co/Tableau_UCDavis
ðŽââ ïž Data Science: Foundations using R ððŒ lukeb.co/RforDataScienceJH
â Coursera Plus Subscription (7-day free trial) ððŒ lukeb.co/CourseraPlus
ððŒââïž My Courses ððŒ lukeb.co/courses
Books for Data Nerds
==================================
ð Book Recommendations ððŒ lukeb.co/recommendations
ð Data Analyst Must Read ððŒ geni.us/StorytellingWithData
Tech for Data Nerds
==================================
âïž Tech Recommendations ððŒ lukeb.co/recommendations
ðªWindows Virtual Machine for Mac (Parallels) ððŒ lukeb.co/ParallelsFreeTrial
Social Media / Contact Me
======================
ðŸ r/DataNerd ððŒ reddit.com/r/DataNerd
ð Instagram: instagram.com/lukebarousse
â° TikTok: tiktok.com/@lukebarousse
ð Facebook: facebook.com/datavizbyluke
ððŒââïžNewsletter: 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
ðšðŒâð» My FREE Course to be a Data Analyst ð lukebarousse.com/5daycourse
Courses for Data Nerds
==================================
ð€ Google Data Analytics Certificate ððŒ lukeb.co/GoogleCert
ð Python for Everybody ððŒ lukeb.co/PythonForEverybody
ð¿ SQL for Data Science ððŒ lukeb.co/SQLdataScience
𧟠Excel Skills for Business ððŒÂ lukeb.co/ExcelBusinessAnalyst
ð PowerBI for Data Viz ððŒ lukeb.co/powerbi-cert
ð Tableau for Data Viz ððŒÂ lukeb.co/Tableau_UCDavis
ðŽââ ïž Data Science: Foundations using R ððŒ lukeb.co/RforDataScienceJH
â Coursera Plus Subscription (7-day free trial) ððŒ lukeb.co/CourseraPlus
ððŒââïž My Courses ððŒ lukeb.co/courses
Books for Data Nerds
==================================
ð Book Recommendations ððŒ lukeb.co/recommendations
ð Data Analyst Must Read ððŒ geni.us/StorytellingWithData
Tech for Data Nerds
==================================
âïž Tech Recommendations ððŒ lukeb.co/recommendations
ðªWindows Virtual Machine for Mac (Parallels) ððŒ lukeb.co/ParallelsFreeTrial
Social Media / Contact Me
======================
ðŸ r/DataNerd ððŒ reddit.com/r/DataNerd
ð Instagram: instagram.com/lukebarousse
â° TikTok: tiktok.com/@lukebarousse
ð Facebook: facebook.com/datavizbyluke
ððŒââïžNewsletter: 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
