Our Black Friday Sale is here! 🎉 Master data analysis, Excel, Power BI, and more... Grab exclusive discounts today 👉 link.xelplus.com/yt-bf-savings This offer won’t last long-don’t miss it!
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.
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!
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.
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.
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!
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.
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)
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.
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"_
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 😇
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!!!
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 😊
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!
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…
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!
Leila, you're really good in excel-- Your information is so simple and clear - which is what people will be looking at from any tutorials out there! It's Clear, concise and perfect. Thank you so much!
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.
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.
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.
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!
@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.
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?
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.
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
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.
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.
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 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!
Besides the Python library called pandas, she also demonstrated the Python library called matplotlib and hinted that seaborn and numpy will be available.
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!
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.
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)
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!
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.
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.
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.
Hi Leila, I just started using Python with Excel and I am impressed! I have a question : how do you do to incorporate PY() within a LET() function and how do you pass parameters back and forth ? Thanks for your answer.
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.
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! 🙏
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!
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 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'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.
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
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 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.
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. 😃
I love it!! Exactly like you said, it opens up a whole new world. Finally Excel gets new life. A question I have is: Can the Python integration also handle Objects like e.g. buttons in Excel, to basically completely replace VBA? That would give us the additional treat to (mis)-use Excel as a quickly available GUI for simple tasks.
😱😱😱 Leila! I'm blown away, you are just the best! You can't imagine the pictures and scenarios and dashboard and expands and drilldown I have in my mind as you move on with this video. 😲 I can't wait for it to be rolled out. This is even far better than Power Query ...
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 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
Amazing, I've dreamed about being able to use Python in excel directly instead of using an IDE. This is a dream come true 😍 I heard rumours about this but never thought it was real.
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
the problem with businesses building with excel is not that it isnt a powerful or even useful tool. The problem is maintainability. One user gets super powers at low cost and starts making large sweeping changes that break business processes downstream. We made almost 300 million dollars off of eliminating excel from business processes where groups within our departments worked off shared spreadsheets. it was ridiculous with the amount of pain excel causes. we just started building our own web platforms instead.
This is amazing - I am particularly stoked that you can apparently import external libraries into Excel Python. This opens up the possibility of importing CUDA-accelerated libraries such as CUDA Python and Numba, thus enabling Excel to leverage nVidia GPUs for massively parallel computation and neural network processing!
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.
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!!!
Our Black Friday Sale is here! 🎉 Master data analysis, Excel, Power BI, and more...
Grab exclusive discounts today 👉 link.xelplus.com/yt-bf-savings
This offer won’t last long-don’t miss it!
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.
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!
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.
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!
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
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.
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)
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.
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 a great way of creating spreadsheets that no one else in your company can understand, thus ensuring you retain your job! Thank you!🎉
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
You are opening a totally new world on using Excel and Python! This is mindblowing to me. Only amazing!
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 😆
Great introduction to Python in Excel! You started with the basics and got more complex in a very logical and easy to follow manner.
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
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!
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!
So grateful to you Leila, you are usually keeping us updated with these valuable information
Thank you from Egypt 🇪🇬
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!
Leila, you're really good in excel-- Your information is so simple and clear - which is what people will be looking at from any tutorials out there! It's Clear, concise and perfect. Thank you so much!
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.
As Data Engineer/Analyst this is so powerful, I cant wait to work with it
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.
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.
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!
@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.
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
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!
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.
Absolutely Amazing Python transforms the way of calculation in Excel. Thank you Miss Leila Gharani. You taught very well.
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.
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.
Leila, just 6 minutes into your teaching, and I'm already incredibly impressed. I'll definitely be exploring more of your content.
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?
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!
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.
This is great. I've used pythonto in excel for years so it's great they officially include it
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
Besides the Python library called pandas, she also demonstrated the Python library called matplotlib and hinted that seaborn and numpy will be available.
@@Based-Pharaohwtf are you talking about!? Pandas is a python library???
@@funk44 Correct hence why it makes more sense to have named this function 'pd' instead of 'py'
Better late than never. I've been using Excel and developing for decades. I'm glad this was recommended to me. Thanks.
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!!
YASSSSSS!!!
REGULAR FREAKING EXPRESSIONS!!!!!!!
IVE WANTED THIS IN EXCEL SINCE 2020!!!!
YESSSSSSS!!!!!!!
THIS IS THE BEESSSTTTTT!!!!!
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!
What a lovely lady. So many tutors are very hard / painful to listen to but she is a pleasure...................
I am impatiently waiting for Python to appear in my version of Excel 365
I remember being excited about Excel 5 because it had VBA macros. Great to see this all modernised!
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.
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)
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!
The start was epic😂
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.
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.
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
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.
Super exciting. Life-changing for someone who really loves to work with Python.
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.
Soon I'll start to learn python now this amazing video added one more strong reason and excitement to use in excel.
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.
Hi Leila, I just started using Python with Excel and I am impressed!
I have a question : how do you do to incorporate PY() within a LET() function and how do you pass parameters back and forth ?
Thanks for your answer.
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 ❤
Will they call it Pyxcel?
Actually is Excelthon
Grand Maester.
Pexcel
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.
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.
This opens up a lot of possibiilties for those who know python and leverage its powerful library in Excel. Thanks for this tutorial
Anyone else feels like this is overwhelming ?
Let's explore this feeling. Because Excel as a whole is overwhelming for a lot of people.
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! 🙏
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.
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 :)
This is amazing! Especially the Regex example. I can’t wait for this functionality to be rolled out in Excel at my company!
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 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! 😃
Great news! I am super excited about Matplotlib and Seaborn being in Excel. Game-changer!
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.
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
I'm a Rookie programmer in Excel and these utilities are super useful.... First time I saw it....
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 !!!!!
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 going to be very helpful. Excel is such a useful tool, to have python in it is amazing.
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.
Thank you, this is crazy helpful. Sometimes I forget how new these functionalities are, and it amazes me what we can do now compared to a year ago.
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. 😃
I love it!! Exactly like you said, it opens up a whole new world. Finally Excel gets new life. A question I have is: Can the Python integration also handle Objects like e.g. buttons in Excel, to basically completely replace VBA? That would give us the additional treat to (mis)-use Excel as a quickly available GUI for simple tasks.
😱😱😱 Leila! I'm blown away, you are just the best! You can't imagine the pictures and scenarios and dashboard and expands and drilldown I have in my mind as you move on with this video. 😲 I can't wait for it to be rolled out. This is even far better than Power Query ...
🤗 Who would have thought something more exciting than Power Query would come to Excel?!
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 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
With the everyday increasing popularity and power of Python this a right move by Microsoft... Thanks Leila for putting this together, great stuff!
Hello 👋👋👋👋
Which version are you using MS Excel???
This is great! I can now literally get rid of Jupyter notebooks. SQL server>Power Query>DataModel/Excel>Python! 😁
Amazing, I've dreamed about being able to use Python in excel directly instead of using an IDE. This is a dream come true 😍 I heard rumours about this but never thought it was real.
Wow. Wonderful video for accountants, bookkeeper, and financial managers. You make it so easy.
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
the problem with businesses building with excel is not that it isnt a powerful or even useful tool. The problem is maintainability. One user gets super powers at low cost and starts making large sweeping changes that break business processes downstream. We made almost 300 million dollars off of eliminating excel from business processes where groups within our departments worked off shared spreadsheets. it was ridiculous with the amount of pain excel causes. we just started building our own web platforms instead.
This is amazing - I am particularly stoked that you can apparently import external libraries into Excel Python. This opens up the possibility of importing CUDA-accelerated libraries such as CUDA Python and Numba, thus enabling Excel to leverage nVidia GPUs for massively parallel computation and neural network processing!
All of the compute runs on MS servers so that’s unlikely.
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.
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!!!