def get_json_data(self): df = self.get_df() series = df.to_dict('series') chart_data = [] for name, ys in series.items(): if df[name].dtype.kind not in "biufc": continue df['timestamp'] = pd.to_datetime(df.index, utc=False) if isinstance(name, basestring): series_title = name elif len(self.metrics) > 1: series_title = ", ".join(name) else: series_title = ", ".join(name[1:]) d = { "key": series_title, "color": utils.color(series_title), "values": [ {'x': ds, 'y': ys[i]} for i, ds in enumerate(df.timestamp)] } chart_data.append(d) return dumps({ 'chart_data': chart_data, 'query': self.results.query, 'duration': self.results.duration, })
def to_series(self, df, classed="", title_suffix=""): series = df.to_dict("series") chart_data = [] for name in df.T.index.tolist(): ys = series[name] if df[name].dtype.kind not in "biufc": continue df["timestamp"] = pd.to_datetime(df.index, utc=False) if isinstance(name, string_types): series_title = name else: name = ["{}".format(s) for s in name] if len(self.form_data.get("metrics")) > 1: series_title = ", ".join(name) else: series_title = ", ".join(name[1:]) color = utils.color(series_title) if title_suffix: series_title += title_suffix d = { "key": series_title, "color": color, "classed": classed, "values": [{"x": ds, "y": ys[ds]} for i, ds in enumerate(df.timestamp)], } chart_data.append(d) return chart_data
def to_series(self, df, classed='', title_suffix=''): series = df.to_dict('series') chart_data = [] for name in df.T.index.tolist(): ys = series[name] if df[name].dtype.kind not in "biufc": continue df['timestamp'] = pd.to_datetime(df.index, utc=False) if isinstance(name, basestring): series_title = name else: name = ["{}".format(s) for s in name] if len(self.form_data.get('metrics')) > 1: series_title = ", ".join(name) else: series_title = ", ".join(name[1:]) color = utils.color(series_title) if title_suffix: series_title += title_suffix d = { "key": series_title, "color": color, "classed": classed, "values": [ {'x': ds, 'y': ys[i]} for i, ds in enumerate(df.timestamp)] } chart_data.append(d) return chart_data
def get_json_data(self): df = self.get_df() series = df.to_dict('series') chart_data = [] for name, ys in series.items(): if df[name].dtype.kind not in "biufc": continue df['timestamp'] = pd.to_datetime(df.index, utc=False) if isinstance(name, string_types): series_title = name elif len(self.metrics) > 1: series_title = ", ".join(name) else: series_title = ", ".join(name[1:]) d = { "key": series_title, "color": utils.color(series_title), "values": [{ 'x': ds, 'y': ys[i] } for i, ds in enumerate(df.timestamp)] } chart_data.append(d) return dumps({ 'chart_data': chart_data, 'query': self.results.query, 'duration': self.results.duration, })
def to_series(self, df, classed='', title_suffix=''): series = df.to_dict('series') chart_data = [] for name in df.T.index.tolist(): ys = series[name] if df[name].dtype.kind not in "biufc": continue df['timestamp'] = pd.to_datetime(df.index, utc=False) if isinstance(name, string_types): series_title = name else: name = ["{}".format(s) for s in name] if len(self.form_data.get('metrics')) > 1: series_title = ", ".join(name) else: series_title = ", ".join(name[1:]) color = utils.color(series_title) if title_suffix: series_title += title_suffix d = { "key": series_title, "color": color, "classed": classed, "values": [{ 'x': ds, 'y': ys[ds] } for i, ds in enumerate(df.timestamp)] } chart_data.append(d) return chart_data
def get_json_data(self): df = self.get_df() series = defaultdict(list) for row in df.to_dict(orient="records"): series[row["group"]].append(row) chart_data = [] for k, v in series.items(): chart_data.append({"key": k, "color": utils.color(k), "values": v}) return dumps({"chart_data": chart_data, "query": self.results.query, "duration": self.results.duration})
def get_json_data(self): df = self.get_df() series = defaultdict(list) for row in df.to_dict(orient='records'): series[row['group']].append(row) chart_data = [] for k, v in series.items(): chart_data.append({'key': k, "color": utils.color(k), 'values': v}) return dumps({ 'chart_data': chart_data, 'query': self.results.query, 'duration': self.results.duration, })
def get_json_data(self): df = self.get_df() series = defaultdict(list) for row in df.to_dict(orient='records'): series[row['group']].append(row) chart_data = [] for k, v in series.items(): chart_data.append({ 'key': k, "color": utils.color(str(k)), 'values': v }) return dumps(chart_data)
def get_json_data(self): df = self.get_df() series = defaultdict(list) for row in df.to_dict(orient='records'): series[row['group']].append(row) chart_data = [] for k, v in series.items(): chart_data.append({ 'key': k, "color": utils.color(k), 'values': v }) return dumps({ 'chart_data': chart_data, 'query': self.results.query, 'duration': self.results.duration, })
def get_json_data(self): df = self.get_df() series = df.to_dict("series") chart_data = [] for name, ys in series.items(): if df[name].dtype.kind not in "biufc": continue df["timestamp"] = pd.to_datetime(df.index, utc=False) if isinstance(name, string_types): series_title = name elif len(self.metrics) > 1: series_title = ", ".join(name) else: series_title = ", ".join(name[1:]) d = { "key": series_title, "color": utils.color(series_title), "values": [{"x": ds, "y": ys[i]} for i, ds in enumerate(df.timestamp)], } chart_data.append(d) return dumps({"chart_data": chart_data, "query": self.results.query, "duration": self.results.duration})