skullplot.pl - plot data from a manual db select
# default to first column on x-axis, all following columns on y-axis skullplot.pl input_data.dbox # specifying that explicitly skullplot.pl --dependents='x_axis_field' --independents='y_axis_field1,y_axis_field2' input_data.dbox # additional "dependents" fields determine color/shape of points skullplot.pl --dependents='x_axis_field1,category_field1' --independents='y_axis_field1,y_axis_field2' input_data.dbox # compact way of specifying similar case: first two columns independent, remaining columns dependent skullplot.pl --indie_count=2 input_data.dbox # don't use /tmp as working area skullplot.pl --working_loc='/var/scratch' input_data.dbox # turn on debugging skullplot.pl -d input_data.dbox
skullplot.pl is a script which use's the R ggplot2 library to plot data input in the form of the output from a SELECT as performed manually in a db shell, e.g.:
+------------+---------------+-------------+ | date | type | amount | +------------+---------------+-------------+ | 2010-09-01 | factory | 146035.00 | | 2010-10-01 | factory | 208816.00 | | 2011-01-01 | factory | 191239.00 | | 2010-09-01 | marketing | 467087.00 | | 2010-10-01 | marketing | 409430.00 | +------------+---------------+-------------+
I call this "box format data" (file extension: *.dbox).
This script takes the name of the *.dbox file containing the data as an argument. It has a number of options that control how it uses the data
The second argument is a comma-separated list of names of dependent variables (the x-axis). The third argument is a comma-separated list of the independent variables to plot (the y-axis).
The default for dependent variables: the first column. The default of independent variables: all of the following columns
The supported input data formats are as in the Table::BoxFormat module. At present, this is mysql and postgresql (including the unicode form).
Joseph Brenner, <doom@kzsu.stanford.edu>
Copyright (C) 2016 by Joseph Brenner
This program is free software; you can redistribute it and/or modify it under the terms of either: the GNU General Public License as published by the Free Software Foundation; or the Artistic License.
See http://dev.perl.org/licenses/ for more information.
To install Graphics::Skullplot, copy and paste the appropriate command in to your terminal.
cpanm
cpanm Graphics::Skullplot
CPAN shell
perl -MCPAN -e shell install Graphics::Skullplot
For more information on module installation, please visit the detailed CPAN module installation guide.