Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Python:Picking values from a table
Top Forums Programming Python:Picking values from a table Post 302763957 by kaf3773 on Wednesday 30th of January 2013 09:57:57 PM
Old 01-30-2013
Python:Picking values from a table
Hi

I trying to write a python script that executes a command to screen scrub results below
I will appreciate it very much if you can help me with a python script that can
pick the percentage USAGE in the second column based on the supplied queue number in the first column
Thanks in advance.

Code:
NUMBER of Queues = 5
SYSTEM Treshold = 80%
  ==================================================================

QUEUE   USAGE   TOTAL book1   book2

------------------------------------------------------------------

0001 18%   822   481    98  

0002 16%   345   765    88  

0003 10%   400   300   166  

0004 15%   994   322    177  

0005 17%   348   297    131  

----------------------------------------------------------

---------- Post updated at 09:57 PM ---------- Previous update was at 05:50 PM ----------

I was able to get this screen scrub done using php preg_match_all
but i want to do the same with the re module in python.

Please suggestions and help will be very much appreciated

Thanks
Last edited by Scrutinizer; 01-31-2013 at 02:24 AM.. Reason: code tags
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Inserting Values From A File Into A Table

Guys, I want to insert some values from a log file into a temporary table. the values in the log file looks like this SV_NAME CC_NAME CP_DISP_RUN_STATE ------- ------------------- ----------------- sble01 ALLTEL WorkMon24Hrs Running I want to enter the... (2 Replies)
Discussion started by: ragha81
2 Replies

2. Shell Programming and Scripting

select values from db1 table and insert into table of DB2

Hi I am having three oracle databases running in three different machine. their ip address is different. from one of the DB am able to access both the databases.(means am able to select values and insert values in to tables individually.) I need to fetch some data from DB1 table(say DB1 ip is... (2 Replies)
Discussion started by: aemunathan
2 Replies

3. Shell Programming and Scripting

Retrieving values from the oracle table

Hi, How to retrieve two different date values(min & max) from the oracle table and assign to two different variables in the shell script to process further. With Regards (8 Replies)
Discussion started by: milink
8 Replies

4. Shell Programming and Scripting

Picking contents value of file at run time based on variable values

HI, I have to write a unix script and need your help. in my application where I have to invoke this script a varialble is there where the value comes in a variable . for example variable can be var=ABC like this there will be any type of value in the vcariable. there is a unix directory... (2 Replies)
Discussion started by: manish8484
2 Replies

5. Shell Programming and Scripting

Picking values from a file.

Hi, I have a file which contains values in this format. abc cde fgh ijk lmn opq rst uvw The user will pass the required parameter from the command line. My requirement is that script should pick the values passed by the user and the next value in the next line. Like if the user... (10 Replies)
Discussion started by: arijitsaha
10 Replies

6. Shell Programming and Scripting

Query the table and return values to shell script and search result values from another files.

Hi, I need a shell script, which would search the result values from another files. 1)execute " select column1 from table_name" query on the table. 2)Based on the result, need to be grep from .wft files. could please explain about this.Below is the way i am using. #!/bin/sh... (4 Replies)
Discussion started by: Rami Reddy
4 Replies

7. Shell Programming and Scripting

Perl: Writing table values to a file

I have a file like this, 1,a,saurav 2,b,rout I want to show this file in a perl cgi page table and want to add a column which will contain a text box. There I will give some manual input, which will be written to the existing file(or a new file) in below format. 1|a|saurav|bangalore... (2 Replies)
Discussion started by: sauravrout
2 Replies

8. Shell Programming and Scripting

Put repeated values into a table

Hi all, I have blocks of records like the following, each block ends in = in a new line, I want tabularize the entire output. The pattern is the same in every block although not all types are there in every block. For example gine3 is absent in the second block but present first and third. ... (7 Replies)
Discussion started by: ritakadm
7 Replies

9. Shell Programming and Scripting

awk file to read values from Db2 table replacing hard coded values

Hi, I want to replace a chain of if-else statement in an old AWK file with values from Db2 table or CSV file. The part of code is below... if (start_new_rec=="true"){ exclude_user="false"; user=toupper($6); match(user, "XXXXX."); if (RSTART ==2 ) { ... (9 Replies)
Discussion started by: asandy1234
9 Replies

10. Shell Programming and Scripting

Python Script to take file count and insert into DB2 table

Team I have files in different directories . How can i take the count of latest file and insert into Db2 table . I am using awk 'END{print NR+1-ARGC}' (File name) to get the counts. How can i take 1.The count of latest file 2.Insert into Db2 table( File Name and Counts) . cd... (4 Replies)
Discussion started by: Perlbaby
4 Replies

LEARN ABOUT SUSE

irunner

IRUNNER(1)																IRUNNER(1)

NAME

       irunner - interactive runner interface

SYNOPSIS

       irunner [options] file_to_run

DESCRIPTION

       irunner is an interface to the various interactive runners available in IPython's irunner module.

       The already implemented runners are listed below; adding one for a new program is a trivial task, see the source for examples.

OPTIONS

       -h, --help
	      show this help message and exit

       --ipython
	      IPython interactive runner (default).

       --python
	      Python interactive runner.

       --sage SAGE interactive runner.

EXAMPLE

       irunner.py --python -- --help will pass --help to the python runner.  Similarly, irunner.py --ipython -- --interact script.ipy

SEE ALSO

       ipython(1)

AUTHOR

       irunner	is  an extension of Ken Schutte <kschutte-AT-csail.mit.edu>'s script contributed on the ipython-user list: http://scipy.net/piper-
       mail/ipython-user/2006-May/001705.html

       This manual page was written by Bernd Zeimetz <bernd@bzed.de>, for the Debian project (but may be used by others).   Modified  by  Fernando
       Perez <Fernando.Perez@berkeley.edu> for inclusion in IPython.

								  April 24, 2007							IRUNNER(1)
All times are GMT -4. The time now is 03:55 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy