Posts by Juliano Rodrigues • 116 points
9 posts
-
0
votes1
answer49
viewsA: Merge two files in python
try to create a list by concatenating the two #criando as duas listas para exemplo a=[x for x in range(360)] b=[y for y in range(361,721)] #criando a nova lista uniao=[] #juntando as duas for z in…
pythonanswered Juliano Rodrigues 116 -
0
votes4
answers8851
viewsA: Full Python file path
I usually use the os.walk()as follows: from os import walk for caminho,_,arquivo in walk('.'): print(str(caminho)+"/"+str(arquivo))
-
2
votes1
answer37
viewsA: Get web data for VBA string
built in my form the following code Private Sub UserForm_Activate() Dim validacao, retorno As Variant Dim site As Object Set site = CreateObject("WinHttp.WinHttpRequest.5.1") On Error GoTo proximo…
-
0
votes1
answer37
viewsQ: Get web data for VBA string
Good morning! I developed some macros and functions for my use in the company and I would like to validate their use by searching a web page. the page is actually a blogspot. in which I will leave a…
-
1
votes3
answers64
viewsA: optimize Camelot large pdf files
after the help and test the use of the tabula the script was like this: import tabula, PyPDF2, tqdm from tkinter import Tk, filedialog as dlg Tk().withdraw() file_path = dlg.askopenfilename()…
-
1
votes3
answers64
viewsQ: optimize Camelot large pdf files
Good afternoon! I use Camelot to extract data from PDF files (bank statements to be more accurate). However, I have a PDF file with more than 5000 pages, and Camelot is a bit slow. I decided to…
-
0
votes1
answer35
viewsA: I need to delete all the contents of a list before I finish my loop
I noticed in your code the unnecessary use of some lists, and also noticed the origin of the error: when using def picking_random there was an increment of these lists that would be the basis to…
pythonanswered Juliano Rodrigues 116 -
1
votes3
answers66
viewsA: How to remove values that are in another list?
see if this helps you: schedules_dict = {1: ['00:00'], 2: ['00:30', '00:45'], 3: ['00:00', '00:30', '00:45']} appointments_dict = {1: ['00:00'], 2: ['00:30'], 3: ['00:00', '00:30']} for key in…
-
5
votes4
answers167
viewsA: How to return the first vowel of several words in a list?
insert a break after the print of the volgal: palavras = ('boi', 'vaca', 'macaco', 'ovelha', 'lesma',) vogais = ('a', 'e', 'i', 'o', 'u') for palavras in palavras: print(f'\nPalavra {palavras}',…