Public
Edited
Sep 23, 2024
Importers
countyRegionMapping = FileAttachment("county_region_mapping.csv").csv()
getWorkflowAnnotations(23681, ["T0"])
annotations = FileAttachment("annotations@6.json").json()
dataExportDate = meta.date
meta = FileAttachment("date@1.json").json()
_.groupBy(_.orderBy(Object.values(newspapers), "year"), "chain_id")
getNewspapersPoliticalShift(newspapers.slice(0, 500))
getNewspapers = (nlps = null) => {
const data = nlps
? newspapers.filter((n) => nlps.includes(n.nlp))
: newspapers;
return data.map((n) => ({
...n,
politics: n.politics || "unknown"
}));
}
newspapers = FileAttachment("newspapers@13.json").json()
getParticipantsBreakdown(sampleWorkflows)
getParticipantsBreakdown = (workflows) => {
const users = _.uniqBy(
workflows.flatMap((w) =>
participants
.filter((p) => p.workflow_id === w.workflow_id)
.map((p) => ({
user_name: p.user_name,
user_logged_in: p.user_logged_in
}))
),
(d) => `${d.user_name}:${d.user_logged_in}`
);
const loggedInCounts = _.countBy(users, "user_logged_in");
return {
total: users.length,
loggedIn: loggedInCounts[true] || 0,
notLoggedIn: loggedInCounts[false] || 0
};
}
getParticipants = (workflowId) => {
const workflow = getWorkflow(workflowId);
const users = participants.filter((p) => p.workflow_id === workflowId);
const loggedInCounts = _.countBy(users, "user_logged_in");
return [
{
workflow: workflow.display_name,
count: loggedInCounts[true] || 0,
loggedIn: true
},
{
workflow: workflow.display_name,
count: loggedInCounts[false] || 0,
loggedIn: false
}
];
}
participants = FileAttachment("participants@5.json").json()
getProject("Language of accidents")
subjects_ids = FileAttachment("subjects_ids@1.json").json()
subjects_image = FileAttachment("subjects_image@5.json").json()
getSubjects = (workflowId) =>
subjects
.filter((s) => s.workflow_id === workflowId)
.map((s) => ({
...s,
year: parseInt(s.year),
img: subjects_image[s.sid]?.img
}))
subjects = FileAttachment("subjects@6.json").json()
getWorkflow = (workflowId) => ({ workflow_id: workflowId, ...workflows[workflowId] })
import { T } from "@pbeshai/tidyjs"
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.
