I have a list of files that I am supposed to combine and do some data analysis on. The problem with these files is that they contain Titles. I am familiar with pd.read_excel but I am not sure how do I remove the titles. You can look at this attached image. There is like 12 extra files doen the same. So I do not think that spending time deleting the rows is practical. Any thoughts?

CodePudding user response：

Le read_excel itself has some good facilities:

skiprows: let you to cut out useless information (on top)

header: you can use it to load all titles into a Multiindex. You can decide to ignore it or use in some manner.

CodePudding user response：

pandas.read_excel( header=0(remove header),or skiprows=(specific row number))