Tech

Windows CMD Command to Display All IP Addresses

for /L %i in (0,1,255) do ping -n 1 -w 250 192.168.1.%i>>ipaddress.txt The above scans all the IP address on the subnet 192.168.1.XXX and saves them to a file named ipaddress.txt. Thanks to Clifford on the thread here for pulling this together. I often remote desktop into my mining PC. However my ATT router is spotty at best so there are times I failover to a backup network which renews my PCs IP address according to its DHCP.

Excel to Pandas Cheat Sheet

Translating Common Excel Functions to Python Pandas Methods. This is my cheat sheet for commonly used Excel functions roughly translated to their Python Pandas equivalents. Over the last 3 years I have increasingly found myself booting up a Jupyter Notebook to perform data analysis using Python Pandas rather than relaying on Excel. A few factors play into that: speed when performing data analysis tasks: what one loses in GUI ability one can often make up for in speed of executing extractions, transformations, filters, calculations, etc.

How to Password Protect a Hugo Website

Hugo is a static website generator that ships without a database which adds security, simplicity, and speed. But, no database means that Hugo doesn’t have a built-in solution for password protection or user management. Luckily, your web server does have the ability to perform basic user management. This is a good solution for making a Hugo site private. I use this very basic .htaccess configuration to prompt a user for credentials before they can access my site.

How to Delete a Local Git Branch

I’m posting this here as a reference for myself, but know that this may help others in a similar situation. I don’t often delete branches in Git, but when I do I like to make sure that I am doing so correctly. The below guide to How to Delete a Git Branch is directly from the highest rated answer on StackOverflow. If one wishes to delete a branch named “Test_Branch.” Switch to some other branch to avoid any errors when attemtping to delete.

SSH into NextCloudPi Without a Password

I recently set up a NextCloudPi (NCP) server on my Raspberry Pi to use on my LAN. Initially, I used a monitor to configure NextCloudPi. However, as this setup is now sitting on a shelf several feet from my desk, I set up SSH to allow me to connect remotely from my main PC. I wanted to remove the password requirement everytime I SSHed in. Here’s how. Part 1 - Enabling SSH on NextCloudPi Part 2 - Setting Up SSH Without Requiring a Password on NextCloudPi