Ji Wei Liew – Medium

Ji Wei Liew

Pinned

Ji Wei Liew
in
Towards Data Science

Python tips for someone transiting from Excel

Excel is one of the most frequently used application for data analysis. However, due with its clear limitations (i.e. performance, row and…

Oct 20, 2020

Python tips for someone transiting from Excel

Oct 20, 2020

Ji Wei Liew
in
Towards Data Science

Supercharged pandas: Tracing dependencies with a novel approach

An object-oriented approach to manage multiple files and dataframes, and tracing dependencies

Mar 11

Supercharged pandas: Tracing dependencies with a novel approach

Mar 11

Ji Wei Liew
in
Towards Data Science

Supercharged pandas: Encrypting Excel Files Written from DataFrames

Introducing an ExcelHelper class which allows you to encrypt Excel files with a strong password or a password of your choice

Jun 12, 2023

Supercharged pandas: Encrypting Excel Files Written from DataFrames

Jun 12, 2023

Ji Wei Liew
in
Towards Data Science

Supercharged pandas: Reading from and Writing to Excel

Enhancing .read_excel & .to_excel methods to allow you to focus on data exploration

Sep 12, 2022

Supercharged pandas: Reading from and Writing to Excel

Sep 12, 2022

Ji Wei Liew
in
Towards Data Science

How to compare 2 dataframes easily

…with a comprehensive data reconciliation script.

Jul 26, 2021

How to compare 2 dataframes easily

Jul 26, 2021

Ji Wei Liew
in
Towards Data Science

What you might not know about VLOOKUP

…and why you should perhaps start using pandas

Jan 29, 2021

What you might not know about VLOOKUP

Jan 29, 2021

Ji Wei Liew
in
Towards Data Science

How to encrypt PDF and send as an email attachment using Python

…and probably save some expense on HR tools for your firm

Dec 21, 2020

How to encrypt PDF and send as an email attachment using Python

Dec 21, 2020

Ji Wei Liew
in
Towards Data Science

I downloaded a game but end up learning about search algorithms

Performing a breadth first search in python and optimizing the solution.

Dec 1, 2020

I downloaded a game but end up learning about search algorithms

Dec 1, 2020

Ji Wei Liew
in
Towards Data Science

How to create a list of files, folders, and subfolders and then export as Excel

A productivity tool to Marie Kondo your folders

Oct 26, 2020

How to create a list of files, folders, and subfolders and then export as Excel

Oct 26, 2020

Ji Wei Liew

Ji Wei Liew

Business consultant for banks, passionate about scripting and automating work using python. www.linkedin.com/in/ji-wei-liew

Following

Help
Status
About
Careers
Press
Blog
Privacy
Terms
Text to speech
Teams