List only not unique values of column and count instances of .csv file in UNIX Post: 303045059

9 More Discussions You Might Find Interesting

1. 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...

2. Shell Programming and Scripting

How to count Unique Values from a file.

Hi I have the following info in a file - <Cell id="25D"/> <Cell id="26A"/> <Cell id="26B"/> <Cell id="26C"/> <Cell id="27A"/> <Cell id="27B"/> <Cell id="27C"/> <Cell id="28A"/> I would like to know how would you go about counting all...

3. Shell Programming and Scripting

List unique values and count instances in .csv file

I need to take the second column of a .csv file and count the number of instances of each unique value in that same second column. I'd like the output to be value,count sorted by most instances. Thanks for any guidance! Data example: 317476,317756,0 816063,318861,0 313123,319091,0...

4. Shell Programming and Scripting

Find and count unique date values in a file based on position

Hello, I need some sort of way to extract every date contained in a file, and count how many of those dates there are. Here are the specifics: The date format I'm looking for is mm/dd/yyyy I only need to look after line 45 in the file (that's where the data begins) The columns of...

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...

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?

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 ,. ...

8. Shell Programming and Scripting

Count occurrence of column one unique value having unique second column value

Hello Team, I need your help on the following: My input file a.txt is as below: 3330690|373846|108471 3330690|373846|108471 0640829|459725|100001 0640829|459725|100001 3330690|373847|108471 Here row 1 and row 2 of column 1 are identical but corresponding column 2 value are...

9. 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...

LEARN ABOUT DEBIAN

passenger-status

passenger-status(8)					      Adminstration Commands					       passenger-status(8)

NAME

       passenger-status - inspect Phusion Passenger's internal status

SYNOPSIS

       passenger-status [pid]

DESCRIPTION

       passenger-status  looks	at the current status of a Phusion Passenger installation. It will locate Phusion Passenger automatically if it is
       running and will give you a list of instances if there is more than one Phusion	Passenger  instance  running.  You  can  then  select  the
       instance by specifying the relevant PID on the command line.

       The general information section shows the following details:

       max    The  maximum number of application instances that Phusion Passenger will spawn. This equals the value given for PassengerMaxPoolSize
	      in the configuration.

       count  The number of application instances that are currently alive. This value is always less than or equal to max.

       active The number of application instances that are currently processing requests. This value is always less than or equal to count.

       inactive
	      The number of application instances that are currently not processing requests, i.e. are idle. Idle application  instances  will	be
	      shutdown	after  a  while, as can be specified with PassengerPoolIdleTime in the configuration. The value of inactive equals count -
	      active.

       The applications section shows each application instance, which directory it belongs to. The sessions field shows how many HTTP client  are
       currently being processed by that application instance.

OPTIONS

       pid    The process ID of the Phusion Passenger instance you want to look at

SEE ALSO

       passenger-memory-stats(8), ps(1), top(1)

       User guide at http://www.modrails.com/documentation.html

AUTHOR

       Phusion Passenger is written by Phusion (http://www.phusion.nl)

       "Phusion" and "Phusion Passenger" are trademarks of Hongli Lai & Ninh Bui.

       This manual page was written by Neil Wilson <neil@brightbox.co.uk> for the Ubuntu project (but may be used by others).

Phusion Passenger							2.0						       passenger-status(8)