NodeJS script to sort collectors by editions (from multiple tokens) collectors.csv from https://fxcollectors.stroep.nl/

index.js

const fs = require('fs')

function getCollectors(number) {
    const data = fs.readFileSync('./collectors.csv', 'utf8')
    let lines = data.split('\n').slice(1)
    const collectorsObject = {}
    lines.forEach((l) => {
        if(l.length === 0) return
        const row = l.split(' ')

        if (row.length > 0) {
            const address = row[0]
            const editions = parseInt(row[1].replace(/[\])}[{(]/g, ''))

            if(collectorsObject[address] === undefined) {
                collectorsObject[address] = editions
            } else {
                collectorsObject[address] += editions
            }
        }
    })
    const collectorsArray = Object.keys(collectorsObject).map(
        function (e) {
            return {
                address: e,
                editions: collectorsObject[e]
            }
    })
    const sortedCollectors =  collectorsArray.sort(({editions: a}, {editions: b}) => b-a)
    for (let i = 0; i < number; i++) {
        console.log(
            `${sortedCollectors[i]['editions']}eds /https://www.fxhash.xyz/pkh/${sortedCollectors[i]['address']}/collection`
        )
    }
}


getCollectors(10)