Sponsored Content
Top Forums UNIX for Beginners Questions & Answers Find unique values but only in column 1 Post 302988342 by Aia on Friday 23rd of December 2016 07:20:47 PM
Old 12-23-2016
Please, try also, the following, which it will preserve the order of appearance for the unique first fields:

Code:
 perl -nalF, -e 'unless($c{$F[0]}++){push @o, $F[0]; $d{$F[0]} = $_} END{for(@o){print "$d{$_}" if $c{$_} == 1}}' input.csv

 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Need to find only unique values for a given tag across the files

Need to find only unique values for a given tag across the files: For eg: Test1: <Tag1>aaa</Tag1> <Tag2>bbb</Tag2> <Tag3>ccc</Tag3> Test2: <Tag1>aaa</Tag1> <Tag2>ddd</Tag2> <Tag3>eee</Tag3> Test3: <Tag1>aaa</Tag1> <Tag2>ddd</Tag2> <Tag3>eee</Tag3> Test4: (8 Replies)
Discussion started by: sudheshnaiyer
8 Replies

2. Shell Programming and Scripting

Concatenating column values with unique id into single row

Hi, I have a table in Db2 with data say id_1 phase1 id_1 phase2 id_1 phase3 id_2 phase1 id_2 phase2 I need to concatenate the values like id_1 phase1,phase2,phase3 id_2 phase1,phase2 I tried recursive query but in vain as the length of string to be concatenated in quite long. ... (17 Replies)
Discussion started by: jsaravana
17 Replies

3. Shell Programming and Scripting

return a list of unique values of a column from csv format file

Hi all, I have a huge csv file with the following format of data, Num SNPs, 549997 Total SNPs,555352 Num Samples, 157 SNP, SampleID, Allele1, Allele2 A001,AB1,A,A A002,AB1,A,A A003,AB1,A,A ... ... ... I would like to write out a list of unique SNP (column 1). Could you... (3 Replies)
Discussion started by: phoeberunner
3 Replies

4. Shell Programming and Scripting

print unique values of a column and sum up the corresponding values in next column

Hi All, I have a file which is having 3 columns as (string string integer) a b 1 x y 2 p k 5 y y 4 ..... ..... Question: I want get the unique value of column 2 in a sorted way(on column 2) and the sum of the 3rd column of the corresponding rows. e.g the above file should return the... (6 Replies)
Discussion started by: amigarus
6 Replies

5. Shell Programming and Scripting

Count frequency of unique values in specific column

Hi, I have tab-deliminated data similar to the following: dot is-big 2 dot is-round 3 dot is-gray 4 cat is-big 3 hot in-summer 5 I want to count the frequency of each individual "unique" value in the 1st column. Thus, the desired output would be as follows: dot 3 cat 1 hot 1 is... (5 Replies)
Discussion started by: owwow14
5 Replies

6. Linux

To get all the columns in a CSV file based on unique values of particular column

cat sample.csv ID,Name,no 1,AAA,1 2,BBB,1 3,AAA,1 4,BBB,1 cut -d',' -f2 sample.csv | sort | uniq this gives only the 2nd column values Name AAA BBB How to I get all the columns of CSV along with this? (1 Reply)
Discussion started by: sanvel
1 Replies

7. Shell Programming and Scripting

Extracting unique values of a column from a feed file

Hi Folks, I have the below feed file named abc1.txt in which you can see there is a title and below is the respective values in the rows and it is completely pipe delimited file ,. ... (4 Replies)
Discussion started by: punpun66
4 Replies

8. UNIX for Dummies Questions & Answers

Unique values in a row sum the next column in UNIX

Hi would like to ask you guys any advise regarding my problem I have this kind of data file.txt 111111111,20 111111111,50 222222222,70 333333333,40 444444444,10 444444444,20 I need to get this file1.txt 111111111,70 222222222,70 333333333,40 444444444,30 using this code I can... (6 Replies)
Discussion started by: reks
6 Replies

9. Shell Programming and Scripting

awk to filter out lines containing unique values in a specified column

Hi, I have multiple files that each contain four columns of strings: File1: Code: 123 abc gfh 273 456 ddff jfh 837 789 ghi u4u 395 File2: Code: 123 abc dd fu 456 def 457 nd 891 384 djh 783 I want to compare the strings in Column 1 of File 1 with each other file and Print in... (3 Replies)
Discussion started by: owwow14
3 Replies

10. Shell Programming and Scripting

Count number of unique values in each column of array

What is an efficient way of counting the number of unique values in a 400 column by 1000 row array and outputting the counts per column, assuming the unique values in the array are: A, B, C, D In other words the output should look like: Value COL1 COL2 COL3 A 50 51 52... (16 Replies)
Discussion started by: Geneanalyst
16 Replies
vzlist(8)							    Containers								 vzlist(8)

NAME
vzlist - show various information about containers SYNOPSIS
vzlist [-a | -S] [-n] [-H] [-o name[,name...] | -1] [-s [-]name] [-h pattern] [-N pattern] [-d pattern] [CTID [CTID ...]] vzlist -L | --list vzlist --help DESCRIPTION
This utility is used for listing containers and their parameters. By default only running containers are listed. If one or more CTIDs are specified, only specified containers are displayed. For the fields that can have many values (e.g. ip), all the values are displayed only for the last (i.e. leftmost) column; otherwise, only the first value is shown. OPTIONS
-a, --all List all containers. -S, --stopped List only not running containers (including the ones with status shown as mounted or suspended). -n, --name Display container names instead of hostnames. -H, --no-header Suppress displaying the header row. -o, --output field[,field...] Display only the specified fields (see Standard fields subsection below). -1 Synonym for -H -octid, i.e. only show container IDs, one per line. -s, --sort [-]field Sort by the value of field (possible arguments are the same as for -o). The - before the field name means sorting in the reverse order. Output filters List of CTs can be further filtered using the following options. For patterns one can use the same wildcards as in shell (i.e. *, ?, and []). Note: to avoid expansion of wildcards by the shell, one have to escape the pattern by either putting it into single quotes (like 'a*a') or by adding a backslash before the wildcard character (like a*a). -h, --hostname pattern List only containers whose hostnames matches the pattern. -N, --name_filter pattern List only containers whose names matches the pattern. -d, --description pattern List only containers with descriptions matching the pattern. Possible fields -L, --list list all available format specifiers that can be used for both output (-o, --output) and the sorting order (-s, --sort). For the user beancounter fields, if suffix is not specified, current usage (a.k.a. "held") value is show. One can also use the fol- lowing suffixes: .m maxheld .b barrier .l limit .f fail counter For the disk quota fields, if suffix is not specified, current usage is shown. One can also use the following suffixes: .s soft limit .h hard limit EXAMPLES
vzlist -o ctid,kmemsize,kmemsize.l -s kmemsize Show CTIDs, kmemsize usage, and kmemsize limit for all running containers, sorted by the kmemsize usage. EXIT STATUS
Returns 0 upon success. COPYRIGHT
Copyright (C) 2000-2011, Parallels, Inc. Licensed under GNU GPL. OpenVZ 4 Jul 2011 vzlist(8)
All times are GMT -4. The time now is 10:56 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy