🌐 Mailman 3 February 2020 - Tutor - python.org

Scripting Calligra sheets with Python
by Jim Byrnes Feb. 1, 2022

Feb. 1, 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

overlapping tuples
by Narasimharao Nelluri March 7, 2020

March 7, 2020

Hi I got stuck at below problem for couple of days, can you guys help tp solve this problem. i need find overlapping tuples for various list of tuples, my current solution doest solve all the cases. I am failing at last input list3 . please check below #!/usr/bin/env python3 def tuple_overlap(old_list,overlap = None): old_list.sort() if overlap is None: overlap = [] for fir,sec in zip(old_list,old_list[1:]): if fir[1] >= sec[0] and fir[1] <=sec[1]: overlap.append(fir) if sec[0] >= fir[0] and sec[1] <= fir[1]: overlap.append(sec) overlap = sorted(overlap) print(overlap) list1 = [(1,10),(15,20),(101,110)] tuple_overlap(list1) list2 = [(1,20),(15,20),(101,110)] tuple_overlap(list2) list3 = [(1,10),(15,20),(1,10),(1,10),(101,110)] tuple_overlap(list3) NNELLURI-M-L13P:google_class nnelluri$ ./overlap.py [] [(1, 20), (15, 20)] [(1, 10), (1, 10), (1, 10), (1, 10)] NNELLURI-M-L13P:google_class nnelluri$

6 15

Pay-at-Pump Use Case - Tkinter GUI
by Jon Davies March 3, 2020

March 3, 2020

Hi all, I'm completely new to programming, Python and the like. I've researched various modules and frameworks, and am beginning to feel overwhelmed with the hundreds of ways in which to create a (hopefully) basic functioning application. In short, my aim is to create a GUI app that mimics a Pay-At-Pump software application which navigates multiple screens depending on options selected, following a simple flow e.g. Select Language > Select Payment Method > Insert Card > Select Currency > Begin Fuelling > Fuelling In Progress > Total and Goodbye. Semantics wise, I'd love to be able to make it look fantastic, but for now, I want to make sure I can develop something that works. Ideally, this is being built to deploy onto a Raspberry Pi, as I was planning to (hopefully) use a touchscreen to provide input to the GUI, and a breadboard with a push button to provide the input (simulate a fuel pump) – however, this is not a priority as such! I’ve been following some video tutorials and other online resources to get to a stage where I have created a VERY basic GUI which can navigate through multiple pages based on clicking a button, however I need to enhance this with some of the other features. The key parts of functionality for me concern the language translation of the entire app, and the calculation of fuel price based on an input multiplied by a set of currency exchange rates (depending on which is selected). For translation, I am struggling to find the right way in which to present the rest of the app in a different language, based on the button pressed on the first frame. Having googled, there were a couple of different solutions but I couldn’t seem to apply them to my code. My baseline code is below: class Oleum(tk.Tk): def __init__(self, *args, **kwargs): # tk.Tk.__init__(self, *args, **kwargs) container = tk.Frame(self) container.pack(side="top", fill="both", expand = True) container.grid_rowconfigure(0, weight=1) container.grid_columnconfigure(0, weight=1) self.frames = {} for F in (SelectLanguagePage, SelectPaymentPage, InsertCardPage, SelectCurrencyPage, BeginFuellingPage, FuellingInProgressPage, TotalGoodbyePage): frame = F(container, self) self.frames[F] = frame frame.grid(row=0, column = 0, sticky = "nsew") self.show_frame(SelectLanguagePage) def show_frame(self, cont): frame = self.frames[cont] frame.tkraise() I tried to create lists containing the string input for every single label and button for each frame. At the moment, I have put prompt labels on the first frame (SelectLanguagePage) in all languages with a button to select each respective language. #LANGUAGE DICTIONARY - 17 ITEMS TOTAL ENGLISH = ['WELCOME!', 'SELECT YOUR LANGUAGE', 'SELECT PAYMENT METHOD', 'PAY-AT-PUMP', 'PAY-AT-KIOSK', 'PLEASE INSERT CARD', 'PLEASE SELECT CURRENCY', '£ GBP', '$ USD', '€ EUR', 'BEGIN FUELLING', 'TOTAL FUEL', 'TOTAL COST', 'FUELLING IN PROGRESS', 'FINISH', 'THANK YOU, GOODBYE'] GERMAN = ['DAS WILLKOMMEN!', 'WÄHLE DEINE SPRACHE', 'ZAHLUNG AUSWÄHLEN METHODE', 'PAY-AT-PUMP', 'PAY-AT-KIOSK', 'BITTE KARTE EINFÜGEN', 'BITTE WÄHLEN SIE IHRE WÄHRUNG', '£ GBP', '$ USD', '€ EUR', 'TANKEN BEGINNEN', 'GESAMTKRAFTSTOFF', 'GESAMTKOSTEN', 'TREIBEN IM FORTSCHRITT', 'FERTIG', 'DANKE. AUF WIEDERSEHEN'] SPANISH = ['¡BIENVENIDA!', 'ELIGE TU IDIOMA', 'SELECCIONAR PAGO MÉTODO', 'PAGO EN BOMBA', 'PAGO EN EL KIOSCO', 'INSERTE LA TARJETA', 'POR FAVOR SELECCIONE SU MONEDA', '£ GBP', '$ USD', '€ EUR', 'COMENZAR COMBUSTIBLE', 'COMBUSTIBLE TOTAL', 'COSTE TOTAL', 'COMBUSTIBLE EN PROGRESO', 'TERMINAR', 'GRACIAS, ADIOS'] FRENCH = ['BIENVENUE!', 'CHOISISSEZ VOTRE LANGUE', 'CHOISIR LE PAIEMENT MÉTHODE', 'PAYER À LA POMPE', 'PAYER AU KIOSQUE', 'VEUILLEZ INSÉRER LA CARTE', 'VEUILLEZ SÉLECTIONNER VOTRE MONNAIE', '£ GBP', '$ USD', '€ EUR', 'COMMENCER LE CARBURANT', 'CARBURANT TOTAL', 'COÛT TOTAL', 'RAVITAILLEMENT EN COURS', 'TERMINER', 'MERCI, AU REVOIR'] class SelectLanguagePage(tk.Frame): def __init__(self, parent, controller): tk.Frame.__init__(self, parent) EN_lang_prompt = tk.Label(self, text = "PLEASE SELECT LANGUAGE", font = LARGE_FONT) #tk.Label is the class, the object is label EN_lang_prompt.pack(pady = 10, padx = 10) DE_lang_prompt = tk.Label(self, text = "WÄHLE DEINE SPRACHE", font = LARGE_FONT) DE_lang_prompt.pack(pady = 10, padx = 10) ES_lang_prompt = tk.Label(self, text = "ELIGE TU IDIOMA", font = LARGE_FONT) ES_lang_prompt.pack(pady = 10, padx = 10) FR_lang_prompt = tk.Label(self, text = "CHOISISSEZ VOTRE LANGUE", font = LARGE_FONT) FR_lang_prompt.pack(pady = 10, padx = 10) EN_lang_button = tk.Button(self, text = "ENGLISH", command = lambda: controller.show_frame(SelectPaymentPage)) EN_lang_button.pack() DE_lang_button = tk.Button(self, text = "GERMAN", command = lambda: controller.show_frame(SelectPaymentPage)) DE_lang_button.pack() ES_lang_button = tk.Button(self, text = "SPANISH", command = lambda: controller.show_frame(SelectPaymentPage)) ES_lang_button.pack() FR_lang_button = tk.Button(self, text = "FRENCH", command = lambda: controller.show_frame(SelectPaymentPage)) FR_lang_button.pack() The aim is to show SelectPaymentPage (and essentially all subsequent pages as defined in frames (F) in baseline code) in the desired language as selected via the buttons in 1st Frame. Again, I assume this would involve passing multiple commands through lambda to show the 2nd frame, pull in the values from my language lists etc.) How best would I achieve this, in a way that I can then replicate for each frame? My current basic code for 2nd frame is below. class SelectPaymentPage(tk.Frame): def __init__(self, parent, controller): tk.Frame.__init__(self, parent) label = tk.Label(self, text = "SELECT PAYMENT OPTION", font = LARGE_FONT) label.pack(pady = 10, padx = 10) pap_button = tk.Button(self, text = "PAY-AT-PUMP", command = lambda: controller.show_frame(InsertCardPage)) pap_button.pack() pap_button = tk.Button(self, text = "PAY-AT-KIOSK", command = lambda: controller.show_frame(SelectCurrencyPage)) pap_button.pack() button1 = tk.Button(self, text = "RESTART", command = lambda: controller.show_frame(SelectLanguagePage)) button1.pack() I’d found the following online, but as mentioned above I have struggled to apply this in my scenario: Changing the language is as simple as modifying each Tk widget depending on the selected language. For example, def change_language(lang): if lang == 'English': root.title('Program') menuButton.config(text='Menu') elif lang == 'Spanish': root.title('Programa') menuButton.config(text='Menú') To make it easier to write the code, you could store your language data in a file (e.g. csv), parse it into lists or dictionaries, and have something like this: english = ['Program', 'Menu'] spanish = ['Programa', 'Menú'] def change_language_2(lang): root.title(lang[0]) menuButton.config(text=lang[1]) Any help would be greatly appreciated, as in theory once I know the specific code structure/command/variables required, I should be able to then take this an apply it where necessary. Kind regards, Jon

3 5

Control MS Access with Python
by Will Liu March 1, 2020

March 1, 2020

Hello. I am new to Python. I am wondering if it is possible to control MS Access with Python? I have a MS Access database. Every month, I need to export 100+ excel files from this database manually based on different criteria. I am wondering if it is possible to let Python distinguish, pick, and export data from MS Access automatically? I already have pyodbc installed and have MS Access connected with Python IDLE. Now I am able to read data through Python IDLE. Am I on the right way? If not, please explain. Thanks! Will Liu Engineer Assistant | iGeo LLC 3000 Wilcrest Drive, Suite 240 | Houston, Texas 77042 United States Phone: +1 281 857 2091 E-mail: yichen.liu(a)igeollc.com

3 2

Facing problem in printing a large number of points for my problem
by SATYABRATA DATTA Feb. 29, 2020

Feb. 29, 2020

I previously explained my problem that I want to print each output to specific .txt file and than repeatedly do it for several points and even if there some error which generally stops the program at some midway , can't happen in this case For this I have used the simple line which is giving each numbered output to specific folder for %i in (1,5) do python.exe test_model.py > tests/TestModel_%i.txt But I am getting only 1 and 5 as output in the above example. So I need to print nearly 100 s of such i by such simple command without using additional for loops I think here I can get a suitable answer

3 2

(no subject)
by Abdurauf Isokjonov Feb. 29, 2020

Feb. 29, 2020

Even i’ve installed bs4, python says “no module named bs4”. How to solve this?

4 3

Basic ElementTree xml question
by Phil Feb. 28, 2020

Feb. 28, 2020

Thank you for reading this, I'm trying to create an xml file with an output that looks like this" <gpx> <wpt lat="-32.506533000" lon="137.740017000"> and this is the closest that I have so far achieved: <gpx> <wpt> with this code snippet: from xml.etree import ElementTree as ET gpx = ET.Element("gpx") wpt = ET.SubElement(gpx, "wpt") So my question is, how to I include the lat and lon text after <wpt ? I've searched the Internet for example code but haven't found anything that allows strings after "<wpt ". So far, I haven't been able to turn the information in the Etree manual into anything close to what I need. -- Regards, Phil

5 15

Need help to print outputs on seperate files and avoid some unwanted error messages which can stop my code at some mid point
by SATYABRATA DATTA Feb. 28, 2020

Feb. 28, 2020

There is some code *import math class Vector(): def __init__(self,vx,vy,vz): self.x=vx self.y=vy self.z=vz def norm(self): xx=self.x**2 yy=self.y**2 zz=self.z**2 return math.sqrt(xx+yy+zz)* Now in the run file *import math* *import numpy as np* *from Desktop import Test* *def random_range(n, min, max):* *return min + np.random.random(n) * (max - min)* *filenumber = 0* *x=random_range(20,2,9)* *y=random_range(20,2,9)* *z=random_range(20,2,9)* *trial_args = np.stack((x, y, z), axis=-1)* *for x, y, z in trial_args:* * model=Test.Vector(x,y,z)* * if model.norm() > 5:* * filenumber += 1* * filename = str(filenumber)* * with open(filename+'.txt', 'w') as f:* * print(x, y, z, '=>', model.norm(), * Now let say I have a similar program which need two operator ouptput means model.operation1 #that produces some output which is used by operation2 model.operation2 Not I want to print print(x,y,z,’=>’,model.operation1,\n model.operation2,file=(my specified folder)f How to write that(In case of my original program the model.operation1 and model.operation2 when given print command gives ouput in python shell). But since there happens to be some error at some specific points(x,y,z) which causes my program to stop at some intermediate point. So my trick is to print each output to seperate files wherether errorful or right and than I can manually search which outputs are ok for me

4 3

I don’t know how to generate a number of data points from this part of code
by SATYABRATA DATTA Feb. 28, 2020

Feb. 28, 2020

I have a package and this part is written to calculate the quantity called ‘action’ at a output temperature T. But now I need a set of ‘action’ at slightly different temperatures say T+1e-3,T+3*1e-3,T+4*1e-3… Etc.Since I am a beginner at python I can’t figure out where in. This definition I have to put a loop to print different values of action at slightly different temperatures. The part of code is attached as below def _tunnelFromPhaseAtT(T, phases, start_phase, V, dV, phitol, overlapAngle, nuclCriterion, fullTunneling_params, verbose, outdict):""" Find the lowest action tunneling solution. Return ``nuclCriterion(S,T)``, and store a dictionary describing the transition in outdict for key `T`. """try: T = T[0] # need this when the function is run from optimize.fminexcept: passif T in outdict: return nuclCriterion(outdict[T]['action'], T) def fmin(x): return optimize.fmin(V, x, args=(T,), xtol=phitol, ftol=np.inf, disp=False) # Loop through all the phases, adding acceptable minima x0 = fmin(start_phase.valAt(T)) V0 = V(x0, T) tunnel_list = []for key in phases.keys(): if key == start_phase.key: continue p = phases[key] if (p.T[0] > T or p.T[-1] < T): continue x1 = fmin(p.valAt(T)) V1 = V(x1, T) if V1 >= V0: continue tdict = dict(low_vev=x1, high_vev=x0, Tnuc=T, low_phase=key, high_phase=start_phase.key) tunnel_list.append(tdict)# Check for overlapif overlapAngle > 0: excluded = [] cos_overlap = np.cos(overlapAngle * np.pi/180) for i in xrange(1, len(tunnel_list)): for j in xrange(i): xi = tunnel_list[i]['low_vev'] xj = tunnel_list[j]['low_vev'] xi2 = np.sum((xi-x0)**2) xj2 = np.sum((xj-x0)**2) dotij = np.sum((xj-x0)*(xi-x0)) if dotij >= np.sqrt(xi2*xj2) * cos_overlap: excluded.append(i if xi2 > xj2 else j) for i in sorted(excluded)[::-1]: del tunnel_list[i]# Get rid of the T parameter for V and dVdef V_(x,T=T,V=V): return V(x,T)def dV_(x,T=T,dV=dV): return dV(x,T)# For each item in tunnel_list, try tunneling lowest_action = np.inf lowest_tdict = dict(action=np.inf)for tdict in tunnel_list: x1 = tdict['low_vev'] try: print("Tunneling from phase %s to phase %s at T=%0.4g" % (tdict['high_phase'], tdict['low_phase'], T)) print("high_vev =", tdict['high_vev']) print("low_vev =", tdict['low_vev']) tobj = pathDeformation.fullTunneling( [x1,x0], V_, dV_, callback_data=T, **fullTunneling_params) tdict['instanton'] = tobj tdict['action'] = tobj.action tdict['trantype'] = 1 except tunneling1D.PotentialError as err: if err.args[1] == "no barrier": tdict['trantype'] = 0 tdict['action'] = 0.0 elif err.args[1] == "stable, not metastable": tdict['trantype'] = 0 tdict['action'] = np.inf else: print("Unexpected error message.") raise if tdict['action'] <= lowest_action: lowest_action = tdict['action'] lowest_tdict = tdict outdict[T] = lowest_tdictreturn nuclCriterion(lowest_action, T)

3 2

RC5 in Python
by Kai Bojens Feb. 26, 2020

Feb. 26, 2020

Is there any way to use RC5 for decryption purposes in Python? I even looked on page 2 of the Google results and all I found were deprecations notices, removals due to patents and some old github repos with python 2 code. None of the available crypto modules support RC5 at the moment. There are of course very good reasons to not use RC5 today, but there is still some data I need to decrypt … (And of course I don't want to code my own encryption as we all know that this leads to bigger problems) :)

2 1