Salgo60 created this task. Salgo60 added a project: Wikidata Query UI. Restricted Application added a subscriber: Aklapper. Restricted Application added a project: Wikidata.
TASK DESCRIPTION See Jupyter example <https://github.com/salgo60/open-data-examples/blob/master/Wikdata%20-%3E%20Panda%20dataset.ipynb> As data scientist are a target group of using Wikidata and python combined with pandas <https://pandas.pydata.org/> is used a lot I suggest that we add one more option to WDQS Code **"Python -> Pandas"** F31917078: image.png <https://phabricator.wikimedia.org/F31917078> F31917067: image.png <https://phabricator.wikimedia.org/F31917067> My understanding is that we do the same as **option Python** but a new procedure is used **get_sparql_dataframe** def get_sparql_dataframe(endpoint_url, query): """ Helper function to convert SPARQL results into a Pandas data frame. """ user_agent = "salgo60/%s.%s" % (sys.version_info[0], sys.version_info[1]) sparql = SPARQLWrapper(endpoint_url, agent=user_agent) sparql.setQuery(query) sparql.setReturnFormat(JSON) result = sparql.query() processed_results = json.load(result.response) cols = processed_results['head']['vars'] out = [] for row in processed_results['results']['bindings']: item = [] for c in cols: item.append(row.get(c, {}).get('value')) out.append(item) return pd.DataFrame(out, columns=cols) TASK DETAIL https://phabricator.wikimedia.org/T257117 WORKBOARD https://phabricator.wikimedia.org/project/board/2901/ EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: Salgo60 Cc: Aklapper, Salgo60, CBogen, darthmon_wmde, Nandana, Namenlos314, Lahi, Gq86, Lucas_Werkmeister_WMDE, GoranSMilovanovic, Mahir256, QZanden, EBjune, merbst, LawExplorer, _jensen, rosalieper, Scott_WUaS, Jonas, Xmlizer, jkroll, Wikidata-bugs, Jdouglas, aude, Tobias1984, Manybubbles, Lydia_Pintscher, Mbch331
_______________________________________________ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
