Posts by JonesSantos • 79 points
6 posts
-
0
votes2
answers137
viewsA: Very slow python code?? Access to Access database with pyodbc
Test the following items: avoid inserting this step seems that you do nothing with these columns (does not compare or thing like) del data['CampoB'] del data['CampoC'] del data['Dia'] del data…
-
2
votes2
answers1580
viewsA: Import CSV and convert date in dd/mm/yyyy format to yyyy-mm-dd
I managed to solve it this way: (at this point I am considering that you have already managed to make the connection with your database). Import these guys: import os #esse __init__é o arquivo onde…
-
1
votes1
answer1074
viewsA: Power BI - Best practice importing large amount of data
If you know a little of the Sql language you could summarize a lot of the information. If it is not possible to summarize, only import the columns you will actually use in the panel. and work only…
-
1
votes0
answers589
viewsQ: Python3.5 - Import multiple files from one folder
I have the following code: __author__ = 'Jones_Santos' # !/usr/bin/python3 import os from __init__ import mycursor, connection import csv import os from datetime import datetime, date, timedelta,…
-
0
votes1
answer1260
viewsQ: pyautogui compare result CTRL+V
I have the following code import pyautogui pyautogui.moveTo(612, 269) pyautogui.doubleClick() copiar = pyautogui.hotkey('ctrl', 'c') colar = pyautogui.hotkey('ctrl', 'v') resultado = colar…
-
2
votes2
answers1580
viewsQ: Import CSV and convert date in dd/mm/yyyy format to yyyy-mm-dd
I’m a complete beginner in programming, both in Python and Sql, so I have some questions that may seem basic. I get a file. CSV that comes a lot of information not compatible with Sql so always have…