In [ ]:
import pandas

In [ ]:
data = pandas.read_csv('all120326_1544.gain', sep="\(Hz\)\s*|\s+")
data.head()

In [ ]:
def make_config_for(data_column, title=None, values_per_line=5, max_field_length=18, for_pmt_zero=0):
    tab = "    "
    if title is None:
        title=data_column
    result = str(title) + " = [\n"
    if for_pmt_zero is not None:
        result += "# 0  ".rjust(max_field_length) + " -- PMT zero is fake!\n"
        result += ("%s, " % for_pmt_zero).rjust(max_field_length)
    for i, d in data.iterrows():
        if i%values_per_line == 0:
            result += "\n" + ''.join([str("# %s  " % ch).rjust(max_field_length) 
                                      for ch in range(i+1,
                                                      min(i+1+values_per_line, len(data)+1))]) + "\n"
        result += ("%s, " % d[data_column]).rjust(max_field_length)
    return result + "\n%s]" % tab

In [ ]:
print(make_config_for("sigma", "gain_sigmas"))

In [ ]:
print(make_config_for("sigma", "gain_sigmas"))