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: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-0iV4FtpSriY.html
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 !
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!
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.
@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.
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 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.
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?
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.
@@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.