how to remoce header from dataframe after reading excel python 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: r data frame remove column
df$columnName <- NULL