2e:null 2f:["$","title",null,{"children":"Criterion top 10 picks explorer | Sepand Ansari | Observable"}] 34:[{"id":"1f9cefa99dc1f67b6b82da334e745c7f7443d3217c61331acd8e5b148e7a8fd112cd59830f30efb115236d070eb03a8b5f2c5d0abc76419741b510f8b29d4698","href":"https://static.observableusercontent.com/files/1f9cefa99dc1f67b6b82da334e745c7f7443d3217c61331acd8e5b148e7a8fd112cd59830f30efb115236d070eb03a8b5f2c5d0abc76419741b510f8b29d4698","name":"top10.json","type":"application/json","lastModified":1609285417728.178,"size":2064090},{"id":"6b8a2abd64dae1f7dfa6adce03780d74fd466db03fb7176f8f7cb2ff020c8d295e7a2860430e7b0e524abb1085fd56ae575e2ce1c07a9cc2e46e36897a602654","href":"https://static.observableusercontent.com/files/6b8a2abd64dae1f7dfa6adce03780d74fd466db03fb7176f8f7cb2ff020c8d295e7a2860430e7b0e524abb1085fd56ae575e2ce1c07a9cc2e46e36897a602654","name":"movies.json","type":"application/json","lastModified":1609351268720.495,"size":249154},{"id":"402545c2d13f70cd4c8a2d4fda6fe0fe2202cc6ba3497580a1d48cc5d0230b204d68744a86e448f15ec28df49bc832d77d072741e570cf1c048fcbf07b6b5eb2","href":"https://static.observableusercontent.com/files/402545c2d13f70cd4c8a2d4fda6fe0fe2202cc6ba3497580a1d48cc5d0230b204d68744a86e448f15ec28df49bc832d77d072741e570cf1c048fcbf07b6b5eb2","name":"top10@1.json","type":"application/json","lastModified":1609353461391.297,"size":2083893}] 32:{"id":"16371c849fb790b4","slug":"criterion","title":"Criterion top 10 picks explorer","thumbnail":"dbca3c90b138cb8ee44ac46eaa8b5e548324e2e36abaac619fce3458f66712b8","access_level":"public","create_time":"$D2020-12-29T23:42:48.722Z","update_time":"$D2023-05-04T16:47:26.703Z","view_time":null,"first_public_time":"$D2020-12-30T02:07:45.615Z","has_unpublished_edits":null,"fork":false,"stars":2,"starred":false,"owner":{"type":"team","id":"b337ed3e32e6b28a","login":"sepans","name":"Sepand Ansari","avatar_url":"https://avatars-next.observableusercontent.com/4949e3ce1cc496571515afa8ec6ba78cfa2d0975bdaee8a19b2b0e3fab72db19","tier":"starter_2024"},"version":676,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"690defe36945fea1","login":"sepans","name":"Sepand Ansari","avatar_url":"https://avatars-next.observableusercontent.com/4949e3ce1cc496571515afa8ec6ba78cfa2d0975bdaee8a19b2b0e3fab72db19","tier":null}],"members":[{"type":"individual","id":"690defe36945fea1","login":"sepans","name":"Sepand Ansari","avatar_url":"https://avatars-next.observableusercontent.com/4949e3ce1cc496571515afa8ec6ba78cfa2d0975bdaee8a19b2b0e3fab72db19","tier":null,"role":"editor"}],"comments":[{"id":"f22bdd88eabe85d6","reply_to_id":null,"content":"testing comment","create_time":"$D2022-03-04T16:34:56.993Z","update_time":null,"resolved":true,"user":{"type":"individual","id":"690defe36945fea1","login":"sepans","name":"Sepand Ansari","avatar_url":"https://avatars-next.observableusercontent.com/4949e3ce1cc496571515afa8ec6ba78cfa2d0975bdaee8a19b2b0e3fab72db19","tier":null}}],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":2,"collection":null,"type":"notebook","body":{"title":"Criterion top 10 picks explorer","cells":[{"id":0,"value":"md`\n

\n# Criterion top 10 picks explorer\n\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":672,"value":"These are some explorations on the criterion's [top 10 picks](https://www.criterion.com/current/top-10-lists) data I scraped. Instead of going through each person's pick you can see aggregated data on top picks, countries and film durations.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":152,"value":"md`## Top Movies\nBy total number of times picked by someone.\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":46,"value":"table(topMovesTableData, {columns: [{title: 'cover'}, {title: 'title'}, {title: 'director'}, {title: 'country'}, {title: 'year'}, {title: 'count'}], paged: 10, sortable: false})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":267,"value":"md`## Top directors`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":40,"value":"\n\ntable(directorTableData, {\n columns: [\n {title: 'director'}, \n {title: 'Picked movies (count)'},\n {title: 'total count'}\n ], \n sortable: false,\n \n paged: 8\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":262,"value":"md`## Search for a movie title and see who has picked it\nNot a fuzzy search, exact match only`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":119,"value":"\nviewof movieName = text({title: 'Movie title', submit: 'Go', description: 'Search movies (exact title)', placeholder: 'Close-up'}) ","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":161,"value":"\nmd`### ${Array.from(uniqueMovies).map(movie => movie).join(\" / \")}\n\n

\n\n*Year:* ${filteredByMovie[0].year}
\n*Country:* ${filteredByMovie[0].country}
\n*Language:* ${filteredByMovie[0].language}
\n*Duration:* ${filteredByMovie[0].duration}
\n\nTotal count: ${filteredByMovie.length}\n\n#### Movie was picked by:\n`\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":142,"value":"filterTableData.length && table(filterTableData, { columns: [{title: 'by'}, {title: 'rank'}, {title: 'story'}], })","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":462,"value":"md`## Top movies by country/countries`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":397,"value":"viewof countryChart = embed({\n $schema: 'https://vega.github.io/schema/vega-lite/v4.json',\n width: 700,\n height: 600,\n data: {\n values: movieByCountryChartData,\n name: 'source'\n },\n selection: {\n label: {type: 'single'}\n },\n mark: {type: 'bar', tooltip: {\"content\": \"data\"}},\n encoding: {\n x: {field: 'country', type: 'ordinal', sort: \"-y\"},\n y: {field: 'count', type: 'quantitative'},\n //tooltip: {field: 'tooltip', type: 'ordinal'},\n color: {\n condition: {selection: 'label', value: 'steelblue'},\n value: 'grey'\n }\n }\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":518,"value":"md`## Who likes old movies? Who likes long movies?\n\nTop pickers sorted by median/mean/min/max of picked movies \n\nscroll → \n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":616,"value":"viewof yAxisParam = select({\n title: \"Comparison parameter\",\n description: \"Select year to compar picks based on year it was made or duration\",\n options: [\n {label: \"Year made\", value: \"year\"},\n {label: \"Duration\", value:\"durationMinutes\"}],\n value: \"year\"\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":559,"value":"viewof yearSort = select({\n title: \"Sort by\",\n description: \"Sort pickers by ... of comparison parameter (hint: Median, e.g. the middle point, is the most meaningful but Min and Max give nice looking charts)\",\n options: [\"min\", \"max\", \"mean\", \"median\"],\n value: \"max\"\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":468,"value":"viewof tickchart = embed({\n $schema: 'https://vega.github.io/schema/vega-lite/v4.json',\n width: 1800,\n height: 600,\n data: {\n values: yearChartData,\n name: 'source'\n },\n selection: {\n label: {type: 'single'}\n },\n mark: {type: 'tick', tooltip: {content: \"data\"}},\n encoding: {\n x: {field: 'pickedBy', type: 'ordinal', format: \"x\", sort: {op: yearSort, field: yAxisParam, order: \"ascending\"}},\n y: {field: yAxisParam, type: 'quantitative', scale: {zero: false}},\n //tooltip: {field: 'tooltip', type: 'ordinal'},\n color: {\n field: \"countryColor\", \n type: \"nominal\",\n scale: { scheme: \"category10\"}\n },\n },\n config: {\n tick: {\n thickness: 5,\n bandSize: 8\n }\n } \n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":656,"value":"md`## Data massaging`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":281,"value":"movieNameOrDefault = movieName || 'Close-up' ","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":124,"value":"filteredByMovie = allMovies.filter(d => { return d.title.toLowerCase() === movieNameOrDefault.toLowerCase()} )","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":182,"value":"uniqueMovies = new Set(filteredByMovie.map(d => `${d.title} - ${d.director}`))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":137,"value":"filterTableData = filteredByMovie.map(movie => {\n return [\n html`${movie.pickedBy}`,\n movie.count,\n html`${movie.desc}`\n ]\n}) ","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":94,"value":"directorTableData = topDirectors.map(topDirector => {\n const name = topDirector[0]\n const count = topDirector[1].count\n const groupByMovie = d3.rollups(topDirector[1].fans, v => { return { count: v.length, href: v[0].href }} , d => d.title).sort((a, b) => b[1].count - a[1].count)\n const countOfEachMovie = groupByMovie.map(d=> { return `${d[0]} (${d[1].count})`}).join(\"
\")\n return [\n name,\n html`${countOfEachMovie}`,\n html`${count}`\n ]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":30,"value":"topDirectors = d3.rollups(allMovies, v => { return { count: v.length, fans: v}}, d => d.director).sort((a, b) => b[1].count - a[1].count)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":11,"value":"topMovies = d3.rollups(allMovies, \n v => {\n return { \n count: v.length, \n movie: _.pick(v[0], ['href', 'thumbnail', 'title', 'director', 'country', 'year', 'language' ]),\n pickers: v.map(picker => { return { picker: picker.pickedBy, pickerPage: picker.pickerPage }})\n }}, \n d => `${d.title} - ${d.director}`)\n.sort((a, b) => b[1].count - a[1].count)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":356,"value":"topMovesTableData = topMovies.map(topMovie => {\n return [\n html`

`, \n html`${topMovie[1].movie.title}`,\n topMovie[1].movie.director,\n topMovie[1].movie.country,\n topMovie[1].movie.year,\n html`${topMovie[1].count}`,\n ]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":387,"value":"movieByCountryPicked = d3.rollups(allMovies, \n v => { \n return { \n count: v.length,\n movieTitles: d3.rollups(v, vv => vv.length, d => d.title).sort((a, b) => b[1] - a[1]).map(movie => `${movie[0]} (${movie[1]})`).join(\", \")\n }\n }, \n d => d.country && d.country)\n.sort((a, b) => b[1].count - a[1].count)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":403,"value":"movieByCountryChartData = movieByCountryPicked.map(d => { return { country: d[0], count: d[1].count, movies: d[1].movieTitles }})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":659,"value":"countriesToColor = [\"United States\", \"United Kingdom\", \"France\", \"Italy\", \"Japan\"]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":497,"value":"yearChartData = allMovies.map(movie => {\n const countryColor = countriesToColor.includes(movie.country) ? movie.country : \"Other\"\n return _.assign(_.omit(movie, ['cover', 'thumbnail', 'pickerPage', 'href', 'desc']), {countryColor: countryColor})\n})\n.filter(item => { \n return (yAxisParam === 'year' && item.year && !item.year.includes(\"minutes\")) || \n (yAxisParam === 'durationMinutes' && item.durationMinutes && !isNaN(item.durationMinutes))\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":544,"value":"noYear = allMovies.filter(item => item.year && item.year.includes(\"minutes\"))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":37,"value":"md`## Data Loading`","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":4,"value":"json = FileAttachment(\"top10@1.json\").json()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":292,"value":"movieMeta = FileAttachment(\"movies.json\").json()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":295,"value":"movieMetaDict = movieMeta.reduce((acc, curr) => {\n acc[curr.name] = curr\n return acc\n}, {})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":8,"value":"allMovies = json.flatMap(fan => {\n const movies = fan.topList.map((movie) => {\n const title = movie.title !== 'The Apu Trilogy' ? movie.title : 'Pather Panchali' \n const movieMeta = movieMetaDict[title]\n return {pickedBy: fan.name.replace(\"’s Top10\", \"\"), ...movie, ...movieMeta, durationMinutes: movieMeta && movieMeta.duration && parseInt(movieMeta.duration.replace(\" minutes\",\"\")), pickerPage: fan.link}\n })\n return movies\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":399,"value":"embed = require(\"vega-embed@6\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":12,"value":"d3 = require(\"d3-array@2\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":342,"value":"_ = require(\"lodash\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":35,"value":"import {table} from \"@tmcw/tables@513\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":117,"value":"import {text} from \"@jashkenas/inputs\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":556,"value":"import {select} from \"@jashkenas/inputs\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W34","stdlib":"1","titling":"auto"}} 33:"$32:body"