DATA Manipulation

KNIME Analytics Platform
1

Hi
I have a data set like :
ORIGINAL DATA.xlsx (9.4 KB)
I would like this final data set :
DATA MEAN.xlsx (9.8 KB)
Actually, I want to create a row that gives the averages of all the numerical values. The name becomes “MEAN”
Thanks
Br

2

Hi @Brain ,

001
0011880×1046 361 KB

Br

PS:

  1. “groupby” node, “groupby: date” is not mandatory. If you don’t consider dates, set the group columns to < null >.

  2. At the same time, add a fixed value setting to the missing value node.

example.knwf (27.5 KB)

2 Likes
3

Thanks a lot
My problem was the “date”

4

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.