copy/paste numpy arrays to/from excel (os x)

gistfile1.py

import subprocess
import tempfile
import numpy as np
import os

def npArrayFromClipboard():
    """Reads the current clipboard and tries to make an numpy array out of it"""

    p = subprocess.Popen(['pbpaste'], stdout=subprocess.PIPE)
    output = p.communicate()
    return np.array([i.split('\t') for i in output[0].split('\r')])
        
def openArrayInExcel(A):
    """create a temporary file from a 1 or 2D numpy array and open it in excel.
    works on OS X"""

    t = tempfile.NamedTemporaryFile(suffix='.csv', delete=False)
    np.savetxt(t.file, A, delimiter=',')
    t.file.close()
    os.system('open ' + t.name)