A reactive notebook for Python — run reproducible experiments, query with SQL, execute as a script, deploy as an app, and version with git. Stored as pure Python. All in a modern, AI-native editor.
Python artificial-intelligencedagdata-sciencedata-visualizationdataflowdeveloper-toolsmachine-learningnotebookspipelinepythonreactivesqlweb-app
# boolean
_base = (
alt.Chart(df)
.transform_aggregate(count="count()", groupby=["some_column"])
.transform_joinaggregate(total="sum(count)")
.transform_calculate(percentage="datum.count / datum.total")
.encode(
theta=alt.Theta(
field="count",
type="quantitative",
stack=True,
),
color=alt.Color("some_column:N"),
tooltip=[
alt.Tooltip("some_column:N", title="some_column"),
alt.Tooltip("count:Q", title="Number of records", format=",.0f"),
],
)
)
_pie = _base.mark_arc(outerRadius=85)
_text = _base.mark_text(radius=110, size=13).encode(
text=alt.Text("percentage:Q", format=".2%"),
)
_chart = (_pie + _text).properties(width="container").configure_view(stroke=None)
_chart
# date
_chart = (
alt.Chart(df)
.transform_filter(f"datum.some_column != null")
.transform_timeunit(as_="_some_column", field="some_column", timeUnit="yearmonthdate")
.mark_area()
.encode(
x=alt.X("_some_column:T", title="some_column"),
y=alt.Y("count():Q", title="Number of records"),
tooltip=[
alt.Tooltip("_some_column:T", title="some_column", timeUnit="yearmonthdate"),
alt.Tooltip("count():Q", title="Number of records", format=",.0f")
]
).properties(width="container").configure_view(stroke=None)
)
_chart
# datetime
_chart = (
alt.Chart(df)
.transform_filter(f"datum.some_column != null")
.transform_timeunit(as_="_some_column", field="some_column", timeUnit="yearmonthdate")
.mark_area()
.encode(
x=alt.X("_some_column:T", title="some_column"),
y=alt.Y("count():Q", title="Number of records"),
tooltip=[
alt.Tooltip("_some_column:T", title="some_column", timeUnit="yearmonthdate"),
alt.Tooltip("count():Q", title="Number of records", format=",.0f")
]
).properties(width="container").configure_view(stroke=None)
)
_chart
# time
_chart = (
alt.Chart(df)
.transform_filter(f"datum.some_column != null")
.transform_timeunit(as_="_some_column", field="some_column", timeUnit="yearmonthdate")
.mark_area()
.encode(
x=alt.X("_some_column:T", title="some_column"),
y=alt.Y("count():Q", title="Number of records"),
tooltip=[
alt.Tooltip("_some_column:T", title="some_column", timeUnit="yearmonthdate"),
alt.Tooltip("count():Q", title="Number of records", format=",.0f")
]
).properties(width="container").configure_view(stroke=None)
)
_chart
# integer
_chart = (
alt.Chart(df)
.mark_bar()
.encode(
x=alt.X("some_column", type="quantitative", bin=True, title="some_column"),
y=alt.Y("count()", type="quantitative", title="Number of records"),
tooltip=[
alt.Tooltip(
"some_column",
type="quantitative",
bin=True,
title="some_column",
),
alt.Tooltip(
"count()",
type="quantitative",
format=",.0f",
title="Number of records",
),
],
).properties(width="container").configure_view(stroke=None)
)
_chart
# number
_chart = (
alt.Chart(df)
.mark_bar()
.encode(
x=alt.X("some_column", type="quantitative", bin=True, title="some_column"),
y=alt.Y("count()", type="quantitative", title="Number of records"),
tooltip=[
alt.Tooltip(
"some_column",
type="quantitative",
bin=True,
title="some_column",
format=",.2f",
),
alt.Tooltip(
"count()",
type="quantitative",
format=",.0f",
title="Number of records",
),
],
).properties(width="container").configure_view(stroke=None)
)
_chart
# string
_chart = (
alt.Chart(df)
.mark_bar()
.transform_aggregate(count="count()", groupby=["some_column"])
.transform_window(
rank="rank()",
sort=[
alt.SortField("count", order="descending"),
alt.SortField("some_column", order="ascending"),
],
)
.transform_filter(alt.datum.rank <= 10)
.encode(
y=alt.Y(
"some_column:N",
sort="-x",
axis=alt.Axis(title=None),
),
x=alt.X("count:Q", title="Number of records"),
tooltip=[
alt.Tooltip("some_column:N"),
alt.Tooltip("count:Q", format=",.0f", title="Number of records"),
],
)
.properties(width="container")
.configure_view(stroke=None)
.configure_axis(grid=False)
)
_chart
# string (limit to 10 items)
_chart = (
alt.Chart(df)
.mark_bar()
.transform_aggregate(count="count()", groupby=["some_column"])
.transform_window(
rank="rank()",
sort=[
alt.SortField("count", order="descending"),
alt.SortField("some_column", order="ascending"),
],
)
.transform_filter(alt.datum.rank <= 10)
.encode(
y=alt.Y(
"some_column:N",
sort="-x",
axis=alt.Axis(title=None),
),
x=alt.X("count:Q", title="Number of records"),
tooltip=[
alt.Tooltip("some_column:N"),
alt.Tooltip("count:Q", format=",.0f", title="Number of records"),
],
)
.properties(title="Top 10 some_column", width="container")
.configure_view(stroke=None)
.configure_axis(grid=False)
)
_chart
# unknown
_chart = (
alt.Chart(df)
.mark_bar()
.encode(
x=alt.X("some_column", type="nominal"),
y=alt.Y("count()", type="quantitative", title="Number of records"),
tooltip=[
alt.Tooltip("some_column", type="nominal"),
alt.Tooltip("count()", type="quantitative", title="Number of records"),
],
).properties(width="container").configure_view(stroke=None)
)
_chart