Does Python in Excel Replace Excel Charts?

[@DaveOnData]

You don't have to wait on Microsoft to grant you access to Python in Excel to start building your Python skills. Check out my video on how you can get started NOW: kzbin.info/www/bejne/Zpq5ZXmqpbiln7s

[@rafaeljeronimolimaesilva1099]

Ive been working with Excel since 2015 and I miss faceting for a long time ... I can do wonders in excel but no simple solution to faceting. I've been complaining about this for too long. I'm glad we have this now. Just need some time to study this ... thanks !

[@DaveOnData]

You are welcome! I've asked Microsoft to include the plotnine library in Python in Excel. If that happens, it would be awesome to create faceted data visualizations!

[@michaelt312]

Another awesome video.

[@DaveOnData]

Thank you for your continued support of the channel. I am happy to hear that you are enjoying the content.

[@tiaanstander6340]

If you are competent enough in Python to code the visualizations - why have Excel as part of the solution at all? Why not Python alone? The ability to easily distribute it to an Excel crowd is the only reason I can think of.

[@DaveOnData]

@tiaanstander6340-Accessibility to business users who only have Excel is certainly one aspect of the appeal (e.g., giving a manager a workbook with the Python results available as read-only). My clients are most excited about the ability to access Python with minimal IT involvement. For example, a client uses Azure, but their IT department will not allow local Python installations.

[@ОлегВоропаев-к6ъ]

I need to create a combined function from several ones and make its projection over several periods and calculate the deviation, is this Python add-in for Excel capable of doing this?

[@DaveOnData]

Yes, Python in Excel supports writing custom functions and classes.

[@ОлегВоропаев-к6ъ]

@@DaveOnData I need to create a combined function consisting of linear, exponential and steped, add gradient descent there for a better selection of the function for the data type and the least squares method for a more accurate approximation. If I ask you to do this in Excel, what will be the price? It could be made in a macro or in a python add on for excel, it doesn't matter.

[@RonDavidowicz]

Those don’t look like violins to me!! I don’t want to say what they look like, might get you demonetized! Btw: any idea when MS will release python generally?

[@DaveOnData]

Microsoft has not announced a release date as of yet.

[@StopWhining491]

Why not use Power BI?

[@DaveOnData]

Tools like Power BI are excellent if visual data analysis is the only goal. However, Power BI isn't designed as a general-purpose analytics tool. This is where the combination of Excel and Python really shines.

[@michaelt312]

PBI is outside of Excel.

[@recalc]

question: by facet you mean multiples?

[@DaveOnData]

Yes! Faceting is a mechanism for creating "small multiples" data visualizations.

[@recalc]

@@DaveOnDataThank you David. Last one: could you point to further reading about this? Never heard this term of "faceting" as a mechanism for small multiples. Very interesting.

[@DaveOnData]

@recalc - Sure! You may find this link of interest: seaborn.pydata.org/examples/many_facets.html

[@tiaanstander6340]

I'll always make time for someone wearing a Maiden shirt!

[@DaveOnData]

@tiaanstander6340 - Ha! Thank you. How do you feel about Metallica and Judas Priest t-shirts? 🤣

[@rafaeljeronimolimaesilva1099]

Won't you share this excel sheet so we can see the code ?