Platform
Resources
Pricing
Sign in
Get started
Benjamin Schmidt
Digital Humanist. Manhattan-based.
Workspace
Fork
Public
By
Benjamin Schmidt
Edited
Nov 1, 2022
3 stars
1
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.
Try it for free
Learn more
Fork
View
Export
Edit
Add comment
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
Edit
Add comment
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
Edit
Add comment
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
Edit
Add comment
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
Edit
Add comment
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
Edit
Add comment
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
Edit
Add comment
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
Edit
Add comment
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
Add comment
Select
Duplicate
Copy link
Embed
Delete
Cells
db
File attachments
Databases
Edit
Add comment
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
Add comment
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
lowest_ids
Edit
Add comment
Copy import
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
follower
Add comment
Copy import
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
Edit
Add comment
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
tweets
Edit
Add comment
Copy import
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
Edit
Add comment
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
tweet_table
Add comment
Copy import
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
Add comment
Copy import
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
tidytweets
Add comment
Copy import
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
db
Add comment
Copy import
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
most_mentioned
Add comment
Copy import
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
Add comment
Copy import
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
Add comment
Copy import
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
mentioned_users
Edit
Add comment
Copy import
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML