Home - News ( United States | United Kingdom | Italy | Germany ) - Football scores

Showing content from https://pyexcel.readthedocs.io/en/latest/generated/pyexcel.Sheet.project.html below:

pyexcel.Sheet.project — pyexcel 0.7.3 documentation

Sheet.project(new_ordered_columns, exclusion=False)[source]

Rearrange the sheet.

Variables:

• new_ordered_columns – new columns

• exclusion – to exclude named column or not. defaults to False

Example:

>>> sheet = Sheet(
... [["A", "B", "C"], [1, 2, 3], [11, 22, 33], [111, 222, 333]],
... name_columns_by_row=0)
>>> sheet.project(["B", "A", "C"])
pyexcel sheet:
+-----+-----+-----+
|  B  |  A  |  C  |
+=====+=====+=====+
| 2   | 1   | 3   |
+-----+-----+-----+
| 22  | 11  | 33  |
+-----+-----+-----+
| 222 | 111 | 333 |
+-----+-----+-----+
>>> sheet.project(["B", "C"])
pyexcel sheet:
+-----+-----+
|  B  |  C  |
+=====+=====+
| 2   | 3   |
+-----+-----+
| 22  | 33  |
+-----+-----+
| 222 | 333 |
+-----+-----+
>>> sheet.project(["B", "C"], exclusion=True)
pyexcel sheet:
+-----+
|  A  |
+=====+
| 1   |
+-----+
| 11  |
+-----+
| 111 |
+-----+

RetroSearch is an open source project built by @garambo | Open a GitHub Issue

Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo

HTML: 3.2 | Encoding: UTF-8 | Version: 0.7.4