Pandas DataFrame CheatSheet

1. Pandas DataFrame 寻找若干列的所有unique combination

# For example, if df is a Pandas DataFrame of data of muitiple 
# item_third_cate_cds and item_fourth_cate_cds

# Step 1. use drop_duplicate() to remove duplicates
cd34_df = df[['item_third_cate_cd','item_last_cate_cd']].drop_duplicates()

# Step 2. values and tolist() can be jointly used
# to convert a Pandas DataFrame to 2d list
cd34_list = cd34_df.drop_duplicates().values.tolist()