파이썬_장바구니 목록에서 여러가지 아이템 필터 처리

# 목표 : 장바구니 목록에서 여러가지 아이템 필터 처리

# 결론 : 필터링 된 데이터 프레임명 = 장바구니.loc[장바구니['Item'].isin(['사과','오렌지','포도'])]

 

import pandas as pd
import numpy as np
ncolor=pd.read_excel('D:\\account\\_PH_\\email\\Randy_WIP_09142020.xlsx')
ncolor.head()

yes=ncolor.loc[ncolor['Item Number'].isin(['404M.48P.L/XL','404M.48P.S/M','404M.48P.XS',
                                       '404M.059.L/XL','404M.059.S/M','404M.059.XS',
                                       '404M.098.L/XL','404M.098.S/M','404M.098.XS',
                                       '404M.108.L/XL','404M.108.S/M','404M.108.XS',
                                       '404M.119.L/XL','404M.119.S/M','404M.119.XS',
                                       '404M.150.L/XL','404M.150.S/M','404M.150.XS',
                                       '404M.169.L/XL','404M.169.S/M','404M.169.XS',
                                       '404M.532.L/XL','404M.532.S/M','404M.532.XS',
                                       '404M.536.L/XL','404M.536.S/M','404M.536.XS',
                                       '404M.609.L/XL','404M.609.S/M','404M.609.XS',
                                       '404M.L80.L/XL','404M.L80.S/M','404M.L80.XS',
                                       '404M.L81.L/XL','404M.L81.S/M','404M.L81.XS',
                                       '404M.L82.L/XL','404M.L82.S/M','404M.L82.XS',
                                       '404M.L83.L/XL','404M.L83.S/M','404M.L83.XS',
                                       '404M.T78.L/XL','404M.T78.S/M','404M.T78.XS',
                                       '404M.Y85.L/XL','404M.Y85.S/M','404M.Y85.XS'])]
yes.head()

yes.to_excel('404Mnew.xlsx')