Mike Freeman

Ian Johnson

Observable

Discovering Date Patterns

Correlation over time

Toph Tucker

Compare a forecast, goal, or estimate to reality by filling up hollow bars.

Targets vs. Actuals

Do users who searched for you stay engaged longer than those who saw an ad? Compare retention across groups.

User Retention with Segments

Mike Bostock

Introduction to data

Deepti Srivastava

Observable aims to make the end-to-end data-insights journey collaborative and efficient for cross-functional teams working with different types of data. We've recently added two new features to specifically address and streamline the end-to-end spreadsheet-based workflows: Cloud Files and xlsx pars

Spreadsheet-based data collaboration gets supercharged with Observable

Summary Table

Visnu Pitiyanuvath

Connecting to databases

Robert Kosara

Paul Buffa

Observable may look nothing like Microsoft Excel, but it actually has a lot in common with it - if you change a value, all the calculations that depend on it automatically update. Observable does that and so much more! Let's try it out...

Observable for Excel Users: Introduction

Data Loading and Cleanup

Adding Columns to Data

Analyzing Data

Modeling in Observable

Ayodele Odubela

Plot for Matplotlib Users: Overview

Torsten Sprenger

Upset Plots with Observable Plot

Distributions and summary statistics - a collection of Plot examples

Jarrett Meyer

Sankey With Animated Gradients

Eric Lo

Hacking Power BI Charts with Plot

Raju Ps

NF Difference Chart

rcatlord

Greenhouse gas emission projections

francobollo

Concentration values vs. Time

Plot: regression

Examples for Data Analysts

Note that the <style> element that you append here affects all elements on a page. <style> cannot be scoped (unless you append it to a shadowRoot). Instead you will have to add a dynamic class or ID to create a specific scope for your td rule.

I recommend to set the scope class/ID on `el`, and to migrate all inline styles into the <style> element.

Fabian Iwand

Wow this looks super convenient. Excited to use it. Thanks!

Scott

Thanks so much, let me know if you have any trouble or feedback!

Tom Larkworthy

I think the min and max is already on the graph?

Cobus Theunissen

ah! I was looking at the median area not the ticks, good one!

I really love this Summary Table!
How could we combine this with a csv autotype refiner? I mean, sometimes, a column would be unproperly "autotyped" as numeric, but it is actually a nominal variable (zip code, gender...)
I'd love a kind of intermediate "table input" listing columns, their guessed type, and offering options to refine it (like the RStudio Import dataset wizard).

This would be very useful for the Data Wrangler as well.

And also, some i18n options would be welcomed... (but i can fork the notebook to translate Summary Table in french myself, and display numbers with locale delimiters, obviously).

Éric Mauvière

Thanks for your thoughts, Éric (and sorry I missed as the year was winding down). I've noticed that the Summary Table is a nice tool for surfacing *when I have a type error in my data* (e.g., I see that autotyping, and want to change it). 

The table input listing columns and types is a great idea for a tiny tool -- here's a super quick one:

https://observablehq.com/@ambassadors/data-type-table

Adjusting them would be a great step to explore!

Could it be possible to support Arrow Table as input? It's not difficult to convert table to array but still it would nice to have this feature on SummaryTable. Especially because Inputs.table supports Arrow Table as input.

Kimmo Linna

That's a great idea! Do you have a notebook where you have an ArrowTable that I can fork to test it out?

I think that you are familiar with DuckDBClient? ;) It returns Arrow Table. Here is a simple example. https://observablehq.com/@kimmolinna/duckdb-and-arrow-table

Thanks for the suggestion, and sorry I lost track of this thread! I've added Arrow Table support to the SummaryTable -- let me know if you have any issues! Here's an example https://observablehq.com/d/53b82a2f05a848de

Hi there!
(really interesting feature to get a quick overview)
Came across this and thought of pandas Dataframe (https://pandas.pydata.org/docs/reference/api/pandas.DataFrame.html) where the datatypes are infered. However if you want to "force" one you would pass the kwarg dtype. Maybe something you considered?

Thanks for the feedback! We did consider that, but leaned towards a simpler API for use, imagining that people could transform their type before passing it into the function (using the SummaryTable has actually helped me surface incorrect types!)

The mouse cursor suggests that the bars are supposed to be clickable, but nothing happens on click. I also see no related event handling in the notebook. Has this not been implemented yet?

Hi. First of all, I use the summary table in almost all my notebooks, and I really love it.

Just a simple request/suggestion: I think it would be really useful to have the numeric total (length) of every category besides of the percentage in the tooltips of categorical data.

Thank you for your awesome work!

Emigpa

How to set column type to be number? I imported some CSV data and numbers are detected as string categories.

Anatoli Babenia

You’ll need to do that type setting before passing it into the table- depending on how you’re loading the data, you can:

FileAttachment("path.csv").csv({ typed: true })

Or, using d3.csv:

d3.csv(“path.csv”, d3.autoType)

That helps, thanks! I read the [FileAttachment](https://observablehq.com/@observablehq/file-attachments#cell-417) docs, but didn't understand what a well-typed CVS meant. Thought that I have just a plain CSV that carries no type information.

Looks like you already tracked down the documentation: https://observablehq.com/@observablehq/file-attachments. If you include {typed:true}, the FileAttachment will use the automatic type inference described here: 

https://observablehq.com/@d3/d3-autotype

How does one go about reversing the colors? Instead of dark blue to light blue, it goes light blue to dark blue?