drorata

drorata

drorata

drorata

-- Compute the ratios of each type of status from the overall count
-- After re-learning it over and over again, it is time to document this useful snippet.
-- I hope my future-self will find it.

SELECT status,
       c,
       c / cast((sum(c) over ()) AS float) AS ratio
FROM
  (SELECT status,
          count(*) AS c

drorata

drorata

drorata

drorata

import pandas as pd
import sklearn
from sklearn.preprocessing import StandardScaler


class GetDummiesCatCols(sklearn.base.BaseEstimator, sklearn.base.TransformerMixin):
    """Replace `cols` with their dummies (One Hot Encoding).

    `cols` should be a list of column names holding categorical data.
    Furthermore, this class streamlines the implementation of one hot encoding

drorata

Hello World

drorata

--- A query that count the number of positive/zero/negatives of the column 'value'
--- and group it by the year-month
WITH t AS
  ( SELECT value,
           YEAR,
           MONTH
   FROM my_table AS l
   )
SELECT YEAR,
       MONTH,