161222-1754.tsv

161222-1755.tsv

gistfile1.txt

#!/usr/bin/env python

from sys import argv, exit
from os import listdir, path 
from pandas import DataFrame, read_csv, concat
from datetime import datetime

try:
    folder = argv[1]
    if folder[-1] == '/':
        folder = folder[:-1]
    files = listdir(folder)
except IndexError:
    print("Provide a folder path as argument")
    exit(1)
except FileNotFoundError:
    print("Path is not valid")
    exit(2)


start = 26
end = start + 13
result = []

for file in files:

    timestamp = datetime.strptime(file[start:end], '%y%m%d-%H%M%S')
    print("Parsing file '%s', %r" % (file, timestamp))

    csv_path = path.join(folder, file)
    data = read_csv(csv_path, index_col=0, sep=None, engine='python')
    data.index.name = 'Elevation'

    result.append(DataFrame(data.E355P + data.E355S * 0.12, columns=[timestamp]).T)

result = concat(result, axis=0)
result.index.name = 'Timestamp'