Sponsored Content
Full Discussion: Pivot table
Top Forums Shell Programming and Scripting Pivot table Post 302287812 by gio001 on Sunday 15th of February 2009 05:54:52 PM
Old 02-15-2009
Pivot table

Hello everyone,
I would like to use awk to parse a file with three columns in, like:
monday 0 1
monday 1 1
monday 2 1
monday 3 1
monday 4 1
monday 5 1
tuesday 0 5
tuesday 1 1
tuesday 2 1
tuesday 3 1
tuesday 4 1
wednesday 0 1
monday 5 25

they represent the day the hour and the number of transactions.
There are thousand of lines, I would like to generate a single table
with hours as headers, the row name will be the day name, and the cells will be the average number of transaction for that day name in that particular hour like:
=========== 0 1 2 3 4 5 6 7 ... 23
Monday xxx xxx xxx ... . . . . . . . . . . . . . .
Tuesday xxx xxx xxx ... . . . . . . . . . . . . . .
Wednesday xxx xxx xxx ... . . . . . . . . . . . . . .
.
.
.
Sunday xxx xxx xxx ... . . . . . . . . . . . . . .

I only have access to the standard AWK, no gawk ....
I hope you understand and can help.
Thanks.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

pivot

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

Create Pivot table

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

Pivot script

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

Pivot multiple

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

Pivot using awk

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

Create a pivot table from CSV file

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

Data Pivot

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

Awk- Pivot Table Averages

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

DB Query for Pivot

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

Pivot example

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
DateTime::Event::ICal(3pm)				User Contributed Perl Documentation				DateTime::Event::ICal(3pm)

NAME
DateTime::Event::ICal - Perl DateTime extension for computing rfc2445 recurrences. SYNOPSIS
use DateTime; use DateTime::Event::ICal; my $dt = DateTime->new( year => 2000, month => 6, day => 20, ); my $set = DateTime::Event::ICal->recur( dtstart => $dt, freq => 'daily', bymonth => [ 10, 12 ], byhour => [ 10 ] ); my $dt_next = $set->next( $dt ); my $dt_previous = $set->previous( $dt ); my $bool = $set->contains( $dt ); my @days = $set->as_list( start => $dt1, end => $dt2 ); my $iter = $set->iterator; while ( my $dt = $iter->next ) { print ' ', $dt->datetime; } DESCRIPTION
This module provides convenience methods that let you easily create "DateTime::Set" objects for rfc2445 style recurrences. USAGE
recur This method returns a "DateTime::Set" object representing the given recurrence. my $set = DateTime::Event::ICal->recur( %args ); This method takes parameters which correspond to the rule parts specified in section 4.3.10 of RFC 2445. Rather than rewrite that RFC here, you are encouraged to read that first if you want to understand what all these parameters represent. o dtstart A DateTime object, which is the start date. This datetime is not included in the recurrence, unless it satisfies the recurrence's rules. A set can thus be used for creating exclusion rules (rfc2445 "exrule"), which don't include "dtstart". o until A DateTime object which specifies the recurrence's end date. Can also be specified as "dtend". o count A positive number which indicate the total number of recurrences. Giving both a "count" and an "until" parameter is pointless, though it is currently allowed. o freq One of: "yearly", "monthly", "weekly", "daily", "hourly", "minutely", "secondly" See the "DateTime::Event::Recurrence" documentation for more details on what these mean. o interval The interval between recurrences. This is a multiplier for the value specified by "freq". It defaults to 1. So if you specify a "freq" of "yearly" and an "interval" of 3, that means a recurrence that occurs every three years. o wkst Week start day. This can be one of: "mo", "tu", "we", "th", "fr", "sa", "su". The default is monday ("mo"). Note: this parameter is not yet implemented o bysecond => [ list ], byminute => [ list ], byhour => [ list ] This should be one or more positive or numbers, specified as a scalar or array reference. Each number represents a second/minute/hour. See RFC 2445, section 4.3.10 for more details. o byday => [ list ] This should be a scalar or array reference containing days of the week, specified as "mo", "tu", "we", "th", "fr", "sa", "su" The day of week may have a prefix: "1tu", # the first tuesday of month or year "-2we" # the second to last wednesday of month or year See RFC 2445, section 4.3.10 for more details. o bymonthday => [ list ], byyearday => [ list ] A scalar or array reference containing positive or negative numbers, but not zero. For "bymonthday", the allowed ranges are -31 to -1. For "byyearday", the allowed ranges are -366 to -1, and 1 to 366. Day -1 is last day of month or year. See RFC 2445, section 4.3.10 for more details. o byweekno => [ list ] A scalar or array reference containing positive or negative numbers, but not zero. The allowed ranges are -53 to -1, and 1 to 53. The first week of year is week 1. The default week start day is monday. Week -1 is the last week of year. See RFC 2445, section 4.3.10 for more details. o bymonth => [ list ] A scalar or array reference containing positive or negative numbers, from -12 to -1 and 1 to 12. Month -1 is December. See RFC 2445, section 4.3.10 for more details. o bysetpos => [ list ] This can be either a scalar or an array reference of positive and negative numbers from -366 to -1, and 1 to 366. This parameter is used in conjuction with one of the other "by..." parameters. See RFC 2445, section 4.3.10 for more details. AUTHOR
Flavio Soibelmann Glock fglock@gmail.com CREDITS
The API was developed with help from the people in the datetime@perl.org list. COPYRIGHT
Copyright (c) 2003 Flavio Soibelmann Glock. All rights reserved. This program is free software; you can redistribute it and/or modify it under the same terms as Perl itself. The full text of the license can be found in the LICENSE file included with this module. SEE ALSO
datetime@perl.org mailing list DateTime Web page at http://datetime.perl.org/ DateTime DateTime::Event::Recurrence - simple rule-based recurrences DateTime::Format::ICal - can parse rfc2445 recurrences DateTime::Set - recurrences defined by callback subroutines DateTime::Event::Cron - recurrences defined by "cron" rules DateTime::SpanSet RFC2445 - Internet Calendaring and Scheduling Core Object Specification - http://www.ietf.org/rfc/rfc2445.txt perl v5.10.1 2009-11-30 DateTime::Event::ICal(3pm)
All times are GMT -4. The time now is 08:43 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy