Tom Waterman tjwaterman99

## Update soupstars repos
#!/bin/bash

root=$(pwd)

echo "Checking client..."
cd client
git pull
git status
echo "Done"
echo ""

## subquery.sql
# Flags users with a pageview during 2019. Faster than joining!
select
  user.id,
  exists(
    select 1
    from pageviews
    where pageviews.user_id=users.id
      and pageviews.created_at between '2019-01-01' and '2020-01-01'
    limit 1
  ) as "active_2019"

## table.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                tjwaterman99
                / table.md
            
            
              Created
              January 10, 2020 18:49
            
          
A
B
C


0
1
goodbye
False


1
2
cruel
True


2
3
world
False


## timeseries-data.csv

          
            dau
            date

            
              672
              2019-01-01

            
              705
              2019-01-02

            
              538
              2019-01-03

            
              745
              2019-01-04

            
              514
              2019-01-05

            
              721
              2019-01-06

            
              618
              2019-01-07

            
              720
              2019-01-08

            
              732
              2019-01-09

## table2.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                tjwaterman99
                / table2.md
            
            
              Last active
              January 14, 2020 19:19
            
              
                table2.md
              
          
dau
date


672
2019-01-01 00:00:00


705
2019-01-02 00:00:00


538
2019-01-03 00:00:00


745
2019-01-04 00:00:00


514
2019-01-05 00:00:00


## table.csv

          
            Gender
            	Age
            	Height

            
              Female
              	2
              	33.7

            
              Female
              	3
              	37.0

            
              Female
              	4
              	39.5

            
              Female
              	5
              	42.5

            
              Female
              	6
              	45.5

            
              Female
              	7
              	47.7

            
              Female
              	8
              	50.5

            
              Female
              	9
              	52.5

            
              Female
              	10
              	54.5

## earnings.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                tjwaterman99
                / earnings.md
            
            
              Last active
              February 9, 2020 18:08
            
          
Article
Views
Reads
Earnings


Google just published 25 million free datasets
511K
176K
$842


Top features of Pandas 1.0
33K
17.6K
$323


3 Python list comprehension tricks you might not know yet
14.7K
5.9K
$211


Web scraping is now legal
62K
23K
$178


Is No-SQL killing SQL?
47K
13.5K
$157


How to pass the Facebook Data Science interview
25K
11.7K
$143


Why Python is better than R for Data Science careers
21K
6.7K
$37


Fast plotting with Pandas
6.1K
2.7K
$24


## setup.sh
#!/bin/bash

# Install with curl https://gist.githubusercontent.com/tjwaterman99/7eae237c05f2a76ed841a5bba00897d5/raw | bash

# TODO:
# paramaters for $USER, AWS keys, github access token
# docker
# docker-compose
# Heroku
# https://zaiste.net/posts/shell-commands-rust/

## ci.yml
  # For workflow syntax reference, please see the documentation available on Github
# https://docs.github.com/en/actions/reference/workflow-syntax-for-github-actions

name: CI

on:
  push:
  schedule:
    - cron: '50 11 * * *'  # Run the `main` branch daily at 11:50am UTC
  workflow_dispatch: # Allow the workflow to be triggered manually
	#!/bin/bash

	root=$(pwd)

	echo "Checking client..."
	cd client
	git pull
	git status
	echo "Done"
	echo ""
	# Flags users with a pageview during 2019. Faster than joining!
	select
	user.id,
	exists(
	select 1
	from pageviews
	where pageviews.user_id=users.id
	and pageviews.created_at between '2019-01-01' and '2020-01-01'
	limit 1
	) as "active_2019"
	dau	date
	672	2019-01-01
	705	2019-01-02
	538	2019-01-03
	745	2019-01-04
	514	2019-01-05
	721	2019-01-06
	618	2019-01-07
	720	2019-01-08
	732	2019-01-09
dau	date
672	2019-01-01 00:00:00
705	2019-01-02 00:00:00
538	2019-01-03 00:00:00
745	2019-01-04 00:00:00
514	2019-01-05 00:00:00
Gender	Age	Height
Female	2	33.7
Female	3	37.0
Female	4	39.5
Female	5	42.5
Female	6	45.5
Female	7	47.7
Female	8	50.5
Female	9	52.5
Female	10	54.5
Article	Views	Reads	Earnings
Google just published 25 million free datasets	511K	176K	$842
Top features of Pandas 1.0	33K	17.6K	$323
3 Python list comprehension tricks you might not know yet	14.7K	5.9K	$211
Web scraping is now legal	62K	23K	$178
Is No-SQL killing SQL?	47K	13.5K	$157
How to pass the Facebook Data Science interview	25K	11.7K	$143
Why Python is better than R for Data Science careers	21K	6.7K	$37
Fast plotting with Pandas	6.1K	2.7K	$24
	#!/bin/bash

	# Install with curl https://gist.githubusercontent.com/tjwaterman99/7eae237c05f2a76ed841a5bba00897d5/raw \| bash

	# TODO:
	# paramaters for $USER, AWS keys, github access token
	# docker
	# docker-compose
	# Heroku
	# https://zaiste.net/posts/shell-commands-rust/
	# For workflow syntax reference, please see the documentation available on Github
	# https://docs.github.com/en/actions/reference/workflow-syntax-for-github-actions

	name: CI

	on:
	push:
	schedule:
	- cron: '50 11 * * *' # Run the `main` branch daily at 11:50am UTC
	workflow_dispatch: # Allow the workflow to be triggered manually