## Help with Data Sorting

Help with Data Sorting
# 1
03-15-2011
Help with Data Sorting

Hi All,
I have a long list made of 4 columns containing entries such as the following example:
So the top row is the header and I need to arrange the data in a way as to verify (using 1 for present or 0 for absent) the occurrence of each entry in the entire grid. My expected output is to keep the header row, place each individual entry in a new single column and then for each of them to put 1 or 0 under a, b, c, or d columns depending on their presence or absence. The output for the above data should look like:

Cheers
 pawannoel View Public Profile for pawannoel Find all posts by pawannoel
# 2
03-15-2011
What is present? The row number? How do you determine what to check for?

In other words, why does
2 5 3 4 give 1 1 0 1 ? (rownumber == 2)
 jim mcnamara View Public Profile for jim mcnamara Find all posts by jim mcnamara
# 3
03-15-2011
Present means existing.

To break it down for example
An entry called 0 is present in all columns a, b, c and d and thus its existence is denoted by 1, 1, 1, and 1 under a, b, c and d;
An entry called 1 is only present in columns a and c, but not in columns b and d. Thus its existence is denoted by a 1 in columns a and c and by a 0 in columns b and d;
Another entry called 2 exists/is present in columns a, b and d but not in column c, and thus its existence is denoted by 1 in columns a, b and d and by a 0 in column c;
the same goes true for other numbers in the entire data set of all columns.
Hope its clear.
 pawannoel View Public Profile for pawannoel Find all posts by pawannoel
# 4
03-15-2011
Here is a script solution for the example, assuming the file with the data is named file.tmp, and the file separator is a tab
This User Gave Thanks to Dahu For This Post:
 Dahu View Public Profile for Dahu Find all posts by Dahu
# 5
03-15-2011
This worked perfectly !

Could you please comment on the following to let me know what it means. That will be a great help in understanding the code for me to experiment.

To go one step ahead, in the output, how can I add another column lets say "e" after "d" which contains the sum of values in a, b, c and d. In other words, because 0 was present in all 4 initial columns in file.tmp, it got a value of 1(for existence) in all 4 output columns. How can I generate a column "e" which contains the sum of all these new entries, so inthe case of 0 I should get 4, and so on for the rest of the list.
I know I can do this in excel but I want to learn the command line for this.
Thanks a lot for the useful input.
 pawannoel View Public Profile for pawannoel Find all posts by pawannoel
# 6
03-15-2011
This User Gave Thanks to ctsgnb For This Post:
 ctsgnb View Public Profile for ctsgnb Find all posts by ctsgnb
# 7
03-15-2011
could you please comment on the code to make me understand a bit

 pawannoel View Public Profile for pawannoel Find all posts by pawannoel

Test Your Knowledge in Computers #475
Difficulty: Medium
A Yottabyte (YB) equals 1,208,925,819,614,629,174,706,176 bytes.
True or False?

## How AS 400 sorting data?

Hi Gurus, I have a requests to sort data based on AS 400 sorting order. below is example: the data is sorted by ascending order. could anybody explain how AS 400 sort data? IMM00007 07918607 1242 423

## Sorting the data with date

Hi, PFB the data: C_Random_130417 Java_Random_130518 Perl_Random_120519 Perl_Random_120528 so the values are ending with year,i.e.,130417 i want to sort the values with date. i want the output like this: Perl_Random_120519 Perl_Random_120528 C_Random_130417 Java_Random_130518 can...

## Sorting the Data

My actual data looks like below i have given only format. i can't give exact data format of my requirement due to some reasons. I this set of data lines about 5000 I need to come up with information in below exact format of my data set : Line<space>Number1<space>"somedata":...

## Sorting data

Hello guys. I need help figuring this one out. It's probably really easy. Thanks in advance! I have a file say for example containing this: Rice Food Carrots Food Beans Food Plates Kitchen Fork Kitchen Knives Kitchen I need: Food Rice, Carrots, Beans Kitchen Plates, Fork,...

## Help with Data Sorting Command

Hi, I have a problem on data sorting, example my file as below: 123 123/789 aaa bbb ccc ddd (adf) 112 112/123 aaa bbb ccc (ade) 102 1a3/7g9 (adf)03 110 12b/129 aaa bbb ccc ddd fff(a8f)03 117 42f/8c9 aaa bbb ccc ddd (adf) 142 120/tyu fff...

## Sorting data from a to z

Hi, Let's say I have these 3 columns; NGC1234 6 9 SL899 4 1 NGC1075 8 3 SL709 5 2 And I want to sort the data according to the first column (from a to z) like having them as: NGC1075 8 3 NGC1234 6 9 SL709 5 2 SL899 4 1 Can that be done...

## PERL data - sorting

Hello, I have a page where multiple fields and their values are displayed. But I am able to sort only a few fields. When I looked into the issue, it is seen that the for each row of info , an unique id is generated and id.txt is generated and saved. Only those fields which are inside that id.txt...

## sorting data from who by IP

Hello. I have an RS/6000 running AIX 4 and I need to be able to see if there are any users that are logged on more than once from the same terminal so I can kick them off to make room for other terminals. 64 connections is the limit. Currently I am doing this: who | more and then manually...

## Sorting blocks of data

Hello all, Below is what I am trying to accomplish: I have a file that looks like this /* ----------------- xxxx.y_abcd_00000050 ----------------- */ jdghjghkla sadgsdags asdgsdgasd asdgsagasdg /* ----------------- xxxx.y_abcd_00000055 ----------------- */ sdgsdg sdgxcvzxcbv...