sheet pyexcel sheet+---+---+---+ row +---+---+---+ row +---+---+---+ row +---+---+---+you can name your rows by column index at sheet name_rows_by_column( sheet pyexcel sheet++---+---+---row ++---+---+---row ++---+---+---row ++---+---+---then you can access rows by its namesheet row["row "[' '' '' 'sheetdata filtering use filter(function to apply filter immediately the content is modified suppose you have the following data in any of the supported excel formatscolumn column column import pyexcel sheet pyexcel get_sheet(file_name="example_series xls"name_columns_by_row= sheet content +++column column column +==========+==========+========== +++ +++ +++ support the project