Aug-26-2019, 06:36 PM
Something like this should do it,boolean indexing with loc.
>>> import pandas as pd >>> df = pd.read_clipboard() >>> df Group Category Subject AC1 AC2 AC3 BM1 BM2 NJ1 NJ2 NJ3 0 Va Vb Vc Datecode Run1 Status Datecode Rank Datecode Power voltage 1 HY JK KL 2019-08-01 23 29 2019-08-12 0 2019-08-03 123 110 2 HH MK VN 2019-08-09 28 45 2019-08-06 32 2019-08-13 125 220 >>> mask = df.iloc[0].isin(['Datecode']) >>> df.loc[:, ~mask] >>> df Group Category Subject AC2 AC3 BM2 NJ2 NJ3 0 Va Vb Vc Run1 Status Rank Power voltage 1 HY JK KL 23 29 0 123 110 2 HH MK VN 28 45 32 125 220