Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Arrange word in table metrix format
Top Forums Programming Arrange word in table metrix format Post 302767987 by awil on Thursday 7th of February 2013 10:01:17 PM
Old 02-07-2013
Arrange word in table metrix format
Hello everyone,

I have some problem about this code :
Code:
#!/usr/bin/env python
import sys

try :
   filename = sys.argv[1]
except :
   print 'Specify filename'
   sys.exit()
fd = open(filename)
lines = fd.xreadlines()
compare = {}
for line in lines :
    split_line = line.strip().split('\t')
        if compare.has_key(split_line[0]) :
            for i in range(1,3) :
                try :
                    compare[split_line[0]].index(split_line[i])
                except :
                    compare[split_line[0]].append(split_line[i])
        else :
            compare[split_line[0]] = []
            for i in range(1,3) :
                try :
                    compare[split_line[0]].index(split_line[i])
                except :
                     compare[split_line[0]].append(split_line[i])
fd.close()
for i in compare.keys() :
   print '%s\t%s' %(i,compare[i])

Input file is
Quote:
SN1 data1 A,A
SN1 data2 A,B
SN1 data3 A,C
AC2 data1 A,B
AC2 data2 A,C
TP3 data3 C,C
TP3 data1 C,A
Output from this code showed :
Quote:
AC2 ['data1', 'A,B', 'data2', 'A,C']
TP3 ['data3', 'C,C', 'data1', 'C,A']
SN1 ['data1', 'A,A', 'data2', 'A,B', 'data3', 'A,C']
If I would like get the output file in below :
Quote:
AC2 data1 A,B data2 A,C data3 N,N
TP3 data1 C,A data2 N,N data3 C,C
SN1 data1 A,A data2 A,B data3 A,C
Expected output should be arranged in data1 to data3 in every row. If any column is loss, the data will show in N,N.

I don't know that how to solve this problem, please suggest me.
Thank in advance.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Format & re-arrange the records

Data on my input file : Ac1n1s1c2n2s2XPd1r1e1t1d2r2e2t2d3r3e3t3d4r4e4t4RT Bh1k1p1h2k2p2NTq1y1f1m1q2y2f2m2q3y3f3m3q4y4f4m4ZN and i want the output to be: Ac1n1s1XPd1r1e1t1RT Ac1n1s1XPd2r2e2t2RT Ac1n1s1XPd3r3e3t3RT Ac1n1s1XPd4r4e4t4RT Ac2n2s2XPd1r1e1t1RT Ac2n2s2XPd2r2e2t2RT... (6 Replies)
Discussion started by: rlmadhav
6 Replies

2. Shell Programming and Scripting

Arrange Data in table and send by mail

Everybody, can you tell me how express about this; we have text data file as : parameter1 Parameter2 AA 55 BB 77 . . . . . . We want to draw table for this data as attached then send as body of Email (4 Replies)
Discussion started by: xjklop2009
4 Replies

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

4. Shell Programming and Scripting

Arrange / format data using awk

Input 217:fngadi4osa:fngadi4osa:M 217:415744:N/A 227:fngadi4osa:fngadi4osa: M 227:51200:N/A 228:fngadi4osa:fngadi4osa: M 228:102400:N/A 65:sapgt04:sapgt04: M 65:104448:N/A 228:fngadi4osa:fngadi4oma: M 228:102400:N/A Output 217:fngadi4osa:fngadi4osa:M 217:415744:N/A... (3 Replies)
Discussion started by: greycells
3 Replies

5. Shell Programming and Scripting

Table format

My Code Hi Friends, I need to get output in table format using unix shell script.For example my server CPU and memory utilization report will come as a mail with ordinary format but i want to make as table format. Here two output finally we are getting:- CPU utilization is... (2 Replies)
Discussion started by: susindram
2 Replies

6. Shell Programming and Scripting

script to arrange file in specific format

Hi All, I am new to forum, I am looking to arrange a file in specific format but unable to get the formula to do it, already googled for the same, but didnt find the answer :(. hope to get help here :o:o:o:o:o I have to files : $ cat Dev_List2 0685 0686 0687 0688 0689 068A 068B 068C... (2 Replies)
Discussion started by: prasan_Aix
2 Replies

7. Shell Programming and Scripting

How to words in arrange as Table

Hi Team, I have one file in that almost 100+ words in lines Eg:- Unix windows solaris Linux ... ... But I want arrange all lines in table format and can able read on screen Eg: - Unix windows solaris Lunix...... Hp unix Mac-os ...... Like as Table...... (11 Replies)
Discussion started by: Bhaskar Alagala
11 Replies

8. Shell Programming and Scripting

Arrange data in table

Hello All, I have following data into my file named record. Name City phone number email Jhon Newyork 123456987 jhon@gmail.com Maria Texas 569865612 Maria_Sweet@rediffmail.com Chan Durben NA Chan123@gmail.com |---------------------------------------------------------------| |Name ... (2 Replies)
Discussion started by: Nakul_sh
2 Replies

9. Shell Programming and Scripting

Arrange data in table

Hello All, I have following data into my file named record. Name City phone number email Jhon Newyork 123456987 jhon@gmail.com Maria Texas 569865612 Maria_Sweet@rediffmail.com Chan Durben NA Chan123@gmail.com The output should be in straight columns.. There should not be any... (1 Reply)
Discussion started by: Nakul_sh
1 Replies

10. Shell Programming and Scripting

Output in table format

I have one script which generate file called report.txt having following output parameter_name status comment banking ok NA finance 30% hike NA Loan_department ok 20% HR_Group defaulters Ajay I wanted to convert this file into tabular form. You can see each line contain 3 words and... (7 Replies)
Discussion started by: Nakul_sh
7 Replies

LEARN ABOUT DEBIAN

openipmicmd

openipmicmd(1)						     An IPMI Command Interface						    openipmicmd(1)

NAME

       openipmicmd - An IPMI Command Interface

SYNOPSIS

       openipmicmd [-k entry-to-execute] <connection parms>

DESCRIPTION

       The  openipmicmd program allows a user to execute direct IPMI commands.	It can work with direct interface with the OpenIPMI driver or with
       IPMI LAN interfaces.

OPTIONS

       -k entry-to-execute
	      Execute a single command an exit.

       <connectionparms>
	      The parameters for the connection depend on the connection type.	These are all described in openipmi_conparms (7)

COMMANDS

       Once up, you can execute commands in the user interface.  Note that commands and responses are asynchronous, you issue a  command  and  the
       interface returns immediately.  When the response comes back, it will be dumped on your console.  That's a little strange looking, but IPMI
       is ansychronous underneath.  Note that the -k option is synchronous, it will wait for the response or a timeout before returning.

       0f lun netfn cmd [data1 [data2 ...]]
	      Send a command to the BMC you are connected to.

       channel [ipmb] IPMB-addr lun netfn [seq] cmd [data1 [data2 ...]]
	      Send a command to a device on the IPMB bus.  The "ipmb" string is optional.  The seq must be provided if the netfn is a response (an
	      odd number).  It must be the same sequence number that came in on the command in the "Command Sequence = seq" part of the command.

       channel 00 IPMB-addr lun netfn cmd [data1 [data2 ...]]
	      Send a broadcast command to a device on the IPMB bus.

       channel lan handle remote-swid local-swid lun netfn cmd [data1 [data ...]]
	      Send  a  command	to  a device over a LAN channel.  Note that this not the same as a LAN connection.  This sends a message through a
	      local BMC to a remote system that is hooked up with a LAN connection.

       test_lat count command
	      Executes the given commands (one of the previous commands) count times and gives the average time per command to execute.  Note that
	      "count" is hexadecimal.

       help   Display some help.

       regcmd netfn cmd
	      Register to receive the given command.  If the driver receives an external command, it will print it out.  This only works with sys-
	      tem interface connections, it will not work on LAN connections.

       unregcmd netfn cmd
	      Remove a command registration.

SEE ALSO

       ipmi_ui(1), ipmilan(8), openipmi_conparms(7)

KNOWN PROBLEMS

       The asychronous nature of the program can be annoying.

AUTHOR

       Corey Minyard <cminyard@mvista.org>

OpenIPMI							     05/13/03							    openipmicmd(1)
All times are GMT -4. The time now is 01:47 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy