perspective-python 5.6.0

Interactive data grid, pivot table and charts for large, real-time and streaming datasets, with a Jupyter widget and WebSocket server.
Documentation 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88

#  ┏━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┓
#  ┃ ██████ ██████ ██████       █      █      █      █      █ █▄  ▀███ █       ┃
#  ┃ ▄▄▄▄▄█ █▄▄▄▄▄ ▄▄▄▄▄█  ▀▀▀▀▀█▀▀▀▀▀ █ ▀▀▀▀▀█ ████████▌▐███ ███▄  ▀█ █ ▀▀▀▀▀ ┃
#  ┃ █▀▀▀▀▀ █▀▀▀▀▀ █▀██▀▀ ▄▄▄▄▄ █ ▄▄▄▄▄█ ▄▄▄▄▄█ ████████▌▐███ █████▄   █ ▄▄▄▄▄ ┃
#  ┃ █      ██████ █  ▀█▄       █ ██████      █      ███▌▐███ ███████▄ █       ┃
#  ┣━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┫
#  ┃ Copyright (c) 2017, the Perspective Authors.                              ┃
#  ┃ ╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌ ┃
#  ┃ This file is part of the Perspective library, distributed under the terms ┃
#  ┃ of the [Apache License 2.0](https://www.apache.org/licenses/LICENSE-2.0). ┃
#  ┗━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┛

import perspective as psp

client = psp.Server().new_local_client()


class TestViewColumnPaths:
    def test_column_paths(self, superstore):
        tbl = client.table(superstore)
        view = tbl.view()
        paths = view.column_paths()
        assert paths == [[
            "index",
            "Row ID",
            "Order ID",
            "Order Date",
            "Ship Date",
            "Ship Mode",
            "Customer ID",
            "Segment",
            "Country",
            "City",
            "State",
            "Postal Code",
            "Region",
            "Product ID",
            "Category",
            "Sub-Category",
            "Sales",
            "Quantity",
            "Discount",
            "Profit",
        ]]

        view.delete()
        tbl.delete()

    def test_column_paths_split_by(self, superstore):
        tbl = client.table(superstore)
        view = tbl.view(group_by=["State"], columns=["Sales"], split_by=["Ship Mode"])
        paths = view.column_paths()
        assert paths == [
            ["First Class", "Second Class", "Standard Class"],
            ["Sales", "Sales", "Sales"],
        ]

        view.delete()
        tbl.delete()

    def test_column_paths_split_by_range(self, superstore):
        tbl = client.table(superstore)
        view = tbl.view(group_by=["State"], columns=["Sales"], split_by=["Ship Mode"])
        paths = view.column_paths(start_col=1)
        assert paths == [
            ["Second Class", "Standard Class"],
            ["Sales", "Sales"],
        ]

        view.delete()
        view = tbl.view(group_by=["State"], columns=["Sales"], split_by=["Ship Mode"])
        paths = view.column_paths(start_col=1, end_col=2)
        assert paths == [
            ["Second Class"],
            ["Sales"],
        ]

        view.delete()
        tbl = client.table(superstore)
        view = tbl.view(group_by=["State"], columns=["Sales"], split_by=["Ship Mode"])
        paths = view.column_paths(end_col=1)
        assert paths == [
            ["First Class"],
            ["Sales"],
        ]

        view.delete()
        tbl.delete()