01-02-2018
CSV File:Filter duplicate records from column1 & another column having unique record
Hi Rudic,
Thank you
It worked
You saved my life.
Salute you.
Also, pls can you let me know how this code is performing the required task.
what C stands for
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
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
2. Shell Programming and Scripting
Hi,
Need to find a duplicate records on the first column,
ANU4501710430989 0000000W20389390
ANU4501710430989 0000000W67065483
ANU4501130050520 0000000W80838713
ANU4501210170685 0000000W69246611... (3 Replies)
Discussion started by: Murugesh
3 Replies
3. UNIX for Dummies Questions & Answers
Hi Unix gurus,
Maybe it is too much to ask for but please take a moment and help me out. A very humble request to you gurus. I'm new to Unix and I have started learning Unix. I have this project which is way to advanced for me.
File format: CSV file
File has four columns with no header... (8 Replies)
Discussion started by: arvindosu
8 Replies
4. Shell Programming and Scripting
Hi,
I want to remove duplicate records including the first line based on column1. For example
inputfile(filer.txt):
-------------
1,3000,5000
1,4000,6000
2,4000,600
2,5000,700
3,60000,4000
4,7000,7777
5,999,8888
expected output:
----------------
3,60000,4000
4,7000,7777... (5 Replies)
Discussion started by: G.K.K
5 Replies
5. Shell Programming and Scripting
I was reading this thread. It looks like a simpler way to say this is to only keep uniq lines based on field or column 1.
https://www.unix.com/shell-programming-scripting/165717-removing-duplicate-records-file-based-single-column.html
Can someone explain this command please? How are there no... (5 Replies)
Discussion started by: cokedude
5 Replies
6. Linux
I have a .CSV file with the below format:
"column 1","column 2","column 3","column 4","column 5","column 6","column 7","column 8","column 9","column 10
"12310","42324564756","a simple string with a , comma","string with or, without commas","string 1","USD","12","70%","08/01/2013",""... (2 Replies)
Discussion started by: dhruuv369
2 Replies
7. Shell Programming and Scripting
Hi,
I have to output a new csv file from an input csv file with first unique value in the first column.
input csv file
color product id status
green 102 pass
yellow 201 hold
yellow 202 keep
green 101 ok
green 103 hold
yellow 203 ... (5 Replies)
Discussion started by: Chris LAU
5 Replies
8. Linux
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
9. Shell Programming and Scripting
Hello,
I have a script that is generating a tab delimited output file.
num Name PCA_A1 PCA_A2 PCA_A3
0 compound_00 -3.5054 -1.1207 -2.4372
1 compound_01 -2.2641 0.4287 -1.6120
3 compound_03 -1.3053 1.8495 ... (3 Replies)
Discussion started by: LMHmedchem
3 Replies
10. Shell Programming and Scripting
I have csv file with 30, 40 columns
Pasting just three column for problem description
I want to filter record if column 1 matches CN or DN then,
check for values in column 2 if column contain 1235, 1235 then in column 3 values must be sequence of 2345, 2345
and if column 2 contains 6789, 6789... (5 Replies)
Discussion started by: as7951
5 Replies
LEARN ABOUT CENTOS
abrt-retrace-client
ABRT-RETRACE-CLIEN(1) ABRT Manual ABRT-RETRACE-CLIEN(1)
NAME
abrt-retrace-client - Handles the communication with Retrace server.
SYNOPSIS
abrt-retrace-client <operation> [options]
DESCRIPTION
This tool is able to communicate with Retrace server: create a new task, ask about task's status, download log or backtrace of a finished
task.
Integration with libreport events
abrt-retrace-client can be used as an analyzer for application crashes which dump core.
Example usage in report_event.conf:
EVENT=analyze analyzer=CCpp
abrt-retrace-client
OPERATIONS
create
Creates a new task. Prints task ID and password to stdout. Either -d or -c is required.
status
Prints task's status to stdout. Both -t and -p are required.
log
Prints finished task's log to stdout. Both -t and -p are required.
backtrace
Print finished task's backtrace to stdout. Both -t and -p are required.
batch
Runs all operations in one step: creates a new task, periodically asks for status (the period is specified by --status-delay option)
and downloads the result when finished. If the task was successful backtrace file is saved, otherwise log is printed to stdout. Either
-c or -d is required.
OPTIONS
-v, --verbose
be verbose
-s, --syslog
log to syslog
-k, --insecure
allow insecure connection to retrace server
--url URL
retrace server URL
--headers
(debug) show received HTTP headers
-d, --dir DIR
read data from ABRT problem directory
-c, --core COREDUMP
read data from coredump
-l, --status-delay
delay for polling operations (seconds)
--no-unlink
(debug) do not delete temporary archive created in /tmp
-t, --task ID
ID of the task on server
-p, --password PWD
password of the task on server
AUTHORS
o ABRT team
abrt 2.1.11 06/18/2014 ABRT-RETRACE-CLIEN(1)