Python In Excel: Microsoft Changed EVERYTHING

Courses for Data Nerds
==================================

Books for Data Nerds
==================================

Tech for Data Nerds
==================================

Social Media / Contact Me
======================

💬 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 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

[ydmoskow]

I'm an Excel "expert" that has struggled to learn python. This gives people like me the perfect comfort zone environment to learn python as opposed to something like vscode

[michellemorales]

Husband and i just found your videos!!!! Im getting ready for a job interview as Data Analyst so using all your tips!!! thanks for all the knowledge shared!!! :D

[qweng]

First time making a comment to Luke:
This implementation is amazing! The allowance of python in excel built that bridge, so each expert from one or the other can have some sort of connection, Also thank you Luke for making briliant videos on all sorts of newest tech skills that was introduce. I am a master student in the final year in Data Analytic. Hope to see so much more from you!

[ginokalmeier]

You're so good at conveying the content in an informative and entertaining way. Keep it up👍

[ronanmry]

I already use pyexcel, a python module to edit and use date from a excel sheet, and it's amazing. Knowing that python is implement by default will clearly replace visual basic after

[mohamednour]

Man the quality of the video is on another level 🔥🔥 i really appreciate the amazing efforts you're giving to this. Thank you luke

[Cahangir]

I hope your channel gets more recognition. Keep up the good work!

[SalientInsights]

Luke you absolutely crush your videos, extremely well done. Honestly you are a major reason we started a channel, only hope to one day be on your level of quality and value add. Having started I am not sure how many people know what level of effort you put in to make these and how long it took get this level of quality.

[steampunk]

with this feature i could really see some guys working as controllers getting into programming

[alexaneals]

Good video. Although I don't actually use Excel or Python for much, it's still interesting to see what can be done. I only use Excel to create some quick and dirty data sets for testing. It's convenient to generate insert statements when you need to populate a table with test data.

[shoboyjr]

One of the best Python in Excel analysis that I've seen. Well done Luke. keep it going.

[AhmedGamal-mins]

Wow, this video is awesome! I learned a lot of new things about Python and Excel. You have a great way of teaching and engaging with your audience. I can’t wait to see more of your videos. YOU ARE THE BEST.

[Chikowski]

I just love to watch your videos luke I love python !!

[tak]

Thanks Luke for sharing and bringing your entire personality into this one lol. You made it informational & enjoyable.

[Theultrazombiekiller]

I'm a marketing operations analyst and only use Excel. The nice thing about marketing analytics, is the data is always provided to you by BI groups or CRM/GA4 reports. No data science or mining is required, at least in my position.

[StarLand-glqj]

Wow, such fun and informative too! The chart example A+

[eddysin]

Yo Luke rules as always..Great learning even the panda in video is happy..😊

[theresaparker]

I love Chat GPT. I'm learning database management and I use Chat when I can't figure out what code I need or how to write it. I love that it explains everything in plain English better than the instructors for some of the courses I'm taking. I know Chat is going to be one of the best tools in my data arsenal. Keep the great videos coming, Luke!

[Limestarz]

I think Luke hits it on the head with the experience excel users, and that you can pretty much do everything in excel if you know all the formulas, so I don't think python in its beta state will do much except for maybe a few edge cases that might be cool.

And to expand on that a little excel has pretty much all those functions that you can do in python already, including the graphs. You can do heatmaps, histograms, and even do linear regression, etc in excel and you don't need boiler plate code to do it or even have to use chatgpt as mentioned for noncoders/lazy coders. I personally find seaborn graphs to be terrible looking (almost all of them, a few look good). The dashboard shown in the video looks clean though, so that looks intriguing, but I would be remise to say that you can do a version of that probably with a pivot table (maybe?) and an advance/expert excel users I work with usually make pretty clean looking excel files that do a bunch of fancy things. That dashboard did look really clean though, but I don't know how much of that you can replicate just through excel because I know filters work basically the same way but just look a little uglier.

So, I'm not convinced right out of the gate that anyone would be able to flex their python skills to all those excel users at work because the graphs are already done and most of the "analysis" is also already been done in excel so anything brought to the table via python is usually not something that anyone would notice (simply because excel can do most of what python can do anyway). I don't know how much machine learning you could reasonable do in excel that, 1, your job would need if they are using excel to begin with, but 2 size limits as mention would limit machine learning to a small degree, but mostly machine learning is at least advance machine learning is a little too complicated to use chatgpt.

The main reason I use python with small office data is primary to automate reports and connect it to other things like outlook for automated emails etc.

Honestly, I think its just better to do python in an installed environment/ide like vscode or jupyter notebook so you can use other modules.

[DeltaXML_Ltd]

Very good video and informative. Keep it up!