Makefiles are super cool, they help you create an executable process. Why run files manually or update everything when only a few files changed? Established in 1976 and not at all obsolete in 2022, Makefiles still have their place. Sounds great right? It is, unless you are running windows and don’t have access to a Unix (or Unix-like) operating system. I highly recommend getting a raspberry pi if you need a Unix system. It’s a flexible and light weight solution…
Well…are you? In a conversation between a few colleagues the concept of a correlation came up. I made a comment that we couldn’t be certain that the correlation formula was being applied correctly by our software, and therefore, we shouldn’t use it (typical black box). To my surprise, my colleague asked me “what’s the difference?” not knowing that using certain correlation formulas for certain data sets is inappropriate and inaccurate. It prompted me to write this article about the four…
Anaconda is a great tool to manage Python packages and host multiple environments easily. It gives a ton of “standard” packages on the initial install, and provides a simple platform to create and remove different Python states. In this video I’ll demonstrate the installation with some critical options, as well as show how to set up and move between environments.
Check out the new video about bullet journaling to keep track of your project work. This is a great technique that I use everyday to organize tasks. While we living in a digital world there is still a place for paper notes!
Many uses of python involve connections to APIs, databases, or hosted information. Embedding a password in a script is always a bad idea. You can easily forget it is there, and inadvertently share confidential information with others. This is especially important if you regularly are posting content to a public GitHub. CSV files Storing important content doesn’t need to be complicated. Simply creating a CSV file that has the information you need in tabular format will certainly do the job….
Check out the new video on timeseries, completing the tutorials of how to segment data for more effective aggregation. In the first two videos I showed how to do this in excel and libre office, the next video uses more technical methods. This video uses the pandas library with some help from datetime to slice up our data following the previous example. Pandas will be a common tool for data munging and is very versatile. The methods shown in this…
Today we are going to explore some of the ways you can connect to sql databases with python. A few examples of why you would want to do this are: Querying large data sets without the need to store the data in an intermediate step. To combine data from several disparate databases. To use as a wrapper for an application (sqlite, mariadb, etc) Extracting data from an application with a hosted database. Let’s dive in and explore the different ways…
As a content creator you may be posting videos to premier or publish videos live. When doing so, would you like a record of the chat? This would allow you to analyze content and look for positive or negative reactions. If this interests you then pytchat is going to be a big help. First, the docs provide minimal help, the code they provide either gives you raw json format *****puke***** or requires you to wait eons to see the data….
Check out the new video on Libre Calc, a great alternative to excel and google products. In this video we replicate the excel tutorial and show basic time series functions. I also pivot/visualize the data, and this is completed in a few simple steps. Why do I like Libre Calc? Its free, Microsoft office follows a SAS model and that’s not something I’m too fond of. Other free hosted material has access to your data, so if you want to…