Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Create Pivot table
Top Forums Shell Programming and Scripting Create Pivot table Post 302501996 by boston_nilesh on Sunday 6th of March 2011 10:49:14 AM
Old 03-06-2011
Create Pivot table
I would like to use awk to parse a file with three columns in, like:


Code:
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
Chennai,08,5
Chennai,09,4
Chennai,10,15
Chennai,11,16
Chennai,12,9
Chennai,13,12




they represent the Circle 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 Circle name, and the cells will be the sum of number of transaction for that Circle name
in that particular hour like:
Code:
=========== 0 1 2 3 4 5 6 7 ... 23
Chennai xxx xxx xxx ... . . . . . . . . . . . . . .
Kerala xxx xxx xxx ... . . . . . . . . . . . . . .
Delhi xxx xxx xxx ... . . . . . . . . . . . . . .
.
.
.
AP xxx xxx xxx ... . . . . . . . . . . . . . .

I only have access to the standard AWK as operating system HP-UX, no gawk ....

Thanks.
Last edited by radoulov; 03-06-2011 at 01:39 PM.. Reason: Code tags, please!
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

create new table/field

Dear Folks, If I have 2 files, say A and B in format: A: $1 $2 01032 12856 01041 13351 01042 11071 01042 12854 01042 12862 01042 12866 . . . and B: (2 Replies)
Discussion started by: Gr4wk
2 Replies

2. Shell Programming and Scripting

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... (2 Replies)
Discussion started by: gio001
2 Replies

3. Shell Programming and Scripting

Create table

Hi I want create table based on csv file .I have come up with some informations getting columns names and then no idea from that .Please any help file.txt col1|col2|col3|col4|col5 1234|zxxxx|xcvvv|300|null file.sh file=$1 c1=`head -1 $file|tr "|" "\n" |cat -n` echo "$c1"... (31 Replies)
Discussion started by: mohan705
31 Replies

4. UNIX for Dummies Questions & Answers

Create a table - very new to unix

I need to create a simple table of information by grepping several columns from various files and display them all at once with simple headers on top. Can anyone help get me started? I am very new to unix so I really have no idea how to work with this and I appreciate any help I can get! Let me... (11 Replies)
Discussion started by: aj250
11 Replies

5. UNIX and Linux Applications

create table via stored procedure (passing the table name to it)

hi there, I am trying to create a stored procedure that i can pass the table name to and it will create a table with that name. but for some reason it creates with what i have defined as the variable name . In the case of the example below it creates a table called 'tname' for example ... (6 Replies)
Discussion started by: rethink
6 Replies

6. Shell Programming and Scripting

Create DB table through shell script

Hi, Can anyone tell me that, How to create table in Oracle database through shell script(ksh). Table contains 3 fields, 1] Emp ID, String, primary key 2] Name, String 3] B Date, date. Thanks in advance. (6 Replies)
Discussion started by: Poonamol
6 Replies

7. Programming

Create table with date format.

Hello, Could you please let me know the correct format of CREATE TABLE statement with DATE format. CREATE TABLE EMP_TABLE1 ( NAME VARCHAR(6) PRIMARY KEY, ADDRESS VARCHAR(6), BIRTH_DATE DATE ); I want BIRTH_DATE to be in "YYYYMMDDHHMISS" format. How we can create table with... (4 Replies)
Discussion started by: Poonamol
4 Replies

8. Shell Programming and Scripting

Create Script from table

I have a table ABC with 4 columns and below data Col1,Col2,Col3,Col4 prod,10,12,joba prod,10,11,jobb qa,10,12,jobc I want to create an output file like this Server:prod StartTime:10 EndTime:12 JobName:joba Server:prod StartTime:10 EndTime:11 JobName:jobb (3 Replies)
Discussion started by: traininfa
3 Replies

9. 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

10. 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

LEARN ABOUT NETBSD

face

face(1)                                                            User Commands                                                           face(1)

NAME

       face - executable for the Framed Access Command Environment Interface

SYNOPSIS

       face [-i init_file] [-c command_file] [-a alias_file] [filename...]

DESCRIPTION

       The  Framed  Access  Command  Environment Interface (FACE) presents your files and file folders on the screen through a system of menus and
       forms if you are properly set up as a FACE user.

       filename must follow the naming convention Menu.xxx for a menu, Form.xxx for a form, and Text.xxx for a text file, where xxx is any  string
       that  conforms  to  the  UNIX   system  file  naming conventions. The Form and Menu Language Interpreter (FMLI) descriptor lifetime will be
       ignored for all frames opened by argument to face. These frames have a lifetime of immortal by default. If filename is not specified on the
       command line, the  FACE Menu will be opened along with those objects specified by the
        LOGINWIN environment variables. These variables are found in the user's .environ file.

OPTIONS

       The following options are supported:

       -a alias_file           Alias file

       -c command_file         Command file

       -i init_file            Initial file

OPERANDS

       The following operand is supported:

       filename        The full pathname of the file describing the object to be opened initially.

EXIT STATUS

       The face command will return a non-zero exit value if the user is not properly set up as a  FACE user.

FILES

       $HOME/pref/.environ

ATTRIBUTES

       See attributes(5) for descriptions of the following attributes:

       +-----------------------------+-----------------------------+
       |      ATTRIBUTE TYPE         |      ATTRIBUTE VALUE        |
       +-----------------------------+-----------------------------+
       |Availability                 |SUNWfac                      |
       +-----------------------------+-----------------------------+

SEE ALSO

       env(1), attributes(5)

SunOS 5.10                                                          5 Jul 1990                                                             face(1)
All times are GMT -4. The time now is 06:52 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy