pandas dataframe remove header row code example

Example 1: python dataframe remove header

new_header = df.iloc[0] #grab the first row for the header
df = df[1:] #take the data less the header row
df.columns = new_header #set the header row as the df header

Example 2: python remove header

df =df.rename(columns={col: "" for col in r})

Example 3: python delete header row

print df.shape[1]          # Show dimension of thecolumns
print range(df.shape[1])   # Show range of the columns

df.columns = range(df.shape[1])   # Delete headers

Example 4: python pd.DataFrame.from_records remove header

df.rename(columns=df.iloc[0]).drop(df.index[0])