Preferred payment types by Industry- Guess I won’t write a check at McD’s

A national study of various industries in 2010 led to some interesting findings for our client in the finance industry.  The below chart displays the preferred payment types by industry by industry.  Given how “cashless” our society has become, it would be very interesting to see how much of a shift from Cash to Credit/Debit cards has occurred.  And does anybody actually write checks anymore?  I keep one in my wallet for “just in case” scenarios but I often go a year or so without using it.

Preferred payment types by Industry

Preferred payment types by Industry

Here’s a great book to get ideas on conveying data visually

Dallas attendance by zip code with drive-time zones- Man we wasted a lot of $

Our Dallas client was adamant that they “drew” from an enormous distance.  And, in truth, they did however when you add it all up and look at the annual attendance for the year, the vast majority of attendance came from a 30 minute drive time.

The below map shows the attendance by zip code overlayed with drive-time zones of 30 minutes, 60 minutes and 90 minutes.  The cost for purchasing mass-media, to reach the outer areas, was definitely not worth the return on investment!

Attendance by zip code

attendance by zip code

If you’re new to GIS analysis, I recommend the following book as good intro.


Here’s a great book to get ideas on conveying data visually

Built-in SciTE Keyboard Shortcuts & Hotkeys: Accelerate your SciTE Usage

SciTE Keyboard Shortcuts & Hotkeys

SciTE Keyboard Shortcuts & Hotkeys

SciTE is a wonderful & powerful editor!  I love using it for AutoHotKey, Python, HTML, SPSS, SQL, XML, and more!  Below are SciTE Keyboard Shortcuts & Hotkeys  to use with SciTE .  I’ve bolded a few of the ones that I use very frequently.  You also may like to check out the documentation.   I have custom SciTE Hotkeys that I’ve added however they require updating files like the user.properties file which review in a this post.

SciTE Keyboard Shortcuts & Hotkeys

Ctrl+Keypad+Magnify text size.
Ctrl+Keypad-Reduce text size.
Ctrl+Keypad/Restore text size to normal.
Ctrl+TabCycle through recent files.
TabIndent block.
Shift+TabDedent block.
Ctrl+BackSpaceDelete to start of word.
Ctrl+DeleteDelete to end of word.
Ctrl+Shift+BackSpaceDelete to start of line.
Ctrl+Shift+DeleteDelete to end of line.
Ctrl+HomeGo to start of document.
Ctrl+Shift+HomeExtend selection to start of document.
Alt+HomeGo to start of display line.
Ctrl+EndGo to end of document.
Ctrl+Shift+EndExtend selection to end of document.
Alt+EndGo to end of display line.
Ctrl+Keypad*Expand or contract a fold point.
Alt+F2Select to next bookmark.
Alt+Shift+F2Select to previous bookmark.
Ctrl+F3Find selection.
Ctrl+Shift+F3Find selection backwards.
Ctrl+UpScroll up.
Ctrl+DownScroll down.
Ctrl+LLine cut.
Ctrl+Shift+TLine copy.
Ctrl+Shift+LLine delete.
Ctrl+TLine transpose with previous.
Ctrl+DSelection duplicate.   (Great to use in SciTE editor)
Ctrl+KFind matching preprocessor conditional, skipping nested ones.
Ctrl+Shift+KSelect to matching preprocessor conditional.
Ctrl+JFind matching preprocessor conditional backwards, skipping nested ones.
Ctrl+QComment out line  (Great to use in SciTE editor)
Ctrl+Shift+JSelect to matching preprocessor conditional backwards.
Ctrl+[Previous paragraph. Shift extends selection.
Ctrl+]Next paragraph. Shift extends selection.
Ctrl+LeftPrevious word. Shift extends selection.
Ctrl+RightNext word. Shift extends selection.
Ctrl+/Previous word part. Shift extends selection
Ctrl+\Next word part. Shift extends selection.
Alt+Shift+MovementRectangular block selection.
Alt+Shift+HomeExtend rectangular selection to start of line.
Alt+Shift+EndExtend rectangular selection to end of line.

 

SciTE Keyboard Shortcuts & Hotkeys

(Regular Expressions) RegEx to clean text on funky SPSS labels

RegEx to clean text

RegEx to Clean Text

I used to work in Market Research and would spend hours cleaning up labels from surveys I’d programmed in online tools. The below video shows how easy it can be if you understand regular expressions and a little programming.

Regular Expressions can have a steep learning curve however it is really worth it if you continually get data that you need to clean.  You can also check out this post of mine showing how they can be used to automate your metrics.

Regex on funky labels

A handy cheat-sheet is downloadable from here and a wonderful course from Kevin Skoglund available from Lynda.com is available here.  Below is a great intro to the Regular Expressions.

An introduction to regular expressions | lynda.com overview

Regex to clean text in preparation for word count in PHP – Code …

Jan 25, 2014 … a question; Anybody can answer; The best answers are voted up and rise to the top. Regex to clean string in preparation for word count in PHP …

php – Match all youtube links in a string of text – Code Review Stack …

Apr 7, 2015 Regular expressions to clean text in preparation for word count in PHP · 0 · Remove parameters from string containing URL · 4 · Normalizing strings using …

php – Regex to remove inline javascript from string – Code Review …

Aug 21, 2013 Regex to clean text in preparation for word count in PHP · 2 · Regex-ing an array · 2 · Removing stray brackets from in between shortcodes.