Average calculation based on number of rows Post: 302429257

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Average completion time calculation?

I've been trying all night to come up with a script that will take a file that contains job completion times like this as input: 18:30 17:45 16:39 18:01 17:50 ... and figure the Average completion time. I've tried several things, and I just can't seem to get it to figure correctly. I'm...

2. Shell Programming and Scripting

Splitting file based on number of rows

Hi, I'm, new to shell scripting, I have a requirement where I have to split an incoming file into separate files each containing a maximum of 3 million rows. For e.g: if my incoming file say In.txt has 8 mn rows then I need to create 3 files, in which two will 3 mn rows and one will contain 2...

3. UNIX for Dummies Questions & Answers

Calculating the Number of Rows and Average

Hi All I like to know how can we calculate the number of rows and the average of the values present in the file. I will not know what will be the rowcount, which will be dynamic in nature of the file. eg. 29 33 48 30 28

4. Shell Programming and Scripting

Script to find the average of a given column and also for specified number of rows??

Hi friends I have 100 files in my directory. Each file look like this.. Temp1 Temp2 Temp3 MAS 1 2 3 MAS 4 5 6 MAS 7 8 9 Delhi 10 11 12 Delhi 13 14 15 Delhi 16 17 ...

5. Shell Programming and Scripting

Script to find the average of a given column and also for specified number of rows?

Hi Friends, In continuation to my earlier post https://www.unix.com/shell-programming-scripting/99166-script-find-average-given-column-also-specified-number-rows.html I am extending my problem as follows. Input: Column1 Column2 MAS 1 MAS 4 ...

6. UNIX for Dummies Questions & Answers

count number of rows based on other column values

Could anybody help with this? I have input below ..... david,39 david,39 emelie,40 clarissa,22 bob,42 bob,42 tim,32 bob,39 david,38 emelie,47 what i want to do is count how many names there are with different ages, so output would be like this .... david,2 emelie,2 clarissa,1...

7. UNIX for Dummies Questions & Answers

Sum the rows number based on first field string value

Hi, I have a file like this one h1 4.70650E-04 4.70650E-04 4.70650E-04 h2 1.92912E-04 1.92912E-04 1.92912E-04 h3A 3.10160E-11 2.94562E-11 2.78458E-11 h4 0.00000E+00 0.00000E+00 0.00000E+00 h1 1.18164E-12 2.74150E-12 4.35187E-12 h1 7.60813E-01 7.60813E-01 7.60813E-01...

8. Shell Programming and Scripting

Split File based on number of rows

Hi I have a requirement, where i will receive multiple files in a folder (say: /fol1/fol2/). There will be at least 14 to 16 files. The size of the files will different, some may be 80GB or 90GB, some may be less than 5 GB (and the size of the files are very unpredictable). But the names of the...

9. Shell Programming and Scripting

Average select rows

I have no idea how to even get started with this script. I need to average field 3 for each of the unique identifiers found in field 1. However, I only want to average these rows when field 2 is equal to 1506 - 2000 (note that i replaced the values field 2 for security reasons, but the real...

10. UNIX for Beginners Questions & Answers

Help with average calculation.

i have a file with 2 columns. i want to calculate the average of column 1 based on the values of column 2. here's how the file looks like. i want to calculate the sums of numbers corresponding to 1 and then calculate the average. same for numbers corresponding to zero. any help with a code would...

LEARN ABOUT LINUX

scsi_setup_cdb

scsi_setup_cdb(9F)					   Kernel Functions for Drivers 					scsi_setup_cdb(9F)

NAME

       scsi_setup_cdb - setup SCSI command descriptor block (CDB)

SYNOPSIS

       int scsi_setup_cdb(union scsi_cdb *cdbp, uchar_t cmd, uint_t addr, uint_t cnt, uint_t othr_cdb_data);

INTERFACE LEVEL

       Solaris DDI specific (Solaris DDI).

PARAMETERS

       cdbp	       Pointer to command descriptor block.

       cmd	       The first byte of the SCSI group 0, 1, 2, 4, or 5 CDB.

       addr	       Pointer to the location of the data.

       cnt	       Data  transfer  length  in  units  defined by the SCSI device type. For sequential devices cnt is the number of bytes.  For
		       block devices, cnt is the number of blocks.

       othr_cdb_data   Additional CDB data.

DESCRIPTION

       scsi_setup_cdb() function initializes a group 0, 1, 2, 4, or 5 type of command descriptor block pointed to by  cdbp using  cmd, addr,  cnt,
       othr_cdb_data.

       addr  should  be  set to 0 for commands having no addressing information (for example, group 0 READ command for sequential access devices).
       othr_cdb_data should be additional CDB data for Group 4 commands; otherwise, it should be set to 0.

       scsi_setup_cdb() function does not set the LUN bits in CDB[1] as the  makecom(9F) functions do.	Also, the fixed bit for sequential  access
       device commands is not set.

RETURN VALUES

       scsi_setup_cdb() returns:

       1	Upon success.

       0	Upon failure.

CONTEXT

       These functions can be called from a user or interrupt context.

SEE ALSO

       makecom(9F), scsi_pkt(9S)

       Writing Device Drivers

       American National Standard Small Computer System Interface-2 (SCSI-2)

       American National Standard SCSI-3 Primary Commands (SPC)

SunOS 5.10							    23 Jun 1997 						scsi_setup_cdb(9F)