|
|
Sponsored Content
Top Forums
UNIX for Dummies Questions & Answers
print average of duplicates
Post 302470320 by vgersh99 on Tuesday 9th of November 2010 06:49:07 PM
|
|
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
If I have a file like this, could anyone please guide me how to find the average value in each metrix. The file has got about 130,000 metrixs.
Grid-ref= 142, 235
178 182 203 240 273 295 289 293 283 262 201 176
167 187 187 246 260 282 299 312 293 276 230 191
169 ... (2 Replies)
Discussion started by: su_in99
2 Replies
2. HP-UX
how to get duplicates in a file containing data in columns using command or scripting? (4 Replies)
Discussion started by: megh
4 Replies
3. Shell Programming and Scripting
I have input file like below.
I00789524 0213 5212
D00789524 0213 5212
I00778787 2154 5412
The first two records are same(Duplicates) except I & D in the first character. I want non duplicates(ie. 3rd line) to be output. How can we get this . Can you help. Is there any single AWK or SED... (3 Replies)
Discussion started by: awk_beginner
3 Replies
4. Shell Programming and Scripting
input
a
a
a
b
b
c
output
a 3
b 2
c 1
Could you guyz help me.
I tried uniq and wc -l to count uniq line (3 Replies)
Discussion started by: repinementer
3 Replies
5. Shell Programming and Scripting
Hi I want to use awk to print avg and st deviation but it does not go into a file for column 1 only.
I can do average and # of records but i cannot get st deviation.
awk '{sum+=$1} END { print "Average = ",sum/NR}'
thanks (1 Reply)
Discussion started by: phil_heath
1 Replies
6. Shell Programming and Scripting
Masters,
I have a text file in the following format.
vrsonlviee RVEBAALSKE
lyolzteglx UUOSIWMDLR
pcybtapfee DKGFJBHBJO
ozhrucfeau YQXATYMGJD
cjwvjolrcv YDHALRYQTG
mdukphspbc CQZRIOWEUB
nbiqomzsgw DYSUBQSSPZ
xovgvkneav HJFQQYBLAF
boyyzdmzka BVTVUDHSCR
vrsonlviee TGTKUCUYMA... (2 Replies)
Discussion started by: genehunter
2 Replies
7. Shell Programming and Scripting
Can some one provide me a shell script.
I have file with many columns and many rows. need to sort the first column and then remove the duplicates records if exists.. finally print the full data with first coulm as unique.
Sort BASED ON FIRST FIELD and remove the duplicates if exists... (2 Replies)
Discussion started by: tuffEnuff
2 Replies
8. UNIX for Dummies Questions & Answers
Hi,
How to eliminate the duplicate values in unix? I have a excel file which contains duplicate values.
Need to use this in a script.
Thanks in advance. (3 Replies)
Discussion started by: venkatesht
3 Replies
9. Shell Programming and Scripting
Hi everyone,
I have a program that generates logs that contains sections like this:
IMAGE INPUT
81 0 0.995 2449470 0 1726 368 1 0.0635 0.3291
82 0 1.001 2448013 0 1666 365 1 0.0649 0.3235
83 0 1.009 2444822 0 1697 371 1 ... (3 Replies)
Discussion started by: euval
3 Replies
10. Shell Programming and Scripting
Is it possible to print the average of 2 nd column based on a key in 1st col
input
a1X 4
a1X 6
a2_1 10
a2_1 20
a2_1 30
a2_1 30
a2_1 10
output
a1X 5
a2_1 20 (11 Replies)
Discussion started by: quincyjones
11 Replies
LEARN ABOUT CENTOS
end
END(7) PostgreSQL 9.2.7 Documentation END(7) NAME
END - commit the current transaction SYNOPSIS
END [ WORK | TRANSACTION ] DESCRIPTION
END commits the current transaction. All changes made by the transaction become visible to others and are guaranteed to be durable if a crash occurs. This command is a PostgreSQL extension that is equivalent to COMMIT(7). PARAMETERS
WORK, TRANSACTION Optional key words. They have no effect. NOTES
Use ROLLBACK(7) to abort a transaction. Issuing END when not inside a transaction does no harm, but it will provoke a warning message. EXAMPLES
To commit the current transaction and make all changes permanent: END; COMPATIBILITY
END is a PostgreSQL extension that provides functionality equivalent to COMMIT(7), which is specified in the SQL standard. SEE ALSO
BEGIN(7), COMMIT(7), ROLLBACK(7) PostgreSQL 9.2.7 2014-02-17 END(7)