{"action":"created","issue":{"url":"https://api.github.com/repos/jupyter-incubator/sparkmagic/issues/69","labels_url":"https://api.github.com/repos/jupyter-incubator/sparkmagic/issues/69/labels{/name}","comments_url":"https://api.github.com/repos/jupyter-incubator/sparkmagic/issues/69/comments","events_url":"https://api.github.com/repos/jupyter-incubator/sparkmagic/issues/69/events","html_url":"https://github.com/jupyter-incubator/sparkmagic/pull/69","id":122639499,"number":69,"title":"Create Auto Visualization Widget with Plotly","user":{"login":"aggFTW","id":654204,"avatar_url":"https://avatars.githubusercontent.com/u/654204?v=3","gravatar_id":"","url":"https://api.github.com/users/aggFTW","html_url":"https://github.com/aggFTW","followers_url":"https://api.github.com/users/aggFTW/followers","following_url":"https://api.github.com/users/aggFTW/following{/other_user}","gists_url":"https://api.github.com/users/aggFTW/gists{/gist_id}","starred_url":"https://api.github.com/users/aggFTW/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/aggFTW/subscriptions","organizations_url":"https://api.github.com/users/aggFTW/orgs","repos_url":"https://api.github.com/users/aggFTW/repos","events_url":"https://api.github.com/users/aggFTW/events{/privacy}","received_events_url":"https://api.github.com/users/aggFTW/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":4,"created_at":"2015-12-17T01:08:15Z","updated_at":"2015-12-17T22:33:27Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/jupyter-incubator/sparkmagic/pulls/69","html_url":"https://github.com/jupyter-incubator/sparkmagic/pull/69","diff_url":"https://github.com/jupyter-incubator/sparkmagic/pull/69.diff","patch_url":"https://github.com/jupyter-incubator/sparkmagic/pull/69.patch"},"body":"To test, you can run this code:\r\n\r\n```\r\nfrom remotespark.datawidgets.encoding import Encoding\r\nfrom remotespark.datawidgets.autovizwidget import AutoVizWidget\r\nfrom remotespark.datawidgets.plotlygraphs.graphrenderer import GraphRenderer\r\nimport pandas as pd\r\n\r\nrecords = [{u'buildingID': 0, u'date': u'6/1/13', u'temp_diff': 12},\r\n               {u'buildingID': 1, u'date': u'6/1/13', u'temp_diff': 0},\r\n               {u'buildingID': 2, u'date': u'6/1/14', u'temp_diff': 11},\r\n               {u'buildingID': 0, u'date': u'6/1/15', u'temp_diff': 5},\r\n               {u'buildingID': 1, u'date': u'6/1/16', u'temp_diff': 19},\r\n               {u'buildingID': 2, u'date': u'6/1/17', u'temp_diff': 32}]\r\ndf = pd.DataFrame(records)\r\n\r\nencoding = Encoding(chart_type=Encoding.chart_type_table, x=\"date\", y=\"temp_diff\", y_aggregation=Encoding.y_agg_avg)\r\nrenderer = GraphRenderer()\r\na = AutoVizWidget(df, encoding, renderer)\r\na\r\n```\r\n\r\nYou will get something like this:\r\n\r\nTable view:\r\n![capture](https://cloud.githubusercontent.com/assets/654204/11858503/1cb7f048-a417-11e5-9665-c63ca8135b56.PNG)\r\n\r\nPie chart view:\r\n![capture](https://cloud.githubusercontent.com/assets/654204/11858510/30d2ed9e-a417-11e5-8830-0a7076ff8d75.PNG)\r\n\r\nLine chart view:\r\n![capture](https://cloud.githubusercontent.com/assets/654204/11858520/51335448-a417-11e5-9b67-6b720cefda9d.PNG)\r\n\r\nArea chart view:\r\n![capture](https://cloud.githubusercontent.com/assets/654204/11858539/7243d734-a417-11e5-8203-66c7c070936c.PNG)\r\n\r\nBar chart view:\r\n![capture](https://cloud.githubusercontent.com/assets/654204/11858556/8ecf798a-a417-11e5-8507-0ef75f4c15bc.PNG)\r\n"},"comment":{"url":"https://api.github.com/repos/jupyter-incubator/sparkmagic/issues/comments/165603625","html_url":"https://github.com/jupyter-incubator/sparkmagic/pull/69#issuecomment-165603625","issue_url":"https://api.github.com/repos/jupyter-incubator/sparkmagic/issues/69","id":165603625,"user":{"login":"msftristew","id":13972471,"avatar_url":"https://avatars.githubusercontent.com/u/13972471?v=3","gravatar_id":"","url":"https://api.github.com/users/msftristew","html_url":"https://github.com/msftristew","followers_url":"https://api.github.com/users/msftristew/followers","following_url":"https://api.github.com/users/msftristew/following{/other_user}","gists_url":"https://api.github.com/users/msftristew/gists{/gist_id}","starred_url":"https://api.github.com/users/msftristew/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/msftristew/subscriptions","organizations_url":"https://api.github.com/users/msftristew/orgs","repos_url":"https://api.github.com/users/msftristew/repos","events_url":"https://api.github.com/users/msftristew/events{/privacy}","received_events_url":"https://api.github.com/users/msftristew/received_events","type":"User","site_admin":false},"created_at":"2015-12-17T22:33:27Z","updated_at":"2015-12-17T22:33:27Z","body":"Good work!\r\n\r\nI hereby officially sign off"}}