Kick out your passengers fairly

Posted on Posted in Math

THE PROBLEM At Coders Co. we make the world a better place by helping airlines to kick out their passengers in a fair way. We all heard that using bad algorithms generates a very wrong kind of buzz on social media. Fortunately, it doesn’t have to be the case. In the following lines, we provide […]

Our projects

Posted on Posted in The Company

The coders at Coders Co. have led many projects where solid understanding of math and modeling made the results exceed expectations. That is to be expected if experienced, smart, coders adopt a problem. Real coders love to solve complex challenges with the simplest solutions possible, but not simpler than that. Coding is fun if coding […]

Sort by Regex

Posted on Posted in Coding

Rax string reduction, /cat(), on the IMPALA backend was not trivial to implement. The IMPALA documentation states: GROUP_CONCAT … does not support the OVER clause, … Effectively this means no ORDER BY on GROUP_CONCAT in IMPALA. This must be implemented eventually, because the whole GROUP_CONCAT has limited use without it. Meantime, regexes can be used […]

Unveiling the online journey with Rax

Posted on Posted in Customer Journey

Introduction It is generally believed that there is a lot of valuable information hidden in people’s online-behavior data. By uncovering patterns in this behaviour, we could possibly achieve better segmentation and ad targeting, better website personalization, etc. However, looking for patterns in the (online) behavioral data is not easy. It requires being able to handle […]

Rax 1.1 released

Posted on Posted in Rax

We are happy to announce that Rax 1.1 is avalaible from today! This release contains many stability and performance improvements. Most importantly: Added r’years and a’weeks magic tags to relative duration. Added a sample \ operator for sets: some_set\10 will list random 10 elements of some_set. In explorative analytics scenarios this is handy as it’s […]

R comes to SQL Server

Posted on Posted in Rax, SQL Rants

Database vendors understand that SQL, while great for simple queries, is not a good enough interface for complex analytics. Here at Coders’Co. we would say: use Rax :-). Since R so popular among data scientists, though, many database vendors attempt to somehow integrate R into their technology. This post is the beginning of a series […]

Sessionization with Temporal Union

Posted on Posted in Big-Data Blab, Rax

A common problem in web analytics is sessionization or session reconstruction: taking a series of user events and splitting the series into a set of sessions [1]. Often, it is done based solely on the timestamps of the events: a session ends after a certain time of user inactivity. As an example, let’s take the […]