Python and Google Chart Tool - Help

Dev Shed Forums Sponsor:

February 8th, 2012, 01:45 PM

davnads

Registered User

Join Date: Feb 2012

Posts: 4

Time spent in forums: 56 m
Reputation Power: 0

Python and Google Chart Tool - Help

Hello, I'm new to Python and was tinkering around with Google Chart Tools. Really cool! I'm able to use the below python code to create some html that populates a nice table chart. My question is, how would I convert the chart type to something else, say a pie chart? I would appreciate examples if any has them. Thank you.

Code:

import gviz_api

page_template = """
<html>
  <head>
  <title>Static example</title>
    <script src="http://www.google.com/jsapi" type="text/javascript"></script>
    <script>
      google.load("visualization", "1", {packages:["table"]});

      google.setOnLoadCallback(drawTable);
      function drawTable() {
        %(jscode)s
        var jscode_table = new google.visualization.Table(document.getElementById('table_div_jscode'));
        jscode_table.draw(jscode_data, {showRowNumber: true});

        var json_table = new google.visualization.Table(document.getElementById('table_div_json'));
        var json_data = new google.visualization.DataTable(%(json)s, 0.5);
        json_table.draw(json_data, {showRowNumber: true});
      }
    </script>
  </head>
  <body>
    <H1>Table created using ToJSCode</H1>
    <div id="table_div_jscode"></div>
    <H1>Table created using ToJSon</H1>
    <div id="table_div_json"></div>
  </body>
</html>
"""


def main():
  # Creating the data
  description = {"name": ("string", "Name"),
                 "salary": ("number", "Salary"),
                 "full_time": ("boolean", "Full Time Employee")}
  data = [{"name": "Mike", "salary": (10000, "$10,000"), "full_time": True},
          {"name": "Jim", "salary": (800, "$800"), "full_time": False},
          {"name": "Alice", "salary": (12500, "$12,500"), "full_time": True},
          {"name": "Bob", "salary": (7000, "$7,000"), "full_time": True}]

  # Loading it into gviz_api.DataTable
  data_table = gviz_api.DataTable(description)
  data_table.LoadData(data)

  # Creating a JavaScript code string
  jscode = data_table.ToJSCode("jscode_data",
                               columns_order=("name", "salary", "full_time"),
                               order_by="salary")
  # Creating a JSon string
  json = data_table.ToJSon(columns_order=("name", "salary", "full_time"),
                           order_by="salary")

  # Putting the JS code and JSon string into the template
  print page_template % vars()


if __name__ == "__main__":
  main()

February 8th, 2012, 02:08 PM

b49P23TIvg

Contributing User

Join Date: Aug 2011

Posts: 1,075

Time spent in forums: 4 Weeks 1 Day 4 h 41 m 27 sec
Reputation Power: 98

don't use pie charts!

pie charts are evil link

friends don't let friends use pie charts link

Reason and alternative link

Please don't use pie charts link

February 8th, 2012, 03:09 PM

davnads

Registered User

Join Date: Feb 2012

Posts: 4

Time spent in forums: 56 m
Reputation Power: 0

Thanks but that is not helpful. I'm just trying to understand the concept of presenting the data in a different format. I don't care if it's a pie chart or histogram. I just don't want to present it in a table.

February 8th, 2012, 05:19 PM

b49P23TIvg

Contributing User

Join Date: Aug 2011

Posts: 1,075

Time spent in forums: 4 Weeks 1 Day 4 h 41 m 27 sec
Reputation Power: 98

MMMmmm. You copy and pasted the chart example provided by gviz. Why don't you copy and paste the draw example as well?

http://code.google.com/apis/chart/interactive/docs/reference.html#visdraw

Do you need help reading the python documentation?

search these key words with your favorite internet search engine.

examples of gviz_api draw

Last edited by b49P23TIvg : February 8th, 2012 at 05:31 PM.

February 9th, 2012, 11:35 AM

davnads

Registered User

Join Date: Feb 2012

Posts: 4

Time spent in forums: 56 m
Reputation Power: 0

Thanks I have read these documents. I'm new to Python and can honestly say it's hard to follow a lot of this material with my lack of experience.This exercise is for my own educational purpose.

I copied and pasted the example by gziv because it works. I know how I can make a barchart (or whatever) using just html/java but don't know how to get it to populate from source inside of Python like the gziv example.

February 9th, 2012, 03:44 PM

b49P23TIvg

Contributing User

Join Date: Aug 2011

Posts: 1,075

Time spent in forums: 4 Weeks 1 Day 4 h 41 m 27 sec
Reputation Power: 98

Simple Simple Simple

http://chart.apis.google.com/chart?cht=p3&chs=450x200&chd=t:73,13,10,3,1&chco=80C65A,224499,FF0000&chl=Chocolate|Puff+Pastry|Cookies|Muffins|Gelato

More examples

http://psychopyko.com/tutorial/how-to-use-google-charts/