Category Archives: Data

Are you Smart yet? Will everything become Smart someday?

Everything is getting capital ‘S’ Smart these days. Smart phones, Smart homes, Smart cars, in EPIC there are ‘Smart phrases’, and even a local cafe chain has something called Smart beans…. The Smart trend lumps together intelligent networks, big data, … Continue reading

Posted in Data | Tagged , , | Comments Off on Are you Smart yet? Will everything become Smart someday?

MySQL query for obtaining unique list of domain names with count from email field

The following MySQL query is useful for getting a count of all the domain names used by email addresses in your database.  It isolates the domain name (after the @ sign) in the email field. SELECT substring_index(email, ‘@’, -1), COUNT(*) … Continue reading

Posted in Code, Data | Comments Off on MySQL query for obtaining unique list of domain names with count from email field

The Art of Spreadsheet-Fu – tips for manipulating data with Excel, OpenOffice, or Google Drive Spreadsheets

This post demonstrates 5 examples of Spreadsheet-Fu to make quick work of menial data formatting tasks. Spreadsheet programs have useful functions built into them for string manipulation (concatenation, search and replace, formatting, etc).   It used to be just Excel and Open … Continue reading

Posted in Data, For New Developers | Tagged , | Comments Off on The Art of Spreadsheet-Fu – tips for manipulating data with Excel, OpenOffice, or Google Drive Spreadsheets