Ttyjfyk

How to Make a Beautiful Stacked 3D Plot

8 Prisoners wearing hats

Is it common practice to audition new musicians one-on-one before rehearsing with the entire band?

Why wasn't DOSKEY integrated with COMMAND.COM?

Is "Reachable Object" really an NP-complete problem?

How to answer "Have you ever been terminated?"

If a VARCHAR(MAX) column is included in an index, is the entire value always stored in the index page(s)?

Is it a good idea to use CNN to classify 1D signal?

Using audio cues to encourage good posture

Trademark violation for app?

Is the Standard Deduction better than Itemized when both are the same amount?

Dating a Former Employee

Why do we bend a book to keep it straight?

Compare a given version number in the form major.minor.build.patch and see if one is less than the other

Where are Serre’s lectures at Collège de France to be found?

Do I really need recursive chmod to restrict access to a folder?

Is it ethical to give a final exam after the professor has quit before teaching the remaining chapters of the course?

How come Sam didn't become Lord of Horn Hill?

How to compare two different files line by line in unix?

Closed form of recurrent arithmetic series summation

Why are there no cargo aircraft with "flying wing" design?

How can I use the Python library networkx from Mathematica?

What does the "x" in "x86" represent?

Can anything be seen from the center of the Boötes void? How dark would it be?

Uniq Descending Sort in a column

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;

0

In the given data is it possible to uniq sort and print only the top hits against each region?

Given Data

aza1 18
bcn1 16
sat2 12
lcy2 12
fra1 12
aza1 12
bcn1 10
sat2 8
lcy2 9
fra1 13
aza1 21
bcn1 2
sat2 10
lcy2 0
fra1 1

Required Output

aza1 21
bcn1 16
sat2 12
lcy2 12
fra1 13

sort uniq

share|improve this question

edited 9 hours ago

Inian

5,4751531

asked 9 hours ago

Maran GaneshMaran Ganesh

244

• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  Is the order important? it's easier to do if the first column can be in lexical order
  
  – steeldriver
  9 hours ago
  

  
  
  
  

add a comment | 

0

In the given data is it possible to uniq sort and print only the top hits against each region?

Given Data

aza1 18
bcn1 16
sat2 12
lcy2 12
fra1 12
aza1 12
bcn1 10
sat2 8
lcy2 9
fra1 13
aza1 21
bcn1 2
sat2 10
lcy2 0
fra1 1

Required Output

aza1 21
bcn1 16
sat2 12
lcy2 12
fra1 13

sort uniq

share|improve this question

edited 9 hours ago

Inian

5,4751531

asked 9 hours ago

Maran GaneshMaran Ganesh

244

• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  Is the order important? it's easier to do if the first column can be in lexical order
  
  – steeldriver
  9 hours ago
  

  
  
  
  

add a comment | 

In the given data is it possible to uniq sort and print only the top hits against each region?

Given Data

aza1 18
bcn1 16
sat2 12
lcy2 12
fra1 12
aza1 12
bcn1 10
sat2 8
lcy2 9
fra1 13
aza1 21
bcn1 2
sat2 10
lcy2 0
fra1 1

Required Output

aza1 21
bcn1 16
sat2 12
lcy2 12
fra1 13

sort uniq

share|improve this question

edited 9 hours ago

Inian

5,4751531

asked 9 hours ago

Maran GaneshMaran Ganesh

244

aza1 18
bcn1 16
sat2 12
lcy2 12
fra1 12
aza1 12
bcn1 10
sat2 8
lcy2 9
fra1 13
aza1 21
bcn1 2
sat2 10
lcy2 0
fra1 1

aza1 21
bcn1 16
sat2 12
lcy2 12
fra1 13

share|improve this question

edited 9 hours ago

Inian

5,4751531

asked 9 hours ago

Maran GaneshMaran Ganesh

244

share|improve this question

edited 9 hours ago

Inian

5,4751531

asked 9 hours ago

Maran GaneshMaran Ganesh

244

edited 9 hours ago

Inian

5,4751531

edited 9 hours ago

Inian

5,4751531

asked 9 hours ago

Maran GaneshMaran Ganesh

244

asked 9 hours ago

Maran GaneshMaran Ganesh

244

2 Answers
2

active

oldest

votes

0

If the order doesn't matter:

<infile sort -rnk2,2 |sort -uk1,1

-revers -numerical sort on -key column number 2 (sort -rnk2,2), then keep and -unique lines on first -key column (sort -uk1,1);

or same with awk:

<infile awk '
 arr[$1]= (arr[$1]<$2)? $2 : arr[$1] 
 END for (x in arr) print x, arr[x] '

share|improve this answer

answered 9 hours ago

αғsнιηαғsнιη

17.4k103070

add a comment | 

0

Solution if order matters, using only sort and uniq

cat <INPUT_FILE> | sort -k 1,1 -k 2nr,2 | uniq -w4

OUTPUT:

aza1 21
bcn1 16
fra1 13
lcy2 12
sat2 12

Sort parameters:

-k: sort by key (in this case column, pairs with -t)

-n: sort as a number

-r: reverse order

(optional) -t: in case you want to change the key separator (default: space)

Uniq parameter:

-w: choose the first N characters

Explanation:

In your problem, we need to first sort the first column and then the second one. So there is a -k 1,1 followed by -k 2,2.
But, the second key (ONLY) must be sorted as a number and in the reverse order.
Thus, it should be -k 2nr,2.

Note that if the -n or -r sort parameters are outside -k parameter, they are applied to the whole input instead of specific keys.

Lastly, me must find the unique lines, but matching only the first 4 chars. Thus, uniq -w 4

share|improve this answer

edited 8 hours ago

answered 9 hours ago

brunosktxbrunosktx

11

New contributor

brunosktx is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

Your Answer

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "106"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2funix.stackexchange.com%2fquestions%2f513057%2funiq-descending-sort-in-a-column%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

0

If the order doesn't matter:

<infile sort -rnk2,2 |sort -uk1,1

-revers -numerical sort on -key column number 2 (sort -rnk2,2), then keep and -unique lines on first -key column (sort -uk1,1);

or same with awk:

<infile awk '
 arr[$1]= (arr[$1]<$2)? $2 : arr[$1] 
 END for (x in arr) print x, arr[x] '

share|improve this answer

answered 9 hours ago

αғsнιηαғsнιη

17.4k103070

add a comment | 

0

If the order doesn't matter:

<infile sort -rnk2,2 |sort -uk1,1

-revers -numerical sort on -key column number 2 (sort -rnk2,2), then keep and -unique lines on first -key column (sort -uk1,1);

or same with awk:

<infile awk '
 arr[$1]= (arr[$1]<$2)? $2 : arr[$1] 
 END for (x in arr) print x, arr[x] '

share|improve this answer

answered 9 hours ago

αғsнιηαғsнιη

17.4k103070

add a comment | 

If the order doesn't matter:

<infile sort -rnk2,2 |sort -uk1,1

-revers -numerical sort on -key column number 2 (sort -rnk2,2), then keep and -unique lines on first -key column (sort -uk1,1);

or same with awk:

<infile awk '
 arr[$1]= (arr[$1]<$2)? $2 : arr[$1] 
 END for (x in arr) print x, arr[x] '

share|improve this answer

answered 9 hours ago

αғsнιηαғsнιη

17.4k103070

<infile sort -rnk2,2 |sort -uk1,1

<infile awk '
 arr[$1]= (arr[$1]<$2)? $2 : arr[$1] 
 END for (x in arr) print x, arr[x] '

share|improve this answer

answered 9 hours ago

αғsнιηαғsнιη

17.4k103070

answered 9 hours ago

αғsнιηαғsнιη

17.4k103070

answered 9 hours ago

αғsнιηαғsнιη

17.4k103070

0

Solution if order matters, using only sort and uniq

cat <INPUT_FILE> | sort -k 1,1 -k 2nr,2 | uniq -w4

OUTPUT:

aza1 21
bcn1 16
fra1 13
lcy2 12
sat2 12

Sort parameters:

-k: sort by key (in this case column, pairs with -t)

-n: sort as a number

-r: reverse order

(optional) -t: in case you want to change the key separator (default: space)

Uniq parameter:

-w: choose the first N characters

Explanation:

In your problem, we need to first sort the first column and then the second one. So there is a -k 1,1 followed by -k 2,2.
But, the second key (ONLY) must be sorted as a number and in the reverse order.
Thus, it should be -k 2nr,2.

Note that if the -n or -r sort parameters are outside -k parameter, they are applied to the whole input instead of specific keys.

Lastly, me must find the unique lines, but matching only the first 4 chars. Thus, uniq -w 4

share|improve this answer

edited 8 hours ago

answered 9 hours ago

brunosktxbrunosktx

11

New contributor

brunosktx is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

0

Solution if order matters, using only sort and uniq

cat <INPUT_FILE> | sort -k 1,1 -k 2nr,2 | uniq -w4

OUTPUT:

aza1 21
bcn1 16
fra1 13
lcy2 12
sat2 12

Sort parameters:

-k: sort by key (in this case column, pairs with -t)

-n: sort as a number

-r: reverse order

(optional) -t: in case you want to change the key separator (default: space)

Uniq parameter:

-w: choose the first N characters

Explanation:

In your problem, we need to first sort the first column and then the second one. So there is a -k 1,1 followed by -k 2,2.
But, the second key (ONLY) must be sorted as a number and in the reverse order.
Thus, it should be -k 2nr,2.

Note that if the -n or -r sort parameters are outside -k parameter, they are applied to the whole input instead of specific keys.

Lastly, me must find the unique lines, but matching only the first 4 chars. Thus, uniq -w 4

share|improve this answer

edited 8 hours ago

answered 9 hours ago

brunosktxbrunosktx

11

New contributor

brunosktx is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

Solution if order matters, using only sort and uniq

cat <INPUT_FILE> | sort -k 1,1 -k 2nr,2 | uniq -w4

OUTPUT:

aza1 21
bcn1 16
fra1 13
lcy2 12
sat2 12

Sort parameters:

-k: sort by key (in this case column, pairs with -t)

-n: sort as a number

-r: reverse order

(optional) -t: in case you want to change the key separator (default: space)

Uniq parameter:

-w: choose the first N characters

Explanation:

In your problem, we need to first sort the first column and then the second one. So there is a -k 1,1 followed by -k 2,2.
But, the second key (ONLY) must be sorted as a number and in the reverse order.
Thus, it should be -k 2nr,2.

Note that if the -n or -r sort parameters are outside -k parameter, they are applied to the whole input instead of specific keys.

Lastly, me must find the unique lines, but matching only the first 4 chars. Thus, uniq -w 4

share|improve this answer

edited 8 hours ago

answered 9 hours ago

brunosktxbrunosktx

11

New contributor

brunosktx is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

cat <INPUT_FILE> | sort -k 1,1 -k 2nr,2 | uniq -w4

aza1 21
bcn1 16
fra1 13
lcy2 12
sat2 12

share|improve this answer

edited 8 hours ago

answered 9 hours ago

brunosktxbrunosktx

11

New contributor

brunosktx is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

answered 9 hours ago

brunosktxbrunosktx

11

New contributor

brunosktx is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

answered 9 hours ago

brunosktxbrunosktx

11