Python In Excel: Microsoft Changed EVERYTHING

Veröffentlicht am: 06 September 2023
auf dem Kanal: Luke Barousse

448,336

6.9k

👨🏼‍💻 ChatGPT Tutorial 👉    • ChatGPT for Data Analytics: Full Course
🆇 X/Twitter 👉   / lukebarousse
🔗 LinkedIn 👉   / 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-anal...

Books for Data Nerds
==================================
📚 Books I’ve read 👉🏼 https://kit.co/lukebarousse/book-reco...
📗 Data Analyst Must Read 👉🏼 https://geni.us/StorytellingWithData

Tech for Data Nerds
==================================
⚙️ Tech I use 👉🏼 https://kit.co/lukebarousse/computer-...
🪟Windows Virtual Machine for Mac (Parallels) 👉🏼 https://lukeb.co/ParallelsFreeTrial

Social Media / Contact Me
======================
👾 r/DataNerd 👉🏼   / datanerd
🌄 Instagram:   / lukebarousse
⏰ TikTok:   / lukebarousse
📘 Facebook:   / 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

Auf dieser Seite können Sie das Online-Video Python In Excel: Microsoft Changed EVERYTHING mit der Dauer stunde minuten sekunde in guter Qualität ansehen, das der Benutzer Luke Barousse 06 September 2023 hochgeladen hat, den Link mit Freunden und Bekannten teilen, dieses Video wurde auf Youtube bereits 448,336 Mal angesehen und es wurde von 6.9 tausend den Zuschauern gefallen. Viel Spaß beim Betrachtenden Zuschauern gefallen!

15,872

128