Comparison of Birth and Death Rates for a Country
Created: 2011-11-27 20:58:46
Last updated: 2011-11-27 21:05:49
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
Run
Run this Workflow in the Taverna Workbench...
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. ScriptString 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. ScriptString 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. ScriptString 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. Scriptoutput = string1 + string2; |
| string1_value |
stringconstant |
Value| |
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 |
Uploader
License
All versions of this Workflow are
licensed under:
Version 1
(of 1)
Credits (1)
(People/Groups)
Attributions (0)
(Workflows/Files)
None
Shared with Groups (0)
None
Featured In Packs (0)
None
Log in to add to one of your Packs
Attributed By (0)
(Workflows/Files)
None
Favourited By (0)
No one
Statistics
Other workflows that use similar services
(0)
There are no workflows in myExperiment that use similar services to this Workflow.
Download Workflow
]
Reviews
(0)
No comments yet
Log in to make a comment