tjwaterman99

  # 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

tjwaterman99

#!/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/

tjwaterman99

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

tjwaterman99

tjwaterman99

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

tjwaterman99

tjwaterman99

	A	B	C
0	1	goodbye	False
1	2	cruel	True
2	3	world	False

tjwaterman99

# 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" 

tjwaterman99

#!/bin/bash

root=$(pwd)

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