How to sort within array separated by Key with comma separated value

user_911576 0
Viewed 89

How to sort withins single array separated by Key as date with comma separated value.

The legacy Timeseries is sending data in the below format 

arr1 = ['3/13/20,2179','3/14/20,2727', '3/14/20,1024' , '3/14/20,3020', '3/13/20,100', '3/13/20,190']

I'm struggling to sort it on below format the key is the date grouped by all the required values 

arr1 = [3/13/20,2179,100,190,3/14/20,2727,1024,3020]

Any pointer/hint will be helpful.

arrays javascript
3 Answers

Iterate the date, split key to get date and count. Split date-string, if you want to sort on the date. and return diff of compare in sort callback function.

Sort based on date and then count

arr1 = [
  "3/13/20,2179",
  "3/14/20,2727",
  "3/14/20,1024",
  "3/14/20,3020",
  "3/13/20,100",
  "3/13/20,190",
];
const sort = (data) => {
  return data.sort((x, y) => {
    const [mm, dd, yy, num] = x.split(/[/,]/);
    const [mm1, dd1, yy1, num1] = y.split(/[/,]/);
    const d1 = new Date(dd, mm, yy).getTime();
    const d2 = new Date(dd1, mm1, yy1).getTime();
    if (d1 !== d1) return d1 - d2;
    return Number(num) - Number(num1);
  });
};
console.log(sort(arr1));

Updated: groupBy date

arr1 = [
  "3/13/20,2179",
  "3/14/20,2727",
  "3/14/20,1024",
  "3/14/20,3020",
  "3/13/20,100",
  "3/13/20,190",
];
const group = (data) => {
  const mapped = data.reduce((map, item) => {
    const [date, num] = item.split(",");
    if (!map[date]) map[date] = [];
    !map[date].push(num);
    return map;
  }, {});
  let result = [];
  for (const key in mapped) {
    const element = mapped[key];
    result = result.concat(key).concat(element);
  }
  return result;
};
console.log(group(arr1));

user_15943590

You could group by the first part and get a flat stringed result.

var data = ['3/13/20,2179', '3/14/20,2727', '3/14/20,1024', '3/14/20,3020', '3/13/20,100', '3/13/20,190'],
    result = Object
        .entries(data.reduce((r, s) => {
            const [date, value] = s.split(',');
            r[date] = r[date] || [];
            r[date].push(value);
            return r;
        }, {}))
        .flat(2);

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

user_14476750 

const arr1 = [
  '3/13/20,2179',
  '3/14/20,2727',
  '3/14/20,1024',
  '3/14/20,3020',
  '3/13/20,100',
  '3/13/20,190',
];

const groupValuesByDate = (datesDictionary, dateWithValue) => {
  const [date, value] = dateWithValue.split(',');

  return {
    ...datesDictionary,
    [date]: datesDictionary[date] ? [...datesDictionary[date], parseInt(value, 10)] : [parseInt(value, 10)],
  };
};

const valuesGroupedByDate = arr1.reduce(groupValuesByDate, {});

let formattedDates = [];

for (date in valuesGroupedByDate) {
  const values = valuesGroupedByDate[date];
  formattedDates = [...formattedDates, date, ...values];
}

console.log(formattedDates);

user_132892230
Related