第一句子网 - 唯美句子、句子迷、好句子大全
第一句子网 > python导出数据找不到csv_python – 将数据从neo4j导出到csv而不是json

python导出数据找不到csv_python – 将数据从neo4j导出到csv而不是json

时间:2024-01-10 18:33:05

相关推荐

python导出数据找不到csv_python  – 将数据从neo4j导出到csv而不是json

我正在使用neo4jdb-python包来查询Neo4j数据库.例如,考虑以下代码

import neo4j

connection = neo4j.connect("http://localhost:7474")

cursor = connection.cursor()

for i in cursor.execute("MATCH a RETURN a LIMIT 1"):

print i

但输出是元组的形式.即

({u'text': u'Stoyanov, S., Hoogveld, B., Kirschner, P.A., (). Mapping Major Changes to Education and Training in 2025, in JRC Technical Note JRC59079., Publications Office of the European Union: Luxembourg.', u'identifier': u'reference/lak/226'},)

如何以csv格式获得输出.这可以通过neo4j的Web视图实现.输出就像,

"{""text"":""Stoyanov, S., Hoogveld, B., Kirschner, P.A., (). Mapping Major Changes to Education and Training in 2025, in JRC Technical Note JRC59079., Publications Office of the European Union: Luxembourg."",""identifier"":""reference/lak/226""}"

但是我想通过客户端程序来实现它,因为我需要将它嵌入到另一个程序中.如果使用neo4jdb-python是不可能的,那么还有哪些其他选项可用.

解决方法:

该CSV实际上并非来自特定的API – 它在客户端被翻译成CSV格式.

$scope.exportCSV = (data) ->

return unless data

csv = new CSV.Serializer()

csv.columns(data.columns())

for row in data.rows()

csv.append(row)

这指的是CSV.coffee.我猜你应该可以在Python中做类似的事情,也许像using json.dumps这样:

> import json

> t = ({u'text': u'Stoyanov, S., Hoogveld, B., Kirschner, P.A., (). Mapping Major Changes to Education and Training in 2025, in JRC Technical Note JRC59079., Publications Office of the European Union: Luxembourg.', u'identifier': u'reference/lak/226'},)

> json.dumps(t)

'[{"text": "Stoyanov, S., Hoogveld, B., Kirschner, P.A., (). Mapping Major Changes to Education and Training in 2025, in JRC Technical Note JRC59079., Publications Office of the European Union: Luxembourg.", "identifier": "reference/lak/226"}]'

标签:python,list,neo4j,csv,cypher

来源: https://codeday.me/bug/0722/1505834.html

本内容不代表本网观点和政治立场,如有侵犯你的权益请联系我们处理。
网友评论
网友评论仅供其表达个人看法,并不表明网站立场。