Reputation
1,626
Top tag
Next privilege 2,000 Rep.
Edit questions and answers
Badges
1 11 37
Newest
 Yearling
Impact
~127k people reached

Apr
28
accepted Matching the order of a master list of lists from a random list of lists
Apr
28
comment Matching the order of a master list of lists from a random list of lists
correct, that's why EuclidianDistance worked. You can also just round. That happens in some measurement devices. The values in the Master list are quantities. Closest quantities (.001) are equal in this system.
Apr
28
comment Matching the order of a master list of lists from a random list of lists
The master list is always in the list. When measurements are made, they are made with the master list. In the case of duplicate keys the sort order is still the order in the master list because the master list has the same duplicate keys. If there are duplicate keys (and there will be) in the master list they will also be in the measurement lists. So long as the same values in the master list line up with the sorted list, the process works. Duplicate keys, even If their positions end up transposed, if the values match the master, the result is correct.
Apr
27
comment Matching the order of a master list of lists from a random list of lists
when running this answer on the actual files it was not able to order a list when there were duplicate values in the Master list. So I have removed the MWE data as unfortunately not working as an example and posted links to the small 300 position data sets that will provide a better example of the problem to solve.
Apr
27
comment Matching the order of a master list of lists from a random list of lists
@ciao...so (still trying to help you) what if anything do you need me to clarify about my question other than my code?
Apr
27
revised Matching the order of a master list of lists from a random list of lists
MWE was insufficient to provide a correct solution to the problem. Files and link have been posted in their place.
Apr
27
comment Matching the order of a master list of lists from a random list of lists
The list I was attempting to describe needed dimensions, then later I was asked to post a MWE. So yes the scope of the problem goes beyond a 300 part list. If you need more clarity than the above "parts 3;;6 in both lists need to match", please explain that request and I'll do my best to provide something for you.
Apr
27
revised Matching the order of a master list of lists from a random list of lists
added 6 characters in body
Apr
27
revised Matching the order of a master list of lists from a random list of lists
explain the incomplete code example posted
Apr
27
revised Matching the order of a master list of lists from a random list of lists
added 27 characters in body
Apr
26
revised Matching the order of a master list of lists from a random list of lists
changed variable name to match MWE, and clarified the question to make it more easily understandable
Apr
26
comment Matching the order of a master list of lists from a random list of lists
@JackLaVigne corrected that to match the MWE.
Apr
26
revised Matching the order of a master list of lists from a random list of lists
changed variable name to match MWE
Apr
26
comment Matching the order of a master list of lists from a random list of lists
@JackLaVigne Great Catch! That must be what's making this code blow up. Is there a fix that can be made to make this work?
Apr
26
comment Matching the order of a master list of lists from a random list of lists
@Jack LaVigne Everything looks good until step 3 where I get a length longer than the lists it sorts, which rolls into Part errors into step 4 since the lists length is limited to 300.
Apr
26
comment Matching the order of a master list of lists from a random list of lists
@Jack LaVigne Good catch, thanks! corrected that and replaced the List to be sorted with a better completely sortable list.
Apr
26
revised Matching the order of a master list of lists from a random list of lists
Added missing code as noted, and replaced the MWE List dataset to provide a more effective example.
Apr
25
comment Matching the order of a master list of lists from a random list of lists
This produced a small set of values but not an ordered list of lists. Not sure why C.E. removed most of the MWE I posted. I doubt if this is enough data to work from now.
Apr
25
revised Matching the order of a master list of lists from a random list of lists
remove comments in code because they did not add clairity
Apr
25
revised Matching the order of a master list of lists from a random list of lists
clairification