How to fix autogenerated index in dataframe by real index after getting data from pd.read_html

Question

I am not able to find how to index my dataframe columns properly

I tried some methods but not able to find right one

import pandas as pd

df = pd.read_html('sbi.html')
data = df[1]

Screenshot

i want the second row as my index of columns in which "Narration" is there

jezrael · Accepted Answer · 2019-03-27 14:24:24Z

1

Set header parameter to 1:

data = pd.read_html('sbi.html', header=1)[0]

Or use skiprows parameter:

data = pd.read_html('sbi.html', skiprows=1)[0]

answered Mar 27, 2019 at 14:24

jezrael

868k103 gold badges1.4k silver badges1.3k bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Thanks this solved my problem data = pd.read_html('sbi.html', header=0)[1]