def test_get_default_formatters():
"""We test the `awesome_panel_extensions.widgets.dataframe.get_default_formatters` function
applied to a DataFrame.
We expect to see to see a `pn.widgets.DataFrame` with
- ints aligned right, with zero decimals and ',' as thousands separator
- floats aligned right, with two decimals and ',' as thousands separator
- strings aligned left
"""
data = pd.DataFrame(
{
"int": [
1,
2,
3000,
],
"float": [
3.14,
6.28,
9000.42,
],
"str": [
"A",
"B",
"C",
],
},
index=[
1,
2,
3,
],
)
formatters = dataframe.get_default_formatters(data)
code = pnx.Code(
"""\
data = pd.DataFrame(
{"int": [1, 2, 3000], "float": [3.14, 6.28, 9000.42], "str": ["A", "B", "C"]},
index=[1, 2, 3],
)
formatters = dataframe.get_default_formatters(data)
pn.widgets.DataFrame(
data,
formatters=formatters,
)"""
)
return TestApp(
test_get_default_formatters,
pn.widgets.DataFrame(
data,
formatters=formatters,
),
code,
)
def test_get_default_formatters():
"""We test that formatters for int, float and str are as expected"""
# Given
data = pd.DataFrame(
{
"int": [
1,
2,
3000,
],
"float": [
3.14,
6.28,
9000.42,
],
"str": [
"A",
"B",
"C",
],
},
index=[
1,
2,
3,
],
)
assert not data.index.name
# When
actual = dataframe.get_default_formatters(data)
# Then
print(actual)
assert isinstance(
actual["int"],
NumberFormatter,
)
assert actual["int"].format == dataframe.INT_FORMAT
assert actual["int"].text_align == dataframe.INT_ALIGN
assert isinstance(
actual["float"],
NumberFormatter,
)
assert actual["float"].format == dataframe.FLOAT_FORMAT
assert actual["float"].text_align == dataframe.FLOAT_ALIGN
assert "str" not in actual
assert data.index.name == "index"
assert actual["index"].format == dataframe.INT_FORMAT
assert actual["index"].text_align == dataframe.INT_ALIGN
def _update_widgets_panel(self):
self._default_component[self.component_type] = self.component
component = None
controls = None
if self.component is pn.pane.HoloViews:
component = pn.pane.HoloViews(_create_hvplot())
if self.component is pn.pane.ECharts:
# Issue https://github.com/holoviz/panel/issues/1817
component = pn.pane.ECharts(_create_echarts_plot(),
min_height=400,
min_width=200,
sizing_mode="stretch_both")
if self.component is pnw.Ace:
py_code = inspect.getsource(_create_hvplot)
component = pnw.Ace(
value=py_code,
sizing_mode="stretch_width",
language="python",
height=400,
theme=self._ace_theme,
)
elif self.component is pnw.AutocompleteInput:
component = pnw.AutocompleteInput(
name="Autocomplete Input",
options=["Biology", "Chemistry", "Physics"],
placeholder="Write something here",
)
elif self.component is pnw.Button:
component = pnw.Button(name="Click me", button_type="primary")
elif self.component is pnw.CheckBoxGroup:
component = pnw.CheckBoxGroup(
name="Checkbox Group",
value=["Apple", "Pear"],
options=["Apple", "Banana", "Pear", "Strawberry"],
inline=True,
)
elif self.component is pnw.CheckButtonGroup:
component = pnw.CheckButtonGroup(
name="Check Button Group",
value=["Apple", "Pear"],
options=["Apple", "Banana", "Pear", "Strawberry"],
button_type="success",
)
elif self.component is pnw.Checkbox:
component = pnw.Checkbox(name="Checkbox")
elif self.component is pnw.ColorPicker:
component = pnw.ColorPicker(name="Color Picker", value="#DF3874")
elif self.component is pnw.CrossSelector:
component = pnw.CrossSelector(
name="Fruits",
value=["Apple", "Pear"],
options=["Apple", "Banana", "Pear", "Strawberry"],
height=300,
)
elif self.component is pnw.DataFrame:
component = self.component(name="Hello")
component.value = get_dataframe()
component.formatters = get_default_formatters(component.value)
controls = pn.Spacer()
elif self.component is pnw.DatePicker:
component = pnw.DatePicker(name="Date Picker")
# Issue: https://github.com/holoviz/panel/issues/1810
# component.start = date(2020, 1, 20)
# component.end = date(2020, 2, 20)
# component.value = date(2020, 2, 18)
elif self.component is pnw.DateRangeSlider:
component = self.component(name="Hello")
component.start = date(2020, 1, 20)
component.end = date(2020, 2, 20)
component.value = (date(2020, 2, 18), date(2020, 2, 20))
elif self.component is pnw.DateSlider:
component = self.component(name="Hello")
component.start = date(2020, 1, 20)
component.end = date(2020, 2, 20)
component.value = date(2020, 2, 18)
elif self.component is pnw.DatetimeInput:
component = self.component(name="Hello")
component.value = datetime(2020, 2, 18, 1, 2, 3)
elif self.component is pnw.DatetimeRangeInput:
component = self.component(
name="Hello",
start=datetime(2020, 1, 20),
end=datetime(2020, 2, 20),
value=(datetime(2020, 2, 18), datetime(2020, 2, 20)),
)
elif self.component is pnw.DiscretePlayer:
component = pnw.DiscretePlayer(
name="Discrete Player",
options=[2, 4, 8, 16, 32, 64, 128],
value=32,
loop_policy="loop",
)
elif self.component is pnw.DiscreteSlider:
component = pnw.DiscreteSlider(name="Discrete Slider",
options=[2, 4, 8, 16, 32, 64, 128],
value=32)
elif self.component is pnw.FileDownload:
component = pnw.FileDownload(file="README.md",
filename="README.md")
elif self.component is pnw.FileInput:
component = pnw.FileInput(accept=".csv,.json")
elif self.component is pnw.FileSelector:
component = pnw.FileSelector(name="Hello", max_height=400)
elif self.component is pnw.FloatInput:
component = pnw.FloatInput(name="FloatInput",
value=5.0,
step=1e-1,
start=0,
end=1000)
elif self.component is pnw.FloatSlider:
component = pnw.FloatSlider(name="Float Slider",
start=0,
end=3.141,
step=0.01,
value=1.57)
elif self.component is pnw.IntInput:
component = pnw.IntInput(name="IntInput",
value=5,
step=2,
start=0,
end=1000)
elif self.component is pnw.IntRangeSlider:
component = pnw.IntRangeSlider(name="Integer Range Slider",
start=0,
end=100,
value=(8, 40),
step=2)
elif self.component is pnw.IntSlider:
component = pnw.IntSlider(name="Integer Slider",
start=0,
end=20,
step=2,
value=4)
elif self.component is pnw.LiteralInput:
component = pnw.LiteralInput(name="Literal Input (dict)",
value={"key": [1, 2, 3]},
type=dict)
elif self.component is pnw.MenuButton:
menu_items = [
("Option A", "a"),
("Option B", "b"),
("Option C", "c"),
None,
("Help", "help"),
]
component = pnw.MenuButton(name="Dropdown",
items=menu_items,
button_type="primary")
elif self.component is pnw.MultiChoice:
component = pnw.MultiChoice(
name="MultiSelect",
value=["Apple", "Pear"],
options=["Apple", "Banana", "Pear", "Strawberry"],
)
elif self.component is pnw.MultiSelect:
component = pnw.MultiSelect(
name="MultiSelect",
value=["Apple", "Pear"],
options=["Apple", "Banana", "Pear", "Strawberry"],
size=8,
)
elif self.component is pnw.PasswordInput:
component = pnw.PasswordInput(name="Password Input",
placeholder="Enter a string here...")
elif self.component is pnw.Player:
component = pnw.Player(name="Player",
start=0,
end=100,
value=32,
loop_policy="loop")
elif self.component is pnw.Progress:
component = pnw.Progress(name="Progress", value=20, width=200)
elif self.component is pnw.RadioBoxGroup:
component = pnw.RadioBoxGroup(
name="RadioBoxGroup",
options=["Biology", "Chemistry", "Physics"],
inline=True)
elif self.component is pnw.RadioButtonGroup:
component = pnw.RadioButtonGroup(
name="Radio Button Group",
options=["Biology", "Chemistry", "Physics"],
button_type="success",
)
elif self.component is pnw.RangeSlider:
component = pnw.RangeSlider(
name="Range Slider",
start=0,
end=math.pi,
value=(math.pi / 4.0, math.pi / 2.0),
step=0.01,
)
elif self.component is pnw.Select:
component = pnw.Select(name="Select",
options=["Biology", "Chemistry", "Physics"])
elif self.component is pnw.StaticText:
component = pnw.StaticText(name="Static Text", value="A string")
elif self.component is pnw.TextAreaInput:
component = pnw.input.TextAreaInput(
name="Text Area Input", placeholder="Enter a string here...")
elif self.component is pnw.TextInput:
component = pnw.TextInput(name="Text Input",
placeholder="Enter a string here...")
elif self.component == pnw.Toggle:
component = pnw.Toggle(name="Toggle", button_type="success")
elif self.component == pnw.VideoStream:
component = pnw.VideoStream(name="Video Stream",
sizing_mode="stretch_width",
height=300)
if not component:
component = self.component(name="Hello")
if not controls:
controls = component.controls()
controls.margin = 0
self._component_panel[:] = [
pn.pane.Markdown("## " + component.__class__.name + " " +
self.component_type),
component,
pn.layout.Divider(),
pn.pane.Markdown("## Parameters"),
controls,
]