Pandas df header on 2 row

Question

Hi. I have a pandas dataframe that has index on the second row. I want it to ignore the 1st row and consider 2^nd as index. How can I do?

Answer 1

By default when you import a file, pandas considers the first row as the header i.e., index=0. To consider 2^nd row as index, you will have to change this index to 1. Refer to the below code:

dbfile = pd.read_csv('Diabetes.csv', header=1)