Deborah KewonHow 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:·4 min read·Jun 14, 2023----
Deborah KewonMy Bloomberg Interview Experience for a Market Data Analyst Position·4 min read·Nov 27, 2022----
Deborah KewoninGlobetrotters11 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…·7 min read·Jun 6, 2022--10--10
Deborah KewoninAnalytics 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…·4 min read·Feb 25, 2022--2--2
Deborah KewoninAnalytics 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 Sheets·6 min read·Aug 31, 2021--3--3
Deborah KewoninAnalytics VidhyaHow to Receive Water Temperature Data in Real-Time Using Raspberry Pi and PythonPart I: Connecting Raspberry Pi to a Laptop using Wifi·6 min read·Nov 22, 2020----
Deborah KewoninTowards 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…·5 min read·Oct 16, 2019--2--2
Deborah KewoninTowards 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…·3 min read·Aug 17, 2019--1--1
Deborah KewoninTowards 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…·4 min read·May 30, 2019--4--4
Deborah KewoninTowards 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…·4 min read·Apr 6, 2019----