List only duplicate values of column and count instances of .csv file in UNIX
I need to take any one of the column of a .csv file and count the number of instances of each not unique value in that column. I'd like the output to be value,count sorted by most instances. Thanks for any guidance!
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)
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... (4 Replies)
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 Replies)
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... (2 Replies)
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)
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)
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)
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... (4 Replies)
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
LEARN ABOUT NETBSD
de
DE(4) BSD Kernel Interfaces Manual DE(4)NAME
de -- DECchip 21040, 21140, 21141, 21142, and 21143 PCI Ethernet interface driver
SYNOPSIS
de* at pci? dev ? function ?
Configuration of PHYs may also be necessary. See mii(4).
DESCRIPTION
The de driver supports Ethernet and Fast Ethernet interfaces based on the Digital Equipment Corporation DECchip 21040, 21140, 21141, 21142,
and 21143 model controllers for PCI bus.
21040 10BASE-T and AUI/BNC
21140 10BASE-T and 100BASE-TX
21141 10BASE-T and 100BASE-TX
21142 10BASE-T and 100BASE-TX
21143 10BASE-T and 100BASE-TX
Supported Network Interface Cards (NIC) include, but are not limited to:
Accton EN1207i
Cogent EM100
Asante AsanteFAST
DEC DE435
DEC DE450
DEC DE500
SMC 9332
Znyx NetBlaster ZX340 series (345, 348, 346)
Generally, if the NIC is for PCI bus, and the major controller chip has the DIGITAL logo on it, with one of the model numbers above, the de
driver should recognize and control it. Beware, however, that many NIC manufacturers change the Ethernet controller chip without changing
the product model number, and a physical inspection of the NIC, or a probe of the NIC with a PCI diagnostic tool is the only way to tell if a
real DEC TULIP controller is present.
Multi-port interfaces are typically configured as a PCI-PCI bridge with multiple de instances on the PCI bus on the other side of the bridge.
DEC sold its semiconductor division to Intel. In addition, there are many "knock-offs" of the DEC TULIP Ethernet controller chips; NICs
based on these chips are handled by the tlp(4) driver.
This de driver should not be confused with the NetBSD VAX de driver for the DEC DEUNA/DELUA Ethernet controller for UniBus.
SEE ALSO ifmedia(4), intro(4), mii(4), pci(4), tlp(4), ifconfig(8)
http://www.adaptec.com/, http://www.asante.com/, http://www.smc.com/, http://www.znyx.com/
HISTORY
The de driver first appeared in NetBSD 1.1
AUTHORS
Matt Thomas <matt@3am-software.com>.
BSD February 11, 2000 BSD