Posts by Wilson Junior • 182 points
21 posts
-
-1
votes1
answer36
viewsQ: Python: consolidate duplicate lines by adding values
I have a spreadsheet in excel format (.xlsx) with the following columns: "matricula", "name", "value", as shown below. I would like to delete the repeated data by adding up the values. The final…
-
0
votes1
answer503
viewsQ: Python and Kivy: How to select and copy all text from a Text Input
Hello! I’m trying to learn Kivy... 1) I would like to select all text within a Text Input in Kivy. Which attribute should I study to change my code myself?; 2) After selecting all the text, the copy…
-
2
votes1
answer123
viewsA: How to use PROCV to search for code in two spreadsheets?
You are using the references and the wrong form, see the result in the image below. 1) Consider having worksheet 2 active, which you want to put the formula in cell C3; 2) You start by writing in C3…
-
-2
votes1
answer107
viewsQ: Python: Access 4th level of a zipped folder
Hello! I’d like to access the fourth level of a zipped folder. I mean, I have a zip file and inside it there is a folder and inside this has another folder and so on... as graph below. I’d like to…
pythonasked Wilson Junior 182 -
2
votes1
answer991
viewsQ: Python: remove double quotes from a list
Gentlemen(as), I need remove double quotes from each index in the list and, would like to remove each empty space, as well as remove that ' n' from the end of the list. lista = ['"11/07/2019"',…
python-3.xasked Wilson Junior 182 -
0
votes1
answer637
viewsQ: Python: listbox with multiple columns in Tkinter - sort columns by clicking on them
I have a listbox with multiple columns, as shown below. I would like to sort the columns by clicking on the titles of them, see the code: I had thought within the "sortby()" function to identify…
-
1
votes1
answer1006
viewsQ: Python: "list index out of range"
Issues: What makes the code snippet below? He’s making a mistake. How can I identify and correct this mistake? verificar = self.tree.column(titulos_listbox[ix], width=None) When running the code,…
-
2
votes1
answer384
viewsQ: Python: Web Scraping in Dynamic Page
I am researching on web scraping. I have found dozens of pages, however, in none of them found how to extract information from dynamic pages. Well, I’m trying to get the value of the LTCBRL…
python-3.xasked Wilson Junior 182 -
-1
votes1
answer48
viewsQ: Python: Return of a specific function
How can I access the function’s Return on_press(key)? The program below captures keystrokes. Open, for example, the notepad and type test and teclhe Enter The result in the list should be: lista =…
python-3.xasked Wilson Junior 182 -
3
votes3
answers5171
viewsQ: Remove string quotes in array
How can I remove single quotes from the result? Typed user teste and key Esc to get out. The program captures keystrokes and saves digit per digit in a list. The list is hereby filled in: lista…
-
-1
votes1
answer1092
viewsQ: Sqlite3 - unrecognized token
Hello! You can help me? I’ve tried it in many ways, but I couldn’t understand. With up to 3 variables this way works, but with 7 variables presents the error in the image below. I’ve been stuck in…
sqlite3asked Wilson Junior 182 -
0
votes1
answer830
viewsQ: Python: Tkinter + SQLITE. Save records to database and clear field
I am studying, on my own Sqlite, I already bought some courses, but I need a help. Objective: I would like to save the user typed fields in the database and then clear the same fields to allow new…
-
0
votes1
answer492
viewsQ: Python - scroll through a list - replace word within word (.docx)
Good morning! I need some help... I have a word file, named after 'docx test.'. I would like to replace each term inside it with strings that are in a list. See example. The problem that is…
pythonasked Wilson Junior 182 -
0
votes1
answer159
viewsQ: Python - problem with PIP (or modules)
I am developing a program equal to word direct evil, however, which also allows naming each file in the folder. I installed on my PC (Windows 7) Python 3.7 and, to develop the program I needed to…
-
0
votes1
answer332
viewsQ: HTML - moving menu image
good afternoon! I’m training to build a website and, when I minimize the screen, the menu bar that is an image moves and goes out of position (it goes up). I’d like it to stay fixed and adjust to…
-
0
votes1
answer235
viewsQ: Python: Slow code execution and other problems
Dear colleagues, Can someone enlighten me on what might be going on? In summary, it is a code to read cells from a spreadsheet, sort and transport to a new spreadsheet. The problem: The code does…
pythonasked Wilson Junior 182 -
0
votes1
answer410
viewsQ: Python: loop screenshot saving over
Why the code below saves the file one over the other? I wish that every screenshot generates a separate file within the specified folder. import datetime import pyautogui import time #armazena o…
pythonasked Wilson Junior 182 -
1
votes1
answer2400
viewsQ: Python: Tkinter. Run button
Dear friends, good evening! See if you can give me an idea, please! Problem to be solved: I created the TKINTER interface for my program. This interface was in a separate file from the code. I would…
-
1
votes2
answers6485
viewsQ: Python - Moving files to another folder
Could someone give me a help in the code below? Goal: move files from one folder to another. I have on the desktop two folders, one called "test" and the other "teste2". At first, I have 7 text…
python-3.xasked Wilson Junior 182 -
1
votes1
answer842
viewsQ: Python, display index of a specific row within the matrix
Dear Gentlemen(as), You could give me a hand. An idea?! --> I am trying to present (print) the index(the line) of the longest interval between the longest and shortest of the rows of a matrix…
-
0
votes2
answers912
viewsQ: Python: find product of the highest value of each matrix list
Dear Ladies and Gentlemen(s), I’ve done a lot of research before posting my question. I am already discouraged. This is a university job. If you can give me a hint, I’d appreciate it. The exercise…