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

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 DEBIAN

wiki::toolkit::feed::listing

Wiki::Toolkit::Feed::Listing(3pm)			User Contributed Perl Documentation			 Wiki::Toolkit::Feed::Listing(3pm)

NAME

       Wiki::Toolkit::Feed::Listing - parent class for Feeds from Wiki::Toolkit.

DESCRIPTION

       Handles common data fetching tasks, so that child classes need only worry about formatting the feeds.

       Also enforces some common methods that must be implemented.

METHODS

   "fetch_recently_changed_nodes"
       Based on the supplied criteria, fetch a list of the recently changed nodes

   "fetch_newest_for_recently_changed"
       Based on the supplied criteria (but not using all of those used by fetch_recently_changed_nodes), find the newest node from the recently
       changed nodes set. Normally used for dating the whole of a Feed.

   "fetch_node_all_versions"
       For a given node (name or ID), return all the versions there have been, including all metadata required for it to go into a "recent
       changes" style listing.

   "recent_changes"
       Build an Atom Feed of the recent changes to the Wiki::Toolkit instance, using any supplied parameters to narrow the results.

       If the argument "also_return_timestamp" is supplied, it will return an array of the feed, and the feed timestamp. Otherwise it just returns
       the feed.

   "node_all_versions"
       Build an Atom Feed of all the different versions of a given node.

       If the argument "also_return_timestamp" is supplied, it will return an array of the feed, and the feed timestamp. Otherwise it just returns
       the feed.

   "format_geo"
       Using the geo and space xml namespaces, format the supplied node metadata into geo: and space: tags, suitable for inclusion in a feed with
       those namespaces imported.

       The following are methods that any feed renderer must provide:

   "feed_timestamp"
       All implementing feed renderers must implement a method to produce a feed specific timestamp, based on the supplied node

   "generate_node_list_feed"
       All implementing feed renderers must implement a method to produce a feed from the supplied list of nodes

   "generate_node_name_distance_feed"
       All implementing feed renderers must implement a method to produce a stripped down feed from the supplied list of node names, and
       optionally locations and distance from a reference point.

   "parse_feed_timestamp"
       Take a feed_timestamp and return a Time::Piece object.

MAINTAINER

       The Wiki::Toolkit team, http://www.wiki-toolkit.org/.

COPYRIGHT AND LICENSE

       Copyright 2006-2009 the Wiki::Toolkit team.

       This module is free software; you can redistribute it and/or modify it under the same terms as Perl itself.

perl v5.14.2							    2011-09-25					 Wiki::Toolkit::Feed::Listing(3pm)