Kenneth LawLeetcode 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
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…Dec 8, 2021Dec 8, 2021
Kenneth LawHK01 news Web scraping BeautifulsoupWeb-scraping Beautifulsoup exampleDec 8, 2021Dec 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…Aug 21, 2021Aug 21, 2021
Kenneth Lawjson.loads() and json.dumps()?json.loads() takes in a string and returns a json object.Aug 8, 2021Aug 8, 2021
Kenneth LawGoogle Cloud Function http requestAn HTTP POST request containing a parameter to trigger a cloud functionJul 25, 2021Jul 25, 2021
Kenneth LawMy First Leetcode Python challengeI have solved my first Leetcode challenge in Python. Coagulation!Jul 2, 2021Jul 2, 2021
Kenneth LawGit/Gitlab to upload file to new project1.Create a new project in gitlabJun 27, 2021Jun 27, 2021