Re: [Tutor] Sam Kahraman Campus Middle School Advice

2018-04-27 Thread David Wolfe
Sam;

Were I you, I would look for a local MeetUp that deals with Python, attend
one of their meetings, and talk to one of the folks there.  I've learned a
lot from the MeetUp in my area, and there are Python experts in several
fields usually in attendance.  They'll be able to help you with your
questions and interview, as well as to give you pointers on next steps in
learning and proficiency.

Good Luck,
David

On Thu, Apr 26, 2018 at 4:00 PM, Kahraman, Sam K. <
skahra...@cherrycreekschools.org> wrote:

> Hello,
>
>  I am a 8th grade student at Campus Middle School. We have a project on
> coding and I need a expert to interview. Currently I'm learning Python and
> thought I should ask someone who works their to Interview. To contact me
> and ask any questions my email is skahra...@cherrycreekschools.org.
>
> ___
> Tutor maillist  -  Tutor@python.org
> To unsubscribe or change subscription options:
> https://mail.python.org/mailman/listinfo/tutor
>
___
Tutor maillist  -  Tutor@python.org
To unsubscribe or change subscription options:
https://mail.python.org/mailman/listinfo/tutor


[Tutor] Do you have any Ideas for a project.

2018-04-27 Thread Kahraman, Sam K.
Sorry Forgot to explain what my project is about. I chose to learn to code in 
30 hours in  a span of 10 weeks. I'm ok at coding so I was wondering if you had 
any suggests  for a project. I'm 14 and I'm ok at coding  but probably a 
beginner. If you could help me that would be great.

To contact me use my email, skahra...@cherrycreekschools.org
___
Tutor maillist  -  Tutor@python.org
To unsubscribe or change subscription options:
https://mail.python.org/mailman/listinfo/tutor


[Tutor] pandas read sql query advice

2018-04-27 Thread Glenn Schultz

All,

I have the following set-up (below) which will be used to call data from 
multiple sectors.  There is a sql query (transact sql) and connection.  This 
works fine.  However, I would like to parametrize the query so I can enter 
different sectors.  I have checked through pyodbc and several SO posts.  
However, I am stuck and cannot get the parametrized version to work.  Most 
examples I have found are either sqlite or postgres.

sql ="""select foo from mutable where model sector = 'mysector'"""
conn = myconn

def modeldata(modelquery, conn)
modeldata = pandas.read_sql_query(sql, conn)
return modeldata

Here is what I have tried (various combinations) - what am I doing wrong?

sql ="""select foo from mutable where model sector = ?""", [params]
conn = myconn

def modeldata(modelquery, conn, params)
modeldata = pandas.read_sql_query(sql, conn, params)
return modeldata

Thanks in advance,
Glenn
___
Tutor maillist  -  Tutor@python.org
To unsubscribe or change subscription options:
https://mail.python.org/mailman/listinfo/tutor