PortfolioAssignment5.1 by Ravi Duvvuri
REPOSITORY DETAILS:
1.Jupyter Notebook
https://github.com/ravikduvvuri/PortfolioAssignment5.1
Assignment5.1__Ravi_Duvvuri .ipynb
2.Dataset
coupons.csv
EXECUTION DETAILS
STEP1: Analysis of the dataset
A. Checked datasets using info(), Describe(), head() etc.
B. Checked for duplicate data
Duplicate data identified:
C. Checked for missing values
Missing values identified
D. Analyzed how to fill-in missing values
E. Finalized what data to drop
STEP2: CLEAN UP of DATA
-
Drop 'Car' column data since greater than 99% is missing and is not useful for data analysis
-
Drop duplicated data of 74 rows as it is not going to impact the overall data of 12684 rows
-
Fill-in missing values for other columns using appropriate method (ex. mode)
STEP3: OBSERVATIONS
1.Carry out & Takeaway coupons were accepted more when presented
2.Similarly cheaper restaurant coupons (<20) were accepted more when presented
3.Younger Age groups (<30) tend to accept coupons when presented compared to other ages groups
4.When compared with widowed & divorced people, single & married people are lot
willing to accept coupons
STEP4: BAR COUPON INVESTIGATION and FINDINGS
Bar Coupons acceptance percentage: 41%
FINDINGS:
-
Only 41 % of Bar coupons were accepted by the drivers
-
The coupon acceptance rate of drivers who go to bar more than 3 times a month is very low at 7.6%
-
Acceptance rate of drivers who go to bar more than once a month and under the age of 30 is moderately high at 12.36%
-
Even though some drivers go to cheap restaurants more than 4 times a month they did not accept more bar coupons
Based on results, the age group under 30 and those who go to bar fewer times a month are more willing to accept bar coupons when presented.
STEP5: INDEPENDENT INVESTIGATION 'COFFEE HOUSE COUPON'
Coffee House Coupon Findings:
-
Younger generation under 30 years are accepting coffee house coupons more when compared to other groups
-
Coffee House Coupons acceptance is same at 7 am as well as at 2pm and 6pm. Seems like consumption is higher in the evenings.
-
Compared to Divorced and Widowed people, other groups Coffee House coupon acceptance is very high (<~2.5% versus ~20%)
NEXT STEPS
A. Analyze other coupons data and see if any patterns are same across all coupon types
B. Recommend offers to those groups with appropriate coupons and timing