mlopatka

## foo.Rmd

w=spark.sql("""
select
submission_date_s3,
client_id as cid,
sum(coalesce(scalar_parent_browser_engagement_total_uri_count,0)) as turi,
case when sum(coalesce(scalar_parent_browser_engagement_total_uri_count,0)) >=5 then 1 else 0 end as adau,
cast(sum(coalesce(scalar_parent_browser_engagement_total_uri_count,0))/(sum(active_ticks*5.0/3600)) as float) as turihr
from main_summary
where submission_date_s3>='20180701' and submission_date_s3<='20180707'

## human-web-overview.md

      
        
          
            
              
              1 file
            
          
          
            
              
              0 forks
            
          
          
            
              
              0 comments
            
          
          
            
              
              0 stars
            
          
        
        
          
              
          
          
            
                mlopatka
                / human-web-overview.md
            
            
              Created
              October 18, 2017 07:55
                — forked from solso/human-web-overview.md
            
              
                Human Web Overview
              
          
        
      
        
  
      
    HumanWeb Overview

Konark Modi, Alex Catarineu, Philipp Claßen and Josep M. Pujol at Cliqz
München, October 2016 [edited on October 2017]
Motivation

Human Web is a methodology and system developed by Cliqz to collect data from users while protecting their privacy and anonymity.

	w=spark.sql("""
	select
	submission_date_s3,
	client_id as cid,
	sum(coalesce(scalar_parent_browser_engagement_total_uri_count,0)) as turi,
	case when sum(coalesce(scalar_parent_browser_engagement_total_uri_count,0)) >=5 then 1 else 0 end as adau,
	cast(sum(coalesce(scalar_parent_browser_engagement_total_uri_count,0))/(sum(active_ticks*5.0/3600)) as float) as turihr
	from main_summary
	where submission_date_s3>='20180701' and submission_date_s3<='20180707'