Quickly and effortlessly take a row of data and turn it into columns (star schema). This is an alternative to MS SQL UNPIVOT but unlike MS SQL you don’t need to know the column names.
Tag: Python
Record every keystrokes
In this tutorial I’ll show you how to capture every key the user presses on the keyboard.
Pyautogui
Using pyautogui to automate your daily work or play a video game for you.
Copy the code below into a text file and run it in your Python IDE. You may need to install the three libraries first
pip install webbrowser
pip install time
pip install pyautogui
import webbrowser
import time
import pyautogui
webbrowser.open(‘www.youtube.com’)
print(‘waiting for 6 seconds for youtube to open’)
time.sleep(6)
print(‘clicked search bar’)
step1 = pyautogui.locateOnScreen(“search bar.png”)
pyautogui.click(step1)
print(‘typing’)
pyautogui.typewrite(‘afterowl python’)
time.sleep(3)
print(‘clicking on search button’)
step2 = pyautogui.locateCenterOnScreen(“search button.png”)
pyautogui.click(step2)
time.sleep(3)
print(‘clicking on Python Graph image’)
step3 = pyautogui.locateCenterOnScreen(“python graph.png”)
pyautogui.click(step3)
Create and Write to a File
If you need a quick way to log all of the current running processes to a text file you’ll want to check out this video. In this video, I’ll show you how to get all of the currently running processes in Task Manager/Activity Monitor and save that information to a text file. Python is small in size and allows the same code to run in both Windows and Mac which is great because you don’t need to recode for the specific OS.
History Graph
In this tutorial, I’ll show you how to draw a histo-graph using your computer’s CPU usage as the values.