Re: [Tutor] Coming from R, what's a good IDE editor? I've tried PyCharm and Spyder

2017-06-08 Thread Monte Milanuk
Have you looked at Rodeo (https://www.yhat.com/products/rodeo)? The UI looks a *lot* like R-Studio (for a reason)... ___ Tutor maillist - Tutor@python.org To unsubscribe or change subscription options: https://mail.python.org/mailman/listinfo/tutor

Re: [Tutor] Is this possible for a newbie?

2014-07-20 Thread Monte Milanuk
On 2014-07-21, Steven D'Aprano wrote: > On Sun, Jul 20, 2014 at 04:57:24PM -0400, keith papa wrote: > >> Am a newbie to programming and I started learning python days ago. I > > This sounds more like something for a database than for Python itself. > > You can write Python code to talk to the dat

Re: [Tutor] New Re: Clearing Python text

2012-12-14 Thread Monte Milanuk
On 12/14/2012 07:25 AM, Waters, Mike [ITSCA Non-J&J] wrote: Hi Tutor, I am using Win 7 ,Python 2.7. Interpreter. To state my challenge : When I have filled a page with values and text until it reaches the bottom of the screen, how can I highlight this and remove to allow further entries? I have

Re: [Tutor] data analysis with python

2012-11-16 Thread Monte Milanuk
Hello David, I know you said you settled on R... but just in case you are still interested in possible Python options, I think this book might well cover about everything you were looking for using numpy, scipy and pandas. Python for Data Analysis http://shop.oreilly.com/product/0636920023784.do

Re: [Tutor] CSV -> sqlite tables with foreign keys

2012-10-17 Thread Monte Milanuk
Thanks for the help! Not sure why I assumed that csv.reader was returning row as a tuple instead of a list... that makes that part easier ;) As for the 'INSTEAD OF' trigger on a VIEW... that *does* look pretty handy. I was trying to remember why I hadn't heard of that before, or why I hadn't loo

[Tutor] CSV -> sqlite tables with foreign keys

2012-10-16 Thread Monte Milanuk
Hello, I'm working on a python script to take the sql script, create a sqlite3 database, create the tables, and then populate them using the info from the csv file. The sticking point seems to be creating the foreign keys between the tables I've got a data file with lines like this: "John","G.",

Re: [Tutor] newbie Questions

2012-07-16 Thread Monte Milanuk
Probably the single biggest 'problem' with Python for web development, in my opinion, is that while a lot of web hosts have all sorts of PHP templates or frameworks installed and ready for easy deployment... Python options seem to be a bit sparser. Individual hosts may vary, but thats the overall

Re: [Tutor] insert queries into related tables referencing foreign keys using python

2011-12-25 Thread Monte Milanuk
On 12/24/2011 11:13 PM, Lie Ryan wrote: Querying .lastrowid is pretty much safe as long as you don't use a single cursor from multiple threads. The .lastrowid attribute belongs to a cursor, so write operations from one cursor would not affect the .lastrowid of other cursors. However, note that

Re: [Tutor] insert queries into related tables referencing foreign keys using python

2011-12-24 Thread Monte Milanuk
Lie Ryan gmail.com> writes: > In python-sqlite, the rowid of the > last insert operation can be queried using cursor.lastrowid. Therefore, > you can query the lastrowid, right after the insert, to find the primary > key of the value you had just inserted. So, in code: > > ... > cur = conn.exe

[Tutor] insert queries into related tables referencing foreign keys using python

2011-12-23 Thread Monte Milanuk
So... most python-sqlite tutorials concentrate on single tables. The few that deal with multiple tables and that mention foreign keys and such seem to demonstrate mainly using hard-coded data instead of parameterized insert queries into tables with auto-increment primary keys. For the most part I

Re: [Tutor] sqlite3: turning on foreign key support thru python

2011-12-16 Thread Monte Milanuk
That helped immensely... I was trying some different things trying to get at the results, but it never occurred to me to try iterating over it. The bit about some objects being iterable and some not is good to know! Thanks, Monte On Fri, Dec 16, 2011 at 11:43 AM, Modulok wrote: > >> How do I

[Tutor] sqlite3: turning on foreign key support thru python

2011-12-16 Thread Monte Milanuk
I'm setting up an sqlite3 database to use as a base for some programming stuff I want to work on. Currently using python 2.7, which appears to have a new enough version of sqlite (just barely) to support foreign keys. As I understand things, sqlite by default has foreign keys turned off, unless s

[Tutor] Functional tutorial covering SQL database + GUI interface

2011-11-28 Thread Monte Milanuk
Hello all, Thought I might ask here just to make sure my Google-fu isn't on the fritz and I'm not missing something already existing... Is there / do you know of any tutorial that covers actually using an SQL database with a GUI interface (say, sqlite and tkinter since they come packaged with

Re: [Tutor] printing in python 3.x

2010-12-04 Thread Monte Milanuk
Alan, Perhaps this is a silly question (and possibly not strictly python-related) but I was under the impression that controlling exactly layout via html was kind of difficult and somewhat fragile. The latter perhaps less so as one could make some fairly concrete assumptions about the paper

Re: [Tutor] Handling 'None' (null) values when processing sqlite cursorresults

2010-07-14 Thread Monte Milanuk
On 7/14/10 5:32 AM, Alan Gauld wrote: The key principle is do not try to store your data in a display format. Never was my intention. I just hadn't anticipated needing to write my own function to handle something as (I would think) common as a NULL value in a database field. I had been wo

[Tutor] Handling 'None' (null) values when processing sqlite cursor results

2010-07-13 Thread Monte Milanuk
Hello all, I'm struggling a bit trying to find the right way to deal with null values in my sqlite database when querying it and processing the results in python. If my cursor.fetchall() results return the following: (104, None, u'Sylvester', None, u'Evans', None, u'527-9210 Proin Av.', u'L

Re: [Tutor] Extract from file

2010-06-09 Thread Monte Milanuk
Dave Kuhlman rexx.com> writes: > > Monte gave you a good suggestion *if* you are sure that there is no > quoting and, especially, if you are sure that there are no commas > inside of quotes in your input data. > > However, it seems that you are dealing with a CSV (comma separated > values) fil

Re: [Tutor] Extract from file

2010-06-08 Thread Monte Milanuk
On 6/8/10 5:44 PM, Manju wrote: Hi, I need help with extracting information from file. I have a file which is a comma delimited text file containing separate line for each booking. Each line is composed of date, room number, course number and course day. Course day??? Not sure what you meant

[Tutor] raising number to a power

2010-02-25 Thread Monte Milanuk
Is there a benefit (besides brevity) one way or the other between using: import math ... math.pow(x,y) # x raised to the power y vs. x**y ? Thanks, Monte ___ Tutor maillist - Tutor@python.org To unsubscribe or change subscription options: http://

Re: [Tutor] Using Python with a Mac

2010-02-21 Thread Monte Milanuk
On Sun, Feb 21, 2010 at 10:36 PM, Marco Rompré wrote: > Hi everyone, I would like to know how to use python with a mac. > > For now, I go to spotlight, open terminal then type IDLE and a window pops > up but its like the window that opens when you run your programs already > saved and I'm not able

[Tutor] clear screen inside python interpreter

2009-08-06 Thread Monte Milanuk
Okay, simple question: is there anything similar to to 'clear' or 'cls' to clean up a console window full of commands in the python shell? Short of exiting and restarting the interpreter I'm not having a lot of luck here. Thanks, Monte ___ Tutor mailli

Re: [Tutor] string.join()

2008-11-03 Thread Monte Milanuk
Thanks for the verification, folks. What had me stumped for a while was the first method was string.join(words[,sep]), and the new one showed str.join(words)... it wasn't immediately obvious (to me) that 'str' was in this case supposed to be the separator. Thanks again, Monte

[Tutor] string.join()

2008-11-03 Thread Monte Milanuk
Hello again, Just looking for clarification on a point: the book I'm using is written around Python v.2.3, and has an exercise using string.join(). Specifically, it said to use string.join(msgList, ""), the object of which was to take the list items in msgList and concatenate them using a bla

Re: [Tutor] Need help w/ a for loop

2008-10-24 Thread Monte Milanuk
Hello again, and thanks to all of you who extended your help! Wayne, Thanks for your examples. They did end up helping in with finding a pattern to do the odd numbers with. Maybe I'm not clever enough, but I didn't see how either example could be used for doing the addition/subtraction determ

[Tutor] Need help w/ a for loop

2008-10-23 Thread Monte Milanuk
Hello all, New guy here, so go easy on me ;) I'm starting to work my way through Python Programming by Zelle, and have hit a bit of a wall on one of the programming exercises in Chapter 3 (#15 if anyone has the book handy). What the question ask is: Write a program that approimates the valu