Truly Tabular RDF/Info

From BITPlan Wiki
Revision as of 17:14, 2 August 2022 by Wf (talk | contribs) (→‎Aggregates)
Jump to navigation Jump to search

Property columns

#

rank of the property in order of the percentage of instances where at lest one values is available for the property

%

The percentage of instances where at least one value is available for the property

pareto

The Pareto level according to the Pareto principle 80:20 (1 out of 5) as a logarithmic scale to the basis 5..

Pareto levels
level ratio 1 out of
1 80:20 5
2 96:4 25
3 99.2:0.8 125
4 99.84:0.16 625
5 99.97:0.03 3125
6 99.994:0.006 15625
7 99.9987:0.0013 78125
8 99.99974:0.00026 390625
9 99.99995:0.00005 1953125

property

A Wikidata Property e.g. P31/instance of

propertyId

The property Identifier for a Property e.g. P31 for P31/instance of

Statistics

1

maxf

nt

nt%

?f

?ex

Aggregates

count

apply SPARQL

COUNT()

aggregate

min

apply SPARQL

MIN()

aggregate

max

apply SPARQL

MAX()

aggregate

avg

apply SPARQL

AVG()

aggregate

sample

apply SPARQL

SAMPLE()

aggregate

list

apply

GROUP_CONCAT()

aggregate to avoid multiple solutions for the same instance

ignore

Ignore SPARQL solutions that have multiple values for the given property by using a

HAVING COUNT<=1

aggregate condition in the generated query

label

Show the label of the property result in the generated SPARQL query.

select

If a property is selected it will be included in the generated SPARQL query