I finally figured out the problem...it turns out it was a data problem. There were two cells in the shipping_actual column that were empty. Took a while but I learned how to inspect the stack during this exercise...:-) I still need to comprehend the error messages a little better. I'll keep working on it, though!
I'll show you what I come up with as I continue my project. Thanks again for the great headstart you gave me!!...
hjnathan
Last Activity: Sep 8 '08, 05:04 AM
Joined: Feb 14 '08
Location:
-
Well I have spent a few hours trying to get the column comparison code to work.
Here is the error I get...
compList = [[float(item), float(dd['shipping_actua l'][i])] for i, item in enumerate(dd['shipping'])]
for i, item in enumerate(compL ist):
diff = item[0]-item[1]
if abs(diff) > 1:
print 'Record %d difference is %0.4f' % (i, diff)
Here is a bit...Leave a comment:
-
So, those should be keys then...I'l play with it some more. Thanks!...Leave a comment:
-
Okay...I am back at it this morning. I understand how you created the dictionary and how to reorder the columns so far, but I am having a little trouble figuring out the "Comparison " code. In your code where you are defining compList, what list does 'data 1' and 'data 2' represent? I understand that the list is part of the dictionary named "dd" and I have tried replacing those entries with key names and key position numbers with...Leave a comment:
-
Thanks for the quick response!
Breaking this up by columns was definitely a different direction than I was seeing...I was focused on the rows...
It took me a while to reply back because I tried it out with my data, not to mention I'm at work now. It works great! I'm going to spend a little time getting more comfortable with what you sent and try to add to it. I saw your column total and had to comment it out until...Last edited by hjnathan; Feb 15 '08, 01:45 AM. Reason: not sure why I can't see what I posted...now I got it!!Leave a comment:
-
Starting at the beginning...
Hello...
I m very new to programming but not to computers. I am trying to expand my skills beyond what I do in Excel. I started working with Python about a month ago. I feel things are close to clicking for me but I need a bit of a nudge from an expert to get me over the hump.
I am not looking for help writing a script per se, but actually looking for insight on how to approach my project. I have been reading about tuples... -
I have just started learning Python at the beginning of the year. I am currently running WinXP, Python 2.5.1, I have been using Idle mostly but recently started using Wing IDE,...Leave a comment:
No activity results to display
Leave a comment: