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

Draw table and compare random input
by Phaik Huen Tan Aug. 3, 2020

Aug. 3, 2020

Hi there, I am supposed to draw a table for my random input (12 months of expenses) and compared it against the monthly target. I am able to get input from the user but I am not able to compare each input and display each input by month individually. Can you please provide guidance on where I did wrong on my code? Thank you! Phaik-Huen Below is my code: # This program calculates monthly expenses. # Create a variable to control the loop. keep_going = 'Y' #Calculate monthly target for each of the 12 months using annual IT expenses of $42500 monthly_target = 42500/12 print('Monthly target expenditure is $', format(monthly_target,'.2f')) while keep_going == 'Y' or keep_going == 'y': # Initialize an accumulator for site expenditure total = 0 # Get the site expenditure month_exp = int(input('Please enter month expenditure: ')) if month_exp < 0: print('Value must be greater than 0') month_exp = int(input('Enter the correct site expenditure: ')) # See if the user wants to do enter another one. keep_going = input('Do you want to enter another ' + 'month expenditure (Enter Y or y for yes): ') #Print the table headings print() print('Month\t|Expense\t|Over,Under or Exact') print('-----------------------------------------------') if month_exp >= monthly_target: print("Over") elif month_exp <= monthly_target: print("Under") else: print("Exact")

2 1

Assistance request when using python 'calendar'
by o1bigtenor July 31, 2020

July 31, 2020

Greetings I regularly work in planning through multiple years at once. This means that I like to have a lot of stuff available in a calendar function. Python seems to be locked when I need to display more than 1 year at a time. I don't see a way to display something like 3 years worth of calendar starting at a point 23 months from now. (I see how to display 1 year at a time but not multiple years.) Is there a way to do this? TIA

1 0

(no subject)
by sophia lore July 27, 2020

July 27, 2020

Create a program that iterates using a *for loop* over all values of list_mod. The program must check each value and append the string "True" to the list result if the value is even or append the string "False" to the list result otherwise. In [ ]: ### GRADED list_mod = list(range(1,15)) result = [] I have been working on this question for class for two days. I have tried numerous combinations of if/else statements in the for loop to achieve the outcome requested. All of the code I have tried returns errors. I can't seem to grasp how to set this up. Any help would be appreciated. Thanks

4 3

Debug help
by Jim July 26, 2020

July 26, 2020

Mint 18.3 - Python 3.6 I wrote a script that uses the yfinance, oosheet and pandas modules to get closing stock prices from Yahoo Finance to put in a Libreoffice spreadsheet to use in a stock trading simulation. I usually run the script on a Sunday to get each days closing prices and calculate the stocks value in the porfilio for the previous week. The script works fine on Mon to Thurs but gives the following error when I try to get Fridays prices. If I run the script on the following Monday it works without error. (env36) jfb@jims-mint18 ~ $ /home/jfb/EVs/env36/bin/python3 /home/jfb/Dev/Python/LO_update_stk_history_yf_dev.py Traceback (most recent call last): File "/home/jfb/Dev/Python/LO_update_stk_history_yf_dev.py", line 128, in <module> update_from_web() File "/home/jfb/Dev/Python/LO_update_stk_history_yf_dev.py", line 102, in update_from_web S().value = stk File "/home/jfb/EVs/env36/lib/python3.6/site-packages/oosheet/__init__.py", line 438, in value cell.setValue(value) uno.RuntimeException: Couldn't convert Date 2020-07-17 134858.5 <<Note: the date is the date I input, the num >> 2020-07-17 134858.5 << is the value of the 1st stk in the list>> Name: Close, dtype: float64 to a UNO type; caught exception: <class 'AttributeError'>: 'Series' object has no attribute 'getTypes', traceback follows /home/jfb/EVs/env36/lib/python3.6/site-packages/pandas/core/generic.py:5274 in function __getattr__() [return object.__getattribute__(self, name)] I guess something internal at Yahoo Finance is causing the problem. I found an issue that looks similar to mine on the yFinance github page and added to it including a small test program to demonstrate the problem but never heard back. Here is the part of the code that generates the error, the remainder of the script just manipulates the spreadsheet. for stock in stocks: # ~ count = 0 # ~ while count < total_num_of_stocks: # ~ while count < 33: while True: # ~ count = count + 1 try: # ~ print('Day = ' + day) ticker = yf.Ticker(stock) # ~ print('Ticker = ' + ticker) hist = ticker.history(start=day) # ~ print('History = ' + hist) close_price = hist.loc[day]['Close'] # ~ print('Close = ' + close_price) closing_prices.append(close_price) except: print ('yfinance JSONDecodeError DAILY, retyring') # ~ print ('ticker: ' + hist) continue break # Get stock values by multiplying the list elements by number of shares # using zip() value = [num_shares * stk for num_shares, stk in zip(shares, closing_prices)] # Put date in cell then go down one row S(cell_loc).string = day S().dispatch('GoDown') # Fill column for MY100000 with stock values using the number of stocks in MY100000 for stk in value[:total_num_MY100000]: S().value = stk # Line 102 S().dispatch('GoDown') If I run the script with the print lines outside the except commented out it will print the date in the spreadsheet, go down 1 cell and throw the error and end. If I uncomment any of the print lines it seems to go into a endless loop printing out the exception error msg. I wonder if anyone has an idea of how to figure out what Yahoo Finance is doing to cause a problem and I am curious as to why uncommenting a print seems to cause an endless loop. Thanks, Jim

2 4

Request of Help about pymatch
by laura marchesini July 26, 2020

July 26, 2020

Good Morning to everyone, I am Laura, a student at University in Economics and Finance. I am writing my Master thesis using Python and I am facing some problems with pymatch.. I would be very grateful if You could give me a hint to solve this particular issue. I am performing Propensity Score Matching with pymatch, in particular matching companies of two different groups according to three variables. One of these (Sales) is wrongly recognized by Python as many dummies as many values of the variable itself. The other 2 variables are correctly recognized as continuous variables. When I call m.X I see thousands of sales variables, instead of one single column with values for each company. I used the same code before for another group of data, and it worked well, so I am not understanding what is not wrong here.... Could You please help me?? That would mean much for me, Thank You for the attention, Laura

3 2

Error from importing numpy and pandas
by gameli godfred July 24, 2020

July 24, 2020

*Hello, I get this error when ever I try to import numpy and pandas. Please can I get assistance ob how to resolve this? I have tried different methods but to no avail. * *Thank you.* OSError Traceback (most recent call last)<ipython-input-8-59ab05e21164> in <module>----> 1 import numpy as np 2 import pandas as pd ~\AppData\Roaming\Python\Python37\site-packages\numpy\__init__.py in <module> 138 139 # Allow distributors to run custom init code--> 140 from . import _distributor_init 141 142 from . import core ~\AppData\Roaming\Python\Python37\site-packages\numpy\_distributor_init.py in <module> 24 # NOTE: would it change behavior to load ALL 25 # DLLs at this path vs. the name restriction?---> 26 WinDLL(os.path.abspath(filename)) 27 DLL_filenames.append(filename) 28 if len(DLL_filenames) > 1: ~\anaconda3\lib\ctypes\__init__.py in __init__(self, name, mode, handle, use_errno, use_last_error) 362 363 if handle is None:--> 364 self._handle = _dlopen(self._name, mode) 365 else: 366 self._handle = handle OSError: [WinError 193] %1 is not a valid Win32 application <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campai…> Virus-free. www.avast.com <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campai…> <#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>

2 1

TypeError: 'float' object is not iterable
by hongerlapjes July 23, 2020

July 23, 2020

I'm learning python and need help. How can I sum up "bedrag"? I've replaced the "." with a "," and changed the string into a float, but I can't iter. I'm lost. What do I need to do? I've tried numpy For content csv see: My python code: import csv import numpy as np with open('oefen.csv') as csv_file: csv_reader = csv.DictReader(csv_file, delimiter=',') print(csv_reader.fieldnames) for row in csv_reader: #change string into float and replace the comma with a dot bedrag = float(row['Bedrag (EUR)'].replace(",", ".")) #try 1 gives: TypeError: 'float' object is not iterable som = sum(bedrag) print(som) #try 2 gives: TypeError: iteration over a 0-d array arr = np.array(float(row['Bedrag (EUR)'].replace(",", "."))) som = sum(arr) print(som) #try 3 gives: TypeError: 'float' object is not iterable arr = np.array(list(float(row['Bedrag (EUR)'].replace(",", ".")))) som = sum(arr) print(som)

3 2

Re: [Tutor] If - else Vs OR
by Alan Gauld July 22, 2020

July 22, 2020

Please use reply-ALL or Reply0List when responding to the group. CCing my reply. On 22/07/2020 19:00, Nick Kartha wrote: > Since when could we do if else /inside/ the print() > This is new to me, and have not seen this in another language. print takes a string argument(as well as some others) That argument can be a literal string or any python expression that evaluates to a string. The expression <value> if <test> else <another value> can be used anywhere that a value is required, including inside a print. C/C++ has a similar construct: <value> ? <test> : <other value> And a couple of others have borrowed that. Python took it and made it more readable. > I assume the condition is checked before the print Yes it is an expression that is evaluated and the result printed. Think about these examples of similar things: print(5+3) # -> print(8) -> print"8") myObject.name = "Alan" print(myObject.name) # -> print("Alan") x = 42 print("The answer to ... everything is {}".format(x)) -> print("The answer to ... everything is 42") These are all expressions that get evaluated to a string before printing. The conditional expression is no different. -- Alan G Author of the Learn to Program web site http://www.alan-g.me.uk/ http://www.amazon.com/author/alan_gauld Follow my photo-blog on Flickr at: http://www.flickr.com/photos/alangauldphotos

1 1

If - else Vs OR
by Manprit Singh July 21, 2020

July 21, 2020

Dear all, Consider a problem in which there is a list a, which can contain even as well as odd numbers. For Example a = [2, 3, 4, 6, 8] Now i have to filter out all even numbers from this list, and make a new list a1 that contains all odd numbers . In case, if the list a does not contains any odd number, then the resultant will be an empty list , this resultant list can be made by : a1 = [ i for i in a if i%2 != 0] So, a1 will be empty if list a does not contain any odd number , and if list a has one or more odd numbers then a1 will contain all those odd numbers . i have to write a program which will print "Empty List" if a1 is empty and print list a1 if a1 is not empty : i am writing 2 solutions to this problem . My question is which one method should be preferred sol 1) : a = [2, 3, 4, 6, 8] a1 = [i for i in a if i%2 != 0] if a1: print(a1) else: print("Empty list") sol 2) : a = [2, 3, 4, 6, 8] a1 = [i for i in a if i%2 != 0] print(a1 or "Empty list")

4 3