08-20-2013
First extract a unique sorted master list of tags, using both files.
then, pass both file through a transform so values between 10 and 14 (15 must be a typo?, ranges are 5 and 6 wide?) are converted to "10-14", etc., sort them all by range and tag, run through uniq -c, and now you have your counts in "ct tag range" form and range, tag order. Using the master list of tags, build the lines for each range present in tag order. If you know all the tags and ranges ahead of time, you can also use associative vectors keyed on "tag+range" to accumulate values and then spit out the totals without sorting, using awk, bash, ksh.
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hi,
Could anyone help me in changing a tabular format output to comma seperated file pls in K-sh. Its very urgent.
E.g : username empid
------------------------
sri 123
to
username,empid
sri,123
Thanks,
Hema:confused: (2 Replies)
Discussion started by: Hemamalini
2 Replies
2. Shell Programming and Scripting
Here is what old matrix look like,
IDs X1 X2 Y1 Y2
10914061 -0.364613333 -0.362922333 0.001691 -0.450094667
10855062 0.845956333 0.860396667 0.014440333 1.483899333... (7 Replies)
Discussion started by: ssshen
7 Replies
3. Programming
Hi power user,
I have this type of data (distance list):
file1
A B 10
B C 20
C D 50I want output like this
# A B C D
A 0 10 30 80
B 10 0 20 70
C 30 20 0 50
D 80 70 50 0 Which is a distance matrix
I have tried... (0 Replies)
Discussion started by: anjas
0 Replies
4. Ubuntu
Hi all,
Is there a way to convert full data matrix to linearised left data matrix?
e.g full data matrix
Bh1 Bh2 Bh3 Bh4 Bh5 Bh6 Bh7
Bh1 0 0.241058 0.236129 0.244397 0.237479 0.240767 0.245245
Bh2 0.241058 0 0.240594 0.241931 0.241975 ... (8 Replies)
Discussion started by: evoll
8 Replies
5. Shell Programming and Scripting
Hi All,
I was wondering how I can convert each line in an input file where fields are separated by variable width spaces into a CSV file. Below is the scenario what I am looking for.
My Input data in inputfile.txt
19 15657 15685 Sr2dReader 107.88 105.51... (4 Replies)
Discussion started by: vharsha
4 Replies
6. Shell Programming and Scripting
Hi,
Needs for statistics, doing converting
Here is a sample file
Input :
1|A|17,94
1|B|22,59
1|C|56,93
2|A|63,71
2|C|23,92
5|B|19,49
5|C|67,58
expecting something like that
Output :
1|A|17,94|B|22,59|C|56,93
2|A|63,71|B|0|C|23,92
5|A|0|B|19,49|C|67,58 (11 Replies)
Discussion started by: fastlane3000
11 Replies
7. Programming
Dear All
I would like to convert columns to matrix
For example my data looks like this
D2 0 D2 0 1.0
D2 0 D2 1 0.308
D2 0 D2 2 0.554
D2 0 D2 3 0.287
D2 0 D2 4 0.633
D2 0 D2 5 0.341
D2 0 D2 6 0.665
D2 0 D2 7 0.698
D2 0 D2 8 0.625
D2 0 D2 9 0.429
D2 0 D2 10 0.698
D2 0 D2 11... (7 Replies)
Discussion started by: bala06
7 Replies
8. Shell Programming and Scripting
Hi All,
I need to convert an exel spreadsheet into a SAS dataset,
and the following format change is needed. Please help, this is too complex
for a biologist.
Let me describe the input.
1st row is generation.1st column in keyword 'generation', starting 2nd column there are 5... (9 Replies)
Discussion started by: newbie83
9 Replies
9. Shell Programming and Scripting
Hi All,
I do have a file with many lines (rows) and it is space delimited. For example: I have a file named SR345_pl.txt. If I open it in an editor, it looks like this:
adfr A2 0.9345
dtgr/2 A2 0.876
fgh/3 A2 023.76
fghe/4 A2 2345
bnhy/1 A3 3456
bhy A3 0.9876
phy A5 0.987
kdrt A5... (9 Replies)
Discussion started by: Lucky Ali
9 Replies
10. UNIX for Dummies Questions & Answers
Hi,
Can someone help in converting the below unstructured data to a CSV format please.
{
"branchId" : "BNSFGDJNSJG-73264HB-132131BNHJFSDG",
"branchName" : "NEWYORK-SSDF",
"branchProductId" : "72Y5HFHSF7H3RUNAWEF",
"PreferenceId" : "BASDBVcbzcYHcb",
"emailId" :... (9 Replies)
Discussion started by: naveen.kuppili
9 Replies
LEARN ABOUT PHP
yaml_parse_url
YAML_PARSE_URL(3) 1 YAML_PARSE_URL(3)
yaml_parse_url - Parse a Yaml stream from a URL
SYNOPSIS
mixed yaml_parse_url (string $url, [int $pos], [int &$ndocs], [array $callbacks])
DESCRIPTION
Convert all or part of a YAML document stream read from a URL to a PHP variable.
PARAMETERS
o $url
-$url should be of the form "scheme://...". PHP will search for a protocol handler (also known as a wrapper) for that scheme. If
no wrappers for that protocol are registered, PHP will emit a notice to help you track potential problems in your script and then
continue as though filename specifies a regular file.
o $pos
- Document to extract from stream ( -1 for all documents, 0 for first document, ...).
o $ndocs
- If $ndocs is provided, then it is filled with the number of documents found in stream.
o $callbacks
- Content handlers for YAML nodes. Associative array of YAML tag => callable mappings. See parse callbacks for more
RETURN VALUES
Returns the value encoded in $input in appropriate PHP type or FALSE on failure. If $pos is -1 an array will be returned with one entry
for each document found in the stream.
NOTES
Warning
Processing untrusted user input with yaml_parse_url(3) is dangerous if the use of unserialize(3) is enabled for nodes using the
!php/object tag. This behavior can be disabled by using the yaml.decode_php ini setting.
SEE ALSO
yaml_parse(3), yaml_parse_file(3), yaml_emit(3).
PHP Documentation Group YAML_PARSE_URL(3)