script to take row count Post: 302250285

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

row count of all files with more than 0 byte

Hi, Is there any way to get count number of lines in all files which have more than o bytes in current directory for example : in /user/sri/ there are 3 files abc 0 bytes def 5 bytes ghi 10 bytes i need to get wc -l for all files which have > 0 bytes at a time ..is...

2. UNIX for Dummies Questions & Answers

row count but only number part

hi i am pretty new to unix .i am ETL guy I need a unix script to take row count of a file and write it to another file the problem with wc-l is it include filename also wc -l abc.dat will give me like 1000 abc.dat i just want 1000 to be written can u just take 2 min to write a simple...

3. Shell Programming and Scripting

row count of 60 files in one file

hi all plz some unix guy help me in this i have 60 files which will have some records i want to find the total number of records in all the 60 files like file1 has 60 and file2 has 70 record i want to sum all these and find total row count in 60 files

4. UNIX for Dummies Questions & Answers

Script to get Row Count of ZIP Files

Hi, I have some data files in a zipped format.(eg: aa.gz).I would like to know the number or rows in each zip file(May be populate the file name and line numbers into a text file).I know the commands wc -l and gunzip,.But how I will create a shell script for this to extract each files and get...

5. Shell Programming and Scripting

count identical strings print last row and count

I have a sorted file like: Apple 3 Apple 5 Apple 8 Banana 2 Banana 3 Grape 31 Orange 7 Orange 13 I'd like to search $1 and if $1 is not the same as $1 in the previous row print that row and print the number of times $1 was found. so the output would look like: Apple 8 3 Banana...

6. Shell Programming and Scripting

Count the delimeter from a file and delete the row if delimeter count doesnt match.

I have a file containing about 5 million rows, in the file there are some records which has extra delimiter at random position. (we dont know the positions), now we have to Count the delimeter from each row and if the count of delimeter is not matching then I want to delete those rows from the...

7. Shell Programming and Scripting

To count distinct fields in a row

I have . dat file which contains data in a specific format: 0 3 892 921 342 1 3 921 342 543 2 4 817 562 718 765 3 3 819 562 717 761 i need to compare each field in a row with another field of the same column but different row and cont the...

8. Shell Programming and Scripting

Count the number or row with same value in a column

This is the source file, we called it errorlist.out 196 server_a server_unix_2 CD 196 server_b server_win_1 CD 196 server_c server_win_2 CD 196 server_bd server_unix_2 CD 196 server_d server_unix_2 CD 196 server_es server_win_1 CD 196 ...

9. UNIX for Advanced & Expert Users

row count

Hi, I want a row count of a file incliding header and trailer If I do cat Filename | wc -l then I am only getting the row count excluding the header and trailer Buit I want the row count including Header and trailer Please help Many thanks in advance, Pragyan

10. Shell Programming and Scripting

Row Count in .csv file

Hi, I have to find the count of rows starting with "E," in given a.csv file . Sample Data File. E,2333AED,A,MC3,25,31-MAY-18 E,2333AED,A,MC3,25,31-MAY-18 CYMC3 25AED 0000 E,2333CZK,A,MC3,25,31-MAY-18 CYMC3 25CZK 0000 E,2333EUR,A,MC3,25,31-MAY-18...

LEARN ABOUT FREEBSD

ministat

MINISTAT(1)						    BSD General Commands Manual 					       MINISTAT(1)

NAME

     ministat -- statistics utility

SYNOPSIS

     ministat [-Ans] [-C column] [-c confidence_level] [-d delimiter] [-w [width]] [file ...]

DESCRIPTION

     The ministat command calculates fundamental statistical properties of numeric data in the specified files or, if no file is specified, stan-
     dard input.

     The options are as follows:

     -A 	 Just report the statistics of the input and relative comparisons, suppress the ASCII-art plot.

     -n 	 Just report the raw statistics of the input, suppress the ASCII-art plot and the relative comparisons.

     -s 	 Print the average/median/stddev bars on separate lines in the ASCII-art plot, to avoid overlap.

     -C column	 Specify which column of data to use.  By default the first column in the input file(s) are used.

     -c confidence_level
		 Specify desired confidence level for Student's T analysis.  Possible values are 80, 90, 95, 98, 99 and 99.5 %

     -d delimiter
		 Specifies the column delimiter characters, default is SPACE and TAB.  See strtok(3) for details.

     -w width	 Width of ASCII-art plot in characters, default is 74.

     A sample output could look like this:

	     $ ministat -s -w 60 iguana chameleon
	     x iguana
	     + chameleon
	     +------------------------------------------------------------+
	     |x      *	x	     *	    +		   + x		 +|
	     | |________M______A_______________|			  |
	     |		   |________________M__A___________________|	  |
	     +------------------------------------------------------------+
		 N	  Min	     Max     Median	   Avg	     Stddev
	     x	 7	   50	     750	200	   300	  238.04761
	     +	 5	  150	     930	500	   540	  299.08193
	     No difference proven at 95.0% confidence

     If ministat tells you, as in the example above, that there is no difference proven at 95% confidence, the two data sets you gave it are for
     all statistical purposes identical.

     You have the option of lowering your standards by specifying a lower confidence level:

	     $ ministat -s -w 60 -c 80 iguana chameleon
	     x iguana
	     + chameleon
	     +------------------------------------------------------------+
	     |x      *	x	     *	    +		   + x		 +|
	     | |________M______A_______________|			  |
	     |		   |________________M__A___________________|	  |
	     +------------------------------------------------------------+
		 N	  Min	     Max     Median	   Avg	     Stddev
	     x	 7	   50	     750	200	   300	  238.04761
	     +	 5	  150	     930	500	   540	  299.08193
	     Difference at 80.0% confidence
		   240 +/- 212.215
		   80% +/- 70.7384%
		   (Student's t, pooled s = 264.159)

     But a lower standard does not make your data any better, and the example is only included here to show the format of the output when a sta-
     tistical difference is proven according to Student's T method.

SEE ALSO

     Any mathematics text on basic statistics, for instances Larry Gonicks excellent "Cartoon Guide to Statistics" which supplied the above exam-
     ple.

HISTORY

     The ministat command was written by Poul-Henning Kamp out of frustration over all the bogus benchmark claims made by people with no under-
     standing of the importance of uncertainty and statistics.

     From FreeBSD 5.2 it has lived in the source tree as a developer tool, graduating to the installed system from FreeBSD 8.0.

BSD
								 November 10, 2012							       BSD