Does Python in Excel Replace Excel Charts?
Vložit
- čas přidán 23. 07. 2024
- As powerful as Microsoft Excel charts are, they can't do everything. Enter the power of Python in Excel for data visualization!
Building your visual data analysis skills is a great place to start if you want to have more impact at work using data.
The combination of Excel charts and Python in Excel is like chocolate and peanut butter - better together.
Check out what Python in Excel makes possible - you won't regret it!
☕ If you found this content useful and would like to support the channel, you can buy me a coffee: www.buymeacoffee.com/DaveOnData
--------------------------------------------------------------------------------------------
VIDEO CHAPTERS
--------------------------------------------------------------------------------------------
00:00 Intro
01:05 Faceting Data Visualizations
01:47 Faceted Histograms
04:31 Faceted Bar Charts
05:56 Faceted Scatter Plots
07:27 Faceted Strip Plots
08:19 Violin Plots
09:13 Faceted Violin Plots
--------------------------------------------------------------------------------------------
MY EDA TUTORIAL SERIES ON CZcams
--------------------------------------------------------------------------------------------
My 7-part tutorial series will teach you exploratory data analysis (EDA) with Excel. Here's the playlist link:
• Exploratory Data Analy...
--------------------------------------------------------------------------------------------
VIOLIN PLOT TUTORIAL
--------------------------------------------------------------------------------------------
Here's a link to good tutorial on how to read violin plots:
mode.com/blog/violin-plot-exa...
#pythoninexcel #pythonexcel #pythonforexcel - Věda a technologie
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: czcams.com/video/0iV4FtpSriY/video.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!
Another awesome video.
Thank you for your continued support of the channel. I am happy to hear that you are enjoying the content.
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?
Yes, Python in Excel supports writing custom functions and classes.
@@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.
question: by facet you mean multiples?
Yes! Faceting is a mechanism for creating "small multiples" data visualizations.
@@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.
@recalc - Sure! You may find this link of interest: seaborn.pydata.org/examples/many_facets.html
Won't you share this excel sheet so we can see the code ?
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'll always make time for someone wearing a Maiden shirt!
@tiaanstander6340 - Ha! Thank you. How do you feel about Metallica and Judas Priest t-shirts? 🤣
Why not use Power BI?
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.
PBI is outside of Excel.
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?
Microsoft has not announced a release date as of yet.