-
Continue reading →: List your folders in Google Drive using Python
To keep track of all your folders and files in Google Drive, you can run a Python script that automatically scrapes information of all the content uploaded in your account. Let me show you how! This post is part of the Project Pigeon, a series of tutorials that covers using Python to automate the following…
-
Continue reading →: Upload files to GDrive using Python – Part 2
Welcome back! Let’s continue learning how to upload files to GDrive automatically using Python. To recap, we’ve learned in Part 1 the basics of establishing a connection to Google APIs and using these APIs to do a simple file upload in GDrive. But now, let’s put everything together in one cohesive script.…
-
Continue reading →: Upload files to GDrive using Python – Part 1
Learn how to use Python to make most of Google products. Let’s start with a simple use case: uploading files to GDrive automatically. Python is extremely useful at work, especially when your organization is subscribed to G Suite apps for Business. Spending hours uploading files one-by-one to about 500 folders is too much, so I just…
-
Continue reading →: Five lessons I’ve learned from Tableau Conference 2018 #TC18
Attending the Tableau Conference 2018 in New Orleans, Louisiana is definitely a milestone in my tech career! I had a great time immersing myself with fellow data geeks and learning best practices in Big Data and Analytics. TC18 offered 439 sessions on various topics, department and skill level. I had to be strategic in…
-
Continue reading →: Split Excel files using Python
I use Python to split a huge database into multiple files. This is useful if you want to distribute different sets of data to various users. For this tutorial, I will be working with Excel files. You will need: Image: Contacts Masterlist Image: Excel Template that we will be using…
-
Continue reading →: Calculate the nearest lat-long distance using Python
Anyone can just google the nearest airport of any area. But can you do that for more than 40,000 locations? Here’s where Python can help. Sample data covers all airports and zipcodes from the United States. Python is not just useful in building web applications and automating workflows, but also for gaining business…
-
Continue reading →: Breaking the Inertia
I initially built this website as a career portfolio. I wanted this blog to document my learnings from working in the tech industry. But lately, there is inertia. I’ve been stuck. What do I post here? Am I good enough to write about anything? Who am I beyond my career? I decided to…
-
Continue reading →: Why can’t developers manage requirements instead?
Without business analysts, an enterprise software project can still be delivered by a group of software developers alone. But why do companies still hire BAs? Why can’t developers do our job instead? It’s not an issue of capability, but focus. Software engineering, or any technical profession, relies on focused thinking. Developers…