Groupby does not give the expected result

[jipclaassens]

So, I do as requested:

The aggregate by option should also give the count or sum option

The domain here is a ipoint grid domain.

[jipclaassens]

In compactedadmindomain = uint32 domain it does give more aggregation option. But summing the id is also irrelevant. I just want to count the subsector_rel.

[MaartenHilferink]

Microtest open /DistTo in dataview en aggregeer er op: Traceback wordt gesumd, maar dat kan niet met UInt4 values:

[jipclaassens]

Make a list of which value types should give what aggregation options (bold=default):

-id points (e.g. grid id's): count, first, last, asExprList, mean
-string: count, first, last, asExprList
-integers: count, sum, first, last, asExprList, min, max, mean, sd, modus
-floats: count, sum, first, last, asExprList, min, max, mean, sd, modus
-categorials: count, first, last, asFrequencyTable, min, max, modus
-geometry: count, first, last, asExprList

@mtbeek32, what do you think?

[MaartenHilferink]

aanvulling:

• id (eerste) column: default is count als domein integer of categorical is, bounding_box wanneer domein (s/w/i/u)point is.
• points en sequences van points: default bounding box (= combinatie van lower bound en upper bound)
• asFrequencyTable is voorlopig even te complex. Wellicht splitsen in aparte wish-issues voor string weergave van integer of float-sequences, die dan met value2sequene(attr, aggr_rel) gemaakt worden.
• categoricals: naast modus ook:
  • diversity (aantal verschillende waarden),
  • entropy [ n * log(n) - SUM k: n_k * log(n_k) ],
  • modus_count,
  • unique_count
• boolean attributen: geen min, max of bounding box, maar wel all (default) en any, en in de toekomst: frequency_table: false: 20; true: 10

[MaartenHilferink]

Frequency table suggestion:

Apple (25), Banana (30), Orange (15), Strawberry (20), Total (90)

or

To present the data from a frequency table in one line of text, you would typically summarize the key points by listing each category alongside its frequency, often separated by commas, and conclude with the total count if relevant. For the example of fruit preferences, the one-line presentation would look something like this:

"Apple: 25, Banana: 30, Orange: 15, Strawberry: 20, Total: 90"

This format succinctly conveys the essential information from the frequency table, making it suitable for contexts where space is limited or a quick overview is needed.

[MaartenHilferink]

Default resultaat op Aggr op categorische rasterdata is nu dit:

[MaartenHilferink]

Of dit: