SQL: Group Rows By Minute Intervals
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 →$ ls -lh ./posts
// also on this box: ./practice, ./tools and ./games
Determine if Monday’s sales vary significantly from other Mondays using Pandas
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 →
How to Generate Weekly Sinusoidal Data with Random Noise Using Pandas
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 →
Mastering the SQL LAG Function: Comparing Data Like a Pro
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 →
How to replace the nth occurrence of a word using sed
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 →
AWS: manage ssh keys from the cli
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 →
How to force a Linux server to shutdown if there is no active SSH connection for the last hour
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 →
Linux: How to colorize text in bash scripts
Assume the following scenario, you want to create a script that will colorize strings! simple right? and it is simple but we need first to…
cat linux-how-to-colorize-text-in-bash-scripts.md →
Linux: How to append text to a file only if text does not exist
Assume the following scenario! you have multiple log lines coming from various sources but there is always the chance that there could be…
cat linux-how-to-append-text-to-a-file-only-if-text-does-not-exist.md →
Linux: track a file and send an email when a particular text shows up
Assume that you have to solve the following problem, you have to constantly watch a log file for a specific event and then send an email…
cat linux-track-a-file-and-send-an-email-when-a-particular-text-shows-up.md →