By 
There are some good stock scanners, like Tradeview, that can filter stocks based on financial ratios, technical indicators, and fundamentals. What if you want a more tailor-made scanner? How about filtering all the stocks with a median 5-year Return on Equity (ROE) greater than 5%? It is not an easy task if you use online …
How to Extract Data from Text Columns?
Imagine you need to extract the price from the “sell_price” column, what would you do? Before reading the solutions, leave a comment below! ad_cat sell_price 住宅 屋苑 村屋 售 358 萬 住宅 屋苑 售 960 萬 住宅 屋苑 售 465 萬 住宅 屋苑 售 760 萬 住宅 屋苑 售 650 萬 住宅 屋苑 單幢式大廈 售 …
