# Read column names from file cols = list(pd.read_csv("sample_data.csv", nrows =1)) print(cols) # Use list comprehension to remove the unwanted column in **usecol** df= pd.read_csv("sample_data.csv", usecols =[i for i in cols if i != 'name'])