martes, 4 de diciembre de 2018

Leer datos de Neo4j

El siguiente script lee datos de Neo4j  de los últimos 10 dias, y lo guarda en un CSV

script:
from py2neo import Graph
import pandas as pd

def neo_conect():
 srv = "http://mi_server.com:7474"
 auth = ("mi_user", "mi_pass")
 return srv, auth

def get_ndata(srv, auth, days=10):
 dt_from = (datetime.date.today() - datetime.timedelta(days=days))
 dt_from = round(datetime.datetime.fromordinal(dt_from.toordinal()).timestamp())
 graph = Graph(srv, auth=auth)
 q = "MATCH (u:user)-[r:RELACION]->(i:item) WHERE r.date >=" +str(dt_from)+ " RETURN u.id as user_id, i.id as item_id, r.date as fecha"
 df = graph.run(q).to_data_frame()
 return df

def main():
 srv, auth = neo_conect()
 df = get_ndata(srv, auth, days=10)
 df.to_csv('neo4j_data.csv', encoding='utf-8', index=False)

if __name__ == '__main__':
 main()

Referencia:
https://medium.com/neo4j/py2neo-v4-2bedc8afef2

No hay comentarios:

Publicar un comentario