pyexcel.sheets.NamedRow.select¶
-
NamedRow.
select
(names)[source]¶ Delete row indices other than specified
Examples:
>>> import pyexcel as pe >>> data = [[1],[2],[3],[4],[5],[6],[7],[9]] >>> sheet = pe.Sheet(data) >>> sheet pyexcel sheet: +---+ | 1 | +---+ | 2 | +---+ | 3 | +---+ | 4 | +---+ | 5 | +---+ | 6 | +---+ | 7 | +---+ | 9 | +---+ >>> sheet.row.select([1,2,3,5]) >>> sheet pyexcel sheet: +---+ | 2 | +---+ | 3 | +---+ | 4 | +---+ | 6 | +---+ >>> data = [ ... ['a', 1], ... ['b', 1], ... ['c', 1] ... ] >>> sheet = pe.Sheet(data, name_rows_by_column=0) >>> sheet.row.select(['a', 'b']) >>> sheet pyexcel sheet: +---+---+ | a | 1 | +---+---+ | b | 1 | +---+---+