Extracting unique values of a column from a feed file Post: 302894023

10 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

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

3. UNIX for Dummies Questions & Answers

Extracting rows from a text file based on numerical values of a column

I have a text file where the second column is a list of numbers going from small to large. I want to extract the rows where the second column is smaller than or equal to 0.0001. My input: rs10082730 9e-08 12 46002702 rs2544081 1e-07 12 46015487 rs1425136 1e-06 7 35396742 rs2712590...

4. UNIX for Dummies Questions & Answers

Extracting rows from a space delimited text file based on the values of a column

I have a space delimited text file. I want to extract rows where the third column has 0 as a value and write those rows into a new space delimited text file. How do I go about doing that? Thanks!

5. Shell Programming and Scripting

AWK, Perl or Shell? Unique strings and their maximum values from 3 column data file

I have a file containing data like so: 2012-01-02 GREEN 4 2012-01-02 GREEN 6 2012-01-02 GREEN 7 2012-01-02 BLUE 4 2012-01-02 BLUE 3 2012-01-02 GREEN 4 2012-01-02 RED 4 2012-01-02 RED 8 2012-01-02 GREEN 4 2012-01-02 YELLOW 5 2012-01-02 YELLOW 2 I can't always predict what the...

6. Shell Programming and Scripting

Script for extracting data from csv file based on column values.

Hi all, I am new to shell script.I need your help to write a shell script. I need to write a shell script to extract data from a .csv file where columns are ',' separated. The file has 5 columns having values say column 1,column 2.....column 5 as below along with their valuesm....

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

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

9. UNIX for Beginners Questions & Answers

Find unique values but only in column 1

Hi All, Does anyone have any suggestions/examples of how i could show only lines where the first field is not duplicated. If the first field is listed more than once it shouldnt be shown even if the other columns make it unique. Example file : 876,RIBDA,EC2 876,RIBDH,EX7 877,RIBDF,E28...

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

LEARN ABOUT CENTOS

repo-rss

repo-rss(1)															       repo-rss(1)

NAME

       repo-rss - generates an RSS feed from one or more Yum repositories

SYNOPSIS

       repo-rss [options] repoid1 [repoid2...]

DESCRIPTION

       repo-rss is a program for generating RSS feeds for one or more Yum repositories.

GENERAL OPTIONS

       -h, --help
	      Help; display a help message and then quit.

       -f <file>
	      Specify the file to which the RSS will be written.  Default is repo-rss.xml.

       -l <link>
	      Specify the URL to the RSS feed.	Default is http://yum.baseurl.org/.

       -t <title>
	      Specify the title for the RSS feed.  Default is "RSS Repository - Recent Packages".

       -d <description>
	      Specify the description of the RSS feed.	Default is "Most recent packages in Repositories".

       -r <days>
	      Specify the number of days to consider most recent.  Default is 3.

       --tempcache
	      Enable the use of a temporary directory for the yum cache.  This is enabled by default for non-root users.

EXAMPLES

       Generate an RSS for the updates-released repository and save it as updates-release.xml:
	      repo-rss -f updates-released.xml updates-released

FILES

       As repo-rss uses YUM libraries for retrieving all the information, it relies on YUM configuration for its default values like which reposi-
       tories to use. Consult YUM documentation for details:

       /etc/yum.conf
       /etc/yum/repos.d/
       /var/cache/yum/

SEE ALSO

       yum.conf (5)
       http://yum.baseurl.org/

AUTHORS

       See the Authors file included with this program.

BUGS

       There are of course no bugs, but should you find any, you should first consult the FAQ section on  http://yum.baseurl.org/wiki/Faq  and	if
       unsuccessful  in  finding a resolution contact the mailing list: yum-devel@lists.baseurl.org.  To file a bug use http://bugzilla.redhat.com
       for Fedora/RHEL/Centos related bugs and http://yum.baseurl.org/report for all other bugs.

Seth Vidal							       2005							       repo-rss(1)