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

guess my number game (reversed)
by chiara pascucci Oct. 6, 2018

Oct. 6, 2018

Hello. I am very new to learning Python, and I would need some help with a little game I am trying to write. I am trying to write a game where the user is asked to think of a number from 1 to a 100, and the computer tries to guess it. Now, after every guess I would want the programme to ask whether its guess is right, too low, or too high, and then take another guess based on the user's input. The programme works fine if the it guesses the number right on its first try, but when the users inputs "too low" or "too high" an infinite loop is returned. I thinkI have done something wrong in my while loop and that my sentry variable is somehow wrong -but I can't seem to be able to fix it! Any help or commments would be very appreciated. Below is the code written so far Many thanks Chiara print("think of a number from 1 to 100") print("I will try and guess it!") import random number = random.randint(1,100) print(number) answer = input("is this right, too high, or too low?") while answer != "right": if answer == "too high": number2 = random.randint(1,number) print(number2) elif answer == "too low": number3 = random.randint(number,100) print(number3) print("I finally guessed your number. Thank you for playing") input("\n\nPress enter key to exit")

4 4

localhosting
by Roger Lea Scherer Sept. 6, 2018

Sept. 6, 2018

I'm trying to implement a local host. My instructions tell me to type the following command in the command line, make sure I'm in the "www" folder (which I am and not a subfolder, although there is a subfolder "cgi-bin") and then run this: python3 -m http.server --cgi 8000 I'm running Anaconda in Windows 10. I get an error: 'python3' is not recognized as an internal or external command, operable program or batch file. But this is the folder that I thought Python 3.6 was in. I tried Windows PowerShell and received this error message: python3 : The term 'python3' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again. So how do I correct this? I suspect python3 isn't in this folder. I know I have python3 because I run python3.6 shell practically every day. I've looked in the Program Files folder, came up empty as far as python is concerned, but I don't know where else to look? Or if this is not the correct forum, can you please (re)direct me to the correct one? Thank you. -- Roger Lea Scherer 623.255.7719 *Strengths:* Input, Strategic, Responsibility, Learner, Ideation

4 5

Problem compiling code from GitHub
by Dave Hill Sept. 2, 2018

Sept. 2, 2018

Hi, As a volunteer on a Welsh Heritage Railway I undertake their Electrical Equipment testing, for which I use a Megger PAT420. This device stores data in 'sqlite', which using Python I can read and generate a number of reports in 'csv' format. I now wish to collate asset data for various locations, and as I use OpenOffice I want to generate an 'ods' document with a 'sheet' for each location. At present I generate a 'csv' file for each location, but as there are 20 locations this is a bit cumbersome. I use the 20 locations as a method to make the handing of over 500 assets somewhat manageable. I have found 'odswriter' on GitHub https://github.com/mmulqueen/odswriter which appears to provide what I want. However, I have come to a halt, due to the limitation of my knowledge. I admit that I am confounded as to where/how to access this code. I am using Python 3.6.4, in IDLE on a PC running windows. I am using the following code as a starting point , Test_ODS#1.py import datetime import decimal ##import odswriter as ods try: from OdsWriter import odswriter as ods except RuntimeError: print("Error importing OdsWriter!") # Single sheet mode with ods.writer(open("test.ods","wb")) as odsfile: odsfile.writerow(["String", "ABCDEF123456", "123456"]) # Lose the 2L below if you want to run this example code on Python 3, Python 3 has no long type. odsfile.writerow(["Float", 1, 123, 123.123, decimal.Decimal("10.321")]) odsfile.writerow(["Date/DateTime", datetime.datetime.now(), datetime.date(1989, 11, 9)]) odsfile.writerow(["Time",datetime.time(13, 37),datetime.time(16, 17, 18)]) odsfile.writerow(["Bool", True, False, True]) odsfile.writerow(["Formula", 1, 2, 3, ods.Formula("IF(A1=2,B1,C1)")]) # Multiple sheet mode with ods.writer(open("test-multi.ods","wb")) as odsfile: bears = odsfile.new_sheet("Bears") bears.writerow(["American Black Bear", "Asiatic Black Bear", "Brown Bear", "Giant Panda", "Qinling Panda", "Sloth Bear", "Sun Bear", "Polar Bear", "Spectacled Bear"]) sloths = odsfile.new_sheet("Sloths") sloths.writerow(["Pygmy Three-Toed Sloth", "Maned Sloth", "Pale-Throated Sloth", "Brown-Throated Sloth", "Linneaeus's Two-Twoed Sloth", "Hoffman's Two-Toed Sloth"]) I get the following error Traceback (most recent call last): File "C:\Code\Python\ODS_Writer\Test_ODS#1.py", line 5, in <module> from OdsWriter import odswriter as ods File "C:\Code\Python\ODS_Writer\OdsWriter.py", line 7, in <module> from . import ods_components ImportError: attempted relative import with no known parent package I have put the code from GitHub in various locations subject to my limited knowledge of Python, but I have no idea what the following extract means, and searching online on & off for two days has proved unfruitful. from __future__ import unicode_literals from zipfile import ZipFile import decimal import datetime from xml.dom.minidom import parseString from . import ods_components from .formula import Formula I understand the use of 'import' and have written my own modules, but from . import ods_components has me floored. Thank you in advance for any help. Dave

5 6

SQL querying
by Rafael Knuth Aug. 30, 2018

Aug. 30, 2018

Can I do SQL querying in Python? What packages do I need for that purpose? (specifically for mySQL) Thanks.

4 3

OT: How to automate the setting of file permissions for all files in a collection of programs?
by boB Stepp Aug. 30, 2018

Aug. 30, 2018

At work I have accumulated a motley collection of programs I have written since I started around 2012. These all run on the Solaris OS. As long-time readers of my past ramblings may recall, I am not allowed to install any outside programs on this Solaris system, but I am allowed to write my own programs to my heart's content, using only whatever programming-related tools that happen to be installed on a rather bare-bones OS install. We have just recently completed upgrades on hardware, Solaris and treatment planning software. On the good news side we went from the vi editor to Vim/gVim; from Python 2.4 to 2.7; in addition to Tkinter there is now a Python interface to GTK; went from no SQLite to having it; and a few other goodies that currently slip my mind. But on the bad side the only version control system installed, SCCS (RIP!) went bye-bye with _nothing_ to replace it. And as usual the radiation therapy planning software we use was upgraded from version 9.10 to 16.2, breaking several of my programs, requiring updates on my part that I recently completed. So as to not lose the benefits of a version control system, I have installed Git on my windows PC. My current workflow now has gotten more complex, and I'm sure can be improved by those thinking more clearly than I (And surely more knowledgeable!), and is as follows: 1) Using CuteFTP copy all of my original working code (Now with problems due to the planning software upgrade.) to my windows PC. 2) Put this code under Git version control. 3) Create a development branch. 4) FTP this back to Solaris for code repair, testing, etc. BUT! This process has changed all of the Unix file permissions on what are (For me.) many files, some planning system proprietary scripting files, some Perl files, some shell script files and some Python files. So before I can do anything further I must go through all of these files and change their permissions to the values I need them to be. This is quite tedious and error prone. So I wish to either fix the process, or, failing that, automate the process of correcting the file permissions. If there is a way in this CuteFTP software to maintain file permissions in this back-and-forth transferring between a Windows and Solaris environment, I have yet to find it in the software's help (Though I have not yet had much time to invest in this search, so I may not have found it yet.). It occurs to me that in theory it should be possible to automate this either with a shell script or a Python program. Is there a standard way of handling this sort of thing? Bear in mind that if a typical solution would require the installation of a software package in the Solaris environment, I am not allowed to do so. I am not allowed to use Python pip either. Strange rules ... -- boB

3 4

A Python program to Summarise weather results?
by Matthew Polack Aug. 30, 2018

Aug. 30, 2018

Hi, We have a spreadsheet from a local weather station.....it summarises the amount of rainfall per day since 1863. http://www.bom.gov.au/jsp/ncc/cdio/weatherData/av?p_nccObsCode=136&p_displa… We'd love to be able to summarise this into years eg. Total rainfall of 1863, 1864 all the way through to 2018. Would Python be able to do this using the csv file? Thanks, Matt Matthew Polack | Teacher [image: Emailbanner3.png] Trinity Drive | PO Box 822 Horsham Victoria 3402 p. 03 5382 2529 m. 0402456854 e. matthew.polack(a)htlc.vic.edu.au w. www.htlc.vic.edu.au -- **Disclaimer: *Whilst every attempt has been made to ensure that material contained in this email is free from computer viruses or other defects, the attached files are provided, and may only be used, on the basis that the user assumes all responsibility for use of the material transmitted. This email is intended only for the use of the individual or entity named above and may contain information that is confidential and privileged. If you are not the intended recipient, please note that any dissemination, distribution or copying of this email is strictly prohibited. If you have received this email in error, please notify us immediately by return email or telephone +61 3 5382 2529** and destroy the original message.*

3 2

Contour Plots
by Tara 38 Aug. 29, 2018

Aug. 29, 2018

Hi, I wonder if someone can give me some advice? I need to build a contour plot (ideally with Seaborn) in python. The plot would document text data. I cannot work out how I need to convert the data file (currently csv file) so that I have 3 variables that I can then plot as a contour map and visualize in Seaborn. Really stuck as to where to even start. Thanks, Tara [https://ipmcdn.avast.com/images/icons/icon-envelope-tick-green-avg-v1.png]<http://www.avg.com/email-signature?utm_medium=email&utm_source=link&utm_cam…> Virus-free. www.avg.com<http://www.avg.com/email-signature?utm_medium=email&utm_source=link&utm_cam…>

2 1

need help generating table of contents
by Albert-Jan Roskam Aug. 28, 2018

Aug. 28, 2018

Hello, I have Ghostscript files with a table of contents (toc) and I would like to use this info to generate a human-readable toc. The problem is: I can't get the (nested) hierarchy right. import re toc = """\ [ /PageMode /UseOutlines /Page 1 /View [/XYZ null null 0] /DOCVIEW pdfmark [ /Title (Title page) /Page 1 /View [/XYZ null null 0] /OUT pdfmark [ /Title (Document information) /Page 2 /View [/XYZ null null 0] /OUT pdfmark [ /Title (Blah) /Page 3 /View [/XYZ null null 0] /OUT pdfmark [ /Title (Appendix) /Page 16 /Count 4 /View [/XYZ null null 0] /OUT pdfmark [ /Title (Sub1) /Page 17 /Count 4 /OUT pdfmark [ /Title (Subsub1) /Page 17 /OUT pdfmark [ /Title (Subsub2) /Page 18 /OUT pdfmark [ /Title (Subsub3) /Page 29 /OUT pdfmark [ /Title (Subsub4) /Page 37 /OUT pdfmark [ /Title (Sub2) /Page 40 /OUT pdfmark [ /Title (Sub3) /Page 49 /OUT pdfmark [ /Title (Sub4) /Page 56 /OUT pdfmark """ print('\r\n** Table of contents\r\n') pattern = '/Title \((.+?)\).+?/Page ([0-9]+)(?:\s+/Count ([0-9]+))?' indent = 0 start = True for title, page, count in re.findall(pattern, toc, re.DOTALL): title = (indent * ' ') + title count = int(count or 0) print(title.ljust(79, ".") + page.zfill(2)) if count: count -= 1 start = True if count and start: indent += 2 start = False if not count and not start: indent -= 2 start = True This generates the following TOC, with subsub2 to subsub4 dedented one level too much: ** Table of contents Title page.....................................................................01 Document information...........................................................02 Blah...........................................................................03 Appendix.......................................................................16 Sub1.........................................................................17 Subsub1....................................................................17 Subsub2......................................................................18 Subsub3......................................................................29 Subsub4......................................................................37 Sub2.........................................................................40 Sub3.........................................................................49 Sub4.........................................................................56 What is the best approach to do this? Thanks in advance! Albert-Jan

3 5

How to have unique identifiers for multiple object instances of a given class?
by boB Stepp Aug. 28, 2018

Aug. 28, 2018

Python 3.6.6, Linux Mint I feel that I may be missing something truly obvious. I am pondering the design of a solitaire scorekeeper program. It is just meant to be an electronic scorekeeper for hands of solitaire that I plan with a "real" deck of cards, instead of a computer game. I might want to play and track a variety of solitaire games. And I might want to play one game for a bit and then switch to another. One version of solitaire I might play has thirteen possible separately scored versions, depending on which of thirteen cards gets turned up in the beginning (2, 3, 4, ... , J, Q, K, A). So each hand played needs to be scored under its own card. I would need to be able to switch back and forth between all thirteen at need to enter a score for a hand. So no matter what solitaire game I am playing it seems that it would boil down to: class SolitaireGame(): def __init__(self, name): self.name = name <The rest of the class to be determined.> Say I go with the aforementioned game with 13 separate scores to keep track of. The names of these games might be "Two_Mastery", "Three_Mastery", ... , "Ace_Mastery". In principle I want 13 objects with each one keeping track of each of the above games. Then I might want to switch to "Spider_Solitaire", keep track of its score, then go to something else, then back to Mastery, etc. How on earth am I to generate unique identifiers for each of these SolitaireGame objects in a rational way, not knowing in advance moment to moment what type of solitaire game I might be playing? I am *not* wanting to discard one object prior to creating a new one for a new game. I would like to have all such objects to peacefully coexist and be able to switch between them at will. Of course the intent is to persistently store these objects on disk upon program closure. TIA! -- boB

4 8