Project:DMV-Talk: Difference between revisions

From MaRDI portal
No edit summary
 
(5 intermediate revisions by the same user not shown)
Line 1: Line 1:
CRAN Packages
==== CRAN Packages ====
 
{{SPARQL|query=
{{SPARQL|query=PREFIX wdt: <https://portal.mardi4nfdi.de/prop/direct/>
PREFIX wdt: <https://portal.mardi4nfdi.de/prop/direct/>
SELECT ?item ?name
SELECT ?item ?name
WHERE {
WHERE {
   ?item wdt:P229 ?name
   ?item wdt:P229 ?name
<nowiki>}</nowiki>}}
}
}}
 
* Cran packages with publications


Formulae from the DLMF{{SPARQL|query=
{{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 24: Line 36:
       }
       }
Limit 10
Limit 10
}}People with 3 papers
}}
 
===== Paper with many authors =====
{{SPARQL|query=
#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
 
}}

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