Search results

  1. K

    Sort values from multiple columns

    I don't know if what I'm going to say will seem weird, crazy or something else but the feeling I get when I see a solution like this is "elegant". It's that moment when intelligence is recognized and it doesn't need to be something complex. Simplification is often the ultimate intelligence...
  2. K

    Sort values from multiple columns

    First of all, I appreciate your dedication in trying to help. What I intend to do is pre-process data to analyze behavior. Imagine that these are balance values in which it is necessary to understand if it is possible to foresee the most usual balances for each person (with margins, of course)...
  3. K

    Sort values from multiple columns

    It's a multidimensional problem, several columns (features). The reason I want to have some columns sorted it's because I want to calculate the distance (minimum) between some features, a kind of PCA (principal components analysis), probably something you all are used to work with.
  4. K

    Sort values from multiple columns

    So elegant!!!! So, the problem now, is create an index for each number and then create another index after sort the values. PS: I have more columns to work (will try to do a ML model)
  5. K

    Sort values from multiple columns

    You're right! My "n", would be the number of columns that I want to sort even if I have a bunch of others like an ID.
  6. K

    Sort values from multiple columns

    A few thousands, time it-s not a problem it's a self-taught project/discovery
  7. K

    Sort values from multiple columns

    FIRST: Wow, what a community! After 20 minutes 3 reply trying to help! Thank you. An example of what I'm trying to do: What I have: ID; N1; N2; N3; N4 1; 10; 20; 15; 9 2; 2; 44; 5; 9 3; 7; 38; 25; 28 What I want: ID; N1; N2; N3; N4; N11; N21; N31; N41...
  8. K

    Sort values from multiple columns

    Hi, The problem: a) Table with n columns (only integers not duplicated) b) Want to order the multiple values (by row) c) Create new n columns witch have the values from n columns but sorted Imagine the euro millions numbers. I have the sequence from draw order and want to have it sorted by...
  9. K

    Hello!

    I'm Krauss from Portugal and I'm just a newbie trying to learn from myself, just for fun. Thank you
Top Bottom