Han Qi – Medium

Han Qi

Han Qi
in
Towards Data Science

Cherry Pickup Bottom-Up Dynamic Programming Explanation

Develop your abstraction skills in Dynamic Programming

Mar 13, 2022

Cherry Pickup Bottom-Up Dynamic Programming Explanation

Mar 13, 2022

Han Qi
in
Towards AI

Tabibitosan for Consecutive SQL problems

Save yourself from painful cross-joins and lag/lead window functions

Dec 31, 2021

Tabibitosan for Consecutive SQL problems

Dec 31, 2021

Han Qi
in
Towards Data Science

Taming the Python Import System

Do it wrong so you can do it right

Apr 25, 2021

Taming the Python Import System

Apr 25, 2021

Han Qi
in
The Startup

How badly named SQL column aliases confuse when using GROUP BY and ORDER BY

Just don’t use the same alias name as input column name

Feb 6, 2021

How badly named SQL column aliases confuse when using GROUP BY and ORDER BY

Feb 6, 2021

Han Qi
in
Towards Data Science

Gotcha! when using global variable with recursion

I was working on this leetcode question https://leetcode.com/contest/weekly-contest-212/problems/path-with-minimum-effort/ using…

Oct 31, 2020

Gotcha! when using global variable with recursion

Oct 31, 2020

Han Qi
in
The Startup

Scraping Excel Online Read-Only File With Requests

In a previous article…

Sep 9, 2020

Scraping Excel Online Read-Only File With Requests

Sep 9, 2020

Han Qi
in
The Startup

Scraping Excel Online Read-Only File With Selenium and Javascript in Python

This exercise was prompted by a question on a forum https://community.dataquest.io/t/how-to-download-an-excel-online-file/494093 regarding…

Aug 31, 2020

Scraping Excel Online Read-Only File With Selenium and Javascript in Python

Aug 31, 2020

Han Qi
in
Towards Data Science

20 days to Google Cloud Professional Machine Learning Engineer Exam (BETA)

A journey of throwing oneself in the deep end

Aug 23, 2020

20 days to Google Cloud Professional Machine Learning Engineer Exam (BETA)

Aug 23, 2020

Han Qi
in
Towards Data Science

What’s the difference between pd.merge and df.merge?

In my voluntary role providing online technical support for www.dataquest.io, i come across numerous questions which allow me to dive…

Sep 5, 2019

What’s the difference between pd.merge and df.merge?

Sep 5, 2019

Han Qi
in
Towards Data Science

Transformations of stack, melt, pivot_table

Dec 11, 2018

Transformations of stack, melt, pivot_table

Dec 11, 2018

Han Qi

Han Qi

Shares ideas that I can’t find online. You can support my writing by joining Medium through https://hanqi01.medium.com/membership (affiliate link)

Following

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