Author: drweb

Apple iWork is Apple’s suite of office applications, similar to Microsoft Office or Google Docs, consisting of three main applications for documents, spreadsheets, and presentations. iWork files use proprietary formats (.pages, .numbers and .keynote) that are primarily designed to work within the Apple ecosystem. That’s why they can be difficult to open on Linux systems without conversion or third-party applications. If you have a Pages document, Numbers spreadsheet, or Keynote presentation that you need to open on your Linux machine, this guide will walk you through the best options to do so with minimal effort. No need to buy a…

Read More

Think of Statsmodels as Python’s answer to R and Stata. While Python has plenty of libraries for crunching numbers, Statsmodels specifically focuses on statistical analysis and econometric modeling, the kind of work where you need p-values, confidence intervals, and detailed diagnostic tests.The latest version (0.14.5, released July 2025) gives you tools for estimating statistical models, running hypothesis tests, and exploring data with proper statistical rigor. We’re not just talking about making predictions here. Statsmodels helps you understand relationships between variables, test theories, and build models you can actually interpret and defend in front of skeptical stakeholders or peer reviewers.I use…

Read More

Installing Statsmodels takes just a few commands, but the process varies slightly depending on your operating system and Python setup. The library supports Python 3.9 through 3.14, so you’ll need one of these versions installed before starting.I recommend using pip for most installations. Conda works well if you’re managing complex scientific computing environments. Both methods handle dependencies automatically, installing NumPy, SciPy, Pandas, and Patsy alongside Statsmodels.Statsmodel Beginner’s Learning PathWhat you need before installingYour system needs Python 3.9 or newer. Check your version by opening a terminal and running:You should see something like Python 3.12.3 or similar. If your version is…

Read More

Statsmodels organizes its functionality into topic-based subpackages rather than dumping everything into a single namespace. Understanding this structure helps you find the right models quickly and import them efficiently.The library provides two primary access points: statsmodels.api for general use and statsmodels.formula.api for R-style formula syntax. Beyond these, specialized subpackages contain models, tools, and functions organized by statistical domain.Statsmodel Beginner’s Learning PathHow the API structure worksWhen you import statsmodels.api, you’re not loading the entire library. The API module collects the most commonly used classes and functions from various subpackages and presents them through a clean interface.Standard import convention: import statsmodels.api as…

Read More

Mark Lechner, Docker’s CISO, shares his vision for a future where Docker not only powers the software supply chain, but actively safeguards it. Cybersecurity has reached a turning point. The most significant threats no longer exploit isolated systems; they move through the connections between them. The modern attack surface includes every dependency, every container, and every human interaction that connects them.  This interconnected reality is what drew me to Docker. Over the past decade, I’ve defended banks, fintechs, crypto exchanges, and AI startups against increasingly sophisticated adversaries. Each showed how fragile trust becomes when a software supply chain spans thousands…

Read More
SQL

The Power BI Enhanced Report Format (PBIR) will soon become the default, and that’s a good thing because it significantly makes git integration easier. You can already enable it in the preview features of Power BI Desktop (also enable PBIP and TMDL to make git integration of the model itself much easier).There’s also a new admin setting in Power BI/Fabric, which is on by default:I strongly encourage to keep it on It will make certain tasks easier:downloading reports (check out the blog post Export a Power BI Report that cannot be Downloaded on how to do this with the Fabric…

Read More
SQL

I wrote a piece on the new SUBSTRING in SQL Server 2025 and got asked a question. How do we get the last last name, such as only getting “Paolino” from “Miguel Angel Paolino”. This post will show how you can easily do this.Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers.The ScenarioI have a set of names, like those in the Northwind.dbo.Customers table. I want to find the last names only, perhaps for a mailing, or maybe for a search box. I have names like these:Notice line…

Read More

New Relic Inc. unveiled a suite of intelligent observability integrations with Microsoft Azure on Tuesday to streamline incident response and boost developer productivity as enterprises rush to adopt artificial intelligence (AI) workflows. The company’s new AI Model Context Protocol (MCP) Server now feeds real-time observability data directly into Azure’s SRE Agent and Microsoft Foundry, eliminating […]

Read More

In Linux, the ‘cd‘ (Change Directory) command serves as a fundamental navigation tool for both newcomers and experienced system administrators. For administrators working on headless servers, ‘cd‘ represents the primary method for traversing the filesystem to examine logs, execute programs, or perform routine tasks. For those new to Linux, it stands among the initial commands they encounter during their learning process. The command operates through dynamic linking, which allows it to interact directly with the shell’s directory management functions. Since ‘cd‘ is a shell built-in rather than an external binary, it executes with minimal overhead and requires no special privileges…

Read More