Time in PC
A Windows application to keep track of time spent in computer.
July 2015 - Tools: F# .NET, sqlite
Journeyman Series: From Journeyman to Master
Micro blogs about 2 different topics that I’m very passionate about. Sort of an experiment to test whether they will help me develop further on the topics.
I plan to post there frequently findings that helped develop my learning on the topic.
January 2015 - Tools: Tumblr
Guitar Tools in Excel
- Music interval training:
- Improvisation and Guitar Scales: intervals.zip
July 2014 - Tools: Excel
Statistical Tools in Excel
- Calculating a confidence Interval: confidence_interval.xlsm, [demo]
- AB test significance: hypothesis testing proportion.xlsm, [demo]
- Histogram: histogram.xlsm, [demo]
- Box-plot: boxplot.xlsm, [demo]
- 2x Box-plot, side by side: boxplot2.xlsm, [demo]
- Tracking Excel usage with Google analytics - screencast
July 2014 - Tools: Excel
Stocks price monitor
Waiting for a stock price to rise to a certain value to sell it? or waiting for the price to drop to a certain value to buy it? But don’t want to be checking it every day? Here’s a little automation that check it for you.
This script will send you an email when stock price is outside the defined thresholds.
Also, have done before the same in ruby.
Picsort - Picture organizer
After downloading photos from a camera, this application organizes the pictures into folders, so that you/me don’t have to do that manually.
Also, have done the same in ruby and in python.
In Page Debug tool
A visual debug tool to inspect custom tracking code placed in the different html elements of a web page, to ease the debugging of web analytics tracking code.
Table.query (aka R’s sqldf in Ruby)
A small library that given a set of data it transparently inserts it into a sqlite database and then allows for very flexible querying (SQL). Usefull for ad-hoc data tasks that read data from some file or api that require quick analysis. Adding data into a sqlite database will also allow for the data to be bigger than memory can fit. Inspired by R’s sqldf.
A framework for building up interactive html dashboards in ruby. Contains implementation of both simple & multivariate regression for visualizing trends, supports fetching email attachments / content as data sources, allows for posting the end result onto a confluence wiki page.
Linear & Logistic Regression
A collection of exercises from the OpenClassRoom machine learning classes. Serve as a reference in implementing linear and logistic regression with some added debugging features in R.
- linear regression: web
- multivariate linear regression: web
- logistic regression and Newton’s method: web
- regularized linear regression: web
- regularized logistic regression: web
March 2011 - Tools: R
cov3 - Custom Web Crawler
jQuery Twitter ‘mini’ plugin
A jQuery plugin to display a twitter feed on a web page(blog for example). The twitter api feed, i found, has an annoying particularity of not always returning the requested number of tweets, so i added a feature that until it gets the right amount of messages it keeps on fetching. Thats useful when you want to fill a web page space with exactly 3 messages. Also included a “time ago” date calculations based of john resig code, with an added local timezone shift.
The Daily Extract
Scripts that automate the process of aggregating data in a database, extracting it, outputting results into csv files and sending them over by sftp. Very feature rich: task list queue, full logging, email reports, sql templating, sftp support, extract volume validation, unit testing. And with a strong convention over configuration theme.
In Aug 2009 i did a somewhat similar 2nd version of the daily extract, but this time using clojure, with added features: web front end for task queue manipulation, statistics on extracted volumes and sqlite for storing the task list queue and statistics over time.
code - 2007&2009 - Tools: ruby, jruby, clojureTweet
comments powered by Disqus