csv_tools.py

import numpy as np


def csv_strip(reader):
    '''
    Removes all rows and columns, which have only blank cells.
    Takes csv.reader instance.
    Returns numpy array of lists
    '''
    data = np.array(list(reader))
    output = data
    indx = 0
    for item in data:
        if not any(item):
            output = np.delete(output, indx, 0)
        else:
            indx += 1

    data = np.transpose(output)

    output = data
    indx = 0
    for item in data:
        if not any(item):
            output = np.delete(output, indx, 0)
        else:
            indx += 1

    return np.transpose(output)