Hi I have fakebook.csv as following:
F1(current date) F2(popularity) F3(name of book) F4(release date of book)
2006-06-21,6860,"Harry Potter",2006-12-31
2006-06-22,,"Harry Potter",2006-12-31
2006-06-23,7120,"Harry Potter",2006-12-31
2006-06-24,,"Harry Potter",2006-12-31... (0 Replies)
Hi all!
trying my best to parse a public site for information (ie fiscal year and turnover) about corporations.
Doing this by having a file with business name and registration number (search key)
the file bolag.txt currently looks like this
Burgundy 556732-7217
AcademicSearch 556406-9879... (11 Replies)
Hi, I tried to do this in excel but there is a limit to how many rows it can handle.
All I need to do is average each column in a file and get the final value.
My file looks something like this (obviously a lot larger):
Joe HHR + 1 2 3 4 5 6 7 8
Jor HHR - 1 2 3 4 5 6 7 8
the output... (1 Reply)
Dear All,
I have this file tab delimited
A 1 12 22
B 3 34 33
C 55 9 32
A 12 81 71
D 11 1 66
E 455 4 2
B 89 4 3
I would like to make the average every column where the first column is the same, for example,
A 6,5 46,5 46,5
B 46,0 19,0 18,0
C 55,0 9,0 32,0
D 11,0 1,0 66,0... (8 Replies)
Hi,
I would like to calculate the average of column 'y' based on the value of column 'pos'.
For example, here is file1
id pos y c
11 1 220 aa
11 4333 207 f
11 5333 112 ee
11 11116 305 e
11 11117 310 r
11 22228 781 gg
11 ... (2 Replies)
I have a file that looks like this:
id window BV
1 1 0.5
1 2 0.2
1 3 0.1
2 1 0.5
2 2 0.1
2 3 0.2
3 1 0.4
3 2 0.6
3 3 0.8
Using awk, how would I get the average BV for window 1? Output like this:
window avgBV
1 0.47
2 0.23 (10 Replies)
Hi,
My input file
Gene1 1
Gene1 2
Gene1 3
Gene1 0
Gene2 0
Gene2 0
Gene2 4
Gene2 8
Gene3 9
Gene3 9
Gene4 0
Condition:
If the first column matches, then look in the second column. If there is a value of zero in the second column, then don't consider that record while averaging.
... (5 Replies)
please write a shell script
Table
--------------------------
1 2 3 a b c
3 4 5 c d e
7 8 9 f g h
Output should be like this
---------------
1 2 3
3 4 5
7 8 9
a b c
c d e
f g h (1 Reply)
Split column data if the table has n number of column's with some record then how to split n number of colmn's line by line with records
Table
---------
Col1 col2 col3 col4 ....................col20
1 2 3 4 .................... 20
a b c d .................... v
... (11 Replies)
Hi all,
Does anyone know of an efficient unix script to average each numeric column of a multi-column tab delimited file (with header) with some character columns.
Here is an example input file:
CHR RS_ID ALLELE POP1 POP2 POP3 POP4 POP5 POP6 POP7 POP8... (7 Replies)
Discussion started by: Geneanalyst
7 Replies
LEARN ABOUT ULTRIX
folders
folders(1mh)folders(1mh)Name
folders - list folders and contents
Syntax
folders [ +folder ] [ msg ] [ options ]
Description
The command displays the names of your folders and the number of messages that they each contain.
The command displays a list of all the folders in your Mail directory. The folders are sorted alphabetically, each on its own line. This
is illustrated in the following example:
Folder # of messages ( range ); cur msg (other files)
V2.3 has 3 messages ( 1- 3).
adrian has 20 messages ( 1- 20); cur= 2.
brian has 16 messages ( 1- 16).
chris has 12 messages ( 1- 12).
copylog has 242 messages ( 1- 242); cur= 225.
inbox+ has 73 messages ( 1- 127); cur= 127.
int has 4 messages ( 1- 4); cur= 2 (others).
jack has 17 messages ( 1- 17); cur= 17.
TOTAL= 387 messages in 8 folders.
The plus sign (+) after inbox indicates that it is the current folder. The information about the folder includes the term (others). This
indicates that the folder contains files which are not messages. These files may be either sub-folders, or files that do not belong under
the MH file naming scheme.
The command is identical to the effect of using the -all option to the command.
If you use with the +folder argument, it will display all the subfolders within the named folder. as shown in the following example:
% folders +test
Folder # of messages ( range ); cur msg (other files)
test+ has 18 messages ( 1- 18); (others).
test/testone has 1 message ( 1- 1).
test/testtwo has no messages.
TOTAL= 19 messages in 3 folders.
See for more details of sub-folders.
Options-fast
-nofast Lists only the name of folders, with no additional information. This is faster because the folders need not be read.
-help Prints a list of the valid options to this command.
-list
-nolist Lists the contents of the folder-stack. No +folder argument is allowed with this option.
-pack
-nopack Re-numbers messages in the folders. Messages are re-numbered sequentially, and any gaps in the numbering are removed. The
default operation is -nopack, which does not change the numbering in the folder.
-pop Discards the top of the folder-stack, after setting the current folder to that value. No +folder argument is allowed with this
option. This corresponds to the operation in the C-shell; see The -push and -pop options are mutually exclusive: the last occur-
rence of either one overrides any previous occurrence of the other.
-push Pushes the current folder onto the folder-stack, and makes the +folder argument into the current folder. If +folder is not
given, the current folder and the top of the folder-stack are exchanged. This corresponds to the operation in the C-shell; see
The -push switch and the -pop switch are mutually exclusive: the last occurrence of either one overrides any previous occurrence
of the other.
-recurse
-norecurse
Lists folders recursively. Information on each folder is displayed, followed by information on any sub-folders which it con-
tains.
-total
-nototal Displays only the total number of messages and folders in your Mail directory. This option does not print any information about
individual folders. It can be suppressed using the -nototal option.
The defaults for are:
+folder defaults to all
msg defaults to none
-nofast
-noheader
-nototal
-nopack
-norecurse
Restrictions
MH does not allow you to have more than 100 folders at any level in your Mail directory.
Profile Components
Path: To determine your MH directory
Folder-Protect: To set protections when creating a new folder
Folder-Stack: To determine the folder stack
lsproc: Program to list the contents of a folder
Files
The user profile.
See Alsocsh(1), folder(1mh), refile(1mh), mhpath(1mh)folders(1mh)