02-15-2009
I modified this code, but i do not have access to the asorti function....what can I proceed would it work if I do not sort and just use 'count of' array for my loop control?
awk '{y[$2];i[$1];c[$1,$2]+=$2;d[$1,$2]++}END{ny=asorti(y);ni=asorti(i);printf "ID";for(j=1;j<=ny;j++); printf ";%s", y[j];print"";for(x=1;x<=ni;x++){
printf i[x];
for(j=1;j<=ny;j++);printf ";%s", c[i[x],y[j]]/d[i[x],y[j]] ""
print""
}}' file
Thanks.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I have a sql table with :
Acitvity Date Value
ABC 7/11 10
DEF 7/11 98
ABC 7/12 23
DEF 7/12 100
SER 7/12 67
GRH 7/13 123
HJY 7/14 12
I... (4 Replies)
Discussion started by: mukhanj
4 Replies
2. Shell Programming and Scripting
I would like to use awk to parse a file with three columns in, like:
Chennai,01,1
Chennai,07,1
Chennai,08,3
Chennai,09,6
Chennai,10,12
Chennai,11,19
Chennai,12,10
Chennai,13,12
Kerala,09,2
AP,10,1
AP,11,1
Delhi,13,1
Kerala,13,3
Chennai,00,3
Chennai,01,1
Chennai,02,1
Chennai,07,5 (3 Replies)
Discussion started by: boston_nilesh
3 Replies
3. Shell Programming and Scripting
Hi
Please suggest a script that would do a horizontal pivot , on the fields separated by a semicolon
Below is my input file 1|c2|aa
1|c3|dd
1|c4|cc
1|c5|aa
1|c6|ss
1|c7|dd
1|c8|bb
1|c9|jjj
1|c10|kkk
1|c11|fffg
1|c12|nnn;indi;pak;linf;wer
1|c13|lllnk;li;sdfsd;oiuo
1|c14|ppp... (5 Replies)
Discussion started by: mabarif16
5 Replies
4. UNIX for Dummies Questions & Answers
Dear friend,
I want to sum popul based on ville and reg.
input
date country ville reg popul
20131101 INDIA Gujarat College 322047286
20131101 USA Oregon 2 Kindergaten 477305599
20131101 INDIA Delhi 1 Ecole 255029428
20131101 MEXICO ... (2 Replies)
Discussion started by: radius
2 Replies
5. Shell Programming and Scripting
Hi,
I am writing a code to basically pivot the data.
awk -v var1="" -v var2="" -v var3="" -v var4="" -v var5="" -v Disp=0\
'BEGIN {FS=":"; OFS="|";}\
/^Pattern1/ {var1=$2;Disp=0;} \
/^Pattern2/ {var2=$2;} \
/^Pattern3/ {var3=$2;} \
/^Pattern4/ {var4=$2;} \
/^Pattern5/... (5 Replies)
Discussion started by: tostay2003
5 Replies
6. Shell Programming and Scripting
Gents,
Can you please help me to create a pivot table from a csv file. ( I have zip the csv file)
Using the file attached, columns 1,28 and 21 i would like to get something like this output
JD Val 1 2 3 4 5 6 7 8 9 10 11 12 Total... (4 Replies)
Discussion started by: jiam912
4 Replies
7. UNIX for Beginners Questions & Answers
Good Day,
I have file input
6285296582710|20170509|INDOTEL
6285296835209|20170509|INDOTEL
6285296940311|20170509|INDOTEL
6285297027737|20170509|MULTIFLAG
6285297027737|20170509|DELTA
6285297304373|20170510|INDOTEL
6285297384129|20170510|INDOTEL
6285296940311|20170510|MULTIFLAG... (2 Replies)
Discussion started by: radius
2 Replies
8. Shell Programming and Scripting
Hi everyone,
Has anyone figured out yet how to do pivot table averages using AWK. I didn't see anything with regards to doing averages.
For example, suppose you have the following table with various individuals and their scores in round1 and round2:
SAMPLE SCORE1 SCORE2
British ... (6 Replies)
Discussion started by: Geneanalyst
6 Replies
9. Programming
hi team
With below results in Db2 v10.5 . Please refer column A and B are same,while Staus column defers with distinct values .
A B STATUS
Insert Update Old
Insert Update New
Insert Update Final
Can someone guide how to... (2 Replies)
Discussion started by: Perlbaby
2 Replies
10. Shell Programming and Scripting
Hi all, I am new to shell scripting so pardon me for the questions I will be asking.
I was given a task where I have to pivot my data
Example
Source
SGPAPCTUMACCHEA
Expected output
SGP APC TUM
SGP APC ACC
SGP APC HEA
Can anybody assist me on this?Please use CODE tags as required... (3 Replies)
Discussion started by: redaela
3 Replies
LEARN ABOUT MOJAVE
widget_calendar
widget_calendar(n) widget::calendar Megawidget widget_calendar(n)
__________________________________________________________________________________________________________________________________________________
NAME
widget_calendar - widget::calendar Megawidget
SYNOPSIS
package require Tcl 8.4
package require Tk 8.4
package require widget ?3.0?
widget::calendar pathname ?options?
_________________________________________________________________
DESCRIPTION
This package provides a calendar megawidget (snidget).
widget::calendar pathname ?options?
WIDGET OPTIONS
-command
A script to evaluate when a date was selected.
-dateformat
The format of the date that is returned. Default: %m/%d/%Y.
-firstday
Set first day the week, Either sunday or monday. It defaults to monday.
-font Select the font used in the widget. It defaults to Helvetica 9.
-highlightcolor
Selects the background color for the day that has been selected. Default: #FFCC00
-language
Specify language of the calendar contents. The language is specified by abbreviations of the languge, for example: en - english, de
- german ... It defaults to en.
Supported languages: en, de, fr, it, es, pt, ru, sv, zh, fi
-shadecolor
Selects the color of the parts that have a shaded background. Default: #888888
-showpast
Specify if the past shall be shown. It is a boolean value and defaults to 1.
-textvariable
Specifies the name of a variable whose value is linked to the entry widget's contents. Whenever the variable changes value, the
widget's contents are updated, and vice versa.
WIDGET COMMAND
pathname get ?what?
Returns a part of the selected date or 'all'. The argument what selects the part. Valid values for what are: day, month, year and all.
'all' is the default and returns the complete date in the format given with -dateformat.
DEFAULT BINDINGS
On creation of the calendar widget the following bindings are installed.
o Up - Move to week before current date
o Down - Move to week after current date
o Left - Move to day before current date
o Right - Move to day after current date
o Control-Left - Move to month before current date
o Control-Right - Move to month after current date
o Control-Up - Move to year before current date
o Control-Down - Move to year after current date
EXAMPLE
package require widget::calendar ; # or widget::all
set t [widget::calendar .t]
pack $t -fill x -expand 1
KEYWORDS
megawidget, snit, widget
widget 0.93 widget_calendar(n)