How do I exclude header and footer from an excel file in pandas
you should create a sun dataframe from previous data frame which doesn't contain the header and footer attribute.
for example,
if you excel file contains 500 rows, in which first three rows are header and last 10 rows are footers then you can do as below:
df = df[4:491]
df=pd.read_excel(filename)
What attributes should I add to exclude header and footer?