Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Need custom sorting algorithm
#1
Hi all

I m looking for a sorting algorithm, see image.
Thanks in advance for your help.

[Image: IMG1.png] 

the sorting algorithm needs to sort the columns that are most similar like shown in the image above.  The image
was made by hand for illustration purposes.  The attached file is just a small sample but the number of columns 
will always be 112.   The idea is to find around 20 to 25 columns with the highest number of matching *'s 

The output only needs to show column numbers,  Example, if 15 columns are found to have 6 *'s in common then 
those 15 columns will be the output,  "5,12,22,35,43,50... n". 

The file I  am processing  often contains 500 or more lines each with 112 columns.  This seems like it would be easy 
enough but once I started the more complicated it got.  Any info would be greatly appreciated.

R1

Sample file, this is a .txt file which on has 25 lines of data.
https://app.box.com/s/38p52cfs6e6bbcbxsuhver7fxeb5dgcs

RSample 
 appreciate
Reply


Messages In This Thread
Need custom sorting algorithm - by random1 - 11-12-2023, 05:07 AM
RE: Need custom sorting algorithm - by SMcNeill - 11-12-2023, 06:33 AM
RE: Need custom sorting algorithm - by random1 - 11-13-2023, 11:04 AM
RE: Need custom sorting algorithm - by SMcNeill - 11-12-2023, 06:43 AM
RE: Need custom sorting algorithm - by random1 - 11-13-2023, 12:59 PM
RE: Need custom sorting algorithm - by SMcNeill - 11-12-2023, 06:05 PM
RE: Need custom sorting algorithm - by RhoSigma - 11-12-2023, 06:11 PM
RE: Need custom sorting algorithm - by random1 - 11-14-2023, 08:59 AM
RE: Need custom sorting algorithm - by bplus - 11-14-2023, 09:54 AM
RE: Need custom sorting algorithm - by SMcNeill - 11-14-2023, 10:35 AM
RE: Need custom sorting algorithm - by RhoSigma - 11-14-2023, 01:34 PM
RE: Need custom sorting algorithm - by SMcNeill - 11-14-2023, 04:35 PM
RE: Need custom sorting algorithm - by bplus - 11-14-2023, 06:07 PM
RE: Need custom sorting algorithm - by bplus - 11-15-2023, 02:51 AM



Users browsing this thread: 4 Guest(s)