JavaScript is used for sorting an array by transposing the elements

Question

JavaScript is used for sorting an array by transposing the elements

When I transpose my array 'solverPacks_', it creates columns for Excel. However, the values in the columns are not sorted from high to low...

var transposeToExcel = solverPacks_[0]
    .map((_, colIndex) => solverPacks_.map(row => row[colIndex])
      .join('\t')
    ).join('\n');
  console.log("transposeToExcel = " + "\n" + transposeToExcel);

Is there a way to sort the numbers from high to low in the columns while transposing? I would like it to look like this (showing only the first column):

4298 4275 4228 4199 4189 4012 4008 3700 3659 3614 3595 3579

Thank you for taking the time to read this! Christina

javascript

Answer 1

Answer №1

If you're looking to organize your data by column, you'll need to rearrange those columns first. For example, converting an array like [[1,2],[3,4]] into [[1,3],[2,4]]. Once you've done that, you can proceed with sorting the data and then revert it back to its original form:

const dataSet = [
  [8,3,5],
  [9,2,6],
  [7,4,1]
]

const transposeData = (rows) => Array.from({ length: rows.length }, (_, index) => rows.map(row => row[index]))
const sortedData = transposeData(transposeData(dataSet).map(arr => arr.sort().reverse()))
console.log(sortedData.map(JSON.stringify))

Answer 2

If you're looking to organize your data by column, you'll need to rearrange those columns first. For example, converting an array like [[1,2],[3,4]] into [[1,3],[2,4]]. Once you've done that, you can proceed with sorting the data and then revert it back to its original form:

const dataSet = [
  [8,3,5],
  [9,2,6],
  [7,4,1]
]

const transposeData = (rows) => Array.from({ length: rows.length }, (_, index) => rows.map(row => row[index]))
const sortedData = transposeData(transposeData(dataSet).map(arr => arr.sort().reverse()))
console.log(sortedData.map(JSON.stringify))

JavaScript is used for sorting an array by transposing the elements

Answer №1

Similar questions

The Angular application must remain logged in until it is closed in the browser

How to verify if an object is empty in an AngularJS expression

Tips for aligning an element in the center in relation to its sibling above

Retrieve the calculated events of an HTML element using JavaScript

What could be the reason behind three.js SVGLoader flipping SVGs upside down during rendering?

Applying a CSS class to a newly generated row with JavaScript

Can you explain the concept behind the event processing loop in Node.js?

execute a jQuery function within a data list component

What is the best method for managing file storage and retrieval in web applications that only run on the client-side?

Exploring the hidden contents within the zip file

Locate the hyperlink within a div using JavaScript and navigate to it

I am looking for a highly specialized jQuery selector that fits my exact requirements

Tips for detecting when no checkboxes in a group are selected or when at least one checkbox is selected, and then applying a class to the corresponding div

Leveraging icons with Bootstrap 4.5

Divide the data received from an AJAX request

Identify data points on the line chart that fall outside the specified range with ng2-charts

Processing requests through Axios and Express using the methods GET, POST, PUT, and DELETE

Tips for ensuring sequential execution of $.post requests without ajax alternative

What is the process for obtaining X through the use of createElement('img')?

Removing elements from an array with reduced speed