Reduce Date Compression

reduce_compress.py

from functools import reduce

values = df.values
new_values = []
cols = [df.columns.get_loc(d) for d in df.columns if d != "date"]
new_values.append(values[0])

def compress_helper(x, y):
    if (x[cols] == y[cols]).all():
        return x
    new_values.append(y)
    return y

reduce(compress_helper, values)

compressed_df = pd.DataFrame(data=new_values, columns=df.columns)