Skip to content

Instantly share code, notes, and snippets.

View ttresslar's full-sized avatar

Tyler Tresslar ttresslar

5 followers · 12 following
  • Africa
View GitHub Profile
@ttresslar
ttresslar / ssToSQLInsert.gs
Last active February 1, 2020 22:49
//Setting Global variables for the apps I'll be using
var SS = SpreadsheetApp.getActiveSheet()
var UI = SpreadsheetApp.getUi();
//On open is a reserved function. It runs every time a user opens the sheet.
//I'm using it to make the menu
function onOpen() {
var UI = SpreadsheetApp.getUi();
UI.createMenu('Data Archtects')
.addItem('Insert This data', 'makeItHot')
@ttresslar
ttresslar / EpicollectQGIS.py
Created August 23, 2019 09:54
#!/usr/bin/env python3
# -*- coding: utf-8 -*-
#This is a short script I created to add epicollect entries to QGIS.
"""
Created on Mon Mar 25 05:14:27 2019
@author: ttresslar
"""
@ttresslar
ttresslar / gsQGIS.py
Created August 23, 2019 09:51
#This is designed to be used with the google sheets python api
#Please see the "https://developers.google.com/sheets/api/quickstart/python" Google Python API Quickstart and follow the steps listed there.
#You will need to authorize the API and download a file called "credentials.json" for the account you wish to use
#load the required packages/libraries/etc
from __future__ import print_function
import pickle
import os.path
from googleapiclient.discovery import build
@ttresslar
ttresslar / multithread_scraping.py
Created August 16, 2019 09:26
import pandas as pd
import requests, re, datetime, urllib.parse
from bs4 import BeautifulSoup as bs
from multiprocessing.pool import ThreadPool
def get_datelist():
base_time = datetime.datetime.today()
base_time = base_time.replace(hour=0, second=0, minute=0, microsecond=0)
date_list = [base_time + datetime.timedelta(days=x) for x in range(1, 15)]
@ttresslar
ttresslar / exploring_epicollect.html
Last active August 13, 2019 13:08
<!DOCTYPE html>
<html>
<head><meta charset="utf-8" />
<title>exploring_epicollect</title>
<script src="https://cdnjs.cloudflare.com/ajax/libs/require.js/2.1.10/require.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/jquery/2.0.3/jquery.min.js"></script>
@ttresslar
ttresslar / instabot1.py
Created May 14, 2019 17:09 — forked from fnneves/instabot1.py
from selenium import webdriver
from selenium.webdriver.common.keys import Keys
from time import sleep, strftime
from random import randint
import pandas as pd
chromedriver_path = 'C:/Users/User/Downloads/chromedriver_win32/chromedriver.exe' # Change this to your own chromedriver path!
webdriver = webdriver.Chrome(executable_path=chromedriver_path)
sleep(2)
webdriver.get('https://www.instagram.com/accounts/login/?source=auth_switcher')