Posts by AleGR • 144 points
9 posts
-
0
votes2
answers65
viewsA: How to use the filter function using lists?
As the jfaccioni reply, the use of list comprehension is most recommended as it is more readable. However, for teaching purposes, I will demonstrate how a possible solution would be using only map…
-
0
votes2
answers375
viewsA: Export process information to a . txt - Python
@Gigle, you can concatenate your text as follows: a = '%s%s%s\n' % (line.strip(), '¬', word) I also suggest you move the list assignment out of the loop, to improve the performance and readability…
-
3
votes3
answers9053
viewsA: Multiplying terms from the list
You can also use numpy.prod() to obtain multiplication of all the elements in the list. Example: import numpy lista = [1, 2, 3, 4, 5] resultado = numpy.prod(lista) print(resultado) Source:…
-
0
votes3
answers178
viewsA: is not accumulating values in the lists
You can make your code more "pythonic" using list comprehensions. This way, you don’t need to initialize the variables lista1 and lista2 before using them and you can assign list values in only one…
-
0
votes1
answer25
viewsA: Access SQL syntax error to find and delete duplicates leaving only one
@Rodrigo BRF The names of the fields that have spaces or hyphen should be placed between brackets. Example: F.[Criado em]
-
0
votes1
answer198
viewsA: access - subtraction in query duplicates values
@demolion For the values not to double, it is necessary to realize a LEFT JOIN between your table of Artigos and the tables of SomaEntradasTotais and SomaSaidasTotais, as below: FROM (Artigos LEFT…
-
1
votes1
answer253
viewsA: Using Access to export in Excel, Parameterized Query
The most practical way would be to use temporary variables. Try the following: Based on your query using something similar to image that you ordered. Change the criteria [What Date? (dd/mm/yy)] for…
-
1
votes1
answer920
viewsA: Add cascading data from a column in Access
Hello! whereas the structure of the table containing the data is something like: Data AnoSemana Sairam Entraram 01/01/2016 2016/01 5 10 01/02/2016 2016/06 3 8 01/03/2016 2016/10 9 6 01/04/2016…
-
4
votes1
answer707
viewsQ: Attachmate Waithostquiet Method - Extra! with python
I’m using Python to automate Attachmate - EXTRA! as many do with VBA. I’m using the package pywin32 found here. I’m following the method documentation WaitHostQuiet found here. The problem occurs…