Difference between revisions of "Truly Tabular RDF/Info"
(→label) |
|||
| Line 1: | Line 1: | ||
| − | = <nowiki>#</nowiki> = | + | = Property columns = |
| + | == <nowiki>#</nowiki> == | ||
rank of the property in order of the percentage of instances where at lest one values is available for the property | rank of the property in order of the percentage of instances where at lest one values is available for the property | ||
| − | = <nowiki>%</nowiki> = | + | == <nowiki>%</nowiki> == |
The percentage of instances where at least one value is available for the property | The percentage of instances where at least one value is available for the property | ||
| − | = pareto = | + | == pareto == |
The Pareto level according to the [https://en.wikipedia.org/wiki/Pareto_principle Pareto principle] 80:20 (1 out of 5) as a logarithmic scale to the basis 5.. | The Pareto level according to the [https://en.wikipedia.org/wiki/Pareto_principle Pareto principle] 80:20 (1 out of 5) as a logarithmic scale to the basis 5.. | ||
| Line 30: | Line 31: | ||
|} | |} | ||
| − | = property = | + | == property == |
A [https://www.wikidata.org/wiki/Wikidata:List_of_properties Wikidata Property] e.g. | A [https://www.wikidata.org/wiki/Wikidata:List_of_properties Wikidata Property] e.g. | ||
[https://www.wikidata.org/wiki/Property:P31 P31/instance of] | [https://www.wikidata.org/wiki/Property:P31 P31/instance of] | ||
| + | == propertyId == | ||
| + | The property Identifier for a Property e.g. P31 for [https://www.wikidata.org/wiki/Property:P31 P31/instance of] | ||
| + | = Aggregates = | ||
| + | == count == | ||
| + | apply SPARQL <source lang='sparql'>COUNT()</source> aggregate | ||
| + | == min == | ||
| + | apply SPARQL <source lang='sparql'>MIN()</source> aggregate | ||
| + | == max == | ||
| + | apply SPARQL <source lang='sparql'>MAX()</source> aggregate | ||
| + | == avg == | ||
| + | apply SPARQL <source lang='sparql'>AVG()</source> aggregate | ||
| + | == sample == | ||
| + | apply SPARQL <source lang='sparql'>SAMPLE()</source> aggregate | ||
| + | == list == | ||
| + | apply <source lang='sparql'>GROUP_CONCAT()</source> aggregate to avoid multiple solutions for the same instance | ||
| + | |||
= ignore = | = ignore = | ||
Ignore SPARQL solutions that have multiple values for the given property by using a <source lang='sparql'>HAVING COUNT<=1</source> aggregate condition in the generated query | Ignore SPARQL solutions that have multiple values for the given property by using a <source lang='sparql'>HAVING COUNT<=1</source> aggregate condition in the generated query | ||
Revision as of 17:12, 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
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