So is this an add-on to Excel or part of the Excel version? Do you have to install python on your computer? Trying to understand the install setup or dependencies.
Python don't actually offer extra functions that are not already available within Excel... You are now showing how to remove our jobs within the administration industry.. What you are not showing is the imagination needed to interpret the data to assume new conclusions. Please suggest I am wrong.
These developments will free up more time so we can take more time to interpret the data and come up with ideas and action plans @@jamesantonywhitehead2814
I have been learning python this year and most of the stuff you illustrated is relatable. It seems one does not need to use Jupyter notebooks or Vs code to import data from excel. You just work with your data straight from native excell. Mind blowing!!!!
Be interesting to know how many Python libraries are available to excel. You can already do a great deal of stuff in the video in excel; THE ORIGINAL DATAFRAME 😁 Let's see if the Spacy and Top2Vec data mining stuff can be pip installed...?
this does not make much sense yet to me. Importing excel in python is one liner dude. And convert any big data to dataframe means eat up your ram... nah, already learning python or already know it, directly write script, and get most of power!
Thank you so much for this great overview. I am super proud of what our team has been able to do for Microsoft. And the work that the Excel team has done is off the charts (heh). They put so much thought on how best to put Python in the grid. Of course, this is just the beginning-more will come. Thanks again! Michael Grant, SVP, Enterprise Anaconda, Inc.
Excel was already getting great updates lately but this is on another level! Really excited to start using this. Thanks Michael & your team for this. :)
I am so glad I learned python this past year ! This is gonna be so helpful 🎉🎉🎉. To everyone who wants to learn how to code in python, please do not be afraid and do it. Python is way easier than VBA to learn within weeks you’ll be able to write your own code and within months write code with more complexity. Do not let yourself be your own obstacle. If I did it you can do it !
Hi. I did something similar last year. I did the 100 days of Python by Angela Yu on Udemy but lost interest because the course was so outdated that a lot of the solutions don't even work anymore. What course or Bootcamp did you do?
@@zaheer25 hi 👋, I did the same course you did. After day 50 or 60, I just flash forwarded to the more advanced course of data analysis and portfolio project with pandas. After that, I took real projects. What I mean by real projects I registered on freelance website such as Fiver and Upwork and comeup. People reached to me for doing some data analysis job. Taking project is really the hard part and the fun part. Because every single person will come to you with an unique request. I was able to manage multiple projects it was very educating for me as a développer. I really encourage you to do so, to me it’s the best way to learn and any développer will tell you the same
Allow me to add that with ChatGPT and stakoverflow, you’ll be able to work way more faster and still need to put in application what you learned in Angela’s course
Hi, Leila! This is fantastic: Excel (now) using Python! I began learning Python, and sometimes I use Pandas library to open .XLSX or .CSV files to a dataframe, exclude NaN values, etc., generally using Jupyter Notebook or PyCharm to write the programs. Now, these programs can also be written in an Excel sheet! Thanks for your explanation! Greetings from São Paulo, Brazil!
This is actually amazing. One thing you kind of touched on but didn't really dive into is that pandas can make pivot tables too. So basically this just solved one of the oldest most annoying limitations of excel for me which is making automatically/dynamically updating pivot tables. No more bodging to force the pivot table to refresh at strategic points. Just make a pandas pivot table and because it's a formula it's always up to date and dynamic.
Funny the interview question I had for my current job was to make a pivot table that auto-updates. I achieved that by using a combination of UNIQUE() and xxxxIFS() functions. I agree Python constitutes a more robust solution here; but everything could be done already with a little bit of creativity.
This is going to change excel on a fundamental level. The way they integrated it makes it so easy to use for anyone with basic Python skills. Or even with basic Pandas skills.
Everything shown here can be done pretty easily without any python or vba. I suppose it gets more useful later on . The one benefit I do is that it can generate outputs with fewer risk of errors
@@ms3862 Yes, the demo stuff can be done without. It doesn't take much creativity to imagine all the stuff that can be unlocked. I'm using Pandas on a regular basis because Excel has it's limits and I maintain a lot of sheets that are on the brink of breaking because of the load of data. It's so well integrated, that it seems much easier than VBA. I can't see how one cannot be hyped about this =)
@@ms3862 It is way quicker with Python. You can scrap Pivot tables and visualisation tools from Excel. Now it's a matter of just writing a few words. If you just use excel to get average values, then of course Python is not a better option.
While this is currently beyond me, I am glad to learn what is possible and what is coming down the pike. I am storing this away in my "I may need this sometime" file. When the need arises, I know I'll come back here to learn the details. Thanks Leila!
I've watched several videos about this now and this is the first one that got me excited about Python in Excel. The other ones focused too much on the "cool" charts you could create. When it comes to charts, I'm team "simple is best" so I knew I wouldn't need this much. One definite exception are the geoplot libraries. But your examples showed examples that will be actually useful for data analysis and when you said that we can link to Power Query, I got REALLY excited. When analyzing large sets of data, I don't want them in the workbook and no longer having to rely on Pivot tables is wonderful since people tend to forget they have to update. I can see this replacing Power Pivot. I'm definitely looking forward to you posting more videos about Python. Thank you very much!
I’m glad this finally exists. I was looking for this about a month ago and figured out a different way to do what I needed at the time, but it’s nice to know this is available now.
For years, I used to switch back and forth between Python and Excel depending on the case. Finally seems I would be able to do the work within one environment. Aside from the pandas and dataframe stuff, i am hoping we can use Python to replace VBA (at least partially)
yes, for quick and easy calculations, great, but for large database processing, definitely a specialised IDE for Python or R, you still have Excel's big problem, working with large databases.
For small data set, yes. You don’t have to be a DS. However, in this digital age large data is so common, this will demand the data science/big data skills … so both will co-exist…
Really useful video. I've always wanted to get more into data analysis, but the software we use at work generates the absolute worst reports, and finding creative ways to scrape for the data I need in Excel always feels like such a chore and changes from year to year. What little you showed in this video already has me really excited for how much more intuitive it's going to be for me to get the data I need quickly. Thanks!
Let me tell you that, as a programmer, this looks way more sensible and enticing than the “user friendly” (=restrictive) environments like Tableau or Sisense/Periscope.
This is truly amazing! can't wait for the the full deployment of Python in Excel for data science. Big fan of Excel - always relevant!! Thank you for sharing this, Leila!!! I am truly screaming as I watch your video!! Embracing Data Science in Excel!!!
Very useful for an ex-python developer who ended up having to learn Excel since most users were not comfortable in using a web front end. Easy Peasy stuff, love it.
The news only just broke an hour ago. Clearly, you knew about this before the rest of us to get this video out! 😂 Very exciting possibilities await. Excel + Python = The Dream Combination.
One of the advantages of being an MVP but emotionally I have to keep my feelings and excitement to myself until I can talk about it. It feels very freeing now 😇
Hi Leila, another amazing video. I was exposed to this a while back but course was complicated for non programmers. You did an incredible job of breaking this down into simple examples and showing its power. Thank you!
This is really cool!! I happen to know both Excel and Python including pandas, matplotlib among others. Am so excited and can’t wait for this to be released from beta 😊
Thank you for showing us this, Leila. This is the first time I can remember seeing a popular programming language incorporated into an already popular but proprietary application. (I'm not counting SQL being integrated into the various PC database management systems, because the result of that was too many new flavors of SQL.) A lot of students nowadays are graduating high school and college with Python experience, and Microsoft clearly wants them as customers. If Python had been integrated into Excel 13 years ago, when I had a contract job with a major corporation to work on an excruciatingly complex Excel model (multiple workbooks on multiple network shares with charts, tables and code all over the place and daily mainframe data feeds), I would have been able to accomplish a lot more. I've never programmed in Python, but I've learned a number of programming languages, and those Python libraries' straightforward commands are refreshing to me after dealing with all the noodling around I've needed to do in the Excel interface when I need to do any sort of analysis or regrouping. Of course, your videos help me out a lot with that as well.
pandas initial release 2008-01-11; hmm, was pandas that powerful 13 yrs ago in 2010 too 🤔?? > _"If Python had been integrated into Excel 13 years ago"_
This is brilliant, thanks. Superbly explained so you don’t have to be a data scientist to understand it - but it introduces the main terms and processes that data scientists use. Can’t wait to use it myself!
I've looked at Excel and taken a class or two, but wasn't too excited to learn much beyond how to get some pretty print out of it - now that Python is involved I can see this as being something in this century!
I've always wanted Matlab/Octave integration where cells can refer to matrices or even 3D arrays (without having to see the contents). This is probably even better (though I'm not a python pro). Exciting!
@Leilegharani. This is a fantastic overview of python in Excel. I've used python via jupyter notebooks for the past 7 years, but now to have this in Excel....potential game changer and cost saver when coupled with power query and even power automate.
Fantastic demonstration of the functionality. I can see the use for quick adhoc aggregations and transformations, however Excel is a sub-optimal environment in which to use Python, especially so if you're a beginner. If you're going to go the effort of learning Python simply import your .xlsx or .csv into an IDE like PyCharm or Jupyter Notebook that is designed for the purpose of iteratively developing your code and creating visualisations etc. This way your code can be structured, sequential and clearly legible to you and others, not just bunched up in the formula bar with you having to resize cells to view a chart.
I hate to be negative, but I agree as well. The great thing about Pandas is automation and being able to work with massive datasets, Excel is really weak in this aspect.
We want a whole Udemy course on this. This is what I had always wanted. Wondering if python in excel can take inputs for python variables directly from cell values in excel?
What I think is really cool about this is that it makes it possible to do machine learning in Excel. Python has had the ability to create Excel files for a long time with a library like openpyxl, but now instead of sending a .csv file to a machine learning engineer, it would seem that it's possible to import the .py file directly into Excel and pass a Panda dataframe directly into a function in the .py file. This opens up the possibility of doing things like; clustering, classification, and multivariable regression on the fly. I can see data analysts loving this.
That's a great thing. People will quickly learn Python and realize they don't need Excel anymore, they can just switch to using more reliable tools like versioned Jupyter Notebooks + versioned CSV data files + versioned source code
Still not entirely sold on using Excel at all. I use Python to automatically read/parse excel files and automatically output the data to custom built Python user interface. Opening Excel and selecting the data to use, is just an extra step not needed. yes... not everyone knows how to building custom UI's with Python....but if you know how
Looks very interesting. I use python a lot for scientific calculations. The most used modules are numpy, scipy, and matplotlib. By now I probably have more than 1000 functions that I have written. It will be interesting to see how this works with XL.
I am grateful for your videos. I have literally learnt excel from you over the years. I always ask anyone willing to learn excel to look for your videos for the easy explanations.
This is one of my biggest regrets growing up. I should have learned to code. This is so exciting for new Excel users. I am still learning VBA for macros as it has helped me in my work for alot of times. I am hoping to learn more on how Python will be useful in my job. Thank you Leila!
relatable, i have been VBA guy for long time, despite learning Python I could never code it, but with ChatGPT, I'm able to create python codes easily and have the script running in minutes, so you should also be able to code in Python soon, Good Luck!
One type of chart you can do in Python, but can't really do in Excel is heatmaps. Useful if you want to visualise data in two dimensions. For example, during the pandemic, I created a chart that had age in the y axis, date in the x axis, and the infection rate for each date/age pair displayed as a shade of colour from white for 0 to a fully saturated dark colour for highest value. You can put the numbers in a pivot table and do conditional formatting to get something similar, but it doesn't work so well. Also, when you are dealing with millions of rows of data, Python, especially if you use the Numpy library, can be a lot faster. In one example I had, calculation time went from 6 hours on Excel to 10 seconds on Python/Pandas to 0.1 seconds on Python/Numpy.
Python is so easy for things that were awkward in Excel, I found that even just putting an average line in a plot was easier in Python than Excel. I always used py for sourcing and cleaning data. I'm happy about this upcoming feature.
Really great news. Personally, I'm especially interested of working with matplotlib in Excel as this would give possibilities of chartings not available directly in Excel (at least without addins ). Working with connections only seems also to be a big 'yes'. I'm a bit curious though od three are plans to bring It to Excel online as well (or if It will be at least compatible even if code is prepared in desktop version)
I've been using python for a while. It started because excel just couldn't handle large data sets. I find this interesting and somewhat useful. Now that I am in python a lot, not sure how often I will jump back to excel. Thank you for sharing!
Wow! I know R language and have used it with Excel, but Python right inside Excel is something amazing! This will surely be a game changer as combining these two powerful tools will double the power and open up so many possibilities! Thank you Leila, for this wonderful and informative introductory video! BTW, expecting a series on Python from you now, to help us do the magic! 🙂
@@nathasyapramudita6312 Python is great to learn alongside R, native Microsoft intergration will exponentially increase the want for it in the job field in the future.
@@nathasyapramudita6312 No worries, you can still learn Python (it's lot easier than R) and you will have tripled your skill set, that will fetch better opportunities and returns. Good luck! 🙂
Unfortunately, this is pretty useless. Better to just learn python with juypyter notebooks, that way you can automate these excel tasks with any size datasets.
Fantastic, fantastic, fantastic, Leila! glad to be back on your channel, watching your content and your contribution. Finally, I got the chance to go through the whole video! - loving everything you shared, and for certain, I will emulate your small multiples example. Thank you, thank you! 🙏
Hey bro, dont like Excel too much but this update from MS is sick, as a matter of interest, do you have links for the Google sheets equivalent of this PY integration?
This is music for my ears!!!! i 've been waiting for this so long! actually i was thinking that due to MS has already embended TYPE SCRIP in excel .....I thougth that this could be its official languague for excel ( replacing vba) ...but now comes out with this great surprise! and obviously Leila the 1rst one to lunch it to all excel lovers!! Excellent video amiga!!! and the cherry on the top of the Pie was that can interct directly with Power Query OMG !!!!!
this excel integrating python stuff is next level for real but honestly, think it might be a bit overkill for the everyday excel user who's just crunching numbers not everyone's ready to dive deep into python, even if it's just a few formulas still, props to the creator for breaking it down and making it digestible if you're looking to level up your excel game, this is the sauce but it ain't for everyone. keep it 100!
This is excellent!!!! I love Pandas and Python, and hate M Formulas, so that last tidbit has me very excited indeed. The only thing that could top this is replacing VBA with Python, or proper integration into VS Code! We can only dream.
I wonder if there's a panda library for bass 64 encoding/decoding. That way you can put your code in and make it with entropy so it looks like data and gets ignored by EDRs like crowdstrike
If you can find a base 64 encoder decoder in Pandas you can then put your code in as high entropy data that will be ignored by EDR. This is only going to get worse.
Amazing video as always❤. Being a loyal student to lots of Xelplus courses, would you consider developing a course for Python in Excel? Really loves the way you teach new concepts and integrate real-world examples.
The horror! Imagine Dataframes and different excel-files and versions all over the place. No source control, hard to audit and really every code junkie can create stuff. I was so happy that Power BI was finally stopping the excel-based-data architecture you find in so many companies. I think this will make everything worse. Don't misunderstand me here: yes it is powerful to put Python in Excel. But it will create tons of poorly managed technical debt. Add the monkey code of chat-GPT to that and the chaos is complete.
Microsoft leadership has no coherent vision. They are slapping everything they can into Office with no real plan. Let's see: we can program in the original Excel Macro language, or VBA (whose development ended years ago), a dodgy API, or JavaScript (never really implemented). We also have Array functions (of {old} and new types--with the same functionality), Lambda functions (still sorta kludgy), and now Python. If they would just completely FINISH the features they already had, we probably wouldn't need many of these bolt-ons. The Excel object model is a nightmare of half-started ideas. The number of bugs that have persisted for 30+ years is truly staggering. Adding Python in cells is not bad in and of itself, but HOW MANY different languages do people have to learn to use this thing anymore? MS is doing this across ALL of their product lines and it's truly a mess--especially for developers!
Excel-On-Steroids... WOW!!! the script language was really nice addition, but python inside Excel... just blew my mind... this takes Excel into a whole new realm of possibilities. Thanks for sharing Leila, as always, super informative and clear videos. 😃
the fact that created dfs update themselves can come very useful. Usually when you construct a dataframe starting from some datas if you change those datas after creating the df you dont see the df updating accordingly unless you run again the pd.DataFrame( ---) constructor. Here you have the df you create with the xl function updating accordingly.. really REALLY useful.
I know you're not Microsoft but I know there's a lot of other folks with this same problem that are preventing access to Python functionality in Excel, and that is that I can't access the Microsoft Beta Channel even though my account page says "You're signed up to beta channel". I spoke to Microsoft today and they said that unfortunately the demand for beta channel products was so high that they stopped access for a over a million folks that had already been signed up for the beta program - but they can't take us off the sign-up list. So in other words, "you have access to Python but you actually don't until we figure out how to serve that many customers." That's Microsoft for you!
for me this video was a magic show ... as I always say "You are a great teacher" ... slow and steadily making others think differently through your wonderful teachings ... thank you so much ... God bless you
I love you I love you I love you (in a brotherly way). You are by far the best instructor when it comes to EXCEL by a lightyear. Keep up the good work!
This is so exciting. Just recently i developed a very complex financial plan which can be sinplified with Python. Now I'll be able to do it within Excel
I think having an IDE like we have in VBA would make most sense. You can still reference the code from an excel cell, but having a dedciated IDE would be best for larger code stacks, and may also help with the calculation cascade.
Thank you so much for this video. This is so valuable! I can now go ahead and explore the possibilities of what can be achieved with Python in Excel. Will be looking forward to your next series of videos on this topic. thank you again!!!
Another excellent video, and this is definitely something to be excited about: Python in Excel! Thanks for the great content, as always. You are an excellent source of valuable knowledge.
Oh wow. I just decided to start learning Python since I am limited on what I can do with SQL and PQ in Excel, and don't need the summary style of PBI. GREAT TIMING @LeilaGharani! Thank you for this informative session. I'm looking forward to the SQL. Get it? :D
I'm not sure how useful I'll find this feature. The primary use cases for Python with data for most people is that the data wont fit into the "memory" available for Excel. Adding Python on top doesn't change that reality, and in fact, it might hurt Excel performance even further.
Wow!! Will take some time to digest all this, but total gamechanger! Dataframes! In cell! I’m wondering what the performance is for doing big complex calculations in Py versus LET-wrapped array formulas vs the data model
This video put some excitement into my IT job because now I can use my python skills to showcase my skills while making finance be able to crunch their numbers better.
This is really a game changer! Thanks for the video looking forward for the next one. Just small comment note that you have regex also as an argument inside the contains
Want to follow along? Download the exact file I used here 👉 pages.xelplus.com/python-excel-file
Python in Excel is available in Microsoft 365 only.
Wow
This very cool feature
Love to see it
Thanks for sharing
So is this an add-on to Excel or part of the Excel version? Do you have to install python on your computer? Trying to understand the install setup or dependencies.
Python don't actually offer extra functions that are not already available within Excel...
You are now showing how to remove our jobs within the administration industry..
What you are not showing is the imagination needed to interpret the data to assume new conclusions. Please suggest I am wrong.
Part of Excel - no setup will be required. No python installations.@@jameslucas5590
These developments will free up more time so we can take more time to interpret the data and come up with ideas and action plans @@jamesantonywhitehead2814
I have been learning python this year and most of the stuff you illustrated is relatable. It seems one does not need to use Jupyter notebooks or Vs code to import data from excel. You just work with your data straight from native excell. Mind blowing!!!!
Yes! Straight from Excel or Power Query 💪
Be interesting to know how many Python libraries are available to excel.
You can already do a great deal of stuff in the video in excel; THE ORIGINAL DATAFRAME 😁
Let's see if the Spacy and Top2Vec data mining stuff can be pip installed...?
this does not make much sense yet to me. Importing excel in python is one liner dude. And convert any big data to dataframe means eat up your ram... nah, already learning python or already know it, directly write script, and get most of power!
@@jayp5269 Maybe it could be useful for setting up and troubleshooting. Excel doesn't go along with big data but it's good at presenting tabular data.
This comment, and the comment on it, answered me a big question
Thank you so much for this great overview. I am super proud of what our team has been able to do for Microsoft. And the work that the Excel team has done is off the charts (heh). They put so much thought on how best to put Python in the grid. Of course, this is just the beginning-more will come. Thanks again!
Michael Grant, SVP, Enterprise
Anaconda, Inc.
You guys did a great job! We now have many possibilities that go beyond Excel's standard capabilities. Looking forward to the future developments.
super amped about this - good job anaconda team!
This is a game changer for functional teams in finance who were really resistant to notebooks . Thanks Michael.
Excel was already getting great updates lately but this is on another level! Really excited to start using this. Thanks Michael & your team for this. :)
Thank you. As a data analyst and a great fan of python and excel. This is a dream come true for me
I am so glad I learned python this past year ! This is gonna be so helpful 🎉🎉🎉.
To everyone who wants to learn how to code in python, please do not be afraid and do it.
Python is way easier than VBA to learn within weeks you’ll be able to write your own code and within months write code with more complexity.
Do not let yourself be your own obstacle. If I did it you can do it !
Hi. I did something similar last year. I did the 100 days of Python by Angela Yu on Udemy but lost interest because the course was so outdated that a lot of the solutions don't even work anymore. What course or Bootcamp did you do?
@@zaheer25 hi 👋, I did the same course you did.
After day 50 or 60, I just flash forwarded to the more advanced course of data analysis and portfolio project with pandas.
After that, I took real projects. What I mean by real projects I registered on freelance website such as Fiver and Upwork and comeup. People reached to me for doing some data analysis job.
Taking project is really the hard part and the fun part. Because every single person will come to you with an unique request.
I was able to manage multiple projects it was very educating for me as a développer. I really encourage you to do so, to me it’s the best way to learn and any développer will tell you the same
Allow me to add that with ChatGPT and stakoverflow, you’ll be able to work way more faster and still need to put in application what you learned in Angela’s course
print("hello world!")
@@zaheer25if you find the answer. Plz reply me
Hi, Leila! This is fantastic: Excel (now) using Python! I began learning Python, and sometimes I use Pandas library to open .XLSX or .CSV files to a dataframe, exclude NaN values, etc., generally using Jupyter Notebook or PyCharm to write the programs. Now, these programs can also be written in an Excel sheet! Thanks for your explanation! Greetings from São Paulo, Brazil!
This is actually amazing. One thing you kind of touched on but didn't really dive into is that pandas can make pivot tables too. So basically this just solved one of the oldest most annoying limitations of excel for me which is making automatically/dynamically updating pivot tables. No more bodging to force the pivot table to refresh at strategic points. Just make a pandas pivot table and because it's a formula it's always up to date and dynamic.
Funny the interview question I had for my current job was to make a pivot table that auto-updates. I achieved that by using a combination of UNIQUE() and xxxxIFS() functions.
I agree Python constitutes a more robust solution here; but everything could be done already with a little bit of creativity.
You can already do this with DA formulas if your source data is on worksheets, or CUBE formulas if it's in the Data Model.
This is going to change excel on a fundamental level. The way they integrated it makes it so easy to use for anyone with basic Python skills. Or even with basic Pandas skills.
Everything shown here can be done pretty easily without any python or vba. I suppose it gets more useful later on . The one benefit I do is that it can generate outputs with fewer risk of errors
@@ms3862 Yes, the demo stuff can be done without. It doesn't take much creativity to imagine all the stuff that can be unlocked. I'm using Pandas on a regular basis because Excel has it's limits and I maintain a lot of sheets that are on the brink of breaking because of the load of data. It's so well integrated, that it seems much easier than VBA. I can't see how one cannot be hyped about this =)
@@ms3862 It is way quicker with Python. You can scrap Pivot tables and visualisation tools from Excel. Now it's a matter of just writing a few words. If you just use excel to get average values, then of course Python is not a better option.
While this is currently beyond me, I am glad to learn what is possible and what is coming down the pike. I am storing this away in my "I may need this sometime" file. When the need arises, I know I'll come back here to learn the details. Thanks Leila!
Learning python will open you up to the world of programming as well, so it’s a good investment
I've watched several videos about this now and this is the first one that got me excited about Python in Excel. The other ones focused too much on the "cool" charts you could create. When it comes to charts, I'm team "simple is best" so I knew I wouldn't need this much. One definite exception are the geoplot libraries. But your examples showed examples that will be actually useful for data analysis and when you said that we can link to Power Query, I got REALLY excited. When analyzing large sets of data, I don't want them in the workbook and no longer having to rely on Pivot tables is wonderful since people tend to forget they have to update. I can see this replacing Power Pivot.
I'm definitely looking forward to you posting more videos about Python. Thank you very much!
I’m glad this finally exists. I was looking for this about a month ago and figured out a different way to do what I needed at the time, but it’s nice to know this is available now.
Finally? Python extensions have existed for years... free of charge!
Great introduction to Python in Excel! You started with the basics and got more complex in a very logical and easy to follow manner.
For years, I used to switch back and forth between Python and Excel depending on the case. Finally seems I would be able to do the work within one environment.
Aside from the pandas and dataframe stuff, i am hoping we can use Python to replace VBA (at least partially)
Thanks!
You don’t have to be a Data Scientist to see how quick Python in Excel does summaries of tables. This is fantastic!
yes, for quick and easy calculations, great, but for large database processing, definitely a specialised IDE for Python or R, you still have Excel's big problem, working with large databases.
Any ide or python software setup required here
Or is it possible in built
For several dozen rows, it's below measurement error. Test on several millions
For small data set, yes. You don’t have to be a DS. However, in this digital age large data is so common, this will demand the data science/big data skills … so both will co-exist…
Years of -aca- udemy training, wasted!
Really useful video. I've always wanted to get more into data analysis, but the software we use at work generates the absolute worst reports, and finding creative ways to scrape for the data I need in Excel always feels like such a chore and changes from year to year. What little you showed in this video already has me really excited for how much more intuitive it's going to be for me to get the data I need quickly. Thanks!
Let me tell you that, as a programmer, this looks way more sensible and enticing than the “user friendly” (=restrictive) environments like Tableau or Sisense/Periscope.
This is truly amazing! can't wait for the the full deployment of Python in Excel for data science. Big fan of Excel - always relevant!!
Thank you for sharing this, Leila!!! I am truly screaming as I watch your video!! Embracing Data Science in Excel!!!
Haha, it's cool, but screaming with excitement? Maybe not 😆
Very useful for an ex-python developer who ended up having to learn Excel since most users were not comfortable in using a web front end. Easy Peasy stuff, love it.
The news only just broke an hour ago. Clearly, you knew about this before the rest of us to get this video out! 😂 Very exciting possibilities await. Excel + Python = The Dream Combination.
One of the advantages of being an MVP but emotionally I have to keep my feelings and excitement to myself until I can talk about it. It feels very freeing now 😇
@@LeilaGharaniIt's really amazing. I think a specific certification in this field should be useful for everyone. Thanks for sharing
@@LeilaGharani😅
Amazing as usual 👌👏👏
Great... Explanation big fan of your videos🎉thank you
Hi Leila, another amazing video. I was exposed to this a while back but course was complicated for non programmers. You did an incredible job of breaking this down into simple examples and showing its power. Thank you!
This is really cool!! I happen to know both Excel and Python including pandas, matplotlib among others. Am so excited and can’t wait for this to be released from beta 😊
Perfect! You'll have a head start
would excel row limits be an issue for large datasets?
Not as long as it stays in the dataframe and you don't spill the whole thing on the grid @@vik914
wow, didn't expect a response. Thank you so much!@@LeilaGharani
So grateful to you Leila, you are usually keeping us updated with these valuable information
Thank you from Egypt 🇪🇬
Thank you for showing us this, Leila. This is the first time I can remember seeing a popular programming language incorporated into an already popular but proprietary application. (I'm not counting SQL being integrated into the various PC database management systems, because the result of that was too many new flavors of SQL.) A lot of students nowadays are graduating high school and college with Python experience, and Microsoft clearly wants them as customers. If Python had been integrated into Excel 13 years ago, when I had a contract job with a major corporation to work on an excruciatingly complex Excel model (multiple workbooks on multiple network shares with charts, tables and code all over the place and daily mainframe data feeds), I would have been able to accomplish a lot more. I've never programmed in Python, but I've learned a number of programming languages, and those Python libraries' straightforward commands are refreshing to me after dealing with all the noodling around I've needed to do in the Excel interface when I need to do any sort of analysis or regrouping. Of course, your videos help me out a lot with that as well.
pandas initial release 2008-01-11; hmm, was pandas that powerful 13 yrs ago in 2010 too 🤔??
> _"If Python had been integrated into Excel 13 years ago"_
You are opening a totally new world on using Excel and Python! This is mindblowing to me. Only amazing!
This is brilliant, thanks. Superbly explained so you don’t have to be a data scientist to understand it - but it introduces the main terms and processes that data scientists use. Can’t wait to use it myself!
I've looked at Excel and taken a class or two, but wasn't too excited to learn much beyond how to get some pretty print out of it - now that Python is involved I can see this as being something in this century!
I've always wanted Matlab/Octave integration where cells can refer to matrices or even 3D arrays (without having to see the contents). This is probably even better (though I'm not a python pro). Exciting!
@Leilegharani. This is a fantastic overview of python in Excel. I've used python via jupyter notebooks for the past 7 years, but now to have this in Excel....potential game changer and cost saver when coupled with power query and even power automate.
Fantastic demonstration of the functionality. I can see the use for quick adhoc aggregations and transformations, however Excel is a sub-optimal environment in which to use Python, especially so if you're a beginner.
If you're going to go the effort of learning Python simply import your .xlsx or .csv into an IDE like PyCharm or Jupyter Notebook that is designed for the purpose of iteratively developing your code and creating visualisations etc. This way your code can be structured, sequential and clearly legible to you and others, not just bunched up in the formula bar with you having to resize cells to view a chart.
exactly
I hate to be negative, but I agree as well. The great thing about Pandas is automation and being able to work with massive datasets, Excel is really weak in this aspect.
This is a great way of creating spreadsheets that no one else in your company can understand, thus ensuring you retain your job! Thank you!🎉
Leila, just 6 minutes into your teaching, and I'm already incredibly impressed. I'll definitely be exploring more of your content.
Absolutely Amazing Python transforms the way of calculation in Excel. Thank you Miss Leila Gharani. You taught very well.
We want a whole Udemy course on this.
This is what I had always wanted. Wondering if python in excel can take inputs for python variables directly from cell values in excel?
xl("A1")
It definitely can.
@@blzr Would that return a single-cell dataframe or a scalar value?
depends on your range: scalar, vector or martix@@katrinabryce
As Data Engineer/Analyst this is so powerful, I cant wait to work with it
Yes we need full course from you for python and excel ❤thanks
Agreed
Agreed too
Thank you for the trust. I would love to make one at some point 😍
@@LeilaGharani eagerly waiting for your course on Udemy
@@amolnwaghthis!!
What I think is really cool about this is that it makes it possible to do machine learning in Excel. Python has had the ability to create Excel files for a long time with a library like openpyxl, but now instead of sending a .csv file to a machine learning engineer, it would seem that it's possible to import the .py file directly into Excel and pass a Panda dataframe directly into a function in the .py file. This opens up the possibility of doing things like; clustering, classification, and multivariable regression on the fly. I can see data analysts loving this.
That's a great thing. People will quickly learn Python and realize they don't need Excel anymore, they can just switch to using more reliable tools like versioned Jupyter Notebooks + versioned CSV data files + versioned source code
Glad someone said this out loud.
Still not entirely sold on using Excel at all. I use Python to automatically read/parse excel files and automatically output the data to custom built Python user interface. Opening Excel and selecting the data to use, is just an extra step not needed. yes... not everyone knows how to building custom UI's with Python....but if you know how
Looks very interesting. I use python a lot for scientific calculations. The most used modules are numpy, scipy, and matplotlib. By now I probably have more than 1000 functions that I have written. It will be interesting to see how this works with XL.
I am grateful for your videos. I have literally learnt excel from you over the years. I always ask anyone willing to learn excel to look for your videos for the easy explanations.
I appreciate that!
This is one of my biggest regrets growing up. I should have learned to code. This is so exciting for new Excel users. I am still learning VBA for macros as it has helped me in my work for alot of times. I am hoping to learn more on how Python will be useful in my job. Thank you Leila!
No regrets. It's never too late to start. If you know some VBA, learning Python will be really easy for you.
Python is so easy just start
relatable, i have been VBA guy for long time, despite learning Python I could never code it, but with ChatGPT, I'm able to create python codes easily and have the script running in minutes, so you should also be able to code in Python soon, Good Luck!
What a lovely lady. So many tutors are very hard / painful to listen to but she is a pleasure...................
One type of chart you can do in Python, but can't really do in Excel is heatmaps. Useful if you want to visualise data in two dimensions.
For example, during the pandemic, I created a chart that had age in the y axis, date in the x axis, and the infection rate for each date/age pair displayed as a shade of colour from white for 0 to a fully saturated dark colour for highest value.
You can put the numbers in a pivot table and do conditional formatting to get something similar, but it doesn't work so well.
Also, when you are dealing with millions of rows of data, Python, especially if you use the Numpy library, can be a lot faster. In one example I had, calculation time went from 6 hours on Excel to 10 seconds on Python/Pandas to 0.1 seconds on Python/Numpy.
Python is so easy for things that were awkward in Excel, I found that even just putting an average line in a plot was easier in Python than Excel. I always used py for sourcing and cleaning data. I'm happy about this upcoming feature.
Really great news. Personally, I'm especially interested of working with matplotlib in Excel as this would give possibilities of chartings not available directly in Excel (at least without addins ). Working with connections only seems also to be a big 'yes'. I'm a bit curious though od three are plans to bring It to Excel online as well (or if It will be at least compatible even if code is prepared in desktop version)
Teşekkürler.
Thank you!
I remember being excited about Excel 5 because it had VBA macros. Great to see this all modernised!
Better late than never. I've been using Excel and developing for decades. I'm glad this was recommended to me. Thanks.
I've been using python for a while. It started because excel just couldn't handle large data sets. I find this interesting and somewhat useful. Now that I am in python a lot, not sure how often I will jump back to excel. Thank you for sharing!
Soon I'll start to learn python now this amazing video added one more strong reason and excitement to use in excel.
It's absolutely amazing. Thank you Leila for wonderful yet simple explanation. Hoping to deep dive into it, obviously, with the help of your videos.😊
You made me understand python … thanks Leila.. can you come up with more such examples please? Loved this video ❤
Wow! I know R language and have used it with Excel, but Python right inside Excel is something amazing! This will surely be a game changer as combining these two powerful tools will double the power and open up so many possibilities! Thank you Leila, for this wonderful and informative introductory video! BTW, expecting a series on Python from you now, to help us do the magic! 🙂
I ditch Python and dedicated myself to be R advance lvl. Somehow I felt betrayed 😥
@@nathasyapramudita6312 Python is great to learn alongside R, native Microsoft intergration will exponentially increase the want for it in the job field in the future.
@@nathasyapramudita6312 No worries, you can still learn Python (it's lot easier than R) and you will have tripled your skill set, that will fetch better opportunities and returns. Good luck! 🙂
Unfortunately, this is pretty useless. Better to just learn python with juypyter notebooks, that way you can automate these excel tasks with any size datasets.
Fantastic, fantastic, fantastic, Leila! glad to be back on your channel, watching your content and your contribution. Finally, I got the chance to go through the whole video! - loving everything you shared, and for certain, I will emulate your small multiples example. Thank you, thank you! 🙏
The start was epic😂
This is great for Excel users. Google Sheets has had a different way to add Python for awhile now. It's cool how Microsoft has implemented Python.
Hey bro, dont like Excel too much but this update from MS is sick, as a matter of interest, do you have links for the Google sheets equivalent of this PY integration?
I am impatiently waiting for Python to appear in my version of Excel 365
This is music for my ears!!!! i 've been waiting for this so long! actually i was thinking that due to MS has already embended TYPE SCRIP in excel .....I thougth that this could be its official languague for excel ( replacing vba) ...but now comes out with this great surprise! and obviously Leila the 1rst one to lunch it to all excel lovers!! Excellent video amiga!!! and the cherry on the top of the Pie was that can interct directly with Power Query OMG !!!!!
So, Excel now has FIVE languages in it to learn. Formulas, VBA, Power Query (M), DAX, and now Python. When are they finally going to add C#?
Just stick with DAX and Python. No more hassle.
Oh no, not C#! The only thing in worse condition than MS Office (re: bolt-ons) are Windows Development Tools (and all it's manifestations).
VBA 8.1 will rule them all.
Will they call it Pyxcel?
Actually is Excelthon
Grand Maester.
Pexcel
😂 might as well
😅😅😂
this excel integrating python stuff is next level for real
but honestly, think it might be a bit overkill for the everyday excel user who's just crunching numbers
not everyone's ready to dive deep into python, even if it's just a few formulas
still, props to the creator for breaking it down and making it digestible
if you're looking to level up your excel game, this is the sauce
but it ain't for everyone. keep it 100!
This is excellent!!!! I love Pandas and Python, and hate M Formulas, so that last tidbit has me very excited indeed.
The only thing that could top this is replacing VBA with Python, or proper integration into VS Code! We can only dream.
That's a good beginning.
Now when we can natively code in straight Python instead of VBA I will be thrilled. VBA syntax hurts my feelings.
As a programmer working in IT Security, I am horrified 😂
My thoughts exactly, why with about macros when you can just have the python feature
Why?
I wonder if there's a panda library for bass 64 encoding/decoding. That way you can put your code in and make it with entropy so it looks like data and gets ignored by EDRs like crowdstrike
If you can find a base 64 encoder decoder in Pandas you can then put your code in as high entropy data that will be ignored by EDR. This is only going to get worse.
Amazing video as always❤. Being a loyal student to lots of Xelplus courses, would you consider developing a course for Python in Excel? Really loves the way you teach new concepts and integrate real-world examples.
The horror!
Imagine Dataframes and different excel-files and versions all over the place.
No source control, hard to audit and really every code junkie can create stuff.
I was so happy that Power BI was finally stopping the excel-based-data architecture you find in so many companies. I think this will make everything worse.
Don't misunderstand me here: yes it is powerful to put Python in Excel. But it will create tons of poorly managed technical debt. Add the monkey code of chat-GPT to that and the chaos is complete.
Super exciting. Life-changing for someone who really loves to work with Python.
Anyone else feels like this is overwhelming ?
Let's explore this feeling. Because Excel as a whole is overwhelming for a lot of people.
This is AWESOME! I can think of all kinds of ways I can use this at work to update a lot off our old Excel VBA scripts.
Microsoft leadership has no coherent vision. They are slapping everything they can into Office with no real plan. Let's see: we can program in the original Excel Macro language, or VBA (whose development ended years ago), a dodgy API, or JavaScript (never really implemented). We also have Array functions (of {old} and new types--with the same functionality), Lambda functions (still sorta kludgy), and now Python. If they would just completely FINISH the features they already had, we probably wouldn't need many of these bolt-ons. The Excel object model is a nightmare of half-started ideas. The number of bugs that have persisted for 30+ years is truly staggering. Adding Python in cells is not bad in and of itself, but HOW MANY different languages do people have to learn to use this thing anymore? MS is doing this across ALL of their product lines and it's truly a mess--especially for developers!
Totally agree. If Ms continues to improve existing functions like pivot table, you don't need all these mess.
Excel-On-Steroids... WOW!!! the script language was really nice addition, but python inside Excel... just blew my mind... this takes Excel into a whole new realm of possibilities. Thanks for sharing Leila, as always, super informative and clear videos. 😃
the fact that created dfs update themselves can come very useful. Usually when you construct a dataframe starting from some datas if you change those datas after creating the df you dont see the df updating accordingly unless you run again the pd.DataFrame( ---) constructor. Here you have the df you create with the xl function updating accordingly.. really REALLY useful.
I know you're not Microsoft but I know there's a lot of other folks with this same problem that are preventing access to Python functionality in Excel, and that is that I can't access the Microsoft Beta Channel even though my account page says "You're signed up to beta channel". I spoke to Microsoft today and they said that unfortunately the demand for beta channel products was so high that they stopped access for a over a million folks that had already been signed up for the beta program - but they can't take us off the sign-up list. So in other words, "you have access to Python but you actually don't until we figure out how to serve that many customers." That's Microsoft for you!
Great news! I am super excited about Matplotlib and Seaborn being in Excel. Game-changer!
have absolutely no use for Python or Excel, but it has been entertaining to watch and read many spreadsheet nerds get so excited about it :)
YASSSSSS!!!
REGULAR FREAKING EXPRESSIONS!!!!!!!
IVE WANTED THIS IN EXCEL SINCE 2020!!!!
YESSSSSSS!!!!!!!
THIS IS THE BEESSSTTTTT!!!!!
for me this video was a magic show ... as I always say "You are a great teacher" ... slow and steadily making others think differently through your wonderful teachings ... thank you so much ... God bless you
This opens up a lot of possibiilties for those who know python and leverage its powerful library in Excel. Thanks for this tutorial
I love you I love you I love you (in a brotherly way). You are by far the best instructor when it comes to EXCEL by a lightyear. Keep up the good work!
I'm so glad I'm alive at the time Excel integrates itself with Python.
Thank you people for this awesome nice work!
This is so exciting. Just recently i developed a very complex financial plan which can be sinplified with Python. Now I'll be able to do it within Excel
Thank you, Leila, for your lesson. You are so admirable with your Excel teaching. I salute you
Thank you! 😃
Wow. Wonderful video for accountants, bookkeeper, and financial managers. You make it so easy.
This is amazing! Especially the Regex example. I can’t wait for this functionality to be rolled out in Excel at my company!
I think having an IDE like we have in VBA would make most sense. You can still reference the code from an excel cell, but having a dedciated IDE would be best for larger code stacks, and may also help with the calculation cascade.
Thank you so much for this video. This is so valuable! I can now go ahead and explore the possibilities of what can be achieved with Python in Excel. Will be looking forward to your next series of videos on this topic. thank you again!!!
Please, I need some help. I have office 365 for IOS and I could find Phyton for Excel on Formulas tabs. Do you know if is available?
Another excellent video, and this is definitely something to be excited about: Python in Excel! Thanks for the great content, as always. You are an excellent source of valuable knowledge.
Hello 👋👋👋👋
Which version are you using MS Excel???
Oh wow. I just decided to start learning Python since I am limited on what I can do with SQL and PQ in Excel, and don't need the summary style of PBI. GREAT TIMING @LeilaGharani! Thank you for this informative session. I'm looking forward to the SQL. Get it? :D
I'm not sure how useful I'll find this feature. The primary use cases for Python with data for most people is that the data wont fit into the "memory" available for Excel. Adding Python on top doesn't change that reality, and in fact, it might hurt Excel performance even further.
You've actually made it much easier to understand how python works not just in excel but generally,thanks Leila🎉❤,Dubai.
Please do not let this woman fool you. This lease do not let this woman fool you. While useful, this functionality involves pandas, not python
Wow!! Will take some time to digest all this, but total gamechanger! Dataframes! In cell!
I’m wondering what the performance is for doing big complex calculations in Py versus LET-wrapped array formulas vs the data model
You are awesome, as usual, Leila 😮😅 I see why you are excited!
I'm a Rookie programmer in Excel and these utilities are super useful.... First time I saw it....
This video put some excitement into my IT job because now I can use my python skills to showcase my skills while making finance be able to crunch their numbers better.
This is great! I can now literally get rid of Jupyter notebooks. SQL server>Power Query>DataModel/Excel>Python! 😁
This is really a game changer! Thanks for the video looking forward for the next one. Just small comment note that you have regex also as an argument inside the contains
python preview option is not showing in my excel?
I loved this! Thank you Leila!🎉
Which Excel version/year you are using ?