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…
Konstantinos Patronas
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…
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…
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…
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…
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…
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…
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…
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…
Python Bloom Filter: Check String Existence in a Sea of Billions Without the Storage Bloat
Assume the following scenario, you are developing a Python application that processes content from text files. The files might contain…