# Linux, Devops, Scripting, Cats and various things come to my mind
// also on this box: ./practice, ./tools and ./games
When managing large file systems, automating routine tasks like file compression can help improve storage efficiency and reduce manual…
cat how-to-create-a-directory-that-will-automatically-zip-files.md →SSH (Secure Shell) is a widely used protocol for securely accessing remote servers and executing commands. While SSH is a powerful tool…
cat how-to-minimize-ssh-connection-time-using-connection-multiplexing.md →In this tutorial, you will learn how to convert a Pandas DataFrame to SQL commands using SQLite. By the end, you’ll be able to generate SQL…
cat converting-a-pandas-dataframe-to-sql-statements.md →When working with large datasets, especially event logs, it’s common to group data by specific time intervals to better analyze trends and…
cat sql-group-rows-by-minute-intervals.md →In this tutorial, we will walk through a Python script that generates a dataset of daily values, filters the data based on a specific date…
cat determine-if-mondays-sales-vary-significantly-from-other-mondays-using-pandas.md →Time series data is used in many-real world scenarios like sales trends, stock prices, and weather patterns. Many of these phenomena…
cat how-to-generate-weekly-sinusoidal-data-with-random-noise-using-pandas.md →The LAG() function in SQL is a window function that provides access to a row at a specified physical offset before the current row within…
cat mastering-the-sql-lag-function-comparing-data-like-a-pro.md →Assume the following scenario, you have a text file and you want to replace each nth occurrence of a word on each line, using sed is a…
cat how-to-replace-the-nth-occurrence-of-a-word-using-sed.md →Using aws cli to manage ssh keys for your ec2 instances is a programmatic way faster than using the Web Interface and can also be used in…
cat aws-manage-ssh-keys-from-the-cli.md →Ahh the cloud! What a wonderful time to work as a sysadmin/devops. you have the power to create an unlimited number of virtual machines…
cat how-to-force-a-linux-server-to-shutdown-if-there-is-no-active-ssh-connection-for-the-last-hour.md →
