Dash Data Table Creating a thrid column wich contains the difference of the values in the previous columns

Dash Python
1

Hey guys,

im new to dash and im trying to make a Dash Datatable with for example 2 generated Columns from a CSV and i want to generate a third next to the others with the difference of the values in the other 2 Columns for each row!

it would be great if i could get some advice.

best regards
Mae

2

Hey @Mae , welcome to community.

Please see links below

https://www.geeksforgeeks.org/difference-of-two-columns-in-pandas-dataframe/

https://dash.plotly.com/datatable

First you can calculate the difference between col1 and col2 then append it to your dataset. Then create your data table.

Have a nice day.

3

Greetings akroma,
thanks alot for your fast reply. I will try it today.

1 Like
4

Let me know how it goes. Good luck.

1 Like
6

I Found the solution. Cause i made for every year and week a separated append and so i got three times week 1-53 in year 2015, 2016 and 2018 and week 1-52 in year 2017. so i had 211 rows instead of 53 rows as intended.

1 Like
8

I solved it by my own my only problem is to change the column header depending on the year i choosed for the column. I think i need an separate output for each

InkedColumn_LI
InkedColumn_LI1899×892 131 KB

this is the code for the headers of each column:

dash_table.DataTable(
id=‘datatable-interactivity’,
columns=[
{“name” : “KW”, “id” : “KW”},
{“name” : ‘Anzahl’+" “+”%s" %year_picker_1, “id”: ‘Anzahl1’},
{“name” : ‘Umsatz’+" “+”%s" %year_picker_1, ‘id’ : ‘Umsatz1’},
{“name” : ‘Anzahl’+" “+”%s" %year_picker_2, “id”: ‘Anzahl2’},
{“name” : ‘Umsatz’+" “+”%s" %year_picker_2, ‘id’ : ‘Umsatz2’},
{“name” : ‘Anzahl’+" “+”%s" %year_picker_3, “id”: ‘Anzahl3’},
{“name” : ‘Umsatz’+" “+”%s" %year_picker_3, ‘id’ : ‘Umsatz3’},
{“name” : ‘Anzahl’+" “+”%s" %year_picker_4, “id”: ‘Anzahl4’},
{“name” : ‘Umsatz’+" “+”%s" %year_picker_4, ‘id’ : ‘Umsatz4’}

can i return values from a callback function without an Output(id, and value?)
and i need only to return the data for the table (is working) and the values from the year_picker (not working)

this is my current Callback:

Output('datatable-interactivity', 'data'),
[Input('year_picker_1', 'value'),
 Input('year_picker_2', 'value'),
 Input('year_picker_3', 'value'),
 Input('year_picker_4', 'value')]

but i need to return the year picker values too, to name the the column headers with the selected your of the dropdown above…

many thanks in advance

9

Would be nice if you could help me @akroma ^^