Yes! Next I want to figure out how to take the cluster names that are used for the colors and append as a new column in the data frame. That’s my goal for tomorrow.
Here is a confession. I got so frustrated, the original 2013 book was donated to the Thrift Store five years ago. Then, when I needed the book again, I bought a second copy. Double-royalty for that author.
@@Seftehandle When the book arrived, I had Python beta and the charts were not working yet. Today, I am using Google to find anything. The book is two feet away collecting dust. I should move it to the bookshelf for a month.
the way I see it, Python + Pandas/Numpy in Jupyter can replace Excel altogether I like the idea of having Python inside Excel, not sure about its actual use, the more you know Python the less you use Excel, at least for me.
great! pandas library in phyton is like power query and phyton is great tool for data analytics and machine learning, integrating all of this in excel...mind blowing 🤯🤯 i think the best course for python basics there is no best course than CS50 python programing to have all the story "Accounting Data Analytics " Illinois university coursera course is the best.
While I see your point, I have wished I could use LET to define a variable that could be used in multiple formulas, and it seems Python offers that functionality.
If you're only using python to define ranges as variables then you are doing it wrong. You can do so much more with python once you've built on the basics. But it depends on what you want to do with your data, many things will still be easier with excel functions and most people will probably never need python. Personally, after moving from a company that let me use python, through jupyterlab, for analysis to a company that only works with Excel, I am very excited for this.
Very cool indeed. I'm an occasional pythonist. I'm not necessarily convinced by the interface, but I like it. I do like the idea of a toggle on the formula bar but not sure it should be used the way it is, and can't help but think that could have been used for specifying lambdas instead of name manager. For me, returning a cell value or data type should be specified in the code itself. It's not really a setting in my opinion. I like the graphs, but the single cell might be problematic. A great start though and thanks for bringing it to us!
@@MrXL it's very abnormal. It's been said that people who switch between python objects and Excel values are only one step from insanity. Apparently, forty six people have already been institutionalised since the beta release. The US government has actually asked Microsoft to delay the full release as they are concerned that up to a million and seven people could be taken into care, overwhelming the system. Microsoft have refused to comply, stating that python in Excel is too important a development to be held back by interfering bureaucrats and that most of those already effected were: "well down the road to crazy town" anyway.
That would be awesome. It is very hacky, but you can use Home, Paste, Paste Picture Link to line those tables up. (I am embarrassed to even suggest something so geeky). Yes!!! Excel+Word hybrid!
the fee will be to cover the cost of the cloud hosted Conda python environments; if it's possible to get it running using a local python environment then it should be free?
That news on the fee is a right bummer. There are additional fees for AI/Windows CoPilot features and now this, it's all adding up like TV subscriptions. I feel like most businesses will be locked out of this and AI, shame.
I have Microsoft 365 and joined to Microsoft 365 Insider beta version. But unfortunately I always get an error code: 30183-28 (400) after pushing update button. Tried all option what I got from internet (they are almost same) but without any success. Can you help in this please?
@@jamiesray Ok, I'll try to be helpful. I work as an analyst, to people like me the inclusion of Python is a revolution because it gives Excel amazing capabilities and new functionality will not depend on Microsoft but on the development of Python libraries by the community. If in your daily use of Excel you don't need new functionality or functionality related to complex analysis then Python on Excel means nothing of course.
I hope in 30 days to be able to answer this. Right now, I am still trying to find my way around. Right now, I am stuck in the "I can do X in Excel. How do I do the same thing in Python". At some point, I need to graduate to what amazing things can Python do that Excel can not do?
@@MrXL Thanks but no luck. I already sign up a fews ago and it just says "thank you for your interest in python. We'll send you updates in the future". I dont' see any step by step instructions on how to setup ribbons, formulas, etc. Nor do I see python show up in any ribbon as an option
you have shown us the implementation of python in excel. But where is the setup. How have you done this setup and everything. You haven't told that. Where are those details to setup python in excel??
1. Be running Microsoft 365 2. Google "Join Microsoft Insiders Beta" and follow those steps 3. Restart Excel twice 4. Type =PY( in any cell and see if it lights up. If not, wait as they are adding more insiders each week.
YES! And you can even use VBA to write Python formulas Range("A2").Formula2 = "=PY(blah blah blah,1)" for Excel Values and Range("A2").Formula2 = "=PY(blah blah blah,1)" for Python Object
I can't get this =PY( mofo to work and it's making so big mad I could fight ten elephants. I can't wait... I can't sleep... I can't stop thinking of the possibilities... I WANT PYTHON!!!!!!!
4:00 - This is awful design! There's a reason programming languages have scope, and why all variables aren't global... This really needs to change. IMO, only global.df should be fully global. There should be scopes for application, workbook, worksheet level. At this point someone defining some formula in another workbook will likely interfere with this workbook? Or perhaps across different worksheets. Ultimately you can't trust your sheet works, because it might be using old variables, or variables from elsewhere... I am a little disappointed by how these new features are unlikely to be available in the COM model. E.G. displaying objects in a cell would be awesome, and interroping easily with excel formulae would be awesome too for addins. Also a little disappointed that Python isn't being brought in as a VBA replacement, and is instead brought in as formulae alternative. Definitely not a fan of the additional fee ofc too. Otherwise looks fairly well designed.
Must be different levels of "InSider" -- every time you show new stuff on the insiders - i get it 12-15 days later. You must be A-Level insider, and us peons, are D-Level.... LOL. Oh my more to learn :Visi-Calc, Basic, Lotus-1-2-3, Fortran, Excel Pascal, C, C+, Visual Basic, now Python... Danny Glover said it bets - "I'm getting too old for this S***"
There are many times that I am shut out of the new features and I get it 12-15 days later. On those times, I grit my teeth and talk about something else.
@@MrXL it seems to be working now. maybe they updated windows 11. however, i have new problem. ctrl alt shift p opens virtual keyboard of my company's firewall tool called escan. guess I'm stuck with =py(
I hate that Microsoft continues to sell Office 2021. It was obsolete six months before it came out. Somewhere, there is a tiny warning that no human should buy Office 2021 and that it is only for robotic computers on the manufacturing floor. But then MSFT marketing sells Office 2021 as if it is a viable product. When I go into the Microsoft Store in Orlando, those team members actually believe Office 2021 is okay to buy. It is a horrible way to treat customers… we are going to charge you double for an obsolete version and give you nothing new.
Thanks for share this information.
Thank you
Interesting, thanks Bill!
Thank you this is exactly what I wanted to see!
Wow I will wait for it after the refresh
Wow!
That's a very comprehensive test. Thanks for doing it!
Amazing
I can understand your teaching much better, simpler than the python pro tutors guess cause I'm near your shoes learning it
Thank you Mr Excel for introducing to us this new feature
Thanks for watching!
This is great news. Can't wait to learn some new tricks.
Yes! Next I want to figure out how to take the cluster names that are used for the colors and append as a new column in the data frame. That’s my goal for tomorrow.
Nice Visualizations Bill !!!
I love how you showed your purchased py book from 2013. Can relate 100%
Here is a confession. I got so frustrated, the original 2013 book was donated to the Thrift Store five years ago. Then, when I needed the book again, I bought a second copy. Double-royalty for that author.
@@MrXL did it help the second time?
@@Seftehandle When the book arrived, I had Python beta and the charts were not working yet.
Today, I am using Google to find anything. The book is two feet away collecting dust. I should move it to the bookshelf for a month.
@@MrXL books for programming dont seem to help either. Love your channel. :)
Wow finally a moment of clarity on their part.
Mr. Excel, do you think this is a step in replacing VBA with Python?
I thought JavaScript (OfficeScript) was replacing VBA.
the way I see it, Python + Pandas/Numpy in Jupyter can replace Excel altogether
I like the idea of having Python inside Excel, not sure about its actual use, the more you know Python the less you use Excel, at least for me.
I don’t think it will replace VBA but it brings the power of Python to many more people.
GREAT but Fight the Fee!!
This is great and i am looking forward to more :)
Me too!
great!
pandas library in phyton is like power query
and phyton is great tool for data analytics and machine learning, integrating all of this in excel...mind blowing 🤯🤯
i think the best course for python basics there is no best course than CS50 python programing
to have all the story "Accounting Data Analytics " Illinois university coursera course is the best.
I will sign up to take the course, but I don't want to be forced to wear Illini orange
Joy, oh joy, for what seems to be the world's most creative obfuscating complication of a simple range?
While I see your point, I have wished I could use LET to define a variable that could be used in multiple formulas, and it seems Python offers that functionality.
If you're only using python to define ranges as variables then you are doing it wrong. You can do so much more with python once you've built on the basics. But it depends on what you want to do with your data, many things will still be easier with excel functions and most people will probably never need python. Personally, after moving from a company that let me use python, through jupyterlab, for analysis to a company that only works with Excel, I am very excited for this.
Very cool indeed. I'm an occasional pythonist. I'm not necessarily convinced by the interface, but I like it. I do like the idea of a toggle on the formula bar but not sure it should be used the way it is, and can't help but think that could have been used for specifying lambdas instead of name manager. For me, returning a cell value or data type should be specified in the code itself. It's not really a setting in my opinion. I like the graphs, but the single cell might be problematic.
A great start though and thanks for bringing it to us!
There are times when I switch between Python Object and Excel Values. I wonder if that is abnormal or just because I am in the process of learning.
@@MrXL it's very abnormal. It's been said that people who switch between python objects and Excel values are only one step from insanity. Apparently, forty six people have already been institutionalised since the beta release. The US government has actually asked Microsoft to delay the full release as they are concerned that up to a million and seven people could be taken into care, overwhelming the system. Microsoft have refused to comply, stating that python in Excel is too important a development to be held back by interfering bureaucrats and that most of those already effected were: "well down the road to crazy town" anyway.
great introduction ! i've been waiting for excel+word hybrid for a long time. let me resize column for each table independently(same sheet).
That would be awesome.
It is very hacky, but you can use Home, Paste, Paste Picture Link to line those tables up.
(I am embarrassed to even suggest something so geeky).
Yes!!! Excel+Word hybrid!
@@MrXL thank you Mr Excel. that worked😀☺
the fee will be to cover the cost of the cloud hosted Conda python environments; if it's possible to get it running using a local python environment then it should be free?
Noted. I will mention this in video 2615
Exciting!!! but where is the step forward?
See video 2615. Then 2616.
When do you think a decent textbook will be available for Python in Excel (not standalone Python)?
I know at least one author writing one. It’s hard to say how long to get it done.
Please make a new video for forecasting using Python in Excel
I've added it to the list!
That news on the fee is a right bummer. There are additional fees for AI/Windows CoPilot features and now this, it's all adding up like TV subscriptions. I feel like most businesses will be locked out of this and AI, shame.
Just last night, I realized I am somehow paying for Paramount+ but I can't even figure out who is collecting the money and how to get it to stop.
I have Microsoft 365 and joined to Microsoft 365 Insider beta version. But unfortunately I always get an error code: 30183-28 (400) after pushing update button.
Tried all option what I got from internet (they are almost same) but without any success. Can you help in this please?
perhaps its just me but i don't think this looks super helpful for my work
Yeah, it's just you.
@ super helpful comment
@@jamiesray Ok, I'll try to be helpful. I work as an analyst, to people like me the inclusion of Python is a revolution because it gives Excel amazing capabilities and new functionality will not depend on Microsoft but on the development of Python libraries by the community. If in your daily use of Excel you don't need new functionality or functionality related to complex analysis then Python on Excel means nothing of course.
I hope in 30 days to be able to answer this. Right now, I am still trying to find my way around.
Right now, I am stuck in the "I can do X in Excel. How do I do the same thing in Python".
At some point, I need to graduate to what amazing things can Python do that Excel can not do?
I don't see python at all in the ribbon. How do you get it?
Google “join Insiders fast beta” and follow those easy instructions
@@MrXL Thanks but no luck. I already sign up a fews ago and it just says "thank you for your interest in python. We'll send you updates in the future". I dont' see any step by step instructions on how to setup ribbons, formulas, etc. Nor do I see python show up in any ribbon as an option
Does this mean VBA in Excel will be replaced by Python in Excel? Can we create forms and stuff using python in Excel now?
No, we cant.
Can you get Python to dynamcially add sheets/insert rows based on user input, like you can in VBA?
yes, it can
That seems way beyond me. I will be watching @paoloVolterra for videos.
you have shown us the implementation of python in excel. But where is the setup.
How have you done this setup and everything. You haven't told that. Where are those details to setup python in excel??
1. Be running Microsoft 365
2. Google "Join Microsoft Insiders Beta" and follow those steps
3. Restart Excel twice
4. Type =PY( in any cell and see if it lights up. If not, wait as they are adding more insiders each week.
Hi I was able to get into insiders beta, but still do not see python. Please help thanks
Try updating today (Aug 29). They let more people in to the preview today.
Is ChatGPT any better at writing in Python than VBA?
Tried it once. Succeeded once.
Not sure if that pattern will hold up.
It's OK. Some trial and error sometimes, but if you just give it the error message you received it can generally work it out.
Sir can I still run my vba code in excel?I mean in excel with this python apps?
YES! And you can even use VBA to write Python formulas Range("A2").Formula2 = "=PY(blah blah blah,1)" for Excel Values and Range("A2").Formula2 = "=PY(blah blah blah,1)" for Python Object
@@MrXL thanks so much sir....
I can't get this =PY( mofo to work and it's making so big mad I could fight ten elephants. I can't wait... I can't sleep... I can't stop thinking of the possibilities...
I
WANT
PYTHON!!!!!!!
you need to have 365 subscription and need to have joined beta channel of insider program
Update Excel today (Aug 29). They let more people into the preview today.
4:00 - This is awful design! There's a reason programming languages have scope, and why all variables aren't global... This really needs to change. IMO, only global.df should be fully global. There should be scopes for application, workbook, worksheet level. At this point someone defining some formula in another workbook will likely interfere with this workbook? Or perhaps across different worksheets. Ultimately you can't trust your sheet works, because it might be using old variables, or variables from elsewhere...
I am a little disappointed by how these new features are unlikely to be available in the COM model. E.G. displaying objects in a cell would be awesome, and interroping easily with excel formulae would be awesome too for addins.
Also a little disappointed that Python isn't being brought in as a VBA replacement, and is instead brought in as formulae alternative. Definitely not a fan of the additional fee ofc too.
Otherwise looks fairly well designed.
Must be different levels of "InSider" -- every time you show new stuff on the insiders - i get it 12-15 days later. You must be A-Level insider, and us peons, are D-Level.... LOL. Oh my more to learn :Visi-Calc, Basic, Lotus-1-2-3, Fortran, Excel Pascal, C, C+, Visual Basic, now Python... Danny Glover said it bets - "I'm getting too old for this S***"
There are many times that I am shut out of the new features and I get it 12-15 days later.
On those times, I grit my teeth and talk about something else.
Wow. Nope.
finally! is lambda() useless now?
Late this week, I am going to run a head-to-head comparison of Lambda and Python. I suspect Lambda will be faster.
This is only available in Beta Channel Insider level. Rubbish.
Great tips using python, thanks MR Excel
pressing ctrl alt shift m types accented m. how to turn that off and use this shortcut to switch between python object and excel value 😢
Oh no. I am sure no one at Microsoft knows this problem.
@@MrXL it seems to be working now. maybe they updated windows 11.
however, i have new problem. ctrl alt shift p opens virtual keyboard of my company's firewall tool called escan. guess I'm stuck with =py(
what version of Excel because it does not work for me. I have excel 2021.
8.30
I hate that Microsoft continues to sell Office 2021. It was obsolete six months before it came out. Somewhere, there is a tiny warning that no human should buy Office 2021 and that it is only for robotic computers on the manufacturing floor. But then MSFT marketing sells Office 2021 as if it is a viable product. When I go into the Microsoft Store in Orlando, those team members actually believe Office 2021 is okay to buy. It is a horrible way to treat customers… we are going to charge you double for an obsolete version and give you nothing new.