def _chartPie(request, filename, yCol, commaSeparatedColumns):
df, columns = FileOps.GetDataFrame(filename)
selectedColumns = list(
map(lambda x: df.columns[int(x)], commaSeparatedColumns.split(',')))
yCol = df.columns[int(yCol)]
config = BLM.GetConfig(request)
return BLM.Pie.GetMultiplePieCharts(df, selectedColumns, yCol, config)
def _chartStackedBar(request, filename, yCol, commaSeparatedColumns):
df, columns = FileOps.GetDataFrame(filename)
selectedColumns = list(
map(lambda x: df.columns[int(x)], commaSeparatedColumns.split(',')))
yCol = df.columns[int(yCol)]
config = dict(orientation='h')
return BLM.StackedBar(df, selectedColumns, yCol, config)
def _chartTrendAnimation(request, filename, yearCols, yCol, yVal='-'):
df = FileOps.GetDataFrame(filename)[0]
#pdb.set_trace()
config = BLM.GetConfig(request)
if yearCols.find("-") >= 0:
fr, to = [int(t) for t in yearCols.split("-")]
yearCols = ",".join([str(i) for i in range(fr, to)])
return BLM.TrendAnimation(df, yearCols, yCol, config)
def _chartPlot(request, plotName, filename, xCol, yCol, isHorizontal=False):
print("hit the endpoint")
#pdb.set_trace()
df, columns = FileOps.GetDataFrame(filename)
xCol = int(xCol)
yCol = int(yCol)
config = BLM.GetConfig(request)
config['orientation'] = 'h' if isHorizontal == True else 'v'
#print(config)
return BLM.Chart(plotName, df, columns[xCol], columns[yCol], config)
def _chartScatterSize(request, resourceName, xCol, yCol, sizeCol, textCol):
configBase = BLM.GetConfig(request)
df, columns = FileOps.GetDataFrame(resourceName)
xCol = BLM.GetCol(df, xCol)
yCol = BLM.GetCol(df, yCol)
textCol = BLM.GetCol(df, textCol)
sizeCol = BLM.GetCol(df, sizeCol)
#pdb.set_trace()
config = {
**configBase,
**dict(mode='markers',
locked={
**configBase,
**dict(textCol=textCol, sizeCol=sizeCol)
})
}
return BLM.Chart("Scatter", df, xCol, yCol, config)
def _chartTrend(request, api_file, filename, yearCols, yCol, yVal='-'):
#pdb.set_trace()
df = RT.Get(filename,
{}) if api_file == 'api' else FileOps.GetDataFrame(filename)[0]
config = BLM.GetConfig(request)
yCol = int(yCol)
if yearCols.find("-") >= 0:
fr, to = [int(t) for t in yearCols.split("-")]
yearCols = ",".join([str(i) for i in range(fr, to)])
if yVal != '-':
charts = [BLM.TrendChart(df, yearCols, yCol, yVal, config)]
else:
#pdb.set_trace()
charts = [
BLM.TrendChart(df, yearCols, yCol, y, config)
for y in df.iloc[:, yCol].values
]
return charts
def _chartTable(request, filename):
df, columns = FileOps.GetDataFrame(filename)
return BLM.Table(df)
def _chartTimeline(request, filename, timeCol, eventCol):
df, columns = FileOps.GetDataFrame(filename)
config = BLM.GetConfig(request)
return BLM.TimeLine(df, timeCol, eventCol, config)
def _chartSunburst(request, filename, labelCol, parentCol, valCol):
df, columns = FileOps.GetDataFrame(filename)
config = BLM.GetConfig(request)
return BLM.SunBurst(df, labelCol, parentCol, valCol, config)
def _chartGant(request, filename, yCol, startCol, endCol):
df, columns = FileOps.GetDataFrame(filename)
config = BLM.GetConfig(request)
#pdb.set_trace()
return BLM.Gantt(df, yCol, startCol, endCol, config)
def Get(resourceName, filters):
resourceName = resourceName.lower()
df = Ops.GetDataFrameFromJson(
Rest.GetJsonFromName(resourceName, limit=50, filters=filters))
#print(df.columns, flush=True)
return df