Pandas Code Snippets – Python
TonyDeleting a Dataframe Row based on a Column Value (StackOverFlow) df = df[df.column_name != 0] Creating a Column Using a DataFrame.Apply That Uses Multiple Conditions From Other Columns (StackOverFlow) def…
How to use Python SCP to Check local filesize vs remote filesize and also replace remote filesizes that do not match local filesize.
I use code to transfer hundreds of large files to a remote server and sometimes after all transfers are done, the remote file size does not match the actual size…
The Most Useful Python Code Snippets I Use
Separating Large Lists into Chunks for Data Processing import random res = [random.randrange(1, 50, 1) for i in range(100)] chunk_size = 25 for i in range(0, len(res), chunk_size): chunk =…
Use mysqldump to Export All Tables from an MySQL Database to CSV Files
Preface This solution will download all tables in a single database to flat files so you can keep a backup copy or if you want to work with the data…
How to Disable the Updates Are Available or Get Updates Popup in Windows Servers 2016
I've been having this recurring issue on a Windows 2016 Server where there is a pop-up that overlays the entire screen and prevents all the scripts I run on Windows…
How to Run a Python Script with Windows Task Scheduler [Python Script Automation]
Windows Task Scheduler is a component in Windows that gives the ability to schedule and automate repetitive tasks in Windows by running scripts or programs at a specified interval. For…
How to Resize VirtualBox Hard Disk (vdi file) – VirtualBox resize hard disk error: VBOX_E_NOT_SUPPORTED
When trying to resize the size of my VDI to 80GB with this command: VBoxManage modifyhd "C:\Users\<USERNAME>\VirtualBox VMs\<VDU Folder>\<VDI Name>.vdi" --resize 81920 I ran into this error: Progress state: VBOX_E_NOT_SUPPORTEDVBoxManage.exe:…
How to use the private key (.pem file) generated in AWS to connect from a Windows PC to a Linux Server
Frustrated like I was when trying to figure out how to use the key/pair generated via EC2 to connect to your Instance? This solution was a lifesaver for me and…