Black Lives Matter. Please consider donating to Black Girls Code today.

Timestamp Range slider

I want to create a date range slider , which will help me to select any interval between min and max values from my data.

################################

import dash
import dash_html_components as html
import dash_core_components as dcc
import pandas as pd

external_stylesheets = [‘https://codepen.io/chriddyp/pen/bWLwgP.css’]
df= pd.read_excel(‘Sample MallPeopleCount.xlsx’)

app = dash.Dash(name, external_stylesheets=external_stylesheets)
app.layout = html.Div([
dcc.RangeSlider(
id=‘my-range-slider’,

    min=df['Date'].min(),
    max=df['Date'].max(),
    step=None,
    value=[df['Date'].min()+5, df['Date'].max()-5]
),
html.Div(id='output-container-range-slider')

])

@app.callback(
dash.dependencies.Output(‘output-container-range-slider’, ‘children’),
[dash.dependencies.Input(‘my-range-slider’, ‘value’)])
def update_output(value):
return ‘You have selected “{}”’.format(value)

if name == ‘main’:
app.run_server()

###########################

step=None,
** value=[df[‘Date’].min()+5, df[‘Date’].max()-5]**

How to assign step and default value as min+5 next days , max- 5 previous days.

ValueError: Cannot add integral value to Timestamp without freq.

Why not use the DatePickerRange component? https://dash.plot.ly/dash-core-components/datepickerrange

Values in my ‘Date’ column are like as follows:

2019-11-04 00:00:00
2019-11-02 00:00:00

How to deal with these type of data???

Are you able to articulate your question better? I’m not sure what you are trying to achieve to know how I could possibly help.

say for reference, I have database — df[‘Age’] having values 12 ,41,55 … and df[‘In_Time’] which is having multiple values like

2019-10-11 13:23:50.506044,2019-10-12 13:23:50.506044
2019-10-11 09:30:50.506044,2019-10-12 20:20:50.506044
2019-10-11 10:30:50.506044,2019-10-12 10:53:50.506044,2019-10-13 11:33:50.506044

I want to display a bar chart with count of df[‘Age’] on y axis and df[‘In_Time’] on x axis with only dates .
I am having problem plotting dates on x-axis .

Sorry for late reply. Hope this makes you understand my problem clear.