HOW TO : Create free clipart
One can leverage the explosion of generative AI art engines to create your own clip art. Here’s a clipart that I created using the prompt “moscow...
HOWTO
HOWTO : SQL Joins
A simple and useful visual of joins in SQL by Taylor Brownlow from this post https://towardsdatascience.com/take-your-sql-from-good-to-great-part-3-687d797d1ede
HOWTO : Query json data in SQLite
A self note for querying json data in SQLite. BTW, I think SQLite is an under utilized and under appreciated swiss army tool for data storage...
HOWTO : Python string search
Quick self-note 🙂 different ways to search for content in a string in python Basic (and quickest) if ‘content’ in string: String.find (second quickest and doesn’t...
HOWTO : Replace first space in a line using Notepad++
Search for ^([^\s]*)(\s) Replace with $1 AND_WHAT_EVER_STRING_YOU_WANT Here is an example of searching for first space in a line and adding “’,” to the string
HOW TO : Add commas (,) at the end of every line using Notepad++
Thanks for this great nugget from Sumama Waheed Many a time, you get some data as a CSV file and need to copy some of that...