Skip to content

Instantly share code, notes, and snippets.

@ryw89

ryw89/data_tech_interns.org

Created March 15, 2021 18:31
Show Gist options
  • Save ryw89/adaffe1c51b24bb77a6c4185db3396a8 to your computer and use it in GitHub Desktop.
Save ryw89/adaffe1c51b24bb77a6c4185db3396a8 to your computer and use it in GitHub Desktop.
Download ZIP
Data / tech intern projects
Raw
data_tech_interns.org

Sign up for Github

Will send invites for Redash

Projects

10DLC

SQL queries

Visualization

Google Data Studio

Daily report from Telnyx

CSV export from Telnyx, then place in AWS S3

Ad-hoc SQL queries

Redshift

AWS Athena

Based on PrestoDB syntax

Note: Charged by data size of query

Ad-hoc data cleaning

Often to support data analysis

Joining data from different sources

Example: Demographic data from census & our own treatment/control data

Skills

Python (Pandas)

R

App maintenance

Bug fixes / Feature requests

Reading others’ codebases

Python

Flask

Using REST APIs

pytest

selenium

Knowledge of building own Python packages

Docker (less important)

Ad-hoc projects

Previous examples:

Web scraping

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment