12-04-2006
awk -F, 'NR==1 {head=$0;next}
{ y4[$3]+=$4;y5[$3]+=$5;y6[$3]+=$6}
END {
print head;
print "sales,"y4["sales"],y5["sales"],y6["sales"];
print "IT," y4["IT"],y5["IT"],y6["IT"];
print "marketing," y4["marketing"],y5["marketing"],y6["marketing"];
}' <data.txt
John Arackal
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
Can you please tell me how to add empty columns at the end csv file?
Currently there are 6 columns in the csv file. I want to add 35 empty columns at the end of this csv file.
Thanks,
Tushar (17 Replies)
Discussion started by: Tushar Bendale
17 Replies
2. Shell Programming and Scripting
Hi everybody,
I am new here and I need a reel help please
A have a csv file and I want to add new in the end of the file
Devisce Model,VMGuest Name,Host OS Name, Memory Size
Value1,Value2,Value3,Value4
Value5,Value6,Value7,Value8
Value9,Value10,Value11,Value12
And I want to add to new... (3 Replies)
Discussion started by: villebonnais
3 Replies
3. Shell Programming and Scripting
Hi everybody,
I need some help please
I have a csv file named masterFile1.csv
header1,header2,header3
value1,value2,value3
value4,value5,value6
I am trying to add new columns in the end of the csv to have a new csv file named masterFile2.csv like this :... (3 Replies)
Discussion started by: villebonnais
3 Replies
4. UNIX for Dummies Questions & Answers
Hello Unix Gurus,
I have a request 2 perform several functions on a file, delete columns, delete rows based on column value, and finally move around columns in the final output. Consider the following input file with 12 columns;
... (1 Reply)
Discussion started by: chumsky
1 Replies
5. Linux
I have a .CSV file (lets say named as file.csv) with numeric and string values. The string might contain commas hence they are enclosed in double quotes as in the below format.
column1,column2,column3,column4,column5,column6,column7
12,455,"string, with, quotes, and with, commas, in... (3 Replies)
Discussion started by: dhruuv369
3 Replies
6. Shell Programming and Scripting
Hello,
How do i manipulate .csv file to this format?
Thank you very much.
Source:
john,5
marco,7
john,4
paul,3
marco,8
Output:
john,9
marco,15 (5 Replies)
Discussion started by: tara123
5 Replies
7. Shell Programming and Scripting
Hi,
I am new to awk/unix and am trying to put together a script to manipulate the date column in a csv file.
I have file1.csv with the following contents:
Date,ID,Number,Amount,Volume,Size
01-Apr-2014,WERFG,998,105873.96,10873.96,1342.11
01-Apr-2014,POYFR,267,5681.44,5681.44,462.96
I... (2 Replies)
Discussion started by: Prit Siv
2 Replies
8. Shell Programming and Scripting
Hello all,
I have a .csv file of 16 columns consists of bunch of numbers.
6.45E+01 1.17E+01 8.10E+04 8.21E+01 8.50E+00 1.20E+01 1.02E+01 1.88E+01 1.86E+04 3.53E+03 1.09E+07 3.82E+04 2.09E+03 3.57E+03 2.98E+03 3.93E+03
6.34E+01 3.23E+01 9.24E+04 ... (5 Replies)
Discussion started by: Zam_1234
5 Replies
9. Shell Programming and Scripting
Hi, I am new to awk and unix programming and trying to manipulate a csv file.
My current csv file looks like this:
col1,col2,col3,col4,col5,col4,col5,col6,col7,col8
223,V,c,2,4,f,r,,y,z
223,V,c,3,2,f,r,,y,z
223,V,c,1,4,f,r,,y,z
223,V,c,4,3,f,r,,y,z
227,V,c,3,1,f,r,,y,z... (8 Replies)
Discussion started by: Prit Siv
8 Replies
10. Shell Programming and Scripting
Hi Guys,
Can you help to add static values at the end of the csv file with headers
input_file
id,name
1,neo
2,pull
Expected
id,name,status,entry,g_id
1,neo,done,2019-11-01T07:14:23,pass
2,pull,done,2019-11-01T07:14:23,pass
My try but not able replacing properly and unable... (1 Reply)
Discussion started by: Master_Mind
1 Replies
LEARN ABOUT HPUX
list_directory
list directory(1m) list directory(1m)
NAME
list directory - Displays a list of all the directories whose names match the specified directory name
SYNOPSIS
cdscp list directory directory-name [with attribute-name = attribute-value]
ARGUMENTS
The full name of a specific directory. The last simple name can contain wildcard characters. The name of a particular attribute. The
value of a particular attribute.
DESCRIPTION
The list directory command displays a list of all the directories whose names match the specified directory name. The last simple name can
contain wildcards. You can use a with attribute-name = attribute-value clause to limit output only to directories whose attributes have
values equal to the specified values. A space must precede and follow the = (equals sign).
Privilege Required
You must have read permission to the parent directory. If you use a with attribute-name = attribute-value clause in the command, you also
need read or test permission to the selected directories.
NOTE
This command is replaced at Revision 1.1 by the dcecp command and may not be provided in future releases of DCE.
EXAMPLE
The following command displays the names of all the directories in the /.:/sales directory: cdscp> list directory /.:/sales/*
LIST
DIRECTORY /.../abc.com/sales
AT 1991-10-15-15:43:58 atlanta austin boston chicago ontario ny seattle
RELATED INFORMATION
Commands: add directory(1m), create directory(1m), delete directory(1m), remove directory(1m), set directory(1m), set directory to
skulk(1m), show directory(1m)
list directory(1m)