Comparison of Birth and Death Rates for a Country

Created: 2011-11-27 20:58:46 Last updated: 2011-11-27 21:05:49

Download Workflow

This workflow extracts the relevant data from two spreadsheets, formats the data strings, and puts that data through a REST to Google Charts.

Data collected for this project comes from data.un.org. Currently, the workflow supports data from only one country at a time (data from data.un.org can be filtered and exported directly from the website). Data from the Live births by month and Deaths by month works best with this workflow.

Preview

Download as scalable diagram (SVG)

Run

Run this Workflow in the Taverna Workbench...

Option 1:

Copy and paste this link into File > 'Open workflow location...'
http://www.myexperiment.org/workflows/2593/download?version=1
[ More Info Expand ]

Workflow Components

Authors (0)

Titles (0)

Descriptions (0)

Dependencies (0)

Inputs (3)

Name	Description
birthData	Input for spreadsheet with data for births by month.
deathData	Input for spreadsheet with data for deaths by month.
graphTitle	The title of the graph.

Processors (11)

Name	Type	Description
birthsByMonth	spreadsheet	Spreadsheet import and separation by row. The first two rows of data are removed from this spreadsheet. These two rows include the headers and the total yearly value.
deathsByMonth	spreadsheet	Spreadsheet import and separation by row. The first two rows of data are removed from this spreadsheet. These two rows include the headers and the total yearly value.
REST_Service_2	rest	The REST service. Runs through the Google Charts API to create a line chart. The line chart includes: two values (one for births and one for deaths), a month label across the X axis, and numberical labels across the Y axis.
Merge_String_List_to_a_String	localworker	Merges the list of strings into a single string. This is necessary for appropriate interface with the REST service. Script String seperatorString = "\n"; if (seperator != void) { seperatorString = seperator; } StringBuffer sb = new StringBuffer(); for (Iterator i = stringlist.iterator(); i.hasNext();) { String item = (String) i.next(); sb.append(item); if (i.hasNext()) { sb.append(seperatorString); } } concatenated = sb.toString();
Merge_String_List_to_a_String_3	localworker	Merges the list of strings into a single string. This is necessary for appropriate interface with the REST service. Script String seperatorString = "\n"; if (seperator != void) { seperatorString = seperator; } StringBuffer sb = new StringBuffer(); for (Iterator i = stringlist.iterator(); i.hasNext();) { String item = (String) i.next(); sb.append(item); if (i.hasNext()) { sb.append(seperatorString); } } concatenated = sb.toString();
Merge_String_List_to_a_String_2	localworker	Merges the list of strings into a single string. This is necessary for appropriate interface with the REST service. Script String seperatorString = "\n"; if (seperator != void) { seperatorString = seperator; } StringBuffer sb = new StringBuffer(); for (Iterator i = stringlist.iterator(); i.hasNext();) { String item = (String) i.next(); sb.append(item); if (i.hasNext()) { sb.append(seperatorString); } } concatenated = sb.toString();
seperator_bar	stringconstant	Separator value: vertical bar. Separates values by a vertical bar. This is the format required for appropriate input into the REST function. Value \|
seperator_comma	stringconstant	Separator value: comma. Separates values by a comma. This is the format required for appropriate input into the REST function. Value ,
seperator_comma_2	stringconstant	Separator value: comma. Separates values by a comma. This is the format required for appropriate input into the REST function. Value ,
Concatenate_two_strings	localworker	Concatenates the previous string with a starting bar. This is necessary for appropriate interface with the REST service. Script output = string1 + string2;
string1_value	stringconstant	Value \|

Beanshells (0)

Outputs (1)

Name	Description
output	The resulting chart from Google Charts API.

Datalinks (15)

Source	Sink
birthData	birthsByMonth:fileurl
deathData	deathsByMonth:fileurl
graphTitle	REST_Service_2:title
Merge_String_List_to_a_String_2:concatenated	REST_Service_2:birthRate
Merge_String_List_to_a_String_3:concatenated	REST_Service_2:deathRate
Concatenate_two_strings:output	REST_Service_2:month
seperator_bar:value	Merge_String_List_to_a_String:seperator
deathsByMonth:month	Merge_String_List_to_a_String:stringlist
deathsByMonth:deathRate(value)	Merge_String_List_to_a_String_3:stringlist
seperator_comma_2:value	Merge_String_List_to_a_String_3:seperator
seperator_comma:value	Merge_String_List_to_a_String_2:seperator
birthsByMonth:birthRate(value)	Merge_String_List_to_a_String_2:stringlist
Merge_String_List_to_a_String:concatenated	Concatenate_two_strings:string2
string1_value:value	Concatenate_two_strings:string1
REST_Service_2:responseBody	output

Coordinations (0)

Information Workflow Type

Taverna 2

Information Uploader

tpacurtis

Information License

All versions of this Workflow are licensed under:

Information Version 1 (of 1)

Information Credits (1)

(People/Groups)

tpacurtis

Information Attributions (0)

(Workflows/Files)

None

Information Tags (4)

Uploader tags

Log in to add Tags

Information Shared with Groups (0)

None

Information Featured In Packs (0)

None

Log in to add to one of your Packs

Information Attributed By (0)

(Workflows/Files)

None

Information Favourited By (0)

No one

Information Statistics

1110 viewings

933 downloads

[ see breakdown ]

Citations (0)

None

Version History

In chronological order:

Comparison of Birth and Death Rates for a Country

Created by tpacurtis on Sunday 27 November 2011 20:58:46 (UTC)

Last edited by tpacurtis on Sunday 27 November 2011 21:05:51 (UTC)