Make a simple pivot table in Python

Dave Farquhar security
Make a simple pivot table in Python

One of the first things I do when I open a vulnerability scan is make a pivot table on the title of the vulnerability and the count of that title. Then I do the same for all the systems. It’s easy to do in Excel once you’ve seen someone do it once, but if you have a lot of data it can be crash prone. Here’s how to make a simple pivot table in Python.

This example is for Qualys data but it’s easy to adapt it to another scanner. Just change the names of the columns. Python is so much faster and more reliable for this that I rarely make pivots in Excel anymore. I make them in Python, then load the output file in Excel for viewing.
Read more

MOS 74LS logic chips

Dave Farquhar Retro Computing
MOS 74LS logic chips

Commodore (in)famously owned its own chip manufacturer, MOS Technology, later known as Commodore Semiconductor Group. MOS was pivotal to helping Commodore keep prices low in the early 1980s, as it lowered Commodore’s overhead, and ensured a steady supply of chips. In 1983 and 1984, MOS produced 74LS logic chips. These chips are very failure prone. Here’s how to find MOS 74LS logic chips, and more importantly, what to replace them with.

Read more

Game box repair

Dave Farquhar Retro Computing, Toy trains
Game box repair

Vintage computer games and vintage toys display better in their original boxes. But frequently those boxes are in less than ideal condition, especially if you got it at a good price. A pristine box can be worth more than the contents. I recently lucked into a couple of vintage Commodore game cartridge boxes. Their best days were behind them, but I was able to make them presentable again. Here’s my approach to game box repair.

I fixed up quite a few battered books in my day to make them more suitable for resale. The tricks I learned fixing books helped me with fixing game boxes and toy boxes as well.

Read more

Is collecting retro games worth it?

Dave Farquhar Retro Computing
Is collecting retro games worth it?

I saw an interesting perspective this week on the hobby of collecting retro games, from another retro enthusiast. Prices on retro games, he observes, are increasing. That’s making him ask a tough question: Is collecting retro games worth it?

Any hobby seems like a waste of time to the right (or wrong) person. If a hobby, such as collecting retro games, helps you to unwind and get focused, and you can get some of your money back out of it as you lose interest or approach end of life, then I have to argue that hobby is worth it.

Read more

Super glue vs epoxy

Dave Farquhar DIY
Super glue vs epoxy

Super glue and epoxy are two specialty glues that certainly have their uses. But each of them have some pros and cons that will affect your opinion of them. Is epoxy stronger than super glue? Let’s take a look at super glue vs epoxy and when to use each, so you can get the best results possible from each.

Read more

Compaq Presario 425 and 433

Dave Farquhar Retro Computing
Compaq Presario 425 and 433

The Compaq Presario 425 and 433 are popular machines with retro enthusiasts. They are Compaq 486s from 1993, and they look like exactly what they are. They’re well built, have recognizable branding, and don’t take up a lot of space. In some ways they’re the ideal 486 today. Let’s look at why they weren’t necessarily the ideal 486 for 1993, but they, along with the rest of the Presario line, helped transform Compaq anyway.

Read more