#My Code
import dash
import dash_table as dt
import dash_core_components as dcc
import dash_html_components as html
import plotly.express as px
import pandas as pd
import plotly.graph_objects as go
from dash.dependencies import Output,Input
df=pd.read_csv(‘Jan-21.csv’)
df_city=df.groupby([‘BILL_DATE’,‘CTNAME’]).sum().reset_index()
df_city[‘NETAMT’]=round(df_city[‘NETAMT’],2)
app =dash.Dash(name)
app.layout=html.Div([
html.H1(“Jan-21 City Wise Sales DashBoard”),
dcc.Dropdown(id=‘city-choice’,
options=[{‘label’:x, ‘value’:x}
for x in sorted (df_city.CTNAME.unique())],
value=‘BANGALORE’
),
dcc.Graph(id=‘my-graph’,figure={}),
html.Br(),
dt.DataTable(id=‘my-table’,
columns=[{‘name’:i,‘id’:i} for i in df_city],
data=df_city.to_dict(‘records’),
export_format=“csv”,
page_current=0,
page_size=15,
sort_mode=‘multi’,
style_data_conditional=
[{
‘if’: {‘row_index’: ‘odd’},
‘backgroundColor’: ‘rgb(248, 248, 248)’,
‘whiteSpace’: ‘normal’,
‘height’: ‘auto’,
‘lineHeight’: ‘15px’
}],
style_header=
{
‘backgroundColor’: ‘rgb(230, 230, 230)’,
‘fontWeight’: ‘bold’
}
)
])
@app.callback(
Output(component_id=‘my-graph’,component_property=‘figure’),
Output(component_id=‘my-table’,component_property=‘data’),
Input(component_id=‘city-choice’,component_property=‘value’)
)
def interative_graphing(cvalue):
print(cvalue)
dif_city=df_city[df_city.CTNAME==cvalue]
fig=px.bar(data_frame=dif_city, x=‘BILL_DATE’,y=[‘NETAMT’,‘QTY’],opacity=0.5 ,barmode=‘group’)
data=dif_city.to_dict(‘records’)
return fig,data
if name==‘main’:
app.run_server(debug=False)
