🌐 Mailman 3 January 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

Updates to web tutor
by Alan Gauld Feb. 2, 2018

Feb. 2, 2018

Only just on topic but i'd like some help please... I've been doing some much needed maintenance to my web tutor. In particular I'm trying to move it from the (web)stone age of HTML3 and Frames to HTML5/CSS and provide a responsive/reactive design. Along the way I've also completely changed the styling to give it a more modern appearance(*). I'm now at the stage where some independent feedback would be useful so if anyone feels like trying out the new design I'd appreciate any feedback - especially on how it works on mobile devices of the Apple variety. The test site is: http://www.alan-g.me.uk/l2p2/ I've done the first 2 sections - up to the Error Handling topic. PS: There is very little changed in the actual content so far - just a few typos fixed and a couple of extra explanatory paragraphs I've been meaning to add for a while. Its really the web design that I'm working on just now. (*)The TOC will eventually be restyled to a block menu look but is just boring hyperlinks for now. Any feedback is appreciated. -- Alan G Author of the Learn to Program web site http://www.alan-g.me.uk/ http://www.amazon.com/author/alan_gauld Follow my photo-blog on Flickr at: http://www.flickr.com/photos/alangauldphotos

1 4

unable to locate python on mac
by Megan Zirger Feb. 1, 2018

Feb. 1, 2018

Hi there, I am completely new to python and trying to learn how to set up and get going. The one problem is that I’ve supposedly downloaded the new version. When I run it in the terminal I see that I have the version but I can’t find it anywhere in the applications or anywhere on my computer as to make modifications and be able to work with sublime text. Your help is appreciated. Thank you, Megan

5 5

python gui Tkinter
by mamatha n Jan. 31, 2018

Jan. 31, 2018

please any one give me the code for username (entryfld)----- pwrd (entryfld)---- login(button), changepwrd(button) virtualkeyboard-----user has to be use dis keyboard once click on login button regester page open register page content 1.emply name(entryfld) 2.emply id(entryfld), 3.mbil no(entryfld), 4. RFID(entryfld) , 5.back (button), 6.clearbtn(button), 7. ok(button) next user want to clear employee details click on clear button1. employee id text feild shd open click on ok employee id should be removed please i need this code immediatly any one tell me please.

4 3

Python GUI Grid like view with checkboxes in first column
by Dragan Mestrovik Jan. 29, 2018

Jan. 29, 2018

Hi, I need some suggestions/help in showing large amount of data in grid like view with first column having checkboxes. Please see the image attached. How can i achieve this in Python GUI? [image: Inline image 1]http://oi39.tinypic.com/28vq6wn.jpg

2 1

Fwd: Need help with reading and cleaning CSV files for a class
by Geoff Hancock Jan. 29, 2018

Jan. 29, 2018

Good day- I'm in a difficult situation. I have been asked to help teach students how to clean up a CSV file in Python. The job has fallen to me because the teacher of the course is out on emergency leave and I just found out. Tomorrow I have to show students how to get a CSV file and write code to clean and parse it. I understand the process--BUT I don't know how to do it! What I'm looking for is a simple Step 1 Step 2 Step 3 etc I'm running the latest version of Python and am running on Windows Can anyone assist? Much appreciate the time JGH

4 3

doubt in a program
by vinod bhaskaran Jan. 29, 2018

Jan. 29, 2018

Hi, I am a new beginner in programming. I saw a code (given below) to reverse string. newstring = '' oldstring = 'Newton' for char in oldstring: newstring = char + newstring print(newstring) Could someone explain how it is traversing to get the string reversed? As the new character is adding the char in the new string but how is it getting reversed without any line giving the char number to be traversed in reverse order. Thanks, Vinod

4 4

program not doing what I need it to do
by Edna Broukhim Jan. 29, 2018

Jan. 29, 2018

I have the following program. It needs to say the user's name, average and the letter grade of each user. I don't know how to fix it so it gives the average of all users. It only gives the average of the last user. user=int(input("How many students?")) Score1=[] Score2=[] Score3=[] name=[] for i in range (0, user): name.insert(user, input("What is your name?")) for i in range (0, user): ExamGrades=['exam1','exam2','exam3'] Score1.append(float(input(str(name[i])+ ":What is your score on your first exam?"))) Score2.append(float(input(str(name[i])+ ":What is your score on your second exam?"))) Score3.append(float(input(str(name[i])+ ":What is your score on your third exam?"))) def Average(): global average global grade for i in range (0, user): for j in range(len(Score1)): average=(Score1[j]+ Score2[j]+Score3[j])/3 if(average>=90): grade = "A" elif(average>=80 and average<90): grade="B" elif(average>=70 and average<80): grade="C" elif(average>=60 and average<70): grade="D" else: grade = "F" return average finalAverage=[] for i in range (0, user): finalAverage.append(Average()) print(name[i]+ ":Your average is: "+str(finalAverage[i])+ ", which is " + grade)

2 2

thinter: can't figure out how to update a window instead of creating a new on
by Chris Roy-Smith Jan. 28, 2018

Jan. 28, 2018

Hi, system: Python 3.6, LInux I have been playing around with the following code which I want to update the window, but I creates a new window (with the correct display), but I have not been able to find the solution. Perhaps I'm using the wrong key words in my searches. Thank you for any assistance, I'm hoping to learn something from this experience Regards, Chris Roy-Smith #!/usr/bin/python3 import mysql.connector from tkinter import * import pickle master = Tk() def getCfg(): fobj = open('members.pkl', 'rb') cfg = pickle.load(fobj) fobj.close() return cfg def editmember(page=1): form=Toplevel(master) form.title('test form') cfg=getCfg() QrySelectMembers='select ident, concat_ws(" " ,`given`, `surname`) as `fullname` from `details` where 1 order by `surname` asc, `given` asc limit '+str(page)+', 10' db=mysql.connector.connect(user = cfg['user'], password = cfg['password'], database = cfg['database']) cursor=db.cursor() cursor.execute(QrySelectMembers) #,(page)) MemberList=list(cursor) cursor.close() db.close ro=0 for Member in MemberList: ident=Member[0] msg='edit '+Member[1] Button(form, text=msg, command= lambda tmp=ident : EdForm(tmp)).grid(sticky=(W, E), row=ro, column=0) ro+=1 Button(form, text='exit', command=form.destroy).grid(row=ro+1, column=2) Button(form, text='next 10', command= lambda p=page+10 : editmember(p)).grid(row=ro, column=1) Button(form, text="previous 10", command= lambda p=page-10 : editmember(p)).grid(row=ro, column=0) Button(master, text='click to test', command=editmember).grid(row=0, column=0) Button(master, text='quit', command=master.destroy).grid(row=1, column=0) master.mainloop()

2 1

Do _all_ Python builtin methods/functions return "None" IF ...
by boB Stepp Jan. 27, 2018

Jan. 27, 2018

... they are not designed to explicitly return something else? The reason I ask is that I almost fell into the following trap: <GCE trap> py3: a_lst = [0, 1, 2] py3: b_lst = a_lst.append(3) py3: a_lst, b_lst ([0, 1, 2, 3], None) Instead of "None" I was expecting "[0, 1, 2, 3]". Obviously I have a GCE (Gross Conceptual Error). </GCE trap> I almost sent the above as my question, but then I realized (Finally!) that lst.append() performs an append operation on lst and returns None. Just like print() returns None. So my actual question is: For these types of methods/functions, is Python Both versions 2 and 3) consistent throughout and *always* returns None? TIA! -- boB

4 3