32:[] 31:{"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"},{"id":3,"value":"d3 = require(\"d3\")","pinned":true,"hidden":false,"mode":"ojs"},{"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"},{"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"},{"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"},{"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"},{"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"},{"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"},{"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"},{"id":121,"value":"df_2013.sort_values({by: \"rank\", inplace: true})","pinned":true,"hidden":false,"mode":"ojs"},{"id":202,"value":"df_2015.sort_values({by: \"rank\", inplace: true})","pinned":true,"hidden":false,"mode":"ojs"},{"id":204,"value":"df_2017.sort_values({by: \"rank\", inplace: true})","pinned":true,"hidden":false,"mode":"ojs"},{"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"},{"id":167,"value":"addConstantValue(df_2013, \"forbes_2013\", \"2013\")","pinned":true,"hidden":false,"mode":"ojs"},{"id":163,"value":"df_2013.print()","pinned":true,"hidden":false,"mode":"ojs"},{"id":26,"value":"df_2015.print()","pinned":true,"hidden":false,"mode":"ojs"},{"id":58,"value":"df_2017.print()","pinned":true,"hidden":false,"mode":"ojs"},{"id":74,"value":"df_2018.print()","pinned":true,"hidden":false,"mode":"ojs"},{"id":159,"value":"df_2020.print()","pinned":true,"hidden":false,"mode":"ojs"}],"files":"$W32","stdlib":"1","titling":"auto"}