Newer
Older
#! /usr/bin/env python
# -*- coding: utf-8 -*-
import numpy as np
import pandas as pd
from saqc.core.core import prepareMeta, readMeta
David Schäfer
committed
from saqc.core.config import Fields as F
def initData(cols=2, start_date="2017-01-01", end_date="2017-12-31", freq="1h"):
dates = pd.date_range(start=start_date, end=end_date, freq=freq)
data = {}
dummy = np.arange(len(dates))
for col in range(1, cols+1):
data[f"var{col}"] = dummy*(col)
return pd.DataFrame(data, index=dates)
def initMetaString(metastring, data):
cleaned = re.sub(r"\s*,\s*", r",",
re.sub(r"\|", r",",
re.sub(r"\n[ \t]+", r"\n",
metastring)))
fobj = io.StringIO(cleaned)
meta = prepareMeta(readMeta(fobj), data)
fobj.seek(0)
return fobj, meta
David Schäfer
committed
def _getKeys(metadict):
keys = list(metadict[0].keys())
for row in metadict[1:]:
for k in row.keys():
if k not in keys:
keys.append(k)
return keys
def initMetaDict(metadict, data):
David Schäfer
committed
df = pd.DataFrame(metadict)[_getKeys(metadict)]
meta = prepareMeta(df, data)
fobj = io.StringIO()
fobj.seek(0)
return fobj, meta