PinnedJi Wei LiewinTowards Data SciencePython tips for someone transiting from ExcelExcel is one of the most frequently used application for data analysis. However, due with its clear limitations (i.e. performance, row and…9 min read·Oct 20, 2020----
Ji Wei LiewinTowards Data ScienceSupercharged pandas: Tracing dependencies with a novel approachAn object-oriented approach to manage multiple files and dataframes, and tracing dependencies7 min read·Mar 11, 2024--1--1
Ji Wei LiewinTowards Data ScienceSupercharged pandas: Encrypting Excel Files Written from DataFramesIntroducing an ExcelHelper class which allows you to encrypt Excel files with a strong password or a password of your choice6 min read·Jun 12, 2023----
Ji Wei LiewinTowards Data ScienceSupercharged pandas: Reading from and Writing to ExcelEnhancing .read_excel & .to_excel methods to allow you to focus on data exploration4 min read·Sep 12, 2022----
Ji Wei LiewinTowards Data ScienceHow to compare 2 dataframes easily…with a comprehensive data reconciliation script.6 min read·Jul 26, 2021----
Ji Wei LiewinTowards Data ScienceWhat you might not know about VLOOKUP…and why you should perhaps start using pandas5 min read·Jan 29, 2021----
Ji Wei LiewinTowards Data ScienceHow to encrypt PDF and send as an email attachment using Python…and probably save some expense on HR tools for your firm5 min read·Dec 21, 2020----
Ji Wei LiewinTowards Data ScienceI downloaded a game but end up learning about search algorithmsPerforming a breadth first search in python and optimizing the solution.15 min read·Dec 1, 2020--1--1
Ji Wei LiewinTowards Data ScienceHow to create a list of files, folders, and subfolders and then export as ExcelA productivity tool to Marie Kondo your folders4 min read·Oct 26, 2020--2--2