Order Typescript by Segment / Category

Question

Order Typescript by Segment / Category

Suppose we start with this original array of objects:

{vendor:"vendor1", item:"item1", price:1100, rank:0},
{vendor:"vendor1", item:"item2",price:3200, rank:0},
{vendor:"vendor1", item:"item3", price:1100, rank:0},

{vendor:"vendor2", item:"item1", price:2000, rank:0},
{vendor:"vendor2", item:"item2",price:2000, rank:0},
{vendor:"vendor2", item:"item3", price:3200, rank:0},

{vendor:"vendor3", item:"item1", price:3200, rank:0},
{vendor:"vendor3", item:"item2",price:1100, rank:0},
{vendor:"vendor3", item:"item3", price:2000, rank:0},

How can we assign ranks based on the price property within each item category in comparison to all vendors offering the same item?

Desired Output:

{vendor:"vendor1", item:"item1", price:1100, rank:1},
{vendor:"vendor1", item:"item2",price:3200, rank:3},
{vendor:"vendor1", item:"item3", price:1100, rank:1},

{vendor:"vendor2", item:"item1", price:2000, rank:2},
{vendor:"vendor2", item:"item2",price:2000, rank:2},
{vendor:"vendor2", item:"item3", price:3200, rank:3},

{vendor:"vendor3", item:"item1", price:3200, rank:3},
{vendor:"vendor3", item:"item2",price:1100, rank:1},
{vendor:"vendor3", item:"item3", price:2000, rank:2},

javascript typescript sorting rank

Answer 1

Answer №1

GUIDELINES:

Identify unique items
Divide the array into smaller arrays based on unique items and sort by price
Adjust the rank for each object in every separated array
Combine all arrays back together
Arrange them according to vendor to restore the original sequence

let arr = [{vendor:"vendor1", item:"item1", price:1000, rank:0},
{vendor:"vendor1", item:"item2",price:3000, rank:0},
{vendor:"vendor1", item:"item3", price:1000, rank:0},
{vendor:"vendor2", item:"item1", price:2000, rank:0},
{vendor:"vendor2", item:"item2",price:2000, rank:0},
{vendor:"vendor2", item:"item3", price:3000, rank:0},
{vendor:"vendor3", item:"item1", price:3000, rank:0},
{vendor:"vendor3", item:"item2",price:1000, rank:0},
{vendor:"vendor3", item:"item3", price:2000, rank:0},]
let items = [...new Set(arr.map(o => o.item))]
let resultArr = []
items.forEach(item => {
  let filteredArr = arr.filter(o => o.item === item)
  filteredArr.sort((a,b) => (a.price > b.price) ? 1 : ((b.price > a.price) ? -1 : 0))
  for(let i = 0; i < filteredArr.length; i++){
    filteredArr[i].rank = i + 1
  }
  resultArr = resultArr.concat(filteredArr)
})
resultArr.sort((a,b) => (a.vendor > b.vendor) ? 1 : ((b.vendor > a.vendor) ? -1 : 0))
console.log(resultArr)

Answer 2

GUIDELINES:

Identify unique items
Divide the array into smaller arrays based on unique items and sort by price
Adjust the rank for each object in every separated array
Combine all arrays back together
Arrange them according to vendor to restore the original sequence

let arr = [{vendor:"vendor1", item:"item1", price:1000, rank:0},
{vendor:"vendor1", item:"item2",price:3000, rank:0},
{vendor:"vendor1", item:"item3", price:1000, rank:0},
{vendor:"vendor2", item:"item1", price:2000, rank:0},
{vendor:"vendor2", item:"item2",price:2000, rank:0},
{vendor:"vendor2", item:"item3", price:3000, rank:0},
{vendor:"vendor3", item:"item1", price:3000, rank:0},
{vendor:"vendor3", item:"item2",price:1000, rank:0},
{vendor:"vendor3", item:"item3", price:2000, rank:0},]
let items = [...new Set(arr.map(o => o.item))]
let resultArr = []
items.forEach(item => {
  let filteredArr = arr.filter(o => o.item === item)
  filteredArr.sort((a,b) => (a.price > b.price) ? 1 : ((b.price > a.price) ? -1 : 0))
  for(let i = 0; i < filteredArr.length; i++){
    filteredArr[i].rank = i + 1
  }
  resultArr = resultArr.concat(filteredArr)
})
resultArr.sort((a,b) => (a.vendor > b.vendor) ? 1 : ((b.vendor > a.vendor) ? -1 : 0))
console.log(resultArr)

Answer 3

Answer №2

Give this a shot. The ranking is determined by the price value

var array = [{vendor:"vendor1", item:"item1", price:1000, rank:0}, {vendor:"vendor1", item:"item2",price:1000, rank:0}, {vendor:"vendor1", item:"item3", price:1000, rank:0}, {vendor:"vendor2", item:"item1", price:2000, rank:0}, {vendor:"vendor2", item:"item2",price:2000, rank:0}, {vendor:"vendor2", item:"item3", price:2000, rank:0}, {vendor:"vendor3", item:"item1", price:3000, rank:0}, {vendor:"vendor3", item:"item2",price:3000, rank:0}, {vendor:"vendor3", item:"item3", price:3000, rank:0}];
array.forEach(item => item.rank = (item.price/1000))
console.log(array)

Answer 4

Give this a shot. The ranking is determined by the price value

var array = [{vendor:"vendor1", item:"item1", price:1000, rank:0}, {vendor:"vendor1", item:"item2",price:1000, rank:0}, {vendor:"vendor1", item:"item3", price:1000, rank:0}, {vendor:"vendor2", item:"item1", price:2000, rank:0}, {vendor:"vendor2", item:"item2",price:2000, rank:0}, {vendor:"vendor2", item:"item3", price:2000, rank:0}, {vendor:"vendor3", item:"item1", price:3000, rank:0}, {vendor:"vendor3", item:"item2",price:3000, rank:0}, {vendor:"vendor3", item:"item3", price:3000, rank:0}];
array.forEach(item => item.rank = (item.price/1000))
console.log(array)

Answer 5

Answer №3

To organize the grouped price values, sort them, and assign the correct index as rank.

var data = [{ vendor: "vendor1", item: "item1", price: 1100, rank: 0 }, { vendor: "vendor1", item: "item2", price: 3200, rank: 0 }, { vendor: "vendor1", item: "item3", price: 1100, rank: 0 }, { vendor: "vendor2", item: "item1", price: 2000, rank: 0 }, { vendor: "vendor2", item: "item2", price: 2000, rank: 0 }, { vendor: "vendor2", item: "item3", price: 3200, rank: 0 }, { vendor: "vendor3", item: "item1", price: 3200, rank: 0 }, { vendor: "vendor3", item: "item2", price: 1100, rank: 0 }, { vendor: "vendor3", item: "item3", price: 2000, rank: 0 }],     collection = data.reduce((r, o) => ((r[o.item] = r[o.item] || []).push(o.price), r), {});

Object.values(collection).forEach(a => a.sort((a, b) => a - b));

data.forEach(o => o.rank = collection[o.item].indexOf(o.price) + 1);

console.log(data);

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

Answer 6

To organize the grouped price values, sort them, and assign the correct index as rank.

var data = [{ vendor: "vendor1", item: "item1", price: 1100, rank: 0 }, { vendor: "vendor1", item: "item2", price: 3200, rank: 0 }, { vendor: "vendor1", item: "item3", price: 1100, rank: 0 }, { vendor: "vendor2", item: "item1", price: 2000, rank: 0 }, { vendor: "vendor2", item: "item2", price: 2000, rank: 0 }, { vendor: "vendor2", item: "item3", price: 3200, rank: 0 }, { vendor: "vendor3", item: "item1", price: 3200, rank: 0 }, { vendor: "vendor3", item: "item2", price: 1100, rank: 0 }, { vendor: "vendor3", item: "item3", price: 2000, rank: 0 }],     collection = data.reduce((r, o) => ((r[o.item] = r[o.item] || []).push(o.price), r), {});

Object.values(collection).forEach(a => a.sort((a, b) => a - b));

data.forEach(o => o.rank = collection[o.item].indexOf(o.price) + 1);

console.log(data);

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

Answer 7

Answer №4

If you want to organize the array based on the 'item' and 'price', you can utilize the sort method. Following that, iterate through the sorted array and give each element a 'rank' depending on whether the preceding 'item' matches the current 'item':

const arr = [{vendor:"vendor1",item:"item1",price:1100,rank:0},{vendor:"vendor1",item:"item2",price:3200,rank:0},{vendor:"vendor1",item:"item3",price:1100,rank:0},{vendor:"vendor2",item:"item1",price:2000,rank:0},{vendor:"vendor2",item:"item2",price:2000,rank:0},{vendor:"vendor2",item:"item3",price:3200,rank:0},{vendor:"vendor3",item:"item1",price:3200,rank:0},{vendor:"vendor3",item:"item2",price:1100,rank:0},{vendor:"vendor3",item:"item3",price:2000,rank:0}]

const output = arr.sort((a, b) => a.item.localeCompare(b.item) || a.price - b.price)
  .map((o, i) => {
    const prev = arr[arr.length - 1]
    const rank = prev && prev.item === o.item
                   ? prev.rank + 1
                   : 1;
                   
    return { ...o, rank }
  })

console.log(output)

Answer 8

If you want to organize the array based on the 'item' and 'price', you can utilize the sort method. Following that, iterate through the sorted array and give each element a 'rank' depending on whether the preceding 'item' matches the current 'item':

const arr = [{vendor:"vendor1",item:"item1",price:1100,rank:0},{vendor:"vendor1",item:"item2",price:3200,rank:0},{vendor:"vendor1",item:"item3",price:1100,rank:0},{vendor:"vendor2",item:"item1",price:2000,rank:0},{vendor:"vendor2",item:"item2",price:2000,rank:0},{vendor:"vendor2",item:"item3",price:3200,rank:0},{vendor:"vendor3",item:"item1",price:3200,rank:0},{vendor:"vendor3",item:"item2",price:1100,rank:0},{vendor:"vendor3",item:"item3",price:2000,rank:0}]

const output = arr.sort((a, b) => a.item.localeCompare(b.item) || a.price - b.price)
  .map((o, i) => {
    const prev = arr[arr.length - 1]
    const rank = prev && prev.item === o.item
                   ? prev.rank + 1
                   : 1;
                   
    return { ...o, rank }
  })

console.log(output)

Answer 9

Answer №5

To achieve this, you can utilize the map method.

var data = [{vendor: "vendor1", item: "item1", price: 1000, rank: 0},
{vendor: "vendor1", item: "item2", price: 3000, rank: 0},
{vendor: "vendor1", item: "item3", price: 1000, rank: 0},

{vendor: "vendor2", item: "item1", price: 2000, rank: 0},
{vendor: "vendor2", item: "item2", price: 2000, rank: 0},
{vendor: "vendor2", item: "item3", price: 3000, rank: 0},

{vendor: "vendor3", item: "item1", price: 3000, rank: 0},
{vendor: "vendor3", item: "item2", price: 1000, rank: 0},
{vendor: "vendor3", item: "item3", price: 2000, rank: 0}];
data.map(item => item.rank = (item.price / 1000))
console.log(data)

Alternatively, you can also apply the changes using the forEach method.

var data = [{vendor: "vendor1", item: "item1", price: 1000, rank: 0},
{vendor: "vendor1", item: "item2", price: 3000, rank: 0},
{vendor: "vendor1", item: "item3", price: 1000, rank: 0},

{vendor: "vendor2", item: "item1", price: 2000, rank: 0},
{vendor: "vendor2", item: "item2", price: 2000, rank: 0},
{vendor: "vendor2", item: "item3", price: 3000, rank: 0},

{vendor: "vendor3", item: "item1", price: 3000, rank: 0},
{vendor: "vendor3", item: "item2", price: 1000, rank: 0},
{vendor: "vendor3", item: "item3", price: 2000, rank: 0}];
data.forEach(item => item.rank = (item.price / 1000))
console.log(data)

Answer 10

To achieve this, you can utilize the map method.

var data = [{vendor: "vendor1", item: "item1", price: 1000, rank: 0},
{vendor: "vendor1", item: "item2", price: 3000, rank: 0},
{vendor: "vendor1", item: "item3", price: 1000, rank: 0},

{vendor: "vendor2", item: "item1", price: 2000, rank: 0},
{vendor: "vendor2", item: "item2", price: 2000, rank: 0},
{vendor: "vendor2", item: "item3", price: 3000, rank: 0},

{vendor: "vendor3", item: "item1", price: 3000, rank: 0},
{vendor: "vendor3", item: "item2", price: 1000, rank: 0},
{vendor: "vendor3", item: "item3", price: 2000, rank: 0}];
data.map(item => item.rank = (item.price / 1000))
console.log(data)

Alternatively, you can also apply the changes using the forEach method.

var data = [{vendor: "vendor1", item: "item1", price: 1000, rank: 0},
{vendor: "vendor1", item: "item2", price: 3000, rank: 0},
{vendor: "vendor1", item: "item3", price: 1000, rank: 0},

{vendor: "vendor2", item: "item1", price: 2000, rank: 0},
{vendor: "vendor2", item: "item2", price: 2000, rank: 0},
{vendor: "vendor2", item: "item3", price: 3000, rank: 0},

{vendor: "vendor3", item: "item1", price: 3000, rank: 0},
{vendor: "vendor3", item: "item2", price: 1000, rank: 0},
{vendor: "vendor3", item: "item3", price: 2000, rank: 0}];
data.forEach(item => item.rank = (item.price / 1000))
console.log(data)

Order Typescript by Segment / Category

Answer №1

Answer №2

Answer №3

Answer №4

Answer №5

Similar questions

javascript - convert a JSON string into an object without using quotation marks

Generating an order prior to payment being made by the customer

What is the best way to transfer the variant property of the material-ui TextField when using a higher-level React component?

Linking a string value to a specific data structure in TypeScript

Steps to create a toggle feature for the FAQ accordion

AngularJS does not recognize the service being referenced

Is it possible that data scraping with puppeteer consistently retrieves information solely from the initial page?

Experiencing difficulty moving information from React form to DATA.txt file through Express

Updating your Heroku app (Node.js) from a GitHub repository - a step-by-step guide

Interacting with shadow DOM elements using Selenium's JavaScriptExecutor in Polymer applications

Having trouble getting Vuejs to work when appending an element to Fullcalender

Establishing communication between a master process and worker processes in Node.js: A guide to verifying bidirectional communication

I'm having trouble customizing the appearance of a Tab Panel using the TabsAPI. The panel keeps expanding in strange ways. How can I

React Project Encounters NPM Installation Failure

Wrap every character in a span tag within this text

React Timer App: The setInterval function is being reset after each render operation

React: Content has not been refreshed

Converting an array of arguments into tuples within the range of <T extends Tuple> is denoted by [T, (...args: NonNullArray<T>) => any], where each tuple represents the argument of a

Determining the Size and Color of Squares in a Treemap Based on Content with D3.js

Escaping an equal sign in JavaScript when using PHP