In some of my previous posts, you’ve already seen my Python examples on how to count words accurately in a document or in blocks of text (search for: Wordcloud). It’s also possible to count the words in Excel, but we have some gotchas there to be aware of. In this blog, I demonstrate some of […]
Blog
Word Cloud III – Python & Excel together
In two my earlier blogs, I shared two methods & codes in Excel and Python on how to create Word Clouds from any text or document. You can find them here: How To Find The Most Occurring Words In A Document? (python) and Creating Word Cloud Accurately And Easily In Excel (Excel) Now, I’ll turn […]
How to find the most occurring words in a document?
Every now and then I see in technical forums questions such as this: How do I find the most occurring word in my Word document? Or PDF document? Or Emails? etc. The question is a valid one if that’s something you’re curious about or need to find out in your professional role. In this blog, […]
Need a baby name? Or just love data?
In either case, read on. I collected a dataset of poplular baby namesĀ from OpenData government site of City of New York ranging from 2011 through 2016…exactly 19,418 records. Original dataset view: What I want to do is find out: a) Most popular names b) Less popular names (or rare names used) c) Slice it […]