Public
Edited
Nov 1, 2022
3 stars
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
db
WITH screen_names as (select unnest(string_to_array(user_mentions, '|')) as screen_name
from tweets)
select screen_name, count(*)::INT as count
from screen_names
group by screen_name
order by count desc
Insert cell
Insert cell
html`People who join super-early are interesting!<ul>${lowest_ids}</ul>`
Insert cell
Insert cell
follower = {
const follower = await FileAttachment("follower.js").text();
return JSON.parse(follower.slice(follower.indexOf("=") + 2)).map(
(d) => d.follower
);
}
Insert cell
Insert cell
Insert cell
Insert cell
tweet_table = aq.table({
screen_name: tweets.map((d) => mentioned_users(d, "screen_name")),
favorites: tweets.map((d) => +d.favorite_count),
retweets: tweets.map((d) => +d.retweet_count),
text: tweets.map((d) => d.full_text),
date: tweets.map((d) => new Date(d.created_at))
})
Insert cell
import { Plot } from "@mkfreeman/plot-tooltip"
Insert cell
tidytweets = tweets.map((d) => {
let retweet = d.full_text.indexOf("RT @") === 0;
let reply = d.full_text.indexOf("@") === 0;
return {
full_text: d.full_text,
favorite_count: +d.favorite_count,
retweet_count: +d.retweet_count,
user_mentions: d.entities.user_mentions.map((u) => u.screen_name).join("|"),
retweet,
reply,
type: retweet ? "retweet" : reply ? "reply" : "tweet",
id: d.id,
created_at: new Date(d.created_at),
lang: d.lang
};
})
Insert cell
db = DuckDBClient.of({ tweets: tidytweets })
Insert cell
viewof most_mentioned = tweet_table
.unroll("screen_name")
.groupby("screen_name")
.count("screen_name")
.orderby(aq.desc("count"))
.view()
Insert cell
import { aq, op } from "@uwdata/arquero"
Insert cell
import { DuckDBClient } from "@cmudig/duckdb"
Insert cell
Insert cell

Purpose-built for displays of data

Observable is your go-to platform for exploring data and creating expressive data visualizations. Use reactive JavaScript notebooks for prototyping and a collaborative canvas for visual data exploration and dashboard creation.
Learn more