App-CSVUtils-csv_mix_formulas

 view release on metacpan or  search on metacpan

README  view on Meta::CPAN

    second field (by default literally the second field, but can also be
    specified using "--weight-field") is assumed to contain the weight of
    ingredients. A percent form is recognized and will be converted to its
    decimal form (e.g. "60%" or "60.0 %" will become 0.6).

    Example, mixing this CSV:

     ingredient,%weight,extra-field1,extra-field2
     water,80,foo,bar
     sugar,15,foo,bar
     citric acid,0.3,foo,bar
     strawberry syrup,4.7,foo,bar

    and this:

     ingredient,%weight,extra-field1,extra-field2,extra-field3
     lemon syrup,5.75,bar,baz,qux
     citric acid,0.25,bar,baz,qux
     sugar,14,bar,baz,qux
     water,80,bar,baz,qux

    will result in the following CSV. Note: 1) for the header, except for
    the first two fields which are the ingredient name and weight which will
    contain the mixed formula, the other fields will simply collect values
    from all the CSV files. 2) for sorting order: decreasing weight then by
    name.

     ingredient,%weight,extra-field1,extra-field2,extra-field3
     water,80,foo,bar,qux
     sugar,14.5,foor,bar,qux
     lemon syrup,2.875,bar,baz,qux
     strawberry syrup,2.35,foo,bar,
     citric acid,0.275,foo,bar,qux

    Keywords: compositions, mixture, combine

    This function is not exported.

    Arguments ('*' denotes required arguments):

    *   ingredient_field => *str*

        Specify field which contain the ingredient names.

lib/App/CSVUtils/csv_mix_formulas.pm  view on Meta::CPAN

field (by default literally the second field, but can also be specified using
`--weight-field`) is assumed to contain the weight of ingredients. A percent
form is recognized and will be converted to its decimal form (e.g. "60%" or
"60.0 %" will become 0.6).

Example, mixing this CSV:

    ingredient,%weight,extra-field1,extra-field2
    water,80,foo,bar
    sugar,15,foo,bar
    citric acid,0.3,foo,bar
    strawberry syrup,4.7,foo,bar

and this:

    ingredient,%weight,extra-field1,extra-field2,extra-field3
    lemon syrup,5.75,bar,baz,qux
    citric acid,0.25,bar,baz,qux
    sugar,14,bar,baz,qux
    water,80,bar,baz,qux

will result in the following CSV. Note: 1) for the header, except for the first
two fields which are the ingredient name and weight which will contain the mixed
formula, the other fields will simply collect values from all the CSV files. 2)
for sorting order: decreasing weight then by name.

    ingredient,%weight,extra-field1,extra-field2,extra-field3
    water,80,foo,bar,qux
    sugar,14.5,foor,bar,qux
    lemon syrup,2.875,bar,baz,qux
    strawberry syrup,2.35,foo,bar,
    citric acid,0.275,foo,bar,qux

Keywords: compositions, mixture, combine

MARKDOWN
    add_args => {
        ingredient_field => {
            summary => 'Specify field which contain the ingredient names',
            schema => 'str*',
        },
        weight_field => {

lib/App/CSVUtils/csv_mix_formulas.pm  view on Meta::CPAN

field (by default literally the second field, but can also be specified using
C<--weight-field>) is assumed to contain the weight of ingredients. A percent
form is recognized and will be converted to its decimal form (e.g. "60%" or
"60.0 %" will become 0.6).

Example, mixing this CSV:

 ingredient,%weight,extra-field1,extra-field2
 water,80,foo,bar
 sugar,15,foo,bar
 citric acid,0.3,foo,bar
 strawberry syrup,4.7,foo,bar

and this:

 ingredient,%weight,extra-field1,extra-field2,extra-field3
 lemon syrup,5.75,bar,baz,qux
 citric acid,0.25,bar,baz,qux
 sugar,14,bar,baz,qux
 water,80,bar,baz,qux

will result in the following CSV. Note: 1) for the header, except for the first
two fields which are the ingredient name and weight which will contain the mixed
formula, the other fields will simply collect values from all the CSV files. 2)
for sorting order: decreasing weight then by name.

 ingredient,%weight,extra-field1,extra-field2,extra-field3
 water,80,foo,bar,qux
 sugar,14.5,foor,bar,qux
 lemon syrup,2.875,bar,baz,qux
 strawberry syrup,2.35,foo,bar,
 citric acid,0.275,foo,bar,qux

Keywords: compositions, mixture, combine

This function is not exported.

Arguments ('*' denotes required arguments):

=over 4

=item * B<ingredient_field> => I<str>

script/csv-mix-formulas  view on Meta::CPAN

field (by default literally the second field, but can also be specified using
C<--weight-field>) is assumed to contain the weight of ingredients. A percent
form is recognized and will be converted to its decimal form (e.g. "60%" or
"60.0 %" will become 0.6).

Example, mixing this CSV:

 ingredient,%weight,extra-field1,extra-field2
 water,80,foo,bar
 sugar,15,foo,bar
 citric acid,0.3,foo,bar
 strawberry syrup,4.7,foo,bar

and this:

 ingredient,%weight,extra-field1,extra-field2,extra-field3
 lemon syrup,5.75,bar,baz,qux
 citric acid,0.25,bar,baz,qux
 sugar,14,bar,baz,qux
 water,80,bar,baz,qux

will result in the following CSV. Note: 1) for the header, except for the first
two fields which are the ingredient name and weight which will contain the mixed
formula, the other fields will simply collect values from all the CSV files. 2)
for sorting order: decreasing weight then by name.

 ingredient,%weight,extra-field1,extra-field2,extra-field3
 water,80,foo,bar,qux
 sugar,14.5,foor,bar,qux
 lemon syrup,2.875,bar,baz,qux
 strawberry syrup,2.35,foo,bar,
 citric acid,0.275,foo,bar,qux

Keywords: compositions, mixture, combine

=head1 OPTIONS

C<*> marks required options.

=head2 Main options

=over