def graph_test_vector(candidates, data, directory, title, y_axis): if len(candidates) != len(data): raise AttributeError('Length of candidates and data does not match') chart = StackedVerticalBarChart(700, 428, auto_scale=False, custom_scaling=True) chart.set_bar_width(41) chart.set_colours(('3366CC', '000000')) chart.add_data(data) chart.set_axis_range('y', 0, max(data) + 0.1 * max(data)) chart.set_axis_labels('x', candidates) x_title_index = chart.set_axis_labels('x', ['Candidate']) y_title_index = chart.set_axis_labels('y', [y_axis]) chart.set_axis_positions(x_title_index, [50]) chart.set_axis_positions(y_title_index, [50]) chart.set_title(title) # (dataset, all bars, formating, colour, width) chart.add_marker(0, -1, 'N', '000000', 11) chart.download(os.path.join(directory, '%s.png' % title.replace(' ','')))
def graph_test_vector(candidates, data, directory, title, y_axis): if len(candidates) != len(data): raise AttributeError('Length of candidates and data does not match') chart = StackedVerticalBarChart(700, 428, auto_scale=False, custom_scaling=True) chart.set_bar_width(41) chart.set_colours(('3366CC', '000000')) chart.add_data(data) chart.set_axis_range('y', 0, max(data) + 0.1 * max(data)) chart.set_axis_labels('x', candidates) x_title_index = chart.set_axis_labels('x', ['Candidate']) y_title_index = chart.set_axis_labels('y', [y_axis]) chart.set_axis_positions(x_title_index, [50]) chart.set_axis_positions(y_title_index, [50]) chart.set_title(title) # (dataset, all bars, formating, colour, width) chart.add_marker(0, -1, 'N', '000000', 11) chart.download(os.path.join(directory, '%s.png' % title.replace(' ', '')))
# for row in rows: # pm10val = int(rows[4]) # print pm10val pm10val = int(rows[0][4]) colour = 'ad0000' # Draw the bar chart chart = StackedVerticalBarChart(150, 200, y_range=(0, 4000)) chart.set_colours([colour, 'ffffff', 'ffffff']) chart.set_bar_width(40) chart.add_data([0, pm10val, 0]) chart.add_data([35, 1, 1]) chart.add_data([1, 1, 1]) chart.set_axis_labels(Axis.LEFT, [0, 25, 50]) chart.add_marker(1, 0, 'tLimit (35)', 'ad0000', 11) chart.add_marker(0, 1, 'fSo far (%s)' % (pm10val), colour, 11) chart.add_marker(0, 2, 'tSafe (0)', '45bb00', 11) #print '<img src="%s"></img>' % chart.get_url() import scraperwiki.sqlite from pygooglechart import StackedVerticalBarChart, Axis # Get data sourcescraper = 'annual_animal_deaths' scraperwiki.sqlite.attach(sourcescraper, "src") sdata = scraperwiki.sqlite.execute( "select Year, Dates, State, Location, Mortality from src.swdata WHERE Mortality > 1000" ) rows = sdata.get("data") print rows
# pm10val = int(rows[4]) # print pm10val pm10val = int(rows[0][4]) colour = 'ad0000' # Draw the bar chart chart = StackedVerticalBarChart(150, 200, y_range=(0, 4000)) chart.set_colours([colour, 'ffffff', 'ffffff']) chart.set_bar_width(40) chart.add_data([0,pm10val,0]) chart.add_data([35,1,1]) chart.add_data([1,1,1]) chart.set_axis_labels(Axis.LEFT,[0,25,50]) chart.add_marker(1,0,'tLimit (35)','ad0000',11) chart.add_marker(0,1,'fSo far (%s)' % (pm10val),colour,11) chart.add_marker(0,2,'tSafe (0)','45bb00',11) #print '<img src="%s"></img>' % chart.get_url() import scraperwiki.sqlite from pygooglechart import StackedVerticalBarChart, Axis # Get data sourcescraper = 'annual_animal_deaths' scraperwiki.sqlite.attach(sourcescraper, "src") sdata = scraperwiki.sqlite.execute("select Year, Dates, State, Location, Mortality from src.swdata WHERE Mortality > 1000") rows = sdata.get("data") print rows # for row in rows:
if 0 < pm10val < 20: colour = "00ff00" elif 20 < pm10val < 30: colour = "f07f00" else: colour = "ad0000" # Draw the bar chart chart = StackedVerticalBarChart(150, 200, y_range=(0, 50)) chart.set_colours([colour, "ffffff", "ffffff"]) chart.set_bar_width(40) chart.add_data([0, pm10val, 0]) chart.add_data([35, 1, 1]) chart.add_data([1, 1, 1]) chart.set_axis_labels(Axis.LEFT, [0, 25, 50]) chart.add_marker(1, 0, "tLimit (35)", "ad0000", 11) chart.add_marker(0, 1, "fSo far (%s)" % (pm10val), colour, 11) chart.add_marker(0, 2, "tSafe (0)", "45bb00", 11) print '<img src="%s"></img>' % chart.get_url() import scraperwiki.sqlite import os, cgi from pygooglechart import StackedVerticalBarChart, Axis # Get data GET = dict(cgi.parse_qsl(os.getenv("QUERY_STRING"))) print GET sourcescraper = "marylebone_air_monitoring_station_values" scraperwiki.sqlite.attach(sourcescraper, "src") sdata = scraperwiki.sqlite.execute("select td from src.swdata WHERE no = 4") rows = sdata.get("data") pm10val = int(rows[0][0])