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

I also have a confession to make. Today is a crazy busy day. I'm playing the video with my headphones plugged in to help the algorithm. Based on your quality this far, I'm sure this video is awesome. Looking forward to watching and learning.

@DaveOnData

4 ай бұрын

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

Awesome David. Thanks for the tutorial.

@DaveOnData

4 ай бұрын

You are welcome! Next week's video will be on cluster analysis using Python in Excel. Stay tuned.

Just what I was looking for. Thank you!

@DaveOnData

4 ай бұрын

Excellent! You may enjoy my video tomorrow as well. It demonstrates performing a cluster analysis using Python in Excel.

Dave, this is a homerun of a video. It clearly demonstrates a wholistic view of the capabilities of Python in Excel for predictive analytics. To me, it looks as good if not better than in a Jupyter Notebook, and even more digestible for the masses. Well done! I look forward to more deep dive content in the future, so I hope it is on your roadmap!

@DaveOnData

2 ай бұрын

Wow! Thank you for the kind words, they are much appreciated. Yes, I will be shifting gears to more examples of using Python in Excel for data science. Next week's video will be on building a spam filter using Naive Bayes for text analytics.

@kristoferbrown8007

2 ай бұрын

@@DaveOnData this is quite timely! I have a boatload of textual data that needs categorizing. Naive Bayes might be a great starting point. Looking forward to it!

@DaveOnData

2 ай бұрын

@kristoferbrown8007 - Then you will like the video after that even more! It will cover clustering text documents.

Wish there was python in excel when I was learning! This is great start for anyone looking for branch more into data science from the comfort zone of excel 😅

@DaveOnData

3 ай бұрын

Well-said! Quite a few of my Excel videos (e.g., my K-means video) are kinda pointless now that Python in Excel is available.

This is great thanks! Is there a way you can output the model accuracies in the cell itself instead of the diagnostics tab?

@DaveOnData

4 ай бұрын

Great question! There are many ways to accomplish this. For example, creating a DataFrame that you output to the worksheet.

Awesome

@DaveOnData

4 ай бұрын

Glad you enjoyed the tutorial!

Hi Dave, which version of Excel are you using in this video? thanks

@DaveOnData

8 күн бұрын

Microsoft 365 on Windows at the time of the recording.

hallo. new to this. is there some way to joust get the math done i excel over to Pyton on a easy way ? doing some Ballistic stuff and and it have been nice to run a Program Instead of excel :P

@DaveOnData

Ай бұрын

@MyAudioPipe - If I understand your question correctly, a Jupyter Notebook might be better. Check out my Python Crash Course series: kzread.info/head/PLTJTBoU5HOCTIWI3m7PUaeaP5VY3M1a1s

Hi David, This data set where can i find it, to folow along. Tks in advance

@DaveOnData

4 ай бұрын

You can find the Adult dataset here: archive.ics.uci.edu/dataset/2/adult

Hi - awesome learning , grateful if you can share the excel file with the python code regards

@DaveOnData

2 ай бұрын

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

Great post! I fired up excel (On-line & local) and can’t see the ‘PY’ function - am I missing something…

@DaveOnData

4 ай бұрын

Glad you enjoyed the content! Python in Excel is in Public Preview. You need to request access from Microsoft. Check out this article for more information: support.microsoft.com/en-us/office/get-started-with-python-in-excel-a33fbcbe-065b-41d3-82cf-23d05397f53d

@DaveOnData

4 ай бұрын

BTW - If you want to get started now while you wait for access, check out this video on my KZread channel: 📺 kzread.info/dash/bejne/Yp2KlqitoLbYmbw.html

So...what does that tell us? It automates classifying ?

@DaveOnData

3 ай бұрын

Analyzing data with machine learning models can provide many insights. For example, discovering which features (i.e., columns) in the data are most associated with an outcome of interest.

@learning_with_irving4266

3 ай бұрын

@DaveOnData right but for this particular example, it creates a classification tree based on their features, how would that be used? For instance if we take that dataset, it would tell us which of those people are more likely to have a higher income?

@DaveOnData

3 ай бұрын

Correct and which combinations of features are important for making accurate predictions regarding income level.

@learning_with_irving4266

3 ай бұрын

@DaveOnData Thank you sir 🙏