{"action":"created","issue":{"url":"https://api.github.com/repos/nigelsmall/py2neo/issues/468","repository_url":"https://api.github.com/repos/nigelsmall/py2neo","labels_url":"https://api.github.com/repos/nigelsmall/py2neo/issues/468/labels{/name}","comments_url":"https://api.github.com/repos/nigelsmall/py2neo/issues/468/comments","events_url":"https://api.github.com/repos/nigelsmall/py2neo/issues/468/events","html_url":"https://github.com/nigelsmall/py2neo/issues/468","id":132581876,"number":468,"title":"Formatting query results as a pandas.DataFrame","user":{"login":"dhimmel","id":1117703,"avatar_url":"https://avatars.githubusercontent.com/u/1117703?v=3","gravatar_id":"","url":"https://api.github.com/users/dhimmel","html_url":"https://github.com/dhimmel","followers_url":"https://api.github.com/users/dhimmel/followers","following_url":"https://api.github.com/users/dhimmel/following{/other_user}","gists_url":"https://api.github.com/users/dhimmel/gists{/gist_id}","starred_url":"https://api.github.com/users/dhimmel/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dhimmel/subscriptions","organizations_url":"https://api.github.com/users/dhimmel/orgs","repos_url":"https://api.github.com/users/dhimmel/repos","events_url":"https://api.github.com/users/dhimmel/events{/privacy}","received_events_url":"https://api.github.com/users/dhimmel/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":7,"created_at":"2016-02-10T01:05:43Z","updated_at":"2016-06-15T16:05:38Z","closed_at":"2016-03-10T22:49:28Z","body":"I generally want my query results as a dataframe. I use the following command to convert a `py2neo.cypher.core.RecordList` to a pandas.DataFrame`\r\n\r\n```python\r\nresults = neo.cypher.execute(query)\r\npandas.DataFrame(results.records, columns = results.columns)\r\n```\r\n\r\nWould it make sense to add a `to_pandas()` method to `RecordList`? If not, the workaround is easy enough."},"comment":{"url":"https://api.github.com/repos/nigelsmall/py2neo/issues/comments/226235962","html_url":"https://github.com/nigelsmall/py2neo/issues/468#issuecomment-226235962","issue_url":"https://api.github.com/repos/nigelsmall/py2neo/issues/468","id":226235962,"user":{"login":"svidela","id":68902,"avatar_url":"https://avatars.githubusercontent.com/u/68902?v=3","gravatar_id":"","url":"https://api.github.com/users/svidela","html_url":"https://github.com/svidela","followers_url":"https://api.github.com/users/svidela/followers","following_url":"https://api.github.com/users/svidela/following{/other_user}","gists_url":"https://api.github.com/users/svidela/gists{/gist_id}","starred_url":"https://api.github.com/users/svidela/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/svidela/subscriptions","organizations_url":"https://api.github.com/users/svidela/orgs","repos_url":"https://api.github.com/users/svidela/repos","events_url":"https://api.github.com/users/svidela/events{/privacy}","received_events_url":"https://api.github.com/users/svidela/received_events","type":"User","site_admin":false},"created_at":"2016-06-15T16:05:37Z","updated_at":"2016-06-15T16:05:37Z","body":"I'm doing this with python 3.5.1, py2neo v3, and pandas 0.18, and the following works fine for me:\r\n\r\n```\r\ncursor = graph.run(query)\r\ndf = pandas.DataFrame.from_records(cursor, columns=cursor.keys())\r\n```"}}
{"actor":{"display_login":"svidela"}}