While fun, writing code can be very tedious in that it needs to be in a specific format. I use hotstrings to replace words I frequently use but what I also realized is I often have to put parameters into specific format like a quote encapsulated/comma delimited list.
This video shows how I wrote some very simple code that makes it much easier for me to be more productive in my SQL code writing. I have other syntax writers for other languages but the concept stays the same.
Even though I do nearly all my analysis in SPSS, I still prefer to use Excel to graph my data. Unfortunately Excel inverts the legend when graphing. Creating a new variable, or re-coding the old one, is time consuming and errors can creep in. This SPSS macro to invert an ordinal variable with very little work. Saves an amazing amount of time!
It also has a built-in way to filter out too small a sample size.
DEFINE !ISubgp (Var !TOKENS (1) /Cut !TOKENS (1) )
AUTORECODE VARIABLES=!Var /INTO SubGroup /DESCENDING /BLANK=MISSING /PRINT.
AGGREGATE /OUTFILE=* MODE=ADDVARIABLES OVERWRITEVARS=YES /BREAK=subgroup /Sub_CT=N .
Select if Sub_CT >=!Cut.
if missing(Subgroup) Sub_CT=$Sysmis.
!ISubgp Var=Var_toInvert Cut=20 .
The below video demonstrates the usage of the SPSS macro.
Share the clipboard
I wrote a small program with AHK that allows you to share the clipboard with another computer (regardless of where it is). Sometimes I’m using my laptop and copy & then want to paste on my desktop while other times I’m collaborating with my friend in Denmark. Either case is simple for me. All I have to do on one computer is copy it to the clipboard. The other computer can simply paste and the text (or file if you’re in Windows Explorer) will be pasted!
The only requirement is to have a folder that is shared between them. (Use services like Dropbox or Google Drive or a network drive if you are at work. It has been tested on Win XP, Win 7, Win 8 and Windows 10.
Overall Explanation / Review:
How to use ClipShare:
Leveraging the Document Object Model
This third video on Web Scraping gets a little advanced and shows how you can leverage the DOM to make extracting data from a webpage much easier and reliable.
Leveraging the Document Object Model (DOM)will take some practice (especially if you’re not familiar with Object oriented coding) but it is well worth it because it greatly reduces the amount of clean-up you have to do after you extract your data. I used to write some pretty crazy regular expressions to try and clean up my code. Once I learned how to better navigate the DOM it negated the need for cleaning!
Video Leveraging the DOM plus looping over pages
The syntax for writing the writing the web scraping code can be found on my first post here. There is also an AutoHotKey forum thread you might wish to review here.