Sorting an array based on multiple values

Question

I am trying to sort the below array, based on multiple values, report_yr and report_qtr, the array should be sorted according to year first and then as per quarter(for that same year).

// input array

let arr = [{
  report_yr: '2008',
  report_qtr: '1'
},
{
  report_yr: '2019',
  report_qtr: '3'
},
{
  report_yr: '2019',
  report_qtr: '4'
},
{
  report_yr: '2017',
  report_qtr: '2'
},
{ report_yr: '2008',
  report_qtr: '2'
}];

// expected output:

[ 
{ report_yr: '2019',
report_qtr: '4' },
{ report_yr: '2019',
report_qtr: '3' },
{ report_yr: '2008',
report_qtr: '1'
},{ report_yr: '2008',
report_qtr: '2'
},
{ report_yr: '2017',
report_qtr: '2' } ];

// What I am trying:

I am trying to use loadash methods for this,

_.sortBy(arr,
      ['report_yr', 'report_qtr']);

Similarly tried with orderBy but no luck so far.

why does your result ascend with report_qtr when report_yr is 2018 but when the objects with report_yr are 2019 the objects descend? — Nick Parsons
– Nick Parsons, Commented Mar 17, 2020 at 11:52

Nenad Vracar · Accepted Answer · 2020-03-17 11:48:07Z

2

You can use sort method and do this with plain javascript.

let arr = [{"report_yr":"2008","report_qtr":"1"},{"report_yr":"2019","report_qtr":"3"},{"report_yr":"2019","report_qtr":"4"},{"report_yr":"2017","report_qtr":"2"},{"report_yr":"2008","report_qtr":"2"}]

arr.sort((a, b) => b.report_yr - a.report_yr || b.report_qtr - a.report_qtr)
console.log(arr)

answered Mar 17, 2020 at 11:48

Nenad Vracar

122k16 gold badges160 silver badges184 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Biki mallik · Accepted Answer · 2020-03-17 11:48:13Z

0

This may be work for you.

data.sort(function (x, y) {
    var n = y.report_qtr - x.report_qtr;
    if (n !== 0) {
        return n;
    }

    return y.report_yr- x.report_yr;
});

answered Mar 17, 2020 at 11:48

Biki mallik

1521 silver badge11 bronze badges

Comments

qiAlex · Accepted Answer · 2020-03-17 11:51:00Z

0

Use sort method

let arr = [{
  report_yr: '2008',
  report_qtr: '1'
},
{
  report_yr: '2019',
  report_qtr: '3'
},
{
  report_yr: '2019',
  report_qtr: '4'
},
{
  report_yr: '2017',
  report_qtr: '2'
},
{ report_yr: '2008',
  report_qtr: '2'
}]

arr.sort((b, a) => +a.report_yr - +b.report_yr || +a.report_qtr - +b.report_qtr )

console.log(arr)

answered Mar 17, 2020 at 11:51

qiAlex

4,3562 gold badges22 silver badges35 bronze badges

Comments

Ahmed Kesha · Accepted Answer · 2020-03-17 11:53:27Z

0

what If you add report_yr + report_qtr and sort descending like this

    arr = arr.sort((a, b) => {
        const one = parseInt(a.report_yr) + parseInt(a.report_qtr);
        const two = parseInt(b.report_yr) + parseInt(b.report_qtr);
        if (one > two) {
            return -1
        }
        return 1;
    });

answered Mar 17, 2020 at 11:53

Ahmed Kesha

8105 silver badges11 bronze badges

Comments

Mr. Polywhirl · Accepted Answer · 2020-03-17 12:42:28Z

Use _.orderBy instead of _.sortBy. If you do not, you cannot sort descending.

This will sort the report_qtr descending and report_yr ascending. I noticed your desired output contradicts sorting though...

let arr = [{
  report_yr: '2008',
  report_qtr: '1'
}, {
  report_yr: '2019',
  report_qtr: '3'
}, {
  report_yr: '2019',
  report_qtr: '4'
}, {
  report_yr: '2017',
  report_qtr: '2'
}, {
  report_yr: '2008',
  report_qtr: '2'
}];

let sortedArr = _.orderBy(arr, ['report_qtr', 'report_yr'], ['desc', 'asc']);

console.log(sortedArr);

.as-console-wrapper {
  top: 0;
  max-height: 100% !important;
}

<script src="https://cdnjs.cloudflare.com/ajax/libs/lodash.js/4.17.15/lodash.min.js"></script>

If you really want that order, you can do this:

Find the year frequency
Sort by frequency
Sort by year
Check if the years are odd, sort by quarter descending
Check if the years are even, sort by quarter ascending
Fall back to sorting by quarter ascending

let arr = [
  { report_yr: '2008', report_qtr: '1' },
  { report_yr: '2019', report_qtr: '3' },
  { report_yr: '2019', report_qtr: '4' },
  { report_yr: '2017', report_qtr: '2' },
  { report_yr: '2008', report_qtr: '2' }
];

const yearFreq = arr.reduce((o, i) => ({...o, [i.report_yr] : (o[i.report_yr] || 0) + 1}), {});

let sortedArray = arr.sort((a, b) => {
  let diff = yearFreq[b.report_yr] - yearFreq[a.report_yr];
  if (diff !== 0) return diff;
  let a_year = parseInt(a.report_yr, 10);
  let b_year = parseInt(b.report_yr, 10);
  diff = b_year - a_year;
  if (diff !== 0) return diff;
  let a_odd = a_year % 2 === 1;
  let b_odd = b_year % 2 === 1;
  let a_qtr = parseInt(a.report_qtr, 10);
  let b_qtr = parseInt(b.report_qtr, 10);
  if (a_odd && b_odd) return b_qtr - a_qtr;
  if (!a_odd && !b_odd) return a_qtr - b_qtr;
  return a_qtr - b_qtr;
});

console.log(sortedArray);

.as-console-wrapper { top: 0; max-height: 100% !important; }

<script src="https://cdnjs.cloudflare.com/ajax/libs/lodash.js/4.17.15/lodash.min.js"></script>

<!-- Expected

[{
  "report_yr": "2019",
  "report_qtr": "4"
}, {
  "report_yr": "2019",
  "report_qtr": "3"
}, {
  "report_yr": "2008",
  "report_qtr": "1"
}, {
  "report_yr": "2008",
  "report_qtr": "2"
}, {
  "report_yr": "2017",
  "report_qtr": "2"
}]

-->

Collectives™ on Stack Overflow

Sorting an array based on multiple values

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related