Took your crash courses and they are fab. Your explanations are much easier to understand than most of what I've encountered in my self-teaching journey.
@@DaveOnData I do have a followup question too. Currently i use excel to do the majority of my job, will python in excel actually make things easier rather than mainly using formulas, especially with big data sets?
@MichaelSumner-cs7gc - I was an R user and a huge fan of ggplot2 for many years. Not surprisingly, I've always preferred plotnine and have asked Microsoft to include it in Python in Excel. I use seaborn right with Python in Excel because it is better matplotlib. Hopefully Microsoft will get plotnine added soon!
Hi Dave on Data. Incredible, your site is just what I was looking for. Python in Excel. I have been using Excel for a long time! Mainly, for data collection, transferring to Statistical( Minitab, SPSS, Excel and R)and visualisation packages( Surfer and Grapher). I started with Lotus 123! I still do data interpretation using those tools and they are really time consuming. Most of my data are historical river water quality analysis and sediment transportation data. I will do your Python Crash Course. Thank you for sharing your knowledge and expertise.
hi, actually i have a doubt while in conditional column i am not able to fetch the suitable column under column name. can u please provide solution for this.
New version of excel completely changed the look and layout of this. Does not look nor operate the same way as shown in this video. I have to use this for a class and I am extremely frustrated lol
Thanks for the video! But what if the measures in different columns are way different? Lets say, we have spend in thousand dollars and some other parameter in Sq meters? Is it correct to say that we would need first to normalize date, to bring to some comparable values?
With your assistance Dave, I have quickly determined that your crash course is right for me, for my career goals, through the continued development of data analysis skills via Python. With a yottabyte full of thanking you, thank you Dave
Love the method chaining with assign - I'm always looking for new tips! Only difference in my workflow would be to shift the lines within the chaining parens to be under the new object with an indent to better use that white space as linters yell if lines get too long. Not sure if that's 'standard practice', but I like that pattern.
@scottbrewer474 - Method chaining for creating fluent interfaces is common in other OO programming languages. I've never been able to quite figure out why so many Pythonistas don't write their code this way.
Python for the data analysis, VBA for controlling getting input data in environments that don't connect Data Verse or other outside data sources. (Think ETL actions across SharePoint/OneDrive locations.) _WS
@@DaveOnData Sure, but the issue is not a lot of businesses open up DataVerse or DataLake to operational level psudo-developers so you're stuck back into the VBA work-around for automation as the odds are power automate isn't connected either and you will not have Pro license.
question: do we need to study power query m code or pandas or both of them ? because I mean if we can use pandas in power query why do we just study pandas
@DIGITAL_COOKING-I'm not sure what you mean by "use pandas in power query." Python in Excel is currently designed to have limited functionality (e.g., for Security reasons). At this time, Power Query becomes the primary conduit for feeding data to Python in Excel (e.g., from a SQL Server database). I have some video comparing the various ETL options with Python in Excel: SQL vs. Power Query: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-jYR9B6Gz5vc.html Don't Use Python in Excel for Data Wrangling: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-rMjtcsmHf9g.html
@@DaveOnData ok! , my mistake was thinking that the option of Power BI is present in Excel because in Power BI we can add phyton script in Power query maybe you can answer me the same question but for power BI can we rely only on pandas because we can write phyton script or should we study them both the M language and pandas when it comes to data cleaning I don't know if my question is clear and sorry for my poor English
Really liking this video series and your style of teaching. I've been using SQL for a while but looking at it from the lens of Excel give me a new perspective and I'm learning new things. Thanks so much
Awesome video! I’m trying to import a table from the web that has nested table on it, excel even highlights it for me. Unfortunately excel is not allowing me to click on “expand”. Any idea on why this might be happening? Thank you!!
@-Hussainnn - Indeed! Learning the first programming language is always the hardest. I'm an old-school C++ guy, so I found Python easy to learn. Although, I think Python is kind of clunky compared to other options for data science (e.g., R).
The most useful thing I learned in this video is the way you managed to change the pivot table format, I didn't know you can do that! This will be useful for me
Hey David, Do you think that Multiple regression will do all of this analysis for you by finding which variables has the highest correlation with the results being survival rates? If yes, then what are the disadvantages that are masked when using multiple regression directly without analyzing the data?
@-Hussainnn - The mighty Analysis ToolPak in Excel allows you to easily create correlation matrices. There are two primary issues with relying on correlation (Pearson's is the default, which I will assume here): 1 - Correlation assumes a linear relationship with the data. However, the calculation can be misleading. Google "Anscombe's Quartet" to learn why you should always visualize your data. 2 - Categorical data can be problematic. Enter visualizing your data.
What an enjoyable series that was! I learned a lot and hopefully will use that in my department to do some petroleum engineering data analytics work given my background. I will be starting soon to watch your other playlists! Thank you David for the informative knowledge videos!
@-Hussainnn - Thank you so much for taking the time to leave such kind words. I am happy to hear that you've found my content useful. I hope this continues with my other videos.
Thanks for the video David. My question is how do I deploy the model to be used in excel ?So for example I have built a stock predictor model, I want to be able to share this model with a colleague so they can use the model. Can I send them the excel file with a "Dashboard" sheet where they would just enter a single set of the variables(features like High, Low, Open, Close, Volume etc) and have an output cell display the predicted value ?
@andrewvanderpallen155 - If I understand your question correctly, this scenario would be supported if the colleague can access Python in Excel (e.g., they have the subscription add-on). The current word from Microsoft is Python in Excel outputs (e.g., visualizations), which colleagues can view without Python in Excel but cannot run Python formulas.
@@DaveOnData Thanks for your answer. The colleague cannot access Python in Excel yet. I was thinking since the model would be kind of a finished product they wouldn’t need python to use it but I was wrong.
Great, I'm kind of confused with the last example where you find the cumulative sales. I find it hard for me to imagine how the formula is being created. In the mean time, I'm just memorizing the structure of it to find cumulative
David, excellent video, so logical and clear, as with your other videos. I see that you base it on binary values of 0 or 1 but what if the characterstics have multiple values such as a likert based scale or for example such as a person's age?
