Answers for "pandas read csv remove first column"

1

remove 1st column pandas

df = df.drop(df.columns[[0, 1, 3]], axis=1)  # df.columns is zero-based pd.Index
Posted by: Guest on May-20-2020
0

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'])
Posted by: Guest on July-12-2020

Python Answers by Framework

Browse Popular Code Answers by Language