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

how to change the command "string" on a tkinter Button?
by Chris Roy-Smith July 28, 2018

July 28, 2018

Hi, OS is Linux, Python version is 3.6.5 I am trying to change the command of a tkinter Button in my program. Eventually I want to be able to do this to many buttons. My attempt at code brings up no error messages, but the button appears to do nothing. I really have no idea how to do this, but this is what I wrote. ==================================== #!/usr/bin/python3 from tkinter import * class form(object): def __init__(self, x, reply, master, z,bu): self.x=x self.reply=reply self.master=master self.z=z self.bu=bu def change(x, reply, z, b): #f contains the alternative command (as a string) f=["lambda x=vars, txt=reply,fu=0 bu=b1 :form.change(x, txt, fu, bu)", "lambda x=vars, txt=first, fu=1 bu=b1: form.change(x, txt, fu, bu)"] for i in range(4): x[i].set(reply[i]) #attempt to change command clause set.button(f[z]) def draw(master): vars = [] label = [] button = StringVar for i in range(4): var = StringVar() vars.append(var) label.append("") label[i] = Label( master, textvariable=var, relief=RAISED ).grid(row=i, column=0) vars[i].set(first[i]) b1=Button(master, text="change", command=button).grid(row=i+1, column=0) reply=["now I don't know", "Happy birthday", "Many happy returns", "Next it's my turn",1] first=["What's your name?", "My name is Fred", "I have just had my birthday", "your's is next!",2] master=Tk() form.draw(master) master.mainloop() ================================= How should I do this, I had worked around the problem by destroying the window and building it again, but it was pointed out that I have an unusual coding style doing this. All hints appreciated! Regards, Chris Roy-Smith

4 11

CSV Read
by Giulia Marcoux July 1, 2018

July 1, 2018

Hello, I am a student learning python, and i am running into some difficulties. I am tryign to read a csv file that has different delimiters for different rows: Example: Format:V1.1 Model: R Step Size: 10mm Distance: 10cm Gain: 1000 X,Y 1,3 2,5 6,5 5,7 For the X,Y data, I have no problem getting it into the right cells, however I cannot separate the values after the colon for the first few rows. Its either one or the other. I am using pandas to read my CSV file. So far I have: d=pd.read_csv('read.csv',delimiter=',',skiprows=0) When I replace the delimiter for ':', it no longer works, and if i put sep=',|:' it does not work either. In the end I need to plot the x,y values and i will need some of the info in the rows above like the gain to manipulate the y data. If you have any tips for me I would be very grateful! Thanks, Giulia

5 4

RAD GUI Development (like Visual Studio/VBA)
by Glen June 30, 2018

June 30, 2018

Hey guys, Can someone advise on a RAD, drag and drop style graphical form/dialog creator? Akin to VBA or Visual Studio that will work with Python? I currently use the PyCharm IDE, which is fantastic. But I don't have the time or the skill to craft it all by hand. Thanks,

4 4

Re: [Tutor] CSV Read
by Sergio Rojas June 29, 2018

June 29, 2018

On 25/06/18 20:35, Giulia Marcoux wrote: > Hello, > > I am a student learning python, and i am running into some difficulties. I > am tryign to read a csv file that has different delimiters for different > rows: Example: > > Format:V1.1 > Model: R > Step Size: 10mm > Distance: 10cm > Gain: 1000 > X,Y > 1,3 > 2,5 > 6,5 > 5,7 > Hi Giulia, When dealing with unformatted data files, a first quick approach is to read in using standard python routines to read the file and then proceed via looping the lines of the file. Here is a very crude code to deal with your sample (in what follows >>>> represents indentations): # Say you have named your data file "thefile.dat" thefilename = "./thefile.dat" # Assign the filename to a variable # read the whole file with open(thefilename, 'r') as theFile: >>> contentfile = theFile.read() # print(contentfile) # peruse the file content. Find patterns to extract data # split the file in lines according to the newline character "\n" templines = [] for line in contentfile.splitlines(): >>>> templines.append(line.strip()) #Following the pattern extract the data thelines = [] for line in templines: >>>if ':' in line: >>>>>>temp = line.split(":") >>>>>>for i in range(len(temp)): >>>>>>>>try: >>>>>>>>>>>>temp[i] = float(temp[i]) >>>>>>>>except: >>>>>>>>>>>>temp[i] = temp[i] >>>>>>print(temp) >>>>>>thelines.append(temp) >>>elif ',' in line: >>>>>>temp = line.split(",") >>>>>>for i in range(len(temp)): >>>>>>>>try: >>>>>>>>>>>>temp[i] = float(temp[i]) >>>>>>>>except: >>>>>>>>>>>>>>>temp[i] = temp[i] >>>>>>print(temp) >>>>>>thelines.append(temp) >>>else: # not necessary >>>>>>>>pass # print(thelines) # check a few lines # Improve the code to deal with large files (big data stuff) # your turn ... # make a pandas data frame from the data import pandas as pd import numpy as np mypdframe = pd.DataFrame(np.array(thelines)) print(mypdframe) Hope this set your learning of python not too stressful, so you could appreciate its power. Sergio Check out the free first draft of the book: Prealgebra via Python Programming https://www.researchgate.net/publication/325473565 Companion web site: https://github.com/rojassergio/Prealgebra-via-Python-Programming

2 1

programmer raspberry
by Mathieu Sollier June 29, 2018

June 29, 2018

Bonjour, J’essaye de programmer un Raspberry pi 3 modèle B+ composé d’un écran tactile devant notamment allumé mon pc via cette interface. Auriez vous des conseils pour réaliser cela ? et pour l’interface graphique ? Cordialement. Provenance : Courrier pour Windows 10

2 1

getting back my listbox items
by Ali M June 24, 2018

June 24, 2018

Hi, when i do search in my Entrybox the list lowers down to that typed item the code of which i wrote in the update_list function. how should i get listbox items back again after it has been lowered? and another question: if i want to format some specific text in my Text widget i should use BeautifulSoup or can i do that with add_tag method? i used add_tag method in my enter_meaning function but it formats the first 4 letters of anyword, but i want the words which are in the listofwords to be formatted. import sqlite3 as sqlite import tkinter as tk from tkinter import ttk #GUI Widgets class EsperantoDict: def __init__(self, master): master.title("EsperantoDict") master.iconbitmap("Esperanto.ico") master.resizable(False, False) master.configure(background='#EAFFCD') self.style = ttk.Style() self.search_var = tk.StringVar() self.search_var.trace("w", lambda name, index, mode: self.update_list()) self.style = ttk.Style() self.style.configure("TFrame", background='#EAFFCD') self.style.configure("TButton", background='#C6FF02') self.style.configure("TLabel", background='#EAFFCD') self.frame_header = ttk.Frame(master, relief=tk.FLAT) self.frame_header.config(style="TFrame") self.frame_header.pack(side=tk.TOP, padx=5, pady=5) self.logo = tk.PhotoImage(file=r'C:\EsperantoDict\eo.png') self.small_logo = self.logo.subsample(10, 10) ttk.Label(self.frame_header, image=self.small_logo).grid(row=0, column=0, stick="ne", padx=5, pady=5, rowspan=2) ttk.Label(self.frame_header, text='EsperantoDict', font=('Arial', 18, 'bold')).grid(row=0, column=1) self.frame_content = ttk.Frame(master) self.frame_content.config(style="TFrame") self.frame_content.pack() self.entry_search = ttk.Entry(self.frame_content, textvariable=self.search_var, width=30) self.entry_search.bind('<FocusIn>', self.entry_delete) self.entry_search.bind('<FocusOut>', self.entry_insert) self.entry_search.grid(row=0, column=0, padx=5) self.entry_search.focus() self.button_search = ttk.Button(self.frame_content, text="Search") self.photo_search = tk.PhotoImage(file=r'C:\EsperantoDict\search.png') self.small_photo_search = self.photo_search.subsample(3, 3) self.button_search.config(image=self.small_photo_search, compound=tk.LEFT, style="TButton") self.button_search.grid(row=0, column=2, columnspan=1, sticky='nw', padx=5) self.listbox = tk.Listbox(self.frame_content, height=30, width=30) self.listbox.grid(row=1, column=0, padx=5) self.scrollbar = ttk.Scrollbar(self.frame_content, orient=tk.VERTICAL, command=self.listbox.yview) self.scrollbar.grid(row=1, column=1, sticky='nsw') self.listbox.config(yscrollcommand=self.scrollbar.set) self.listbox.bind('<<ListboxSelect>>', self.enter_meaning) self.textbox = tk.Text(self.frame_content, relief=tk.GROOVE, width=60, height=30, borderwidth=2) self.textbox.config(wrap='word') self.textbox.grid(row=1, column=2, sticky='w', padx=5) # SQLite self.db = sqlite.connect(r'C:\EsperantoDict\test.db') self.cur = self.db.cursor() self.cur.execute('SELECT Esperanto FROM Words') for row in self.cur: self.listbox.insert(tk.END, row) for row in range(0, self.listbox.size(), 2): self.listbox.itemconfigure(row, background="#f0f0ff") def update_list(self): search_term = self.search_var.get() for item in self.listbox.get(0, tk.END): if search_term.lower() in item: self.listbox.delete(0, tk.END) self.listbox.insert(tk.END, item) # SQLite def enter_meaning(self, tag): for index in self.listbox.curselection(): esperanto = self.listbox.get(index) results = self.cur.execute("SELECT English FROM Words WHERE Esperanto = ?", (esperanto)) for row in results: self.textbox.delete(1.0, tk.END) self.textbox.insert(tk.END, row) listofwords = ("gram", "med") self.textbox.tag_add('listofwords', '1.0', '1.4') self.textbox.tag_configure('listofwords', background='yellow', font='helvetica 14 bold', relief='raised') def entry_delete(self, tag): self.entry_search.delete(0, tk.END) return None def entry_insert(self, tag): self.entry_search.delete(0, tk.END) self.entry_search.insert(0, "Type to Search") return None def main(): root = tk.Tk() esperantodict = EsperantoDict(root) root.mainloop() if __name__ == '__main__': main() # db tbl name: Words # db first field name: Esperanto # db second field name: English

2 1

egg timer
by Paula Malimba June 24, 2018

June 24, 2018

Hello, I'm new to programming and am studying the book Begin to Code with Python. I'm stuck in lesson 3, trying to make an egg timer. I keep having a syntax error. Please help!!! Thanks, Paula

4 3

Installing Scrapy using Pip
by Andrew Gabler June 23, 2018

June 23, 2018

Hi, I am trying to install Scrapy using pip and keep getting an error message. I have tried to fix the problem in a variety of ways, ensuring that my setuptools are installed and up-to-date and creating a virtualenv to install to. However, I keep getting the error message, and I am at a loss for what to do. Any help would be greatly appreciated. ᐧ

2 1