Skip to content

inspekt//blog

inspekt//blog

  • Home
  • Donate
  • Contact
Python

Pandas Code Snippets – Python

Tony Jun 22, 2022 0 Comments

Deleting 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…

Python

How to use Python SCP to Check local filesize vs remote filesize and also replace remote filesizes that do not match local filesize.

Tony Jan 8, 2022 0 Comments

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…

Python

The Most Useful Python Code Snippets I Use

Tony Jan 8, 2022 0 Comments

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 =…

Linux MySQL

Use mysqldump to Export All Tables from an MySQL Database to CSV Files

Tony Jun 2, 2021 0 Comments

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…

Windows

How to Disable the Updates Are Available or Get Updates Popup in Windows Servers 2016

Tony May 20, 2021 0 Comments

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…

Python Windows

How to Run a Python Script with Windows Task Scheduler [Python Script Automation]

Tony May 19, 2021 0 Comments

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…

VirtualBox Windows

How to Resize VirtualBox Hard Disk (vdi file) – VirtualBox resize hard disk error: VBOX_E_NOT_SUPPORTED

Tony Apr 13, 2021 5 Comments

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:…

AWS Linux Windows

How to use the private key (.pem file) generated in AWS to connect from a Windows PC to a Linux Server

Tony Mar 10, 2021 0 Comments

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…

  • Pandas Code Snippets – Python

    Python

    Pandas Code Snippets – Python

    June 22, 2022

  • How to use Python SCP to Check local filesize vs remote filesize and also replace remote filesizes that do not match local filesize.

    Python

    How to use Python SCP to Check local filesize vs remote filesize and also replace remote filesizes that do not match local filesize.

    January 8, 2022

  • The Most Useful Python Code Snippets I Use

    Python

    The Most Useful Python Code Snippets I Use

    January 8, 2022

  • Use mysqldump to Export All Tables from an MySQL Database to CSV Files

    Linux / MySQL

    Use mysqldump to Export All Tables from an MySQL Database to CSV Files

    June 2, 2021

  • June 2022
  • January 2022
  • June 2021
  • May 2021
  • April 2021
  • March 2021
  • AWS
  • Linux
  • MySQL
  • Python
  • VirtualBox
  • Windows

inspekt//blog