Project:DMV-Talk: Difference between revisions

From MaRDI portal
Created page with "<syntaxhighlight lang=SPARQL> PREFIX wdt: <https://portal.mardi4nfdi.de/prop/direct/> PREFIX wd: <https://portal.mardi4nfdi.de/entity/> SELECT (?dep2nd as ?qId) ?dlmfid ?definesLabel ?formula WHERE { ?item wdt:P4 wd:Q1818 . ?item wdt:P3 ?defines . ?dep2nd wdt:P4 ?defines FILTER( NOT EXISTS { ?dep2nd wdt:P4 wd:1818.}) OPTIONAL{?dep2nd wdt:P2 ?dlmfid .} OPTIONAL{?dep2nd wdt:P14 ?formula .} SERVICE wikibase:label..."
 
 
(7 intermediate revisions by the same user not shown)
Line 1: Line 1:
<syntaxhighlight lang=SPARQL>
==== CRAN Packages ====
{{SPARQL|query=
PREFIX wdt: <https://portal.mardi4nfdi.de/prop/direct/>
SELECT ?item ?name
WHERE {
  ?item wdt:P229 ?name
}
}}
 
* Cran packages with publications
 
{{SPARQL|query=
PREFIX wdt: <https://portal.mardi4nfdi.de/prop/direct/>
SELECT ?item ?name (SAMPLE(?cites) as ?Publication)
WHERE {
  ?item wdt:P229 ?name ; wdt:P223 ?cites
} GROUP by ?item ?name
}}
 
==== Formulae from the DLMF ====
{{SPARQL|query=


PREFIX wdt: <https://portal.mardi4nfdi.de/prop/direct/>
PREFIX wdt: <https://portal.mardi4nfdi.de/prop/direct/>
Line 16: Line 36:
       }
       }
Limit 10
Limit 10
</syntaxhighlight>
}}
{{#sparql:


===== Paper with many authors =====
{{SPARQL|query=
#title:Most authors in MSC 14E30
PREFIX wdt: <https://portal.mardi4nfdi.de/prop/direct/>
PREFIX wdt: <https://portal.mardi4nfdi.de/prop/direct/>
PREFIX wd: <https://portal.mardi4nfdi.de/entity/>
PREFIX wd: <https://portal.mardi4nfdi.de/entity/>


SELECT (?dep2nd as ?qId) ?dlmfid ?definesLabel ?formula
SELECT ?item (COUNT(*) as ?cnt) (GROUP_CONCAT(?authorLabel;separator="; ") as ?authors)
WHERE {
WHERE { ?item wdt:P31 wd:Q56887 ; wdt:P226 "14E30" ; wdt:P16 ?author.
  ?item wdt:P4 wd:Q1818 .
      SERVICE wikibase:label { bd:serviceParam wikibase:language "en".  
        ?item wdt:P3 ?defines .
                            ?author rdfs:label ?authorLabel }
      ?dep2nd wdt:P4 ?defines
}
      FILTER( NOT EXISTS { ?dep2nd wdt:P4 wd:1818.})
GROUP by ?item
        OPTIONAL{?dep2nd wdt:P2 ?dlmfid .}
ORDER by DESC(?cnt)
                OPTIONAL{?dep2nd wdt:P14 ?formula .}     
LIMIT 5
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }


      }
Limit 10
}}
}}

Latest revision as of 14:12, 24 September 2023

CRAN Packages

PREFIX wdt: <https://portal.mardi4nfdi.de/prop/direct/>
SELECT ?item ?name
WHERE {
  ?item wdt:P229 ?name
}
Try it!
  • Cran packages with publications
PREFIX wdt: <https://portal.mardi4nfdi.de/prop/direct/>
SELECT ?item ?name (SAMPLE(?cites) as ?Publication)
WHERE {
  ?item wdt:P229 ?name ; wdt:P223 ?cites
} GROUP by ?item ?name
Try it!

Formulae from the DLMF

PREFIX wdt: <https://portal.mardi4nfdi.de/prop/direct/>
PREFIX wd: <https://portal.mardi4nfdi.de/entity/>

SELECT (?dep2nd as ?qId) ?dlmfid ?definesLabel ?formula
WHERE {
  ?item wdt:P4 wd:Q1818 .
         ?item wdt:P3 ?defines .
       ?dep2nd wdt:P4 ?defines 
       FILTER( NOT EXISTS { ?dep2nd wdt:P4 wd:1818.})
         OPTIONAL{?dep2nd wdt:P2 ?dlmfid .}
                OPTIONAL{?dep2nd wdt:P14 ?formula .}      
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }

      }
Limit 10
Try it!
Paper with many authors
#title:Most authors in MSC 14E30
PREFIX wdt: <https://portal.mardi4nfdi.de/prop/direct/>
PREFIX wd: <https://portal.mardi4nfdi.de/entity/>

SELECT ?item (COUNT(*) as ?cnt) (GROUP_CONCAT(?authorLabel;separator="; ") as ?authors) 
WHERE { ?item wdt:P31 wd:Q56887 ; wdt:P226 "14E30" ; wdt:P16 ?author.
      SERVICE wikibase:label { bd:serviceParam wikibase:language "en". 
                             ?author rdfs:label ?authorLabel }
}
GROUP by ?item
ORDER by DESC(?cnt)
LIMIT 5
Most authors in MSC 14E30