(continued from previous pagesheet pyexcel sheet(dataname_columns_by_row= sheet pyexcel sheet+---+---+---+---+---+---+---+--- +===+===+===+===+===+===+===+=== +---+---+---+---+---+---+---+---and you want to remove columns named as' '' ' ''hthis is how you do itdel sheet column[' '' '' '' 'sheet pyexcel sheet+---+---+---+--- +===+===+===+=== +---+---+---+---what if the headers are in different row suppose you have the following datasheet pyexcel sheet+++ +++column column column +++ +++the way to name your columns is to use index sheet name_columns_by_row( here is what you getsheet pyexcel sheet+++column column column +==========+==========+========== +++ +++row manipulation suppose you have the following data old tutorial