Skip to content

No.193 · Data· New

Column Profile

Every column of a table summarised on its own hard-edged card: nulls, distinct values, and the shape of what's there — a histogram you can read bin by bin, the top values, or a true/false split.

The prompt

Copy this text

Automatic copying is unavailable. Copy the selected text using your device’s copy command.

Written for the variant you picked above: Light

Build a table profiler in a playful-technical, diagrammatic style: warm off-white page #f4efea, white cards, ink #383838, 2px ink borders, 2px corners, flat 4px 4px 0 hard shadows, DM Mono for names, labels and numbers, Inter light elsewhere. Compute everything from rows: per column the row count, nulls (null, missing, empty or NaN), distinct values, and for numbers and ISO dates min, max, mean and a 14-bin equal-width histogram (the last bin includes the max; a constant column is one bin); for text the five most common values; for booleans a true/false count. Header: the table name in 18–22px DM Mono, '400 rows · 6 columns' in small uppercase, and a 'SORT' select (Table order, Most nulls, Most distinct). A responsive grid of cards (min 15rem): the column name with a bordered kind tag coloured by type (number sky #6fc2ff, date teal #16aa98, text coral #ff9538, boolean yellow #ffde00); a stat row of tiny uppercase labels over DM Mono values (Nulls as a percentage, rust when over 10%; Distinct; Mean for numbers). Numbers and dates show a 64px histogram of bordered bars in the kind colour on a 2px baseline; hovering or arrowing to a bar turns it ink and the readout under the axis changes from min…max to '12.5 – 18.0 · 34 rows' (dates as '3 Sept'). Text shows top values as rows with a 40% kind-colour bar behind each, sized to the most common. Booleans show a 34px bordered split bar: yellow 'TRUE 248' and neutral 'FALSE 152' in proportion. Selected variant — Light (light): Light theme: page #f4efea, cards #ffffff, ink, borders and hard shadows #383838, muted #6f6a64, faint #a39e97, rules rgb(56 56 56 / 0.14), boolean false track #ece6df, warning #b33a12; kind colours sky #6fc2ff, teal #16aa98, coral #ff9538, yellow #ffde00. This selection takes precedence over references to other themes or options in the general brief. Implement this selected appearance; do not add a variant picker or alternative appearances unless requested. Implementation requirements: Use React and TypeScript. Keep the component self-contained, with uniquely scoped CSS and no animation libraries. Include required imports, styles and font setup in the result. Interaction: Hover a bar, or focus the chart and use ←/→/Home/End, to read each bin; leaving clears the readout. Changing the sort reorders the cards, which glide to their new positions. Motion: Cards FLIP to new positions over 380ms using offsetLeft/Top; bars change colour over 100ms. Reduced motion re-sorts in place. Accessibility: The section is labelled with the table name; each card's statistics are a description list. Histograms are focusable groups with an instruction label and a polite live readout; top values are an ordered list; the boolean split is an image with a 'N true, N false' label. Responsive behavior: Cards reflow from several columns to one; long names and values truncate with an ellipsis. Touch: Tap a bar to read it; the min and max labels are always visible. Preserve keyboard access, visible focus and reduced-motion behavior. Keep fictional demo data and simulated service calls in a separate usage example; expose callbacks for real actions and recover from rejected requests. Keep usage-example links inside the demo: use local buttons or prevent navigation. Demonstration links must not navigate to Vitrine routes or open other pages; preserve real URL support in the reusable component itself. Verify the result at narrow and wide viewport sizes, with keyboard input and reduced motion enabled.

Notes

Interaction
Hover a bar, or focus the chart and use ←/→/Home/End, to read each bin; leaving clears the readout. Changing the sort reorders the cards, which glide to their new positions.
Motion
Cards FLIP to new positions over 380ms using offsetLeft/Top; bars change colour over 100ms. Reduced motion re-sorts in place.
Accessibility
The section is labelled with the table name; each card's statistics are a description list. Histograms are focusable groups with an instruction label and a polite live readout; top values are an ordered list; the boolean split is an image with a 'N true, N false' label.
Responsive
Cards reflow from several columns to one; long names and values truncate with an ellipsis.
On touch
Tap a bar to read it; the min and max labels are always visible.

Featured

01Glassbreak ButtonA solid plate that fractures from one impact point, cracks racing outward as the shards drift apart.04Liquid GlassA capsule of glass that bends what's behind it, carries a specular highlight around its rim toward your pointer, and squashes like a drop of liquid when pressed.07Phosphor Glass ButtonA liquid-glass pill that senses you coming: its rim light turns to face the cursor and the pill leans in to meet it.08Iris ShutterAn async button with a camera iris for a status light — blades close and turn while it works, then open onto the result.
82Atmosphere CardSmoked-glass link cards: colour pooled in the corners, slow contour currents underneath, a field that leans toward you.94Eclipse Event CardAn editorial event plate with an oversized date and an orbital eclipse bleeding in from the right, alive with slow drift.95Specimen CardAn object mounted under glass: hover lifts the pane with a sweep of reflection and swings out a paper catalogue tag.
97Silk FieldDomain-warped light that pours like liquid silk, with an optional glass lens that refracts the flow under your cursor.108IsobarA living weather map — contour lines traced over a drifting pressure field, with your cursor as a system of its own.
153Prompt ComposerA chat composer where attached files tuck into its top edge like tabs in a folder — they rise from behind it when added and sink back when removed. Send turns into stop while the reply streams.159Aura FieldA writing field where colour only exists while the AI is touching your text: the edge becomes a turning band of light and the words are rewritten in place, one by one, out of a soft blur.
217Halftone CTAA tall CTA banner where slow gold paint drifts beneath a fixed halftone grid, visible only through the dots.
224Nocturne Sign-inA single quiet column on near-black with a breathing seam of frost light behind it — email, password, magic link, nothing more.234Sigil Sign-inA split sign-in whose left half grows a geometric mark from your email — the same address always draws the same sigil.
303Voices CarouselA testimonial exhibition: one large quote at a time on frosted glass, crossfading between voices without ever resizing.
311Feral TitleA brutal condensed wordmark — heartbeat in the dark, letters slam in, a gash tears through and the word bleeds.
333 components