4 days agoPowerApps HtmlText Common CSS AdjustmentsDcoration Full article and easy read on PowerApps HtmlText Common CSS Adjustments — Hung, Chien-Hsiang 洪健翔 | Blog (chienhsiang-hung.github.io) Div Full Screen css div full screen position: absolute;1 .box { background:red; position:absolute; top:0px; right:0px; bottom:0px; left:0px; } Center Horizontally and Vertically css center horizontally and vertically2 not so good methods (won’t work on PowerApps)Powerapps2 min readPowerapps2 min read
Nov 20LeetCode [Hard] Bus Routes | Algorithm — BFSFull article and Easy read on LeetCode [Hard] Bus Routes | Algorithm — BFS — Hung, Chien-Hsiang | Blog (chienhsiang-hung.github.io). Question Bus Routes — LeetCode Attempts Classic DFS At first, I came oup with a classic DFS solution. class Solution: def numBusesToDestination(self, routes: List[List[int]], source: int, target: int) -> int…Algorithms5 min readAlgorithms5 min read
Nov 17Python to Read Large Excel/CSV File FasterRead a CSV with PyArrow In Pandas 1.4, released in January 2022, there is a new backend for CSV reading, relying on the Arrow library’s CSV parser. It’s still marked as experimental, and it doesn’t support all the features of the default parser—but it is faster.1 Full article: Python to…Python2 min readPython2 min read
Nov 16(MSCI) ESG Rating Scraper — Example Inside Using Fund and ISIN by Selenium and The APIWhat is ESG ESG stands for environmental, social and governance. These are non-financial factors investors use to measure an investment or company’s sustainability. …Esg Rating3 min readEsg Rating3 min read
Nov 14Sliding Window — LeetCode (Medium) Contest — Maximum Sum of Distinct Subarrays With Length KWeekly Contest 318 This problem ate most of my time and not until a week after the contest did I realize my code wasn’t correct… So I lost 4 points which means I’ve only solved only 1 question in that weekly contest. Let’s dive right into this tricky but quite frankly easy problem…Python3 min readPython3 min read
Nov 14Heap Queue (heapq) in Python | LeetCode Example Last Stone WeightEasy read on: Heap Queue (heapq) in Python | LeetCode Example Last Stone Weight — Hung, Chien-Hsiang 洪健翔 | Blog (chienhsiang-hung.github.io) Heap Heap data structure is mainly used to represent a priority queue. In Python, it is available using the “heapq” module. …Python2 min readPython2 min read
Nov 12Mock Technology Consulting Case Interview (Case Study): Architecture StrategyCase Architecture Strategy: Federal Finance Agency Practice Case from Deloitte and Christine Wong1. Architecture Strategy: Federal Finance Agency Our client is a small division of a large Federal Finance Agency that is in charge of administering and enforcing economic and trade sanctions determined by US foreign policy and national security goals. BUSINESS SITUATION The agency’s office uses a…Tech Consulting4 min readTech Consulting4 min read
Nov 7Topological Sorting | LeetCode Course Schedule I/II | Graph, DFS, BFSWhat’s Topological Sorting Clearer Article Read Topological Sorting | LeetCode Course Schedule I/II | Graph, DFS, BFS — Hung, Chien-Hsiang 洪健翔 | Blog (chienhsiang-hung.github.io) Topological sorting for Directed Acyclic Graph (DAG) is a linear ordering of vertices such that for every directed edge u v, vertex u comes before v in the ordering.1 …Topological Sort4 min readTopological Sort4 min read
Nov 3TCP/IP | Backend 101Easy read on TCP/IP | Backend 101 — Hung, Chien-Hsiang 洪健翔 | Blog (chienhsiang-hung.github.io) What’s TCP/IP Internet protocol suite1 The Internet protocol suite, commonly known as TCP/IP, is a framework for organizing the set of communication protocols used in the Internet and similar computer networks according to functional criteria. The foundational protocols in the suite…Tcp Ip4 min readTcp Ip4 min read
Nov 1SQL Delete Duplicate with no SELECT by Cartesian productSample Situation Delete Duplicate Emails — LeetCode Table: Person +-------------+---------+ | Column Name | Type | +-------------+---------+ | id | int | | email | varchar | +-------------+---------+ id is the primary key column for this table. Each row of this table contains an email. The emails will not contain uppercase letters. …Sql2 min readSql2 min read
![LeetCode [Hard] Bus Routes | Algorithm — BFS](https://miro.medium.com/fit/c/224/224/0*dvDdZc_DVoSgAD78.jpg)
![LeetCode [Hard] Bus Routes | Algorithm — BFS](https://miro.medium.com/fit/c/160/112/0*dvDdZc_DVoSgAD78.jpg)
