MCMD2 : Command Reference : mshare - Calculate Composition Ratio

3.53 mshare - Calculate Composition Ratio

Calculate the composition ratio of the fields specified in f=, and add results as a new field.

Format

mshare f= [k=] [i=] [o=] [-tmpPath] [-nfn] [-nfno] [-x] [-q] [--help] [--version]

Parameters

`f=`	Calculate share value of field(s) (multiple fields can be specified) specified here.
	Specify the new field name using : (colon). Example: f=Quantity:volume share.
`k=`	Specify the list of field name(s) (multiple items can be specified) as the unit to calculate share.
	If the key is omitted, all lines are assumed to have the same key value.

Example

Example 1: Basic Example

Calculate the share of "quantity" and "amount" fields for each "customer". Save the output in columns "volume share" and "share amount”.

$ more dat1.csv
customer,quantity,amount
A,1,10
A,2,20
B,1,15
B,3,10
B,1,20
$ mshare k=customer f=quantity:qtyShare,amount:amountShare i=dat1.csv o=rsl1.csv
#END# kgshare f=quantity:qtyShare,amount:amountShare i=dat1.csv k=customer o=rsl1.csv
$ more rsl1.csv
customer%0,quantity,amount,qtyShare,amountShare
A,1,10,0.3333333333,0.3333333333
A,2,20,0.6666666667,0.6666666667
B,1,15,0.2,0.3333333333
B,3,10,0.6,0.2222222222
B,1,20,0.2,0.4444444444

Related Command