You might have some commands in earlier pages, here lets take one sample scenario & then we will try to find the issues/problems/requirements which can be related to that scenario. Then we will try to find the solution for those. I will keep on putting such scenarios as I come across, as this way we can understand the things around easily.
Scenario 1 : One telecom operator agency is running a campaign to launch a new post-paid plan, for that it has collected the results of that campaign in one csv file, which has all the required data & its format is like -
age, marital status, income, credit history, campaign results
Column types -
age : Int
marital status : String with one of the values - 'Single', 'Married', 'Unknown'
income : Double
credit history : Int within range of 1-10, 0 means not known
campaign results : String with one of the values - 'Yes', 'No', 'Yes' means got the customer, else didn't get
Above five columns will be there in the received csv file & below are the initial problem statements for which data needs to processed -
a) What percentage of customers agreed to get the plan?
b) In what age group, this plan is more successful?
c) Does the results are effected by marital status?
d) What type of customers are good to provide this plan? For this we need to analyse for good credit history.
You can create your own sample file with mentioned columns & give the data. Then try to find the solutions for the above questions.
I will be posting more questions in the same scenario & the answers later here. Apologies for delay, will take some more time as currently not doing any related work for past few months.
Scenario 1 : One telecom operator agency is running a campaign to launch a new post-paid plan, for that it has collected the results of that campaign in one csv file, which has all the required data & its format is like -
age, marital status, income, credit history, campaign results
Column types -
age : Int
marital status : String with one of the values - 'Single', 'Married', 'Unknown'
income : Double
credit history : Int within range of 1-10, 0 means not known
campaign results : String with one of the values - 'Yes', 'No', 'Yes' means got the customer, else didn't get
Above five columns will be there in the received csv file & below are the initial problem statements for which data needs to processed -
a) What percentage of customers agreed to get the plan?
b) In what age group, this plan is more successful?
c) Does the results are effected by marital status?
d) What type of customers are good to provide this plan? For this we need to analyse for good credit history.
You can create your own sample file with mentioned columns & give the data. Then try to find the solutions for the above questions.
I will be posting more questions in the same scenario & the answers later here. Apologies for delay, will take some more time as currently not doing any related work for past few months.
