On Wed, Jul 30, 2014 at 6:28 PM, Vincent Davis <vinc...@vincentdavis.net> wrote:
> The real slow part seems to be > for n in drugs: > df[n] = > df[['MED1','MED2','MED3','MED4','MED5']].isin([drugs[n]]).any(1) > I was wrong, this is fast, it was selecting the columns that was slow. using keep_col = ['PATCODE', 'PATWT', 'VDAYR', 'VMONTH', 'MED1', 'MED2', 'MED3', 'MED4', 'MED5'] df = df[keep_col] took the time down from 19sec to 2 sec. Vincent Davis 720-301-3003
-- https://mail.python.org/mailman/listinfo/python-list
