The Knowledge Graph Conference Icon

The Knowledge Graph Conference

Home
Events
Members

Announcements
Ask
Ask The Ontologists
Events
Jobs
Promotions
Share

Powered by Tightknit

Converting SPARQL Results to CSV for Excel Use

·May 18, 2022 04:30 PM

Another RDFLib question: is there a way to take SPARQL results and push them to a CSV? I've looked through documentation and it looks possible but I'm still a bit puzzled. (My colleagues want Excel sheets. I know. I know. 🙃)

10 comments

· Sorted by Oldest

nabeel
·
if you do something like
for row in results: dict_results = row.asdict()
the dict_results will be in rdflib variables so like URIRef, Literal, etc so you may need to iterate through the dict and do .toPython() but it might be worth trying and seeing what happens if you write that dict_results to a csv. I haven't tried myself
Leia D.
·
I see. Thank you, nabeel! The len() is working perfectly btw.
nabeel
·
Glad to hear it!
Michael G.
·
i dont know much about rdflib, but you can get sparql results as csv from most endpoints. rdflib might be able to execute the query and get the results as csv w/o you having to transform them
Leia D.
·
Thank you, Michael G.. Working from an endpoint isn't an option unfortunately. That's why I was hoping RDFLib would do it without much issue. I'll definitely use one when I can.
Michael G.
·
that's not my point. rdflib likely already has code to both read and write results as csv. in which case, you can just pass a result to the csv writer built into the library.
Leia D.
·
Ok. I see. Thank you.
Michael G.
·
unless you need a custom csv format, it'll be way easier to just re-use what's in rdflib than to DIY
Donny W.
·
Leia D. I recorded a <10min video walkthrough addressing your questions about printing RDFLib SPARQL results and exporting to CSV. I hope it's helpful to you. https://www.youtube.com/watch?v=FD_xFFotvxU
Leia D.
·
Donny W. Wow. Thank you!