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

Re: [Tutor] Iteration issues
by Albert-Jan Roskam June 7, 2018

June 7, 2018

Verzonden vanaf mijn Samsung Galaxy-smartphone. -------- Oorspronkelijk bericht -------- Van: boB Stepp <robertvstepp(a)gmail.com> Datum: 10-05-18 21:53 (GMT+08:00) Aan: tutor <tutor(a)python.org> Onderwerp: Re: [Tutor] Iteration issues On Wed, May 9, 2018 at 6:27 PM, Roger Lea Scherer <rls4jc(a)gmail.com> wrote: > Hello, again. > > I want to count words in a text file. If a word repeats I want to increase > the count by 1; if the word is new to the dictionary, I want to add the > word to the dictionary. Everything works like I would like and expect, > except for it only adds the last word of each line to the dictionary. What > am I missing? > > import string > > file_name = 'oxford.txt' > wordset = {} > with open(file_name, 'r') as f: > for line in f: > sentence = line.strip() > sentence = sentence.strip(string.punctuation) > print(sentence) > sentence = sentence.lower() > word_list = sentence.strip() > word_list = word_list.split(' ') > > for i in range(len(word_list)): > word_list[i] = word_list[i].strip(string.punctuation) I was wondering if you might want to write a small function so that you can remove all punctuation symbols from each line in one fell swoop? Something like (in pseudocode): Iterate over string.punctuation. If a punctuation symbol is in your string: Replace that symbol with an empty string. =>>> maybe something like import re no_interpunction = re.sub("[%s]" % re.escape(string.punctuation), '', sentence)

6 6

(no subject)
by erich callahana June 1, 2018

June 1, 2018

I’m not sure how to access this window

2 1

Prealgebra via Python programmin
by Sergio Rojas May 31, 2018

May 31, 2018

Hello folks, Released under the Creative Commons Attribution-NonCommercial 4.0 International License [1]http://creativecommons.org/licenses/by-nc/4.0/ Prealgebra via Python programming is available at: [2]https://www.researchgate.net/publication/325473565 In case you find yourself in the mood to collaborate to improve the readability and/or enhance/enrich the content of the book, feel free to contact me at the above email address. Sergio -- Enhance your [3]#MachineLearning and [4]#BigData skills via [5]#Python and [6]#SciPy 1. [7]https://www.packtpub.com/big-data-and-business-intelligence/numerical-and… <br> 2. [8]https://www.packtpub.com/big-data-and-business-intelligence/learning-scip… <br> 3. Python book en Castellano (distribucion gratuita): [9]https://www.researchgate.net/publication/301293668 References Visible links 1. http://creativecommons.org/licenses/by-nc/4.0/ 2. https://www.researchgate.net/publication/325473565 3. https://twitter.com/hashtag/machinelearning 4. https://twitter.com/hashtag/bigdata 5. https://twitter.com/hashtag/python 6. https://twitter.com/hashtag/scipy 7. https://www.packtpub.com/big-data-and-business-intelligence/numerical-and-s… 8. https://www.packtpub.com/big-data-and-business-intelligence/learning-scipy-… 9. https://www.researchgate.net/publication/301293668

1 0

i really need help
by erich callahana May 30, 2018

May 30, 2018

I need to know how to access the window where in the menu at the top it says run and that’s where I can test my script, basically I have no idea how to test my script Thankyou Kind Regards Erich.C

4 3

Tkinter widget (label) updated by TCP/IP message
by Alejandro Chirife May 28, 2018

May 28, 2018

Hi all, I am having a hard time to create what at first looked like a simple program with Python 3 and Tkinter: The UI consist of a window with a label and a button. The label shows "waiting for a message" and the button shows "reset display". The handler for the button click just resets the label text to "waiting for a message". The program would draw the window with the two widgets with root.mainloop() while it is capable of listening on a TCP port for an arriving message like "hello world", and when it arrives it would show the text in the label. The received message should show in the label until any of the following occurs: - Has been shown for 10 seconds- Another packet arrived with new message (will show the new message in the label)- User clicks on the "reset display" button I will really appreciate if someone could give me some guidance on how to manage this with Python 3. Thanks!AC

3 4

Storing passwords and version control
by Pat Martin May 27, 2018

May 27, 2018

Hello all, I am writing a script that will be using an API to connect to some systems to pull info for a search. Since it will be a script I will be running through cron I won't be able to type the password at time of running. I also am going to be putting this in source control, using git specifically. The process I am currently thinking of using is having a separate file with the username and password in it and just having that ignored by source control. That of course doesn't solve the problem of the password sitting in a file on the system unencrypted. Is there a better or more accepted way to do this in python? Thanks

6 5

get key value from Redis instance
by Silviu Chiric May 27, 2018

May 27, 2018

Dear all I need to get the value of given key from Redis, or both key and value, the below code snippet fails always, even the connection is okay StrictRedis<ConnectionPool<Connection<host= redis-15838.c44.us-east-1-2.ec2.cloud.redislabs.com,port=15838,db=0>>> Connected! My code import redis try: conn = redis.StrictRedis( host=' redis-15838.c44.us-east-1-2.ec2.cloud.redislabs.com', port=15838, password='DavidLavinia2') print (conn) conn.ping() print ('Connected!') print 'Set Record:', conn.set("best_car_ever", "Tesla Model S") print 'Get Record:', conn.get("best_car_ever") print 'Delete Record:', conn.delete("best_car_ever") print 'Get Deleted Record:', conn.get("best_car_ever") except Exception as ex: print ('Error:', ex) exit('Failed to connect, terminating.') Thanks!

4 6

Problem importing pandas library
by Bhavna Soni May 27, 2018

May 27, 2018

I installed pandas library using pip9. I get errors while importing it, Uninstalling and Re-installing won't help. It says DLL load failed as window file is not found. The next time I import it says pandas don't have core attribute, ut core folder is present in the directory. I am using Python 3.6 and Windows 10. How to remove this error? -- Bhavna Soni Electronics and Telecommunications National Institute of Technology, Raipur

3 2

Nested use of replication operator on lists
by boB Stepp May 25, 2018

May 25, 2018

On Python-list Steve started a thread, "List replication operator" (https://mail.python.org/pipermail/python-list/2018-May/733513.html) and wrote the following: <quote> Python has a sequence replication operator: py> [1, 2]*3 [1, 2, 1, 2, 1, 2] Unfortunately, it is prone to a common "gotcha": py> x = [[]]*5 # make a multi-dimensional list py> x [[], [], [], [], []] py> x[0].append(1) py> x [[1], [1], [1], [1], [1]] The reason for this behaviour is that * does not copy the original list's items, it simply replicates the references to the items. So we end up with a new list containing five references to the same inner list. </quote> I am having trouble correlating the behavior of the one-dimensional case with the two-dimensional case. The result of [1, 2]*3 seems to be an actual list, not a replication of the references to the items in the original list, [1, 2]. Or if it is, then I do not know how to demonstrate it. Also the "replication operator" does not seem to be replicating anything list-wise if it is instead replicating references to the original list's members. I request explanation/clarification please. -- boB

3 4