How to clean up your data in the command line
May25

How to clean up your data in the command line

I work part-time as a data auditor. Think of me as a proofreader who works with tables of data rather than pages of prose. The tables are exported from relational databases and are usually fairly modest in size: 100,000 to 1,000,000 records and 50 to 200 fields. I haven’t seen an error-free data table, ever. The messiness isn’t limited, as you might think, to duplicate records, spelling and formatting errors, and data...

Read More
How insecure is your router?
May25

How insecure is your router?

I’ve always had a problem with the t-shirt that reads, “There’s no place like 127.0.0.1.” I know you’re supposed to read it as “home,” but to me, it says, “There’s no place like localhost,” which just doesn’t have the same ring to it. And in this post, I want to talk about something broader: the entry point to your home network, which for most people will be a cable or...

Read More