How To Search Text In Multiple Excel Files Quickly

Working with big Excel spreadsheets never have been easy, especially when you need to search for a piece of text in a file that have thousands, even ten of thousands rows. Searching through a single file can cost you hours, if not days if you work on a slow computer. To make the matter worse,… Continue reading How To Search Text In Multiple Excel Files Quickly

Find Big Files And Delete To Clean Up Your Computer

So I usually find out that there are old files that occupy my HDD but I don’t know which one . For example, I downloaded movies long time ago, watched but didn’t delete. I was searching for a program to help me find such files and delete them. Unfortunately, I couldn’t find any. So, I… Continue reading Find Big Files And Delete To Clean Up Your Computer

How To Install MySQL connector for Python 3 in MacOS

Recently, I have a task involving using Python with MySQL. I needed to install MySQL connector for python but all the methods I found on the internet are not applicable. I have Python 3.7 on my Mac. Here is what I did to install mysql connector for python 3: python3 -m pip install pymysql Hope… Continue reading How To Install MySQL connector for Python 3 in MacOS