rosiecakes

rosiecakes

#!/System/Library/Frameworks/Ruby.framework/Versions/Current/usr/bin/ruby

# SET YOUR_HOME TO THE ABSOLUTE PATH OF YOUR HOME DIRECTORY
# chmod +x install.rb
# ./install.rb
YOUR_HOME = '/Users/shimadar'

HOMEBREW_PREFIX = "#{YOUR_HOME}/usr/local"
HOMEBREW_CACHE = '/Library/Caches/Homebrew'
HOMEBREW_REPO = 'https://github.com/Homebrew/homebrew'

rosiecakes

# convert 

['2000,1,1,6,9083',
 '2000,1,2,7,8006',
 '2000,1,3,1,11363',
 '2000,1,4,2,13032',
 '2000,1,5,3,12558',
 '2000,1,6,4,12466',
 '2000,1,7,5,12516',
 '2000,1,8,6,8934',

rosiecakes

res_depts = []
res_depts = {d.split(' ')[0] for d in resdf['reason'] if d.split(' ')[0] not in res_depts}

# bad practice but fun

def split_results_per_dept(df):
    """Take all results, and create a dataframe for each dept
        with that departments rows. Add to dictionary
    """
    dept_DFS = {}

rosiecakes

jt -t onedork -tf georgiaserif -nf droidsans  -cellw 900 -lineh 150 -m 200 -cursc r -cursw 5  -T -N  -f roboto -fs 12

(line height isn't great though)

rosiecakes

Homebrew set up to install to /Users/shimadar/usr/local instead of /usr/local

I'm running OSX 10.11.6, Python 3.5.2, pyenv 1.0.6, pyodbc 4.0.1 (via pip). 
Went through [this][1] and connect fine with both tsql and isql as shown in the walkthrough.
Still cannot import pyodbc.

    >>> import pyodbc
    Traceback (most recent call last):
      File "<stdin>", line 1, in <module>
    ImportError: dlopen(/Users/shimadar/.pyenv/versions/3.5.2/lib/python3.5/site-packages/pyodbc.cpython-35m-darwin.so, 2): Library not loaded: /usr/local/opt/unixodbc/lib/libodbc.2.dylib