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 LINUX
git-lost-found
GIT-LOST-FOUND(1) Git Manual GIT-LOST-FOUND(1)
NAME
git-lost-found - Recover lost refs that luckily have not yet been pruned
SYNOPSIS
git lost-found
DESCRIPTION
NOTE: this command is deprecated. Use git-fsck(1) with the option --lost-found instead.
Finds dangling commits and tags from the object database, and creates refs to them in the .git/lost-found/ directory. Commits and tags that
dereference to commits are stored in .git/lost-found/commit, and other objects are stored in .git/lost-found/other.
OUTPUT
Prints to standard output the object names and one-line descriptions of any commits or tags found.
EXAMPLE
Suppose you run git tag -f and mistype the tag to overwrite. The ref to your tag is overwritten, but until you run git prune, the tag
itself is still there.
$ git lost-found
[1ef2b196d909eed523d4f3c9bf54b78cdd6843c6] GIT 0.99.9c
...
Also you can use gitk to browse how any tags found relate to each other.
$ gitk $(cd .git/lost-found/commit && echo ??*)
After making sure you know which the object is the tag you are looking for, you can reconnect it to your regular refs hierarchy by using
the update-ref command.
$ git cat-file -t 1ef2b196
tag
$ git cat-file tag 1ef2b196
object fa41bbce8e38c67a218415de6cfa510c7e50032a
type commit
tag v0.99.9c
tagger Junio C Hamano <junkio@cox.net> 1131059594 -0800
GIT 0.99.9c
This contains the following changes from the "master" branch, since
...
$ git update-ref refs/tags/not-lost-anymore 1ef2b196
$ git rev-parse not-lost-anymore
1ef2b196d909eed523d4f3c9bf54b78cdd6843c6
GIT
Part of the git(1) suite
Git 1.8.5.3 01/14/2014 GIT-LOST-FOUND(1)