🌐 Mailman 3 November 2020 - 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

Function decorators
by Manprit Singh Dec. 2, 2020

Dec. 2, 2020

Dear sir, I tried to understand the concept of function decorators from various sources but couldn't . Can i request you a small text that describes the decorators along with an example . I am sorry if I said something wrong. Regards Manprit singh

5 5

Re: [Tutor] Recommendation to supersede openpyxl
by Jim Byrnes Dec. 1, 2020

Dec. 1, 2020

On 11/30/20 1:00 PM, Dennis Lee Bieber wrote: > On Mon, 30 Nov 2020 12:44:04 +0000, Alan Gauld via Tutor <tutor(a)python.org> > declaimed the following: > >> On 29/11/2020 04:53, Sailormoon wrote: >>> Dear  sir : >>> Recently I used The openpyxl library to modify some excel documents >>> and save that ,I found all The inserted picture omission >> > <SNIP> >> >> Personally I've only ever used the csv module to create >> excel readable csv files, but it sounds like you need >> more than that would provide. > > I'd have to concur. Most of the Excel interface packages appear to > focus on just the numeric data contents, and /maybe/ formulas. Not on > things that are Excel GUI oriented (forms, embedded images, macros, and VBA > scripts). > > For that level of manipulation, I suspect one will need to script Excel > itself -- not using libraries that just read/write plain Excel files. From > Python that means pywin32 COM control, OR MAYBE using ctypes instead, to > invoke the Excel engine (.DLLs) directly (IOWs, running Excel in the > background and asking /it/ to make the changes to the document).. > > I don't use windows so I have never used Excel so maybe I am way off base here. I have used a combination of pyautogui, oosheet and even openypxl to modify Libreoffice calc sheets. Using pyautogui's ability to send keystrokes I can manipulate calc's menu system and take advantage of what it offers. Maybe you can do the same with Excel. Regards, Jim

2 1

Recommendation to supersede openpyxl
by Sailormoon Nov. 30, 2020

Nov. 30, 2020

Dear  sir : Recently I used The openpyxl library to modify some excel documents and save that ,I found all The inserted picture omission  ,i checked and found that openpyxl can not save The picture information ,so  do You have any other  recommendation for such instance . YOURS SINCERELY　ZHANGTAO

2 1

lists
by Bernardo Rebelo Nov. 29, 2020

Nov. 29, 2020

Hi I would like to know how to check if an element in a list is greater than the next element on the same list like this [5,4,3,2,1] if 5 > 4 > 3 > 2 > 1 return True in an example like this one [5,4,5,2], it would give False. best regards,

6 7

Curses Python: F1 => Xfce Terminal documentation
by alexkleider Nov. 29, 2020

Nov. 29, 2020

In going through some of the examples in Alan's 'translation' of the curses documentation, specifically Example 7: The F1 key seems to be intercepted by the Xfce Terminal in spite of using wrapper. I added "keypad(True)" but to no avail. A work around is to us 'H' (for help) rather than a function key but the documentation indicates that function keys should work. My system is Debian 10 with Xfce. TIA Alex

3 6

Coding question
by Erin Anderson Nov. 28, 2020

Nov. 28, 2020

Hello, I am trying to figure out how to code for reading in text from a URL in python but in two chunks. I am looking at a transcript from a website and I want to read in the text but I want the reading in of the text to stop when the transcript says “Part 2”, I then want to have this chunk of information as one entity and then create another entity filled with the text that occurs after the words “Part 2”. Im thinking one way to do this is using a while loop, but I am not quite sure how to implement it Def text_chunk(url) webpage=web.urlopen(url) while text != “Part 2”: rawbytes=webpage.read() webpage.close() text = rawBytes.decode('utf-8’) return text Thank you!!!!

3 2

Using 'with open' statementfor reading a file two lines at a time
by Ken Green Nov. 27, 2020

Nov. 27, 2020

Gentlemen and ladies: I am using 'with open' statement to read a file two lines at a time and then combining them together to print the results into another file. I can read the first two lines, combine them and print the result into another file and then that is it. Just the first and second lines were printed and save. How can I continue reading the third and fourth lines and so forth on until the end of the file? I am using Python 3.8.5 under Ubuntu 20.04.1 with using Thonny 3.3.0 (2020-11-5) as an interface. I used to use Geany but discovered the latest version doesn't work in Ubuntu 20.04 and it only applicable for Windows and Apple and there is no Linux version according to its website. Thanking you all in advance, Ken

7 9

DataFrame to Nested JSON Conversion issue
by Anitha Kothandan Nov. 26, 2020

Nov. 26, 2020

Hi Guys, I am trying to convert a DataFrame into Nested json. The Policy column value should be an json object instead of an array(square brackets should not be there). Mentioned the code, expected output and screenshots below. Kindly help me out here. Thanks in Advance!! Code: import pandas as pd import json Data=pd.DataFrame() x='{"Specversion":"1.0","PolicyID":"0123456789","EventID":"20201124030503-1000","Division":"LID"}' Data=pd.io.json.json_normalize(json.loads(x)) Data=Data.groupby(['Specversion','PolicyID'])[['EventID','Division']].apply(lambda g: g.to_dict(orient="records")).reset_index(name="Policy") Data['Final_json']=Data.apply(lambda x: x.to_json(date_format='iso'), axis=1) print(json.dumps(json.loads(Data['Final_json'][0]),indent=2,sort_keys=False)) Expected Output: { "Specversion": "1.0", "PolicyID": "0123456789", "Policy": { "EventID": "20201124030503-1000", "Division": "LID" } } Screenshot [cid:image001.png@01D6C323.74E7D370] Thanks, Anitha

2 1

accessing the CD rom
by nathan tech Nov. 25, 2020

Nov. 25, 2020

Hello folks, I was wondering if anyone has any recommendations for modules or methods for accessing the disk drive? I am using windows and have had very little luck installing the pycdio library and it appears the cd module was taken out in python 2.6? To be clear I'm looking to: 1. Check if there is a CD is the drive. 2. Eject the drive. 3. Play the tracks from the drive. The third I'm able to handle already, the thing I'm not sure is how to check for the drive and, then, to eject it. Thanks in advance. Nathan

2 2