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(' ', '')))
示例#3
0
#    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])