It's probably going to take 2 years for my work 365 license to update to include PY but so looking forward to more advanced charting capabilities. Saving all of these for future reference. I always love when you find a workaround for something MS tells you that it can't be done :)
@@ajarivas72 I've been using Spreadsheet programs for 40+ years. I code in VBA, Python, C++, Java, and 8 other computer languages. I started wtih VisiCalc, then Lotus 1-2-3, and finally Excel. I've had a home licence for everything, and am part of the 365 Insider program and 365 Developer Program. The problem is that the file I create at home can't be used at work, which is where it's most needed. My work is very security sensitive which is why it takes so long to roll out updates.
Mynda, I am you following as a retiree with a lot of Excel knowledge, but following your videos is a pleasure and a good way to keep up with all new features. I can not wait to have also PY in my version of Office.
Hi Mynda, You really GENIUS to use Excel app. I am following you from 2013 and learnt a lot. Those really helped me to implement in my work. Waiting for Python in Excel to enable in my Office 365 subscription. Hoping for more videos from you on Python in Excel in future. Thanks a million 🤝
Interesting video. Way beyond my skill level. I'm still trying to understand formulas and Power Query. Mr. Excel gave you praise on your other videos. Keep up the good work.
First video I've watched from you and it has been enough to subscribe before seeing what else you got there. your thought process and attitude was enough to convince me. Thanks for sharing! Gonna dive into your other videos now. :)
Noice! Jaw on floor with my tongue rolled out 😂 It's nice to finally see some original content, seems Excel channels these days are simply copying each other. Well done, Miranda! 👍🏽
Still waiting for Python - got an update yesterday but still not active - but still enjoying your Videos - will catch up eventually. They really are awesome -well done!
Thanks so much! Fingers crossed you get it soon. Be sure to check other PCs/laptops to see if they get the update. It's not specific to your login, but rather the installation of the software on each device.
I loved the use of: dropna, tolist, isin in pandas. Sorry, my English is not good, I use google translate. Thank you very much for your great contributions.
I'm really impress. Thank you very much for share your knowledge. I use a lot Power Query and Power Pivot in Excel. You have a new subscriber from Chile!
Hi! There are two statistical algorithms which are good for our favorite excel... I) for any time when is the most profit and II) in any time, when is the worst profit... !
@garydunken7934 Great to hear! @keylanoslokj1806 that's all part of the development phase, which is why they release it slowly to segments of the beta channel. Not sure I agree that it'll result in new vulnerabilities though 🤔
@@MyOnlineTrainingHub Might solve challenges I encountered creating a clinical biomarker platform, like a formula for APACHE score used in ICU. Hoping to see tutorials on medical applications in the future. I'd be glad to share what I got sofar.
Looks fascinating. Great video. Very evident that you've already deepened your understanding significantly from your first XL Python video. Loving your output. ☺ For me, there are two irritants. 1. I'm on the Insider Programme, but not the Beta Channel. So I can't play around with it yet. 2. Given that we don't know how much of the new functionality is going to be placed behind a paywall (thanks Microsoft!), it could prove to be an anti-climax. I remember that you said once that you and other MVPs lobbied Microsoft NOT to paywall Power Query/Power Pivot and won. Fancy picking up the challenge a second time Mynda?? We're rooting for you! 🥊
Hi Mynda Very interesting, unfortunately I have not Python on my 365 yet, and when the time comes it will be great if you have a full course about the subject, since I must start from scratch. Best regards
So great to see examples of what you can do with it. Unfortunately I have to wait two months at least to start practicing. Future question: you make dynamic charts, for example in the title of a graph referencing to a cell. In Pivot/Excel you can do so to refer to the page field. But if you have multiple selections, you can not refer any more ("multiple fields"). Maybe Python can??
Great to hear you're excited to use Python in Excel, Bart! Yes, I'm sure Python can display multiple selections in the title. You can also do it with Excel using the TEXTJOIN function: www.myonlinetraininghub.com/excel-textjoin-function
Nice work-around. It is great that Excel has the ability to use the extended range of charts available in the Python packages but wouldn't it be easier to just build the full report in python and display it in a browser window? There are some pretty neat Python packages out there that allow you to do just that.
Sure, if you know Python. I find getting nicely formatted charts easier in Excel. The Python chart labels, legends, borders etc. are ugly and require coding to change them. Excel chart tools are point and click, so for Excel users who don't have Python skills and who need a chart that's already natively in Excel, it's easier to use them.
@@MyOnlineTrainingHub yes I totally agree, but would say that anyone who can manage Excel formulae and Power Query M or DAX for Power Pivot would not have a huge learning curve to start to obtain some pretty spectacular results, especially if using some of the amazing packages available to do a lot of the heavy lifting for you. I am finding that, even as a relative newcomer to python, using python and it's associated libraries is pretty intuitive. The hardest part of the process was getting set up, and even that was not overly difficult to work out with a little patience. That said, Excel will always have a special place in heart and I will get excited about every new development that refines the way it handles data. I look forward seeing more of your videos dealing with this topic in the future and getting to use this amazing new feature. It seems that though I have it there is a bug in my implementation that stops excel from recognising the =PY function along with several other people I can't wait for MS to iron this out!
New features are released to batches of Beta users to ensure things run smoothly. If you don't see Python yet, check daily for updates. You might be lucky and be in the next batch!
Wow that is amazing. So am I correct in understanding that we now have access the power queries data size benefits, the ability to use the excel formula bar as a Jupyter Notebook, access all python libraries and visual the output in excel? So excel really has the benefit of a Large Data engine?
Yes, kind of! Not 'all' libraries. Only those supported by Anaconda. Yes, big data via Power Query but currently limited to 100MB while in testing/beta mode.
Yes. The Python code runs in its own hypervisor isolated container using Azure Container Instances and secure, source-built packages from Anaconda through a secure software supply chain. 😊 More here: techcommunity.microsoft.com/t5/excel-blog/announcing-python-in-excel-combining-the-power-of-python-and-the/ba-p/3893439
Hey. I can't get the right version of Excel installed. I opted into the Insider Program via the Account settings. I installed the latest update. It still doesn't work. Really frustrating!
The insider program releases new features to segments of users to test. As the weeks go by, more and more users on the beta channel will get the feature. Hopefully you'll get it in next week's update. 🤞
The insider program releases new features to segments of users to test. As the weeks go by, more and more users on the beta channel will get the feature. Hopefully you'll get it in next week's update. 🤞
Can you use Python to dynamically add rows? If you can use Python to manipulate actual objects (sheets, cols, rows) that is awesome. You can get VBA to do this but the language is pretty horrible imo.
@@MyOnlineTrainingHub I agree with you. But if I create a class in python script file and want to import that into excel. Is it possible to create object of that class ?
It's probably going to take 2 years for my work 365 license to update to include PY but so looking forward to more advanced charting capabilities. Saving all of these for future reference. I always love when you find a workaround for something MS tells you that it can't be done :)
Wow, that's a long time! Glad you're looking forward to it though.
Yes I'm disappointed my build version (same as video) does not include it also.
Buy your own license.
@@ajarivas72 I've been using Spreadsheet programs for 40+ years. I code in VBA, Python, C++, Java, and 8 other computer languages. I started wtih VisiCalc, then Lotus 1-2-3, and finally Excel. I've had a home licence for everything, and am part of the 365 Insider program and 365 Developer Program. The problem is that the file I create at home can't be used at work, which is where it's most needed. My work is very security sensitive which is why it takes so long to roll out updates.
Awesome as always! Please do more videos about Python and Excel in the future.
Thanks, will do!
Mynda, I am you following as a retiree with a lot of Excel knowledge, but following your videos is a pleasure and a good way to keep up with all new features. I can not wait to have also PY in my version of Office.
Wonderful to hear! 🙏😊
Hi Mynda, You really GENIUS to use Excel app. I am following you from 2013 and learnt a lot. Those really helped me to implement in my work. Waiting for Python in Excel to enable in my Office 365 subscription. Hoping for more videos from you on Python in Excel in future. Thanks a million 🤝
Wow, that's wonderful to hear 🙏😊
Interesting video. Way beyond my skill level. I'm still trying to understand formulas and Power Query. Mr. Excel gave you praise on your other videos. Keep up the good work.
Thank you! TBH, it's beyond my skill level too, but ChatGPT helps a lot!
Don't know if you would be interested but there is a course on AI and Python on UA-cam. ua-cam.com/video/5NgNicANyqM/v-deo.html
Excellent video.... Thanks for sharing.... We need more of such videos
Thank you! Working on it 😉
Your videos are awesome.
Thanks for keeping them short and to the point and not dragging out.
Glad you like them! 🙏😊
First video I've watched from you and it has been enough to subscribe before seeing what else you got there. your thought process and attitude was enough to convince me. Thanks for sharing! Gonna dive into your other videos now. :)
Awesome! Thank you!
Impressive job Mynda. You cover so many aspects of Excel and Python in this video. Congrats
Thanks so much, Frederic! 😊
Noice! Jaw on floor with my tongue rolled out 😂
It's nice to finally see some original content, seems Excel channels these days are simply copying each other. Well done, Miranda! 👍🏽
Wow, thanks! 😊
Extraordinary tutorial as always Mynda! Can’t tell how much I have learnt from you. Please keep up the good work!!
You're too kind! Thanks so much! 😊
Gracias Mynda por este gran aporte! Me encantan tus videos.
Thanks for watching!
Still waiting for Python - got an update yesterday but still not active - but still enjoying your Videos - will catch up eventually. They really are awesome -well done!
Thanks so much! Fingers crossed you get it soon. Be sure to check other PCs/laptops to see if they get the update. It's not specific to your login, but rather the installation of the software on each device.
I loved the use of: dropna, tolist, isin in pandas. Sorry, my English is not good, I use google translate. Thank you very much for your great contributions.
Glad you liked it!
I'm really impress. Thank you very much for share your knowledge. I use a lot Power Query and Power Pivot in Excel. You have a new subscriber from Chile!
Awesome! Thank you 😊
Amazing! Well delivered and super useful. Hoping to get this feature in the next update🤞🏽
Thanks for sharing, Mynda!
Thank you! 🤞for the next update for you!
Wow!! Python now in Excel. Can't wait to see new videos. Thanks
More to come!
Hi! There are two statistical algorithms which are good for our favorite excel... I) for any time when is the most profit and II) in any time, when is the worst profit... !
😁
Excellent! Py in Excel will open up so many things for me. Can't wait to get Py working on the beta channel that I signed up yesterday.
It will also introduce many new vulnerabilities though and bugs to fix
@garydunken7934 Great to hear!
@keylanoslokj1806 that's all part of the development phase, which is why they release it slowly to segments of the beta channel. Not sure I agree that it'll result in new vulnerabilities though 🤔
Brilliant. Well done!
Thanks so much!
Awesome tutorial!
Glad you liked it!
So cool! Thanks Mynda
Thanks for watching, Chris!
Your content is amazing.
Glad you think so! 🙏
Love this stuff! So fun! Thank you! :)
🙏 Glad you enjoyed it!
fantastic! Thank you very much indeed!
Glad you liked it!
Thanks! Looking forward to it!
Excel + Python + Pandas 👍
Great to hear!
@@MyOnlineTrainingHub Might solve challenges I encountered creating a clinical biomarker platform, like a formula for APACHE score used in ICU.
Hoping to see tutorials on medical applications in the future. I'd be glad to share what I got sofar.
Great video Mynda - very interesting
Glad you enjoyed it, Heiko!
Looks fascinating. Great video. Very evident that you've already deepened your understanding significantly from your first XL Python video. Loving your output. ☺
For me, there are two irritants.
1. I'm on the Insider Programme, but not the Beta Channel. So I can't play around with it yet.
2. Given that we don't know how much of the new functionality is going to be placed behind a paywall (thanks Microsoft!), it could prove to be an anti-climax. I remember that you said once that you and other MVPs lobbied Microsoft NOT to paywall Power Query/Power Pivot and won. Fancy picking up the challenge a second time Mynda?? We're rooting for you! 🥊
We're already fighting 😉
Thanks a lot Mynda! Very usefull content as always!😊
Glad you think so!
This is awesome. Thanks
Glad you liked it!
You are amazing 🎉
Thanks so much!
blow my mind away I hope R Script will be integration after this.
Who knows what’s next 😁
I am also waiting for R in Excel.
Awesome! So we can use both pivot charts from Excel and pivot charts from PY at the same time.
Yes, absolutely 😁
Magnificent 👍🏻 Great steps to continue my improvement. Thanks for your excellent effort to motivate us 👍🏻
My pleasure 😊 Have fun with it!
Very useful! Hope to get more amazing updates and tips
More to come!
Thanks Mynda. Some of it is Greek to me for now. :) :)
😊me too, John!
Thanks for sharing
Thanks for watching!
wow...just wow Mynda 👍 excellent.
Thank you so much! 😊
Hi Mynda
Very interesting, unfortunately I have not Python on my 365 yet, and when the time comes it will be great if you have a full course about the subject, since I must start from scratch.
Best regards
Cheers, Ivan!
Excellent ❤
Glad you like it!
So great to see examples of what you can do with it. Unfortunately I have to wait two months at least to start practicing. Future question: you make dynamic charts, for example in the title of a graph referencing to a cell. In Pivot/Excel you can do so to refer to the page field. But if you have multiple selections, you can not refer any more ("multiple fields"). Maybe Python can??
Great to hear you're excited to use Python in Excel, Bart! Yes, I'm sure Python can display multiple selections in the title. You can also do it with Excel using the TEXTJOIN function: www.myonlinetraininghub.com/excel-textjoin-function
Awesome tutorials for me as a beginner. A bit too fast though. But very useful 😊
Glad you liked it! Use the cog icon to change playback speed to slower.
@@MyOnlineTrainingHub I have always liked your videos. Your tutorials are very informative and easy to understand
Awesome!
😊
📊📉📈💹
😊🙏
Awesome tutorial. Have you tried using plotly instead of seaborn? I guess you can make the charts interactive with plotly.
You can't use any Python interactive charts by Plotly, Seaborn, Matplotlib.... yet.
Nice work-around. It is great that Excel has the ability to use the extended range of charts available in the Python packages but wouldn't it be easier to just build the full report in python and display it in a browser window? There are some pretty neat Python packages out there that allow you to do just that.
Sure, if you know Python. I find getting nicely formatted charts easier in Excel. The Python chart labels, legends, borders etc. are ugly and require coding to change them. Excel chart tools are point and click, so for Excel users who don't have Python skills and who need a chart that's already natively in Excel, it's easier to use them.
@@MyOnlineTrainingHub yes I totally agree, but would say that anyone who can manage Excel formulae and Power Query M or DAX for Power Pivot would not have a huge learning curve to start to obtain some pretty spectacular results, especially if using some of the amazing packages available to do a lot of the heavy lifting for you.
I am finding that, even as a relative newcomer to python, using python and it's associated libraries is pretty intuitive. The hardest part of the process was getting set up, and even that was not overly difficult to work out with a little patience.
That said, Excel will always have a special place in heart and I will get excited about every new development that refines the way it handles data.
I look forward seeing more of your videos dealing with this topic in the future and getting to use this amazing new feature. It seems that though I have it there is a bug in my implementation that stops excel from recognising the =PY function along with several other people I can't wait for MS to iron this out!
I signed up for Excell Insider but am still not see Python?
New features are released to batches of Beta users to ensure things run smoothly. If you don't see Python yet, check daily for updates. You might be lucky and be in the next batch!
plotly library supports interactive mode. please try it
But not inside of Excel. The interactive Python charts do not work in Excel, unfortunately.
Wow that is amazing. So am I correct in understanding that we now have access the power queries data size benefits, the ability to use the excel formula bar as a Jupyter Notebook, access all python libraries and visual the output in excel? So excel really has the benefit of a Large Data engine?
Yes, kind of! Not 'all' libraries. Only those supported by Anaconda. Yes, big data via Power Query but currently limited to 100MB while in testing/beta mode.
Is Excel using Anaconda (cloud)?
Yes. The Python code runs in its own hypervisor isolated container using Azure Container Instances and secure, source-built packages from Anaconda through a secure software supply chain. 😊 More here: techcommunity.microsoft.com/t5/excel-blog/announcing-python-in-excel-combining-the-power-of-python-and-the/ba-p/3893439
@@MyOnlineTrainingHub interesting.
When this feature will be available for all users?
It will depend how it goes in the beta channel as to how quickly it becomes generally available. My guess is it's at least months away.
Hey. I can't get the right version of Excel installed. I opted into the Insider Program via the Account settings. I installed the latest update. It still doesn't work.
Really frustrating!
The insider program releases new features to segments of users to test. As the weeks go by, more and more users on the beta channel will get the feature. Hopefully you'll get it in next week's update. 🤞
buckle up for this one people! 😵😵😵😵
😁
@@MyOnlineTrainingHub just finished up watching thoroughly Mynda, amazing stuff !thank you!
MSFT is a frustration as always. I signed up for Beta channel in Insider program. Nothing shows up in my Excel 365.
The insider program releases new features to segments of users to test. As the weeks go by, more and more users on the beta channel will get the feature. Hopefully you'll get it in next week's update. 🤞
Interesting. Would it be possible to create a word cloud based on several rows of customer comments?
I expect so, yes. You can use Python to extract sentiment, or keywords and then plot it in a word cloud.
Can you use Python to dynamically add rows? If you can use Python to manipulate actual objects (sheets, cols, rows) that is awesome. You can get VBA to do this but the language is pretty horrible imo.
Yes! You can use Python for data cleaning and manipulation.
Do you know if we can incorporate python chart in powerpoint?
Yes, use the linked picture, or embed the Excel file: ua-cam.com/video/WgpfiVGs6qc/v-deo.html
Microsoft mentioned that certain Python in Excel features will require payment once they are generally available. It's unfortunate news. 😔
Yes. I can see both sides. 😞
It is great, but still I'm don't have Python on my excel 365
It's slowly being rolled out to office insiders on the beta channel. Maybe with next week's update 🤞
No python yet on my Beta channel 😞
Check for updates daily. More and more people will get it in the coming weeks.
@@MyOnlineTrainingHub I'm checking almost every minute :-)
👍😎✊
🙏😊
Microsoft should have provided a library for Python
and C++ developers to interact with excel. Python in a cell does not look promising.
You can bring in more libraries. There are several loaded by default e.g. Pandas, Seaborn, Matplotlip etc.
@@MyOnlineTrainingHub I agree with you. But if I create a class in python script file and want to import that into excel. Is it possible to create object of that class ?