25:null 26:["$","title",null,{"children":"Forbes 2000 list mining | Antoine Logean | Observable"}] 2b:[] 29:{"id":"d1d70687c96c7a6e","slug":"untitled/2","title":"Forbes 2000 list mining","thumbnail":"90efe859534ecca21688033cd2e3af4c9060aa0b8f13292b82a6ed059a68efc4","access_level":"public","create_time":"$D2021-01-09T22:26:11.854Z","update_time":"$D2021-03-04T20:29:06.412Z","view_time":null,"first_public_time":"$D2021-01-09T22:26:18.277Z","has_unpublished_edits":null,"fork":false,"stars":0,"starred":false,"owner":{"type":"team","id":"65de26a690b8cdd9","login":"alogean","name":"Antoine Logean","avatar_url":"https://avatars-next.observableusercontent.com/2417bc8d7e91f029a38337696ec8501d8cf9951c27d3f2fff595764682cf9a07","tier":"starter_2024"},"version":205,"publish_version":205,"role":null,"authored":false,"authors":[{"type":"individual","id":"e05af37d01ef3b9c","login":"alogean","name":"Antoine Logean","avatar_url":"https://avatars-next.observableusercontent.com/2417bc8d7e91f029a38337696ec8501d8cf9951c27d3f2fff595764682cf9a07","tier":null}],"members":[{"type":"individual","id":"e05af37d01ef3b9c","login":"alogean","name":"Antoine Logean","avatar_url":"https://avatars-next.observableusercontent.com/2417bc8d7e91f029a38337696ec8501d8cf9951c27d3f2fff595764682cf9a07","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":1,"collection":null,"type":"notebook","body":{"title":"Forbes 2000 list mining","cells":[{"id":9,"value":"md`# Forbes 2000 list mining\n## Loading of the lists\nLet's load the different Forbes 2000 lists from 2013, 2015, 2017, 2018 and 2020, The oldest lists from 2013 to 2018 were taken from Kaggle. The list of 2020 is taken from the web site of Forbes.`","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":3,"value":"d3 = require(\"d3\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":117,"value":"dfd = require('danfojs@0.0.15/dist/index.min.js').catch(() => {\n window.dfd.Series.prototype.print = window.dfd.DataFrame.prototype.print = function() { return print(this) };\n return window.dfd;\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":0,"value":"df_2013 = dfd.read_csv(await \"https://raw.githubusercontent.com/alogean/corpedia/master/Forbes_2000_2013.csv\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":119,"value":"df_2015 = dfd.read_csv(await \"https://raw.githubusercontent.com/alogean/corpedia/master/Forbes_2000_2015.csv\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":130,"value":"df_2017 = dfd.read_csv(await \"https://raw.githubusercontent.com/alogean/corpedia/master/Forbes_2000_2017.csv\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":132,"value":"df_2018 = dfd.read_csv(await \"https://raw.githubusercontent.com/alogean/corpedia/master/Forbes_2000_2018.csv\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":134,"value":"df_2020 = dfd.read_csv(await \"https://raw.githubusercontent.com/alogean/corpedia/master/Forbes_2000_2020.csv\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":123,"value":"function print(df) {\n const {col_types, series, columns, index, values} = df;\n const table = html`\n

\n \n \n \n \n ${series\n ? html``\n : columns.map((name, i) => html``)}\n \n \n \n ${values.map((row, i) => html`\n \n \n ${series\n ? html``\n : row.map((v, j) => html``)}\n \n `)}\n \n

	${columns}	${name}
${index[i]}	${row}	${v}

\n \n `;\n table.value = df;\n return table;\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":121,"value":"df_2013.sort_values({by: \"rank\", inplace: true})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":202,"value":"df_2015.sort_values({by: \"rank\", inplace: true})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":204,"value":"df_2017.sort_values({by: \"rank\", inplace: true})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":177,"value":"function addConstantValue(df, name, value) {\n let asize = df.shape[0];\n let new_column = Array(asize);\n for (let i = 0; i < asize; i++)\n new_column[i] = value;\n df.addColumn({ \"column\": name, \"value\": new_column })\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":167,"value":"addConstantValue(df_2013, \"forbes_2013\", \"2013\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":163,"value":"df_2013.print()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":26,"value":"df_2015.print()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":58,"value":"df_2017.print()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":74,"value":"df_2018.print()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":159,"value":"df_2020.print()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W2b","stdlib":"1","titling":"auto"}} 2a:"$29:body"