Re: Decimating Excel files

2007-02-05 Thread gonzlobo
I tried to open the file with Kate, trust me, it's an Excel file. I'm using xlrd, it works beautifully (although come to think of it, I haven't tried writing to an .xls file yet... hmmm) To clear up the doubts, I'd suggest that the OP do something like this at the Python interactive prompt:

Re: Decimating Excel files

2007-02-04 Thread gonzlobo
Excellent suggestion. I'm going with xlrd! Thanks I've had good luck with xlrd. It does not require using COM, Excel, or even Windows! http://www.lexicon.net/sjmachin/xlrd.htm Robert Kern -- http://mail.python.org/mailman/listinfo/python-list

Decimating Excel files

2007-02-03 Thread gonzlobo
No, I don't want to destroy them (funny how the word 'decimate' has changed definition over the years) :). We have a data acquisition program that saves its output to Excel's .xls format. Unfortunately, the programmer was too stupid to write files the average user can read. I'd like some advice

Re: Decimating Excel files

2007-02-03 Thread gonzlobo
Thanks, but I was looking for a python solution. Excel has VBA and can do this easily. One thing about Excel's VBA is that it already understands Excel. -- http://mail.python.org/mailman/listinfo/python-list

Re: Decimating Excel files

2007-02-03 Thread gonzlobo
Yeah, it definitely an Excel file (so says Kate). Is the file format really native Excel, or is a CSV or TSV file? I've seen apps (one is a data acquisition program, as a matter of fact) that create Excel files that are just CSV or TSV files. Try opening the file with a text editor to see if

Two dimensional lists

2007-01-25 Thread gonzlobo
I might get an answer since I didn't call them arrays. :^) Ok, I have 2 lists that I need to process individually, then merge them into a 2x list and fill with data. arinc429 = ['ab', '2b', '0b', '21', 'c1', '61', '11', 'db', '9b', '5b', 'eb', '6b', '1b', '6e', '3e'] iPIDs = [300, 301,

Re: Python Windows Editors

2007-01-21 Thread gonzlobo
I prefer PyScripter too, but would like to know if I can have 'indentation guides' enabled like PythonWin allows. On 1/21/07, Stef Mientki [EMAIL PROTECTED] wrote: I tried 2 of them, and only was stable enough: PyScripter http://mmm-experts.com/Products.aspx?ProductID=4 --

Re: How to comment code?

2007-01-19 Thread gonzlobo
If it's hard to write, it should be hard to read! :) On 1/19/07, Martin P. Hellwig [EMAIL PROTECTED] wrote: Hi all, (snip) However since I'm learning more of python I've struggled with commenting, how should I've comment my code (snip) -- http://mail.python.org/mailman/listinfo/python-list

Re: OT Annoying Habits (Was: when format strings attack)

2007-01-19 Thread gonzlobo
I should write a python script to read this. :) .snoitnevnoc hsilgnE tpada )ylbissop revenehw( dluohs ew os dna ,naitraM ton ,puorgswen egaugnal hsilgnE na no er'ew ,segaugnal hcus era ereht fi neve tuB -- http://mail.python.org/mailman/listinfo/python-list

variable scope

2007-01-18 Thread gonzlobo
Greetings, I've been using Python to successfully parse files. When the entire program was smaller, the variable firstMsg worked fine, but now doesn't because it's used in function PID_MinMax. I know it's a result of variables and their scope. I declare the variable 'firstMsg = 0' in the main

Python cheatsheets

2007-01-07 Thread gonzlobo
Curious if anyone has a python cheatsheet* published? I'm looking for something that summarizes all commands/functions/attributes. Having these printed on a 8 x 11 double-sided laminated paper is pretty cool. * cheatsheet probably isn't the right word, but you get the idea. :) --

Writing more efficient code

2007-01-01 Thread gonzlobo
Greetings, and happyNewYear to all. I picked up Python a few weeks ago, and have been able to parse large files and process data pretty easily, but I believe my code isn't too efficient. I'm hoping dictionaries will help out, but I'm not sure the best way to implement them. I've been using a

Re: Noobie: Open file - read characters multiply

2006-12-27 Thread gonzlobo
Thanks to all that responded. I chose a modified version of Scott's second recommendation: time = line[:8] decoded_File.write( '%00.4f' % (int(time, 16) * .0001) + ', ') 'print ' added a CRLF that I didn't need, so I went with '.print' (I need to process about 20 values from the remaining

Noobie: Open file - read characters multiply

2006-12-26 Thread gonzlobo
I've been using Python for a few days. It's such the perfect language for parsing data! I really like it so far, but I'm having a hard time reading a file, reading the first few hex characters converting them to an integer. Once the characters are converted to an integer, I'd like to write the