🌐 Mailman 3 April 2018 - Tutor - python.org

Scripting Calligra sheets with Python
by Jim Byrnes Jan. 31, 2022

Jan. 31, 2022

I am trying to script Calligra Sheets (formerly KSpread) with python. I have gotten some of the included example scripts to run so I know python scripting is running. I found the following snippet on their website: import KSpread sheet = KSpread.view().sheet() # swap text of B5 and C6 t1 = sheet.text("B5") t2 = sheet.text(6,3) sheet.setText("B5", t2) sheet.setText(6, 3, t1) # swap value of D7 and E8 v1 = sheet.value("D7") v2 = sheet.value(8,5) sheet.setValue("D7", v2) sheet.setValue(8, 5, v1) Error: 'str' object has no attribute 'text' File "file:///usr/share/kde4/apps/sheets/scripts/extensions/myswap.py", line 4, in <module> This error message appeared in a dialog box. I've taught myself some Python but I don't understand what is happening here. Shouldn't t1 be a sheet object? What would cause it to be a str instead? Thanks, Jim

5 8

updating stock list
by Shannon Evans May 1, 2018

May 1, 2018

Hi, i'm wanting to update the stock list at the end so that the fruit that's given is taken subtracted from the original stock list. The code i've written isn't updating it it's just staying the same. Any idea what i can do to fix this? import json stock_json= json.load(open("stock.json")) queue_json= json.load(open("queue.json")) queue=[ ["James Bruce", "Bananas"], ["Katherine Newton", "Bananas"], ["Deborah Garcia", "Pears"], ["Marguerite Kozlowski", "Pineapples"], ["Kenneth Fitzgerald", "Pineapples"], ["Ronald Crawford", "Bananas"], ["Donald Haar", "Apples"], ["Al Whittenberg", "Bananas"], ["Max Bergevin", "Bananas"], ["Carlos Doby", "Pears"], ["Barry Hayes", "Pineapples"], ["Donald Haar", "Bananas"] ] stock={ "Apples": 14, "Bananas": 14, "Pineapples": 0, "Pears": 8 } for i in queue: if stock[i[1]]>0: print("Gave {} to {}".format(i[1],i[0])) else: print("Could not give {} to {}".format(i[1],i[0])) def total_stock(fruit): total=0 for i in fruit: if stock[i]>0: stock[i]=stock[i]-1 return total print stock

3 2

Matplotlib scatterplot help
by Daniel Bosah April 30, 2018

April 30, 2018

I have a function in which returns scatterplot of a Isomap <https://en.wikipedia.org/wiki/Isomap>function, which takes output from a TF-IDF <https://en.wikipedia.org/wiki/Tf%E2%80%93idf> function, which calculated TF-IDF values of certain articles online. I used four articles and I want to show the 4 articles by a 3D scatterplot. Below is the function to turn my Isomap values to a 3D scatterplot : def Isomap(tfidf): jon = pd.read_csv(tfidf) le = preprocessing.LabelEncoder() tims = jon.apply(le.fit_transform) iso = manifold.Isomap(n_neighbors=2, n_components=3) john = iso.fit_transform(tims) fig = plt.figure() ax = fig.add_subplot(111, projection='3d') use_colors = 'rybg' ax.scatter(john[:,0], john[:,1],john[:,2],color=use_colors,alpha=.5) # x,y,z coord. jon 1-3 plt.title('Isomap of candiates') plt.xlabel('x') plt.ylabel('y') plt.show() plt.savefig('isomap.png') The problem is that I usually only get one color returned. And even if I get the code to print out 4 colors, I'm not sure how to get those colors to correspond to the four web articles. Thanks for the help in advance.

2 1

Help with loops
by Shannon Evans April 30, 2018

April 30, 2018

Hi, is there any way that i can add a loop or iteration or something so that i dont have to write out every person who has fruit. This information is coming from the following json files: *queue.json* file [ ["James Bruce", "Bananas"], ["Katherine Newton", "Bananas"], ["Deborah Garcia", "Pears"], ["Marguerite Kozlowski", "Pineapples"], ["Kenneth Fitzgerald", "Pineapples"], ["Ronald Crawford", "Bananas"], ["Donald Haar", "Apples"], ["Al Whittenberg", "Bananas"], ["Max Bergevin", "Bananas"], ["Carlos Doby", "Pears"], ["Barry Hayes", "Pineapples"], ["Donald Haar", "Bananas"] ] *stock.json* file { "Apples": 14, "Bananas": 14, "Pineapples": 0, "Pears": 8 } This is what i've done so far: import json #Load the stock and queue files queue=json.load(open("queue.json")) stock=json.load(open("stock.json")) if (stock[queue[0][1]]>0): #in stock print "Gave Bananas to James Bruce" else: print "Could not give Bananas to James Bruce" if (stock[queue[1][1]]>0): #in stock print "Gave Bananas to "+ queue[1][0] else: print "Could not give Bananas to "+ queue[1][0] if (stock[queue[2][1]]>0): #in stock print "Gave Pears to "+ queue[2][0] else: print "Could not give Pears to "+ queue[2][0] if (stock[queue[3][1]]>0): #in stock print "Gave Pineapples to "+ queue[3][0] else: print "Could not give Pineapples to "+ queue[3][0] Thanks Shannon

3 2

Re: [Tutor] pandas read sql query advice
by Albert-Jan Roskam April 28, 2018

April 28, 2018

On Apr 28, 2018 06:54, Glenn Schultz <glennmschultz(a)me.com> wrote: > > 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 pandas.read_sql_query(sql, conn, params=params) The third positional arg is actually index_col, so you need to use a keyword arg. https://pandas.pydata.org/pandas-docs/stable/generated/pandas.read_sql_quer… BTW, I think you can use a context manager to automatically close the connection: with pyodbc.connect(your_conn_string) as conn: df = pd.read_sql_query(sql, conn, params=params)

1 0

pandas read sql query advice
by Glenn Schultz April 27, 2018

April 27, 2018

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

1 0

Sam Kahraman Campus Middle School Advice
by Kahraman, Sam K. April 26, 2018

April 26, 2018

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 skahraman(a)cherrycreekschools.org.

3 2

Need help with FileNotFoundError
by Jim April 26, 2018

April 26, 2018

Been working my way through an online Python course. Up until now I have had no problems writing and running the programs using Python 3.6 in a virtual environment and then pasting them into the courses editor. When I run this program on my system I get the following error. # file_io.py def copy(file, new_file): with open(file) as data: text = data.read() with open(new_file, 'w') as new_text: new_text.write(text) copy('~/Documents/Courses/ModernBootcamp/story.txt', '~/Documents/Courses/ModernBootcamp/story_copy.txt') (env36) jfb@jims-mint18 ~ $ python '/home/jfb/Documents/Courses/ModernBootcamp/file_io.py' Traceback (most recent call last): File "/home/jfb/Documents/Courses/ModernBootcamp/file_io.py", line 11, in <module> copy('~/Documents/Courses/ModernBootcamp/story.txt', '~/Documents/Courses/ModernBootcamp/story_copy.txt') File "/home/jfb/Documents/Courses/ModernBootcamp/file_io.py", line 4, in copy with open(file) as data: FileNotFoundError: [Errno 2] No such file or directory: '~/Documents/Courses/ModernBootcamp/story.txt' The file is there. jfb@jims-mint18 ~/Documents/Courses/ModernBootcamp $ ls adding_to_lists.py errors.py functionsII.py helpers.py modules.py stop_copying.py animals exercise.py functions.py iteration.py oop.py story.txt decorators.py file_io.py generators.py list_comps.py __pycache__ unlucky_numbers.py dictionarys.py FirstProgram guessing_game.py list_methods.py smiley_faces.py while_loop.py I must be doing something wrong path-wise, but I can't seem to figure it out. Any help appreciated. Regards, Jim

2 2

Do you have any Ideas for a project.
by Kahraman, Sam K. April 26, 2018

April 26, 2018

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, skahraman(a)cherrycreekschools.org

1 0

Dict of Dict with lists
by Kai Bojens April 26, 2018

April 26, 2018

Hello everybody, I'm coming from a Perl background and try to parse some Exim Logfiles into a data structure of dictionaries. The regex and geoip part works fine and I'd like to save the email adress, the countries (from logins) and the count of logins. The structure I'd like to have: result = { 'foo(a)bar.de': { 'Countries': [DE,DK,UK] 'IP': ['192.168.1.1','172.10.10.10'] 'Count': [12] } 'bar(a)foo.de': { 'Countries': [DE,SE,US] 'IP': ['192.168.1.2','172.10.10.11'] 'Count': [23] } } I don't have a problem when I do these three seperately like this with a one dimensonial dict (snippet): result = defaultdict(list) with open('/var/log/exim4/mainlog',encoding="latin-1") as logfile: for line in logfile: result = pattern.search(line) if (result): login_ip = result.group("login_ip") login_auth = result.group("login_auth") response = reader.city(login_ip) login_country = response.country.iso_code if login_auth in result and login_country in result[login_auth]: continue else: result[login_auth].append(login_country) else: continue This checks if the login_country exists within the list of the specific login_auth key, adds them if they don't exist and gives me the results I want. This also works for the ip addresses and the number of logins without any problems. As I don't want to repeat these loops three times with three different data structures I'd like to do this in one step. There are two main problems I don't understand right now: 1. How do I check if a value exists within a list which is the value of a key which is again a value of a key in my understanding exists? What I like to do: if login_auth in result and (login_country in result[login_auth][Countries]) continue This obviously does not work and I am not quite sure how to address the values of 'Countries' in the right way. I'd like to check 'Key1:Key2:List' and don't know how to address this 2. How do I append new values to these lists within the nested dict?

4 7