Drop first column read_csv

# 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'])

Source: stackoverflow.com

Similar codes

7 votes170 views3 answers
Python how to create dict from dataframe based on 2 columns
Python
0 vote141 views1 answer
Filter field set in django formds
Python
23 votes200 views6 answers
Average python
Python
0 vote144 views1 answer
How to read docx file in python
Python
0 vote142 views1 answer
How to add scrollbar to listbox in tkinter
Python
0 vote174 views1 answer
How to interrupt a loop in python
Python
2 votes134 views1 answer
What does += mean in python
Python
13 votes132 views1 answer
Selenium getting started
Python
0 vote154 views1 answer
How to see a full row in pandas
Python
5 votes172 views2 answers
Jupyter notebook to python script
Python