A comprehensive list of small projects that I think will keep you in the 2022 trend for beginners looking into dipping their toes in the field of data — A new year is coming and perhaps learning a new skill or getting a new job is on your checklist. Fear not as we will be looking into 5 projects in no particular order I think will help you learn and impress your potential employers. Beginners can start with using…

Everything you need to know about emoji in your database or dataset. — Let us face it, it is 2021 and emojis are inevitable. You see it everywhere from chats to product reviews, and in some cases usernames. Today we will be answering some questions: What are emojis How are emojis stored in a database How important is it to retain emojis in…

Matching 2 different sources of product reviews by Malaysian using fuzzy string matching, and a comparison between Jaccard and Levenshtein algorithm. — This scenario came when I had to match product reviews from a few Malaysian-based online shopping platforms. And what makes us Malaysian’s special is how we spell and give product reviews. I have decided to share this challenge that I came across, and together with a few scenarios that may…

Making sure all changes in Big Query are accountable for — Introduction Working with teams using Big Query and creating views can get messy when people start changing views without informing other members of the team. Some teams are accustomed to using comments on the top of the view, or even a spreadsheet to record changes. Obviously, this leads to a problem…

Creating a dashboard to monitor if your tables ingestion is in accordance to the SLA set and tracking how fast your data is growing — As your Google BigQuery data warehouse grows bigger with more datasets and tables, it becomes increasingly harder to track if your tables are consistently being updated properly, or how big and fast your data is growing in volume. In this article, we will be looking at an approach that will…

Summing up my year with a tutorial on data scrapping and analysis on Tinder users around me according to my preference. — A small introduction Tinder as we know it is a matchmaking app that both parties have to swipe right on each other to match. Over the years, Tinder has evolved and unofficially been used as an app for hookups or just finding friends to socialize with. Our goal today is to find out…

Hi Piotr, It is because "terraform init" needs some configurations to initialize your environment. TLDR you need to create a tf file in your directory before running "terraform init" in your Powershell. For example, in this section: https://towardsdatascience.com/version-control-big-query-with-terraform-with-ci-cd-too-a4bbffb25ad9#a26d A provider.tf file is created first stating what provider I will be using, then only you "terraform init" it. So what terraform init does is it will download the required dependencies or "settings for Google" in the example above. Hopefully my answer helps you get started, else just let me know!

A beginner thought process while completing my final year project and using YOLO for this task — This post is more of a thought process while embarking on this journey rather than a line-by-line code tutorial. …

Creating a quick script using Golang to scrap LINE stickers — Let’s start by agreeing that Whatsapp does not have great stickers, but LINE does. For the people who have no idea what is LINE, or wonder what is so great about their stickers, [check one out here]. …