create_new_predefined_wvs.py

import numpy as np
from scipy.interpolate import interp1d
import pandas as pd


def import_from_excel(filename, sheetid):
    df = pd.read_excel(filename, sheetid)
    f = interp1d(df.ix[:, 0], df.ix[:, 1])
    minwv = df.ix[:, 0].min()

    newwvs = np.arange(minwv, df.ix[:, 0].max(), 2.5)

    maxwv = newwvs.max()

    values = f(newwvs)

    print("%.3f, %.3f,\nnp.%s)" % (minwv / 1000.0, maxwv / 1000.0, values.__repr__()))

def process_band(df, bandid):
	data = df[[0, bandid]]
	data.columns = [0, 1]
	f = interp1d(data.ix[:, 0], data.ix[:, 1])

	indices = np.where(data.ix[:, 1] > 0.001)[0]
	print(indices)
	minwv = data.ix[indices.min(), 0]
	maxwv = data.ix[indices.max(), 0]
	newwvs = np.arange(minwv, maxwv, 2.5)

	values = f(newwvs)

	values[values < 0.001] = 0.0

	print("%.3f, %.3f,\nnp.%s)" % (minwv / 1000.0, maxwv / 1000.0, values.__repr__()))