如何在python的sparql查询中添加列表作为参数

2024-05-20 00:38:04 发布

您现在位置:Python中文网/ 问答频道 /正文

我使用SPARQLWrapper运行我的wikidata查询。在

from SPARQLWrapper import SPARQLWrapper, JSON
import pandas as pd

sparql = SPARQLWrapper("https://query.wikidata.org/sparql")

sparql.setQuery("""
    SELECT DISTINCT ?item {
    VALUES ?searchTerm { "word2vec" "fasttext" "natural language processing" "deep learning" "support vector machine" }
    SERVICE wikibase:mwapi {
        bd:serviceParam wikibase:api "EntitySearch".
        bd:serviceParam wikibase:endpoint "www.wikidata.org".
        bd:serviceParam wikibase:limit 3 .
        bd:serviceParam mwapi:search ?searchTerm.
        bd:serviceParam mwapi:language "en".
        ?item wikibase:apiOutputItem mwapi:item.
        ?num wikibase:apiOrdinal true.
    }
    ?item (wdt:P279|wdt:P31) ?type
    }
    ORDER BY ?searchTerm ?num                    
""")
sparql.setReturnFormat(JSON)
results = sparql.query().convert()
results_df = pd.io.json.json_normalize(results['results']['bindings'])
print(results_df)

我想将单词列表"word2vec" "fasttext" "natural language processing" "deep learning" "support vector machine"作为python列表。i、 e.如下。在

^{pr2}$

在这种情况下,如何将mylist作为参数插入到我前面提到的现有wikidata查询中。在

我试着用下面的f字串。然而,这对我来说并不管用。在

sparql.setQuery(f"
        SELECT DISTINCT ?item {
        VALUES ?searchTerm { {mylist} }
        SERVICE wikibase:mwapi {
            bd:serviceParam wikibase:api "EntitySearch".
            bd:serviceParam wikibase:endpoint "www.wikidata.org".
            bd:serviceParam wikibase:limit 3 .
            bd:serviceParam mwapi:search ?searchTerm.
            bd:serviceParam mwapi:language "en".
            ?item wikibase:apiOutputItem mwapi:item.
            ?num wikibase:apiOrdinal true.
        }
        ?item (wdt:P279|wdt:P31) ?type
        }
        ORDER BY ?searchTerm ?num                    
    ")

如果需要,我很乐意提供更多细节。在


Tags: orgparamserviceitemlanguagesparqlresultsnum