How to Extract Unique Values From Hidden Columns Across Multiple Worksheets Using VBAIf you are reading this article right now, you must be looking for an answer to one of these questions in Excel:Jun 14, 2023Jun 14, 2023
Published inGlobetrotters11 Fascinating Cultural Differences I Faced While Living in the US, France, and KoreaIn 2 weeks, I turn 29 — I spent 15 years of my life in Korea, 11 years in the States, and 2 years in France. While living in 3 different…Jun 6, 202210Jun 6, 202210
Published inAnalytics VidhyaHow to Extract Text from Multiple PDF Attachments in Outlook Using VBAFrom time to time, we come across problems that we think are easy but don’t know where to start. Recently, I had to extract text from PDF…Feb 25, 20222Feb 25, 20222
Published inAnalytics VidhyaHow to Receive Water Temperature Data in Real-Time Using Raspberry Pi and PythonPart II: Setting an Automatic Water Temperature Monitoring System and Saving Real-Time Data in Google SheetsAug 31, 20213Aug 31, 20213
Published inAnalytics VidhyaHow to Receive Water Temperature Data in Real-Time Using Raspberry Pi and PythonPart I: Connecting Raspberry Pi to a Laptop using WifiNov 22, 2020Nov 22, 2020
Published inTowards Data ScienceHow to Create Multiple Worksheets From a List of Column Values and Delete Any Empty Columns…Sometimes, we face problems that we think are very easy to solve, but actually not so easy in real life. Two good examples of these are…Oct 16, 20192Oct 16, 20192
Published inTowards Data ScienceExtracting Information from a Text in 5 Minutes Using R RegexWhen you have a large volume of text files, extracting only relevant information is not so easy. For this reason, I want to show you how I…Aug 17, 20191Aug 17, 20191
Published inTowards Data ScienceDatabricks: How to Save Files in CSV on Your Local ComputerWhen I work on Python projects dealing with large datasets, I usually use Spyder. The environment of Spyder is very simple; I can browse…May 30, 20194May 30, 20194
Published inTowards Data ScienceHow to Get Twitter Notifications on Currency Exchange Rate: Web Scraping and AutomationAs the world becomes more integrated, we are more connected than ever. More students study abroad and more people travel around the globe…Apr 6, 2019Apr 6, 2019