CSV Sort

by stevenkaspar

JavaScript

/*
 * Complete the function below.
 */
function doctorSort(csvString) {
    return csvString.split('\n')
      .map(r => r.split(','))
      .sort(sortRows)
      .map(r => r.join(','))
      .join('\n')
}
function sortRows(a, b){
    let a_per_week = parseFloat(a[3])
    let b_per_week = parseFloat(b[3])
    if(a_per_week === b_per_week){
        return parseFloat(a[4]) < parseFloat(b[4]) ? 1 : -1
    }
    return a_per_week > b_per_week ? 1 : -1
}

var csv = `1,alex,80405,13,5
3,bob,94123,320,1.5
2,jane,94032,35,2.8
4,will,94110,31.6,6.1
5,jess,94117,48,4
6,sam,94032,31.4,9
7,jim,94036,35,19`;

console.log(doctorSort(csv));