Leetcode 534 Game Play Analysis III without sum window functionThis question have two solutions 1) SUM() window function 2) self-join/two table.Jan 20, 2022Jan 20, 2022
DataFlow Bulk Decompress Cloud Storage FilesCloud storage files are needed to decompress. DataFlow has a API template to do it. Here is a showcase. I want to unzip cloud files based…Dec 8, 2021Dec 8, 2021
Python Web Scraping -Beautiful SoupI record web scraping my learning in this story and want to apply it on scraping some Hong Kong news website because I worked in…Aug 21, 2021Aug 21, 2021
json.loads() and json.dumps()?json.loads() takes in a string and returns a json object.Aug 8, 2021Aug 8, 2021
Google Cloud Function http requestAn HTTP POST request containing a parameter to trigger a cloud functionJul 25, 2021Jul 25, 2021
My First Leetcode Python challengeI have solved my first Leetcode challenge in Python. Coagulation!Jul 2, 2021Jul 2, 2021