Sponsored Content
Top Forums Shell Programming and Scripting How to convert the row to column in Perl? Post 302890055 by summer_cherry on Tuesday 25th of February 2014 01:30:41 AM
Old 02-25-2014
python

Code:
import itertools
import operator
a='''Linux 2014_01_24 CPU 10
Linux 2014_01_24 MEM 20
UNIX 2014_01_24 CPU 30
UNIX 2014_01_24 MEM 40'''.split("\n")
a=map(lambda x:x.split(" "),a)
for name,item in itertools.groupby(sorted(a,key=operator.itemgetter(2,1)),operator.itemgetter(2,1)):
    print(name[0],name[1],end=" ")
    for i in item:
        print(i[-1],end=" ")
    print("")

 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

convert column into row with some modifier

A file content have 1 1:-0.289433 2:0.833778 3:0.314471 4:-0.289433 5:-0.81876 6:-0.456693 7:-0.17511 8:-0.644555 9:-0.00666341 10:-1.13603 I will like to have that column into row with numbers to be printed (red color) only after colon output shud be like that -0.289433... (1 Reply)
Discussion started by: cdfd123
1 Replies

2. Shell Programming and Scripting

column to row convert - script - help

Hi, I have a file named col.txt 1.000 2.000 3.000 4.000 5.000 6.000 7.000 8.000 I should get this 1.000 5.000 2.000 6.000 3.000 7.000 (10 Replies)
Discussion started by: G0Y
10 Replies

3. Shell Programming and Scripting

Convert column values into row

hi, I have a requirement where in I read the values from a file using awk. The resulting data should be converted into row format from column format. For ex: My log file login.lst contains the following SERVER1 DB1 SERVER2 DB2 SERVER3 DB3 SERVER4 DB4 I use awk to grep only the server... (6 Replies)
Discussion started by: senthil3d
6 Replies

4. Shell Programming and Scripting

convert a column to row output?

Getting tired of cut-and-paste...so I thought I would post a question. how do I change this column output to a single row? from this: # vgdisplay -v /dev/vgeva05 | grep dsk | awk '{print $3}' /dev/dsk/c6t0d5 /dev/dsk/c11t0d5 /dev/dsk/c15t0d5 /dev/dsk/c18t0d5 /dev/dsk/c7t0d5... (8 Replies)
Discussion started by: mr_manny
8 Replies

5. Shell Programming and Scripting

Convert row to column

Hi, I have a file like this 50 1 2 1374438 50 1 2 1682957 50 5 2 1453574 50 10 2 1985890 100 1 2 737307 100 5 2 1660204 100 10 2 2148483 and I want to convert this by... (1 Reply)
Discussion started by: gvj
1 Replies

6. UNIX for Dummies Questions & Answers

awk: convert column to row in a specific way

Hi all! I have this kind of output: a1|b1|c1|d1|e1 a2|b2|c2 a3|b3|c3|d3 I would like to transpose columns d and e (when they exist) in column c, and under the row where they come from. Then copying the beginning of the row. In order to obtain: a1|b1|c1 a1|b1|d1 a1|b1|e1 a2|b2|c2... (1 Reply)
Discussion started by: lucasvs
1 Replies

7. Shell Programming and Scripting

convert row to column with respect of first column.

Input file A.txt :- C2062 -117.6 -118.5 -117.5 C5145 0 0 0 C5696 0 0 0 Output file B.txt C2062 X -117.6 C2062 Y -118.5 C2062 Z -117.5... (4 Replies)
Discussion started by: asavaliya
4 Replies

8. Shell Programming and Scripting

Script: Convert row in to column

Hi, i need to convert SG_ERP1 SG_ERP2 SG_ERP3 in to: SG_ERP1 SG_ERP2 SG_ERP3 It's possibile? (16 Replies)
Discussion started by: elilmal
16 Replies

9. Shell Programming and Scripting

[Solved] Convert Row To column

Hi Folks, I am using db2 command -> db2 list tablespace show detail Tablespace ID = 10 Name = TSCDDHLMSUM Type = Database managed space Contents = All permanent data.... (5 Replies)
Discussion started by: ckwan
5 Replies

10. Shell Programming and Scripting

Convert Data from Column to Row

Hi FileA.txt E_TIM 16, ETE 15, EOND 26, EEC 81, E_1 un, E_2 un, E_3 un, E_4 284, E_TIM 17, ETE 15, EOND 29, EEC 82, E_1 un, E_2 un, E_3 un, E_4 249, (6 Replies)
Discussion started by: asavaliya
6 Replies
QListViewItemIterator(3qt)												QListViewItemIterator(3qt)

NAME
QListViewItemIterator - Iterator for collections of QListViewItems SYNOPSIS
#include <qlistview.h> Public Members QListViewItemIterator () QListViewItemIterator ( QListViewItem * item ) QListViewItemIterator ( const QListViewItemIterator & it ) QListViewItemIterator ( QListView * lv ) QListViewItemIterator & operator= ( const QListViewItemIterator & it ) ~QListViewItemIterator () QListViewItemIterator & operator++ () const QListViewItemIterator operator++ ( int ) QListViewItemIterator & operator+= ( int j ) QListViewItemIterator & operator-- () const QListViewItemIterator operator-- ( int ) QListViewItemIterator & operator-= ( int j ) QListViewItem * operator* () QListViewItem * current () const DESCRIPTION
The QListViewItemIterator class provides an iterator for collections of QListViewItems. Construct an instance of a QListViewItemIterator, with either a QListView* or a QListViewItem* as argument, to operate on the tree of QListViewItems. A QListViewItemIterator iterates over all the items in a list view. This means that it always makes the first child of the current item the new current item. If there is no child, the next sibling becomes the new current item; and if there is no next sibling, the next sibling of the parent becomes current. The following example creates a list of all the items that have been selected by the user, storing pointers to the items in a QPtrList: QPtrList<QListViewItem> lst; QListViewItemIterator it( myListView ); while ( it.current() ) { if ( it.current()->isSelected() ) lst.append( it.current() ); ++it; } A QListViewItemIterator provides a convenient and easy way to traverse a hierarchical QListView. Multiple QListViewItemIterators can operate on the tree of QListViewItems. A QListView knows about all iterators operating on its QListViewItems. So when a QListViewItem gets removed all iterators that point to this item are updated and point to the following item if possible, otherwise to a valid item before the current one or to 0. See also QListView, QListViewItem, and Advanced Widgets. MEMBER FUNCTION DOCUMENTATION
QListViewItemIterator::QListViewItemIterator () Constructs an empty iterator. QListViewItemIterator::QListViewItemIterator ( QListViewItem * item ) Constructs an iterator for the QListView that contains the item. The current iterator item is set to point to the item. QListViewItemIterator::QListViewItemIterator ( const QListViewItemIterator & it ) Constructs an iterator for the same QListView as it. The current iterator item is set to point on the current item of it. QListViewItemIterator::QListViewItemIterator ( QListView * lv ) Constructs an iterator for the QListView lv. The current iterator item is set to point on the first child (QListViewItem) of lv. QListViewItemIterator::~QListViewItemIterator () Destroys the iterator. QListViewItem * QListViewItemIterator::current () const Returns iterator's current item. Examples: QListViewItem * QListViewItemIterator::operator* () Dereference operator. Returns a reference to the current item. The same as current(). QListViewItemIterator &; QListViewItemIterator::operator++ () Prefix ++. Makes the next item the new current item and returns it. Returns 0 if the current item is the last item or the QListView is 0. const QListViewItemIterator QListViewItemIterator::operator++ ( int ) This is an overloaded member function, provided for convenience. It behaves essentially like the above function. Postfix ++. Makes the next item the new current item and returns the item that was the current item. QListViewItemIterator &; QListViewItemIterator::operator+= ( int j ) Sets the current item to the item j positions after the current item. If that item is beyond the last item, the current item is set to 0. Returns the current item. QListViewItemIterator &; QListViewItemIterator::operator-- () Prefix --. Makes the previous item the new current item and returns it. Returns 0 if the current item is the first item or the QListView is 0. const QListViewItemIterator QListViewItemIterator::operator-- ( int ) This is an overloaded member function, provided for convenience. It behaves essentially like the above function. Postfix --. Makes the previous item the new current item and returns the item that was the current item. QListViewItemIterator &; QListViewItemIterator::operator-= ( int j ) Sets the current item to the item j positions before the current item. If that item is before the first item, the current item is set to 0. Returns the current item. QListViewItemIterator &; QListViewItemIterator::operator= ( const QListViewItemIterator & it ) Assignment. Makes a copy of it and returns a reference to its iterator. SEE ALSO
http://doc.trolltech.com/qlistviewitemiterator.html http://www.trolltech.com/faq/tech.html COPYRIGHT
Copyright 1992-2001 Trolltech AS, http://www.trolltech.com. See the license file included in the distribution for a complete license statement. AUTHOR
Generated automatically from the source code. BUGS
If you find a bug in Qt, please report it as described in http://doc.trolltech.com/bughowto.html. Good bug reports help us to help you. Thank you. The definitive Qt documentation is provided in HTML format; it is located at $QTDIR/doc/html and can be read using Qt Assistant or with a web browser. This man page is provided as a convenience for those users who prefer man pages, although this format is not officially supported by Trolltech. If you find errors in this manual page, please report them to qt-bugs@trolltech.com. Please include the name of the manual page (qlistviewitemiterator.3qt) and the Qt version (3.1.1). Trolltech AS 9 December 2002 QListViewItemIterator(3qt)
All times are GMT -4. The time now is 11:55 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy