Kenneth LawLeetcode 534 Game Play Analysis III without sum window functionThis question have two solutions 1) SUM() window function 2) self-join/two table.2 min read·Jan 20, 2022----
Kenneth LawDataFlow 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…1 min read·Dec 8, 2021----
Kenneth LawHK01 news Web scraping BeautifulsoupWeb-scraping Beautifulsoup example1 min read·Dec 8, 2021----
Kenneth LawPython 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…2 min read·Aug 21, 2021----
Kenneth Lawjson.loads() and json.dumps()?json.loads() takes in a string and returns a json object.1 min read·Aug 8, 2021----
Kenneth LawGoogle Cloud Function http requestAn HTTP POST request containing a parameter to trigger a cloud function1 min read·Jul 25, 2021----
Kenneth LawMy First Leetcode Python challengeI have solved my first Leetcode challenge in Python. Coagulation!1 min read·Jul 2, 2021----
Kenneth LawGit/Gitlab to upload file to new project1.Create a new project in gitlab1 min read·Jun 27, 2021----