Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Merging strings which have deviation in frequency
Top Forums Shell Programming and Scripting Merging strings which have deviation in frequency Post 302912586 by gimley on Sunday 10th of August 2014 05:49:55 AM
Old 08-10-2014
Yes, I did run the file twice instead of one, which I deduced from the awk syntax and piped it out to an out file.
Maybe this is because I am using DOS and Windows Vista and Gawk32 to accommodate a 32 bit version of Windows.
I thought that maybe it was an OS issue. But Awk runs seamlessly along all OS's.(at least that's what I thought). Maybe this is why your syntax for the file separator did not work. I can see it works beautifully for you: the output is flawless.
Any solution to make the program run in my environment.
Once again many thanks for your patience and time. This is a learning experience for me for which I am grateful.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Script for finding standard deviation

I have a CSV file that looks like 0,0,0,0,1,0,1,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,2,0,0,0,0,0,0 10,11,7,0,4,12,2,3,7,0,11,3,12,4,0,5,5,4,5,0,8,6,12,0,9,3,3,0,2,7,8 19,11,7,0,4,14,16,10,8,2,13,7,15,6,0,76,6,4,10,0,18,10,17,1,11,3,3,0,9,9,8... (7 Replies)
Discussion started by: RJ17
7 Replies

2. Shell Programming and Scripting

Mean and Standard deviation

Hi all, I am new to shell scripting and wanna calculate the mean and standard deviation using shell programming. I have a file with letters that are repeating and their corresponding duration a 0.32 a 0.89 aa 0.34 aa 0.23 au 0.012 au 0.26... (4 Replies)
Discussion started by: lakshmikanth.pg
4 Replies

3. UNIX for Dummies Questions & Answers

Calculating the Standard Deviation for a column

Hi all, I want to calculate the standard deviation for a column (happens to be column 3). Does any know of simple awk script to do this? Thanks (1 Reply)
Discussion started by: kylle345
1 Replies

4. Shell Programming and Scripting

using awk to print average and standard deviation into a file

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

5. Shell Programming and Scripting

Standard deviation in awk

Hi all, I need to find the standard deviation of each column of a dataset below for each hour. The data is given in 5 second intervals as shown below DATE TIME FRAC_DAYS_SINCE_JAN1 FRAC_HRS_SINCE_JAN1 EPOCH_TIME ... (11 Replies)
Discussion started by: gd9629
11 Replies

6. Shell Programming and Scripting

AWK script for standard deviation / root mean square deviation

I have a file with say 50 columns, each containing a whole lot of data. Each column contains data from a separate simulation, but each simulation is related to the data in the last (REFERENCE) column $50 I need to calculate the RMS deviation for each data line, i.e. column 1 relative to... (12 Replies)
Discussion started by: chrisjorg
12 Replies

7. Shell Programming and Scripting

Calculate Mean absolute Deviation

Hi, I am trying to use an statistical formula. I tried in excel, but I get different values when I use calculator. The formula is (1/n) ∑|x - mean| n=no. of observations x=each individual expression value mean is median of all observations I have a file with 1000 rows.. So it needs... (1 Reply)
Discussion started by: Diya123
1 Replies

8. Shell Programming and Scripting

Output mean and standard deviation of a row

I have a file that looks that this: 820 890 530 1650 1600 1800 1850 1900 2270 1640 2300 1670 2080 2200 2350 1150 1630 2210 I would like to output the mean and standard deviation of each row so that my final output would look like this 820 890 530 746.667 155.849 1650 1600 1800... (5 Replies)
Discussion started by: kayak
5 Replies

9. Ubuntu

Merging strings that have identical rownames in a dataframe

Hi I have a data frame with repeated names in column 1, and different descriptors in column 2. I want to merge/cat strings that have same entry in column 1 into one row with any separator. Example for input: Cvel_1 KOG0155 Cvel_1 KOG0306 Cvel_1 KOG3259 Cvel_1 ... (4 Replies)
Discussion started by: Alyaa
4 Replies

10. Shell Programming and Scripting

Replicate merging and frequency calculation

Hello, I have a 2 column file with an ID column and a column with some string. ID String EN03 typehellobyedogcatcatdog EN09 typehellobye EN08 dogcatcatdog EN09 catcattypehello EN10 typehellobyedogcatcatdog EN10 typehellobyedogcatcatdogdog I would like to count the amount of times... (9 Replies)
Discussion started by: verse123
9 Replies

LEARN ABOUT DEBIAN

testdisk

TESTDISK(8)						       Administration Tools						       TESTDISK(8)

NAME

       testdisk - Scan and repair disk partitions

SYNOPSIS

       testdisk [/log] [/debug] [/dump] [device|image.dd|image.e01]

       testdisk /version

       testdisk /list [/log]

DESCRIPTION

	  TestDisk checks and recovers lost partitions
	  It works with :
	  - BeFS (BeOS)
	  - BSD disklabel (FreeBSD/OpenBSD/NetBSD)
	  - CramFS, Compressed File System
	  - DOS/Windows FAT12, FAT16 and FAT32
	  - HFS and HFS+, Hierarchical File System
	  - JFS, IBM's Journaled File System
	  - Linux ext2/ext3/ext4
	  - Linux Raid
	    RAID 1: mirroring
	    RAID 4: striped array with parity device
	    RAID 5: striped array with distributed parity information
	    RAID 6: striped array with distributed dual redundancy information
	  - Linux Swap (versions 1 and 2)
	  - LVM and LVM2, Linux Logical Volume Manager
	  - Mac partition map
	  - Novell Storage Services NSS
	  - NTFS (Windows NT/2K/XP/2003/Vista/...)
	  - ReiserFS 3.5, 3.6 and 4
	  - Sun Solaris i386 disklabel
	  - Unix File System UFS and UFS2 (Sun/BSD/...)
	  - XFS, SGI's Journaled File System

	  It can undelete files from
	  - DOS/Windows FAT12, FAT16 and FAT32
	  - Linux ext2
	  - NTFS (Windows NT/2K/XP/2003/Vista/...)

OPTIONS

       /log   create a testdisk.log file

       /debug add debug information

       /dump  dump raw sectors

       /list  display current partitions

SEE ALSO

       fdisk(8), photorec(8).

AUTHOR

       TestDisk 6.13, Data Recovery Utility, November 2011
       Christophe GRENIER <grenier@cgsecurity.org>
       http://www.cgsecurity.org

2011								     November							       TESTDISK(8)
All times are GMT -4. The time now is 08:39 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy