Difference between revisions of "Truly Tabular RDF/Info"
| Line 36: | Line 36: | ||
== propertyId == | == propertyId == | ||
The property Identifier for a Property e.g. P31 for [https://www.wikidata.org/wiki/Property:P31 P31/instance of] | The property Identifier for a Property e.g. P31 for [https://www.wikidata.org/wiki/Property:P31 P31/instance of] | ||
| + | = Statistics = | ||
| + | == 1 == | ||
| + | == maxf == | ||
| + | == nt == | ||
| + | == nt% == | ||
| + | == ?f == | ||
| + | == ?ex == | ||
| + | == ✔ == | ||
| + | |||
= Aggregates = | = Aggregates = | ||
== count == | == count == | ||
Revision as of 16:14, 2 August 2022
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..
| 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