Problem Statement :
We have a list of accounts (customers) and their phone call records to customer service since they were affected because of a network outage. The severity of the customer’s needs to be [url removed, login to view] the basis of the calls made by him and the usual calling pattern. Classify the accounts on the basis of below mentioned points :
· Calculate the mean (M) and standard deviation ($x) of the call data records.
· If the number of calls for a particular account / customer falls between (M + $x) and (M-$x) then classify the customer as ‘Safe’.
· If the number of calls made by the customer fall between (M+$x) and (M+2$x) then classify the customer as “Affected”.(Here 2 is a factor)
· Lastly if the number of calls made by the customer are beyond (M+2$x) then classify customer as “Extremely Affected”. Store the results in an output file with \t separator between fields
Note : Allow user to provide the factor parameter so that he can see variation in the results. (Optional)
2 freelancers are bidding on average $15 for this job
If you provide sample CDR, it'll be done in an hour. The factor will be defined at top of the code, so that you can change it as nessary. The output fileds are need to be defined.