def Histogram(request):
dataset = exportCSVdata()
allcols = list(dataset.columns)
totalrecords = dataset.shape[0]
if request.method == 'POST':
x_data_string = request.POST['rangeNo'].strip()
for i in x_data_string:
if i == ':':
k = x_data_string.index(i)
x_1strange = int(x_data_string[:k])
x_2strange = int(x_data_string[k + 1:])
hist_array = request.POST['hist_array'].strip()
bin_size = int(request.POST['bin_size'].strip())
hist_array_plot = dataset[x_1strange:x_2strange][hist_array]
layout = go.Layout(title=f" Value Distribution for {hist_array}")
hist = go.Histogram(x=hist_array_plot, nbinsx=bin_size)
fig = go.Figure(data=[hist], layout=layout)
plt_div = fig.to_html(full_html=True)
context = {
'totalrecords': totalrecords,
'allcols': allcols,
'plot_div': plt_div
}
return render(request, 'histogram.html', context)
else:
context = {'totalrecords': totalrecords, 'allcols': allcols}
return render(request, 'histogram.html', context)
def HorizontalBar(request):
dataset = exportCSVdata()
allcols = list(dataset.columns)
totalrecords = dataset.shape[0]
if request.method == 'POST':
x_data_string = request.POST['rangeNo'].strip()
for i in x_data_string:
if i == ':':
k = x_data_string.index(i)
x_1strange = int(x_data_string[:k])
x_2strange = int(x_data_string[k + 1:])
y_data = request.POST['y_axis'].strip()
x_1 = request.POST['x_1'].strip()
x_2 = request.POST['x_2'].strip()
x_3 = request.POST['x_3'].strip()
y_plot = dataset[x_1strange:x_2strange][y_data]
x_1plot = dataset[x_1strange:x_2strange][x_1]
x_2plot = dataset[x_1strange:x_2strange][x_2]
x_3plot = dataset[x_1strange:x_2strange][x_3]
fig = go.Figure()
fig.add_trace(
go.Bar(y=y_plot,
x=x_1plot,
name='x1',
orientation='h',
marker=dict(color='rgba(246, 78, 139, 0.6)')))
fig.add_trace(
go.Bar(y=y_plot,
x=x_2plot,
name='x2',
orientation='h',
marker=dict(color='rgba(58, 71, 80, 0.6)')))
fig.add_trace(
go.Bar(y=y_plot,
x=x_3plot,
name='x3',
orientation='h',
marker=dict(color='rgba(25, 71, 45, 0.6)')))
fig.update_layout(barmode='stack')
plt_div = fig.to_html(full_html=True)
context = {
'totalrecords': totalrecords,
'allcols': allcols,
'plot_div': plt_div
}
return render(request, 'horizontal_bar.html', context)
else:
context = {'totalrecords': totalrecords, 'allcols': allcols}
return render(request, 'horizontal_bar.html', context)
def MultipleLine(request):
dataset = exportCSVdata()
allcols = list(dataset.columns)
totalrecords = dataset.shape[0]
if request.method == 'POST':
x_data_string = request.POST['rangeNo'].strip()
for i in x_data_string:
if i == ':':
k = x_data_string.index(i)
x_1strange = int(x_data_string[:k])
x_2strange = int(x_data_string[k + 1:])
x_data = request.POST['x_axis'].strip()
y_g1 = request.POST['y_g1'].strip()
y_g2 = request.POST['y_g2'].strip()
y_g3 = request.POST['y_g3'].strip()
y_g4 = request.POST['y_g4'].strip()
x_plot = dataset[x_1strange:x_2strange][x_data]
y_g1_plot = dataset[x_1strange:x_2strange][y_g1]
y_g2_plot = dataset[x_1strange:x_2strange][y_g2]
y_g3_plot = dataset[x_1strange:x_2strange][y_g3]
y_g4_plot = dataset[x_1strange:x_2strange][y_g4]
fig = make_subplots(rows=2, cols=2)
fig.add_trace(go.Scatter(x=x_plot, y=y_g1_plot, name=f"{y_g1}"),
row=1,
col=1)
fig.add_trace(go.Scatter(x=x_plot, y=y_g2_plot, name=f"{y_g2}"),
row=1,
col=2)
fig.add_trace(go.Scatter(x=x_plot, y=y_g3_plot, name=f"{y_g3}"),
row=2,
col=1)
fig.add_trace(go.Scatter(x=x_plot, y=y_g4_plot, name=f"{y_g4}"),
row=2,
col=2)
fig.update_layout(title=f'Multiple Line Graphs: X_axis:{x_data} ')
plt_div = fig.to_html(full_html=True)
context = {
'totalrecords': totalrecords,
'allcols': allcols,
'plot_div': plt_div
}
return render(request, 'multiple_line.html', context)
else:
context = {'totalrecords': totalrecords, 'allcols': allcols}
return render(request, 'multiple_line.html', context)
def BarGraph(request):
dataset = exportCSVdata()
allcols = list(dataset.columns)
totalrecords = dataset.shape[0]
if request.method == 'POST':
x_data_string = request.POST['rangeNo'].strip()
for i in x_data_string:
if i == ':':
k = x_data_string.index(i)
x_1strange = int(x_data_string[:k])
x_2strange = int(x_data_string[k + 1:])
x_data = request.POST['x_axis'].strip()
y_data1 = request.POST['y_axis1'].strip()
y_data2 = request.POST['y_axis2'].strip()
y_data3 = request.POST['y_axis3'].strip()
x_plot = dataset[x_1strange:x_2strange][x_data]
y_plot1 = dataset[x_1strange:x_2strange][y_data1]
y_plot2 = dataset[x_1strange:x_2strange][y_data2]
y_plot3 = dataset[x_1strange:x_2strange][y_data3]
bar1 = go.Bar(name=f'{y_data1}', x=x_plot, y=y_plot1)
bar2 = go.Bar(name=f'{y_data2}', x=x_plot, y=y_plot2)
bar3 = go.Bar(name=f'{y_data3}', x=x_plot, y=y_plot3)
layout = go.Layout(
title=
f"Bar graph for {x_data} over {y_data1}, {y_data2} & {y_data3}")
fig = go.Figure(data=[bar1, bar2, bar3], layout=layout)
plt_div = fig.to_html(full_html=True)
context = {
'totalrecords': totalrecords,
'allcols': allcols,
'plot_div': plt_div
}
return render(request, 'bar_graph.html', context)
else:
context = {'totalrecords': totalrecords, 'allcols': allcols}
return render(request, 'bar_graph.html', context)
def BubblePlot(request):
dataset = exportCSVdata()
allcols = list(dataset.columns)
totalrecords = dataset.shape[0]
if request.method == 'POST':
x_data_string = request.POST['rangeNo'].strip()
for i in x_data_string:
if i == ':':
k = x_data_string.index(i)
x_1strange = int(x_data_string[:k])
x_2strange = int(x_data_string[k + 1:])
dim1_data = request.POST['dim_1'].strip()
dim2_data = request.POST['dim_2'].strip()
dim3_data = request.POST['dim_3'].strip()
dim1_plot = dataset[x_1strange:x_2strange][dim1_data]
dim2_plot = dataset[x_1strange:x_2strange][dim2_data]
dim3_plot = dataset[x_1strange:x_2strange][dim3_data]
bubble = go.Scatter(mode='markers',
x=dim1_plot,
y=dim2_plot,
marker=dict(size=dim3_plot,
color=dim3_plot,
showscale=True))
layout = go.Layout(
title=
f"Bubble Plot: x-{dim1_data} y-{dim2_data} & size-x-{dim3_data} ")
fig = go.Figure(data=[bubble], layout=layout)
plt_div = fig.to_html(full_html=True)
context = {
'totalrecords': totalrecords,
'allcols': allcols,
'plot_div': plt_div
}
return render(request, 'bubble_plot.html', context)
else:
context = {'totalrecords': totalrecords, 'allcols': allcols}
return render(request, 'bubble_plot.html', context)
def LineGraph(request):
dataset = exportCSVdata()
allcols = list(dataset.columns)
totalrecords = dataset.shape[0]
if request.method == 'POST':
x_data_string = request.POST['rangeNo'].strip()
for i in x_data_string:
if i == ':':
k = x_data_string.index(i)
x_1strange = int(x_data_string[:k])
x_2strange = int(x_data_string[k + 1:])
x_data = request.POST['x_axis'].strip()
y_data = request.POST['y_axis'].strip()
x_plot = dataset[x_1strange:x_2strange][x_data]
y_plot = dataset[x_1strange:x_2strange][y_data]
scatter = go.Scatter(x=x_plot,
y=y_plot,
mode='lines',
marker_color='green')
layout = go.Layout(title=f"{x_data} vs. {y_data}",
xaxis={'title': f'{x_data}'},
yaxis={'title': f'{y_data}'})
fig = go.Figure(data=[scatter], layout=layout)
#plt_div = plot(fig, output_type='div') # can be used to convert plot to html code as well
plt_div = fig.to_html(full_html=True)
context = {
'totalrecords': totalrecords,
'allcols': allcols,
'plot_div': plt_div
}
return render(request, 'line_graph.html', context)
else:
context = {'totalrecords': totalrecords, 'allcols': allcols}
return render(request, 'line_graph.html', context)
def PieGraph(request):
dataset = exportCSVdata()
allcols = list(dataset.columns)
totalrecords = dataset.shape[0]
if request.method == 'POST':
x_data_string = request.POST['rangeNo'].strip()
for i in x_data_string:
if i == ':':
k = x_data_string.index(i)
x_1strange = int(x_data_string[:k])
x_2strange = int(x_data_string[k + 1:])
category_data = request.POST['categories'].strip()
values_data = request.POST['values'].strip()
category_plot = dataset[x_1strange:x_2strange][category_data]
values_data_plot = dataset[x_1strange:x_2strange][values_data]
layout = go.Layout(
title=
f"Segmentwise percentages of {values_data} for {category_data}")
pie = go.Pie(labels=category_plot, values=values_data_plot)
fig = go.Figure(data=[pie], layout=layout)
plt_div = fig.to_html(full_html=True)
graphtitle = f'{category_data} vs. {values_data}'
context = {
'graphtitle': graphtitle,
'totalrecords': totalrecords,
'allcols': allcols,
'plot_div': plt_div
}
return render(request, 'pie_graph.html', context)
else:
context = {'totalrecords': totalrecords, 'allcols': allcols}
return render(request, 'pie_graph.html', context)
def BoxPlot(request):
dataset = exportCSVdata()
allcols = list(dataset.columns)
totalrecords = dataset.shape[0]
if request.method == 'POST':
x_data_string = request.POST['rangeNo'].strip()
for i in x_data_string:
if i == ':':
k = x_data_string.index(i)
x_1strange = int(x_data_string[:k])
x_2strange = int(x_data_string[k + 1:])
plot_1_data = request.POST['plot_1'].strip()
plot_2_data = request.POST['plot_2'].strip()
plot_1 = dataset[x_1strange:x_2strange][plot_1_data]
plot_2 = dataset[x_1strange:x_2strange][plot_2_data]
plot1 = go.Box(y=plot_1)
plot2 = go.Box(y=plot_2)
layout = go.Layout(
title=f"Box plot for column {plot_1_data} and {plot_2_data}")
fig = go.Figure(data=[plot1, plot2], layout=layout)
# plt_div = plot(fig, output_type='div') # can be used to convert plot to html code as well
plt_div = fig.to_html(full_html=True)
context = {
'totalrecords': totalrecords,
'allcols': allcols,
'plot_div': plt_div
}
return render(request, 'box_plot.html', context)
else:
context = {'totalrecords': totalrecords, 'allcols': allcols}
return render(request, 'box_plot.html', context)