garrettmarkscott Goto Github PK

asana_to_wrike

Automatically formats Asana .csv file for import into Wrike

automatetheboringpythonpractice

automotivecrmpuller

Pulls CSVs from CRM emails on a daily bases, aggregates the data, then places in Google Sheets for Google Data Studio visualizations

clientzscoregrowth

Pulls from AWS MySQL warehouse, transforms, places to Google Sheet, then emails updated links

crm-data-from-gsheets

All our clients CRM info is manually scraped and placed into various gsheets that share the same columns. This code pulls it all via API for 1 master dataframe to be used for manipulation.

datastudio_cloner

dw3d_dailybenchmarks

Connecting to our Database, Manipulating Data with Pandas, Saving MatPlotLib Graphic, then sending email.

european_soccer_exploring

Using data from Kaggle I am learning/exploring European soccer

googleads_ctr_analysis

googleads_monthly_accountsurfer

If you are a manager that wants to spot check your teams account but so busy you don't have time to dig out a monthly checklist? This is the over-engineered solution you need in your life!

joke_scraping

Following tutorial to scrape the jokes from laughfactory.com

posts

Material for posts

scrapy_demo

tmmsqlqueries

A repo of queries I use to manage our data

udacity_bikeshare_project

Repository for Udacity's Final Project Submission, "Programming for Data Science"

udacity_jupyter

weratedogs_twitter_analysis

wrike_api_exploring

Looking to build better timelog visuals for Wrike task management platform as they are severely lacking at the current time.