Sierra sierra073

## NewLaptop.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                sierra073
                / NewLaptop.md
            
            
              Last active
              November 24, 2020 03:13
            
              
                Notes for setting up a new Mac for development
              
          
    Software to Download

Browsers


Google Chrome
Firefox

Other


Slack
Spotify
Jumpcut or alternative (keeps clipboard history)
Set up Mail app or Boxy Suite for gmail accounts
OneNote


## lat_long_distance.py
def distance(origin, destination):
    '''Haversine distance function to compute distance between 2 lat/long pairs. source: https://gist.github.com/rochacbruno/2883505'''
    lat1, lon1 = origin
    lat2, lon2 = destination
    radius = 3959  # miles

    dlat = math.radians(lat2 - lat1)
    dlon = math.radians(lon2 - lon1)
    a = math.sin(dlat / 2) * math.sin(dlat / 2) + math.cos(math.radians(lat1)) \
        * math.cos(math.radians(lat2)) * math.sin(dlon / 2) * math.sin(dlon / 2)

## pandas_postgres_helpers.py
import os


def generate_create_table_statement_from_df(df, schema, tablename, output_path, **kwargs):
    '''Function to create a PostgreSQL "create table" statement automatically given a pandas dataframe df.
    Other mandatory inputs: schema, tablename, output_path = absolute path to where you want the "create table" sql file to be placed
    Optional: primary_key = [list of strings of column name(s) (in order) that define the primary key]'''
    headers, type_list = generate_headers(df)
    statement = create_table_sql(schema, tablename, headers, type_list, kwargs.get('primary_key', None))
    os.chdir(output_path)

## multiprocess_progress.py
import os
import pandas as pd
import numpy as np
from tqdm import tqdm
import concurrent.futures as cf
from itertools import zip_longest

GITHUB = os.environ.get("GITHUB")

facilities = pd.read_csv('../data/raw/facilities.csv')

## .block
license: mit

## .block
license: mit

## .block
license: mit

## .block
license: mit
	def distance(origin, destination):
	'''Haversine distance function to compute distance between 2 lat/long pairs. source: https://gist.github.com/rochacbruno/2883505'''
	lat1, lon1 = origin
	lat2, lon2 = destination
	radius = 3959 # miles

	dlat = math.radians(lat2 - lat1)
	dlon = math.radians(lon2 - lon1)
	a = math.sin(dlat / 2) * math.sin(dlat / 2) + math.cos(math.radians(lat1)) \
	* math.cos(math.radians(lat2)) * math.sin(dlon / 2) * math.sin(dlon / 2)
	import os


	def generate_create_table_statement_from_df(df, schema, tablename, output_path, **kwargs):
	'''Function to create a PostgreSQL "create table" statement automatically given a pandas dataframe df.
	Other mandatory inputs: schema, tablename, output_path = absolute path to where you want the "create table" sql file to be placed
	Optional: primary_key = [list of strings of column name(s) (in order) that define the primary key]'''
	headers, type_list = generate_headers(df)
	statement = create_table_sql(schema, tablename, headers, type_list, kwargs.get('primary_key', None))
	os.chdir(output_path)
	import os
	import pandas as pd
	import numpy as np
	from tqdm import tqdm
	import concurrent.futures as cf
	from itertools import zip_longest

	GITHUB = os.environ.get("GITHUB")

	facilities = pd.read_csv('../data/raw/facilities.csv')