Felipe Hoffa fhoffa

## top_reddit_words.md

      
              1 file
            
          
              1 fork
            
          
              1 comment
            
          
              4 stars
            
          
                fhoffa
                / top_reddit_words.md
            
            
              Last active
              September 1, 2021 20:08
            
              
                The top 5 words for the top subreddits
              
          
    The top 5 words for the top subreddits:


subr
words


pics
hell,minutes,hospital,build,backyard


funny
soon,wanted,dads,photos,sums


videos
better,change,plane,simple,curiosity


politics
subject,democrat,democracy,basis,google


technology
streaming,snowden,fast,edward,sued


## bq-sample.ipynb

      
              1 file
            
          
              1 fork
            
          
              0 comments
            
          
              1 star
            
          
                fhoffa
                / bq-sample.ipynb
            
            
              Created
              September 3, 2013 23:10
            
          
        Loading

      Sorry, something went wrong. Reload?
      Sorry, we cannot display this file.
      Sorry, this file is invalid so it cannot be displayed.
      
          Viewer requires iframe.
      
    
## planes_correlation.ipynb

      
              1 file
            
          
              1 fork
            
          
              0 comments
            
          
              1 star
            
          
                fhoffa
                / planes_correlation.ipynb
            
            
              Last active
              December 22, 2015 10:29
            
              
                Planes correlation
              
          
        Loading

      Sorry, something went wrong. Reload?
      Sorry, we cannot display this file.
      Sorry, this file is invalid so it cannot be displayed.
      
          Viewer requires iframe.
      
    
## reddit.top.demo.ipynb

      
              1 file
            
          
              1 fork
            
          
              0 comments
            
          
              1 star
            
          
                fhoffa
                / reddit.top.demo.ipynb
            
            
              Last active
              December 22, 2015 12:28
            
          
        Loading

      Sorry, something went wrong. Reload?
      Sorry, we cannot display this file.
      Sorry, this file is invalid so it cannot be displayed.
      
          Viewer requires iframe.
      
    
## io sensors correlation plots.bin
{
 "metadata": {
  "name": "io sensors correlation plots"
 },
 "nbformat": 3,
 "nbformat_minor": 0,
 "worksheets": [
  {
   "cells": [
    {

## reddit.bigrams.ipynb

      
              1 file
            
          
              1 fork
            
          
              0 comments
            
          
              1 star
            
          
                fhoffa
                / reddit.bigrams.ipynb
            
            
              Last active
              December 22, 2015 18:29
            
          
        Loading

      Sorry, something went wrong. Reload?
      Sorry, we cannot display this file.
      Sorry, this file is invalid so it cannot be displayed.
      
          Viewer requires iframe.
      
    
## twiliocon2.ipynb

      
              1 file
            
          
              1 fork
            
          
              0 comments
            
          
              1 star
            
          
                fhoffa
                / twiliocon2.ipynb
            
            
              Created
              September 19, 2013 18:18
            
          
        Loading

      Sorry, something went wrong. Reload?
      Sorry, we cannot display this file.
      Sorry, this file is invalid so it cannot be displayed.
      
          Viewer requires iframe.
      
    
## appengine load.ipynb

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                fhoffa
                / appengine load.ipynb
            
            
              Created
              September 24, 2013 21:00
            
          
        Loading

      Sorry, something went wrong. Reload?
      Sorry, we cannot display this file.
      Sorry, this file is invalid so it cannot be displayed.
      
          Viewer requires iframe.
      
    
## bigquery discovering data.ipynb

      
              1 file
            
          
              1 fork
            
          
              0 comments
            
          
              1 star
            
          
                fhoffa
                / bigquery discovering data.ipynb
            
            
              Last active
              December 23, 2015 23:09
            
          
        Loading

      Sorry, something went wrong. Reload?
      Sorry, we cannot display this file.
      Sorry, this file is invalid so it cannot be displayed.
      
          Viewer requires iframe.
      
    
## correlation between rows.sql
SELECT CORR(a.value, b.value), a.rowid, b.rowid
FROM
(
SELECT column, value, rowid FROM
(
SELECT 'c1' column, c1 AS value, rowid
FROM
(SELECT 1 c1, 2 c2, 3 c3, 'id1' rowid), (SELECT 9 c1, 2 c2, 3 c3, 'id2' rowid), (SELECT 4 c1, 1 c2, 3 c3, 'id3' rowid)
),
(
subr	words
pics	hell,minutes,hospital,build,backyard
funny	soon,wanted,dads,photos,sums
videos	better,change,plane,simple,curiosity
politics	subject,democrat,democracy,basis,google
technology	streaming,snowden,fast,edward,sued
	{
	"metadata": {
	"name": "io sensors correlation plots"
	},
	"nbformat": 3,
	"nbformat_minor": 0,
	"worksheets": [
	{
	"cells": [
	{
	SELECT CORR(a.value, b.value), a.rowid, b.rowid
	FROM
	(
	SELECT column, value, rowid FROM
	(
	SELECT 'c1' column, c1 AS value, rowid
	FROM
	(SELECT 1 c1, 2 c2, 3 c3, 'id1' rowid), (SELECT 9 c1, 2 c2, 3 c3, 'id2' rowid), (SELECT 4 c1, 1 c2, 3 c3, 'id3' rowid)
	),
	(