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 |
+---+---+