Stuck waiting on Microsoft to grant you access to Python in Excel? Don't wait! Check out my video on how you can get started NOW: kzread.info/dash/bejne/Yp2KlqitoLbYmbw.html

Still new to Python and learning. Really thankful for your videos. But I do know that likes, comments, and shares will get this video in front of more people.

@DaveOnData

4 ай бұрын

Thank you so much for your continued support of the channel! It is much appreciated.

Awesome series David!

@DaveOnData

4 ай бұрын

Thank you! I am glad you are enjoying the content. I'm on a mission to uplevel the quality of Python in Excel content on KZread.

hey David, How do you handle data sets that are incomplete, for example some rows have no value for a specific column?

@DaveOnData

3 ай бұрын

Great question! Assuming you can't correct the data (which is common), here are some strategies you can employ: 1 - Use an algorithm that can handle missing values. 2 - If only a small percentage of observations have missing data, remove the observations. 3 - Remove the feature with missing data. 4 - Find a “proxy feature” for the feature with missing data. 5 - Fill in the missing data (i.e., impute the missing data).

@ScreamingTurtleRacing

3 ай бұрын

@@DaveOnData Thank you for such a complete response! I tried putting in a value that would flag them as not actual data -99999 for example, but I think that just throws the who analysis off. Next I will try removing the rows with null data, then after characterizing the clusters, I will see where the rows with null data might fit back in. sort of a post-hoc assignment to a cluster. Thanks again!

@DaveOnData

3 ай бұрын

You are welcome. Happy data sleuthing!

Hey, great video. I have very little experience in this area and I got this running in an hour or so. I am trying to cluster customer sights(lat/long) in to sales territories. The issue is that with K-means I get all different size clusters. I have done some digging, and I want to try kmedoids clustering. Is it possible to use this method in Excel/Python? Thanks

@DaveOnData

3 ай бұрын

A quick scan of the libraries included with Anaconda Python (which Python in Excel uses) showed that k-medoids doesn't appear to be available at this time. The main machine learning library provided with Python in Excel is scikit-learn which does not offer k-medoids. However, you could use a local Python installation and use a package like the following: python-kmedoids.readthedocs.io/en/latest/

@ScreamingTurtleRacing

3 ай бұрын

@@DaveOnData thank you, I will try to do a local implementation of Python.

hey @daveondata Is there any way that we can get the excel file so we can do this ourselves?

@DaveOnData

2 ай бұрын

@FelixLizama - I've added a GitHub repo link to the video description where you can get the Excel workbook file.

@FelixLizama

2 ай бұрын

@@DaveOnData thanks!.. you are the best!

When are they fully releasing python in excel for everyone

@DaveOnData

4 ай бұрын

Microsoft has not announced the date for Python in Excel General Availability. However, you don't need to wait to start building skills. Check out this video on my channel for more details: kzread.info/dash/bejne/Yp2KlqitoLbYmbw.html

This was great. Thank you for posting this. I have a question - can we read and write data from local folder ? For eg: can I run pandas.read_csv() and read a csv file located at C:/User ?

@DaveOnData

4 ай бұрын

Python in Excel cannot directly access the local file system, networks, or the Excel object model for security. However, you can use Power Query to source data from local files, databases, APIs, etc. For more details on Python in Excel security, check out the following Microsoft article: support.microsoft.com/en-us/office/data-security-and-python-in-excel-33cc88a4-4a87-485e-9ff9-f35958278327

@DaveOnData

4 ай бұрын

BTW - I will have an upcoming video demonstrating sourcing 300,000 rows from SQL Server into Python in Excel via Power Query. Stay tuned!