From the course: Data Science on Google Cloud Platform: Exploratory Data Analytics

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Segmentation and profiling

Segmentation and profiling - Google Cloud Tutorial

From the course: Data Science on Google Cloud Platform: Exploratory Data Analytics

Start my 1-month free trial

Segmentation and profiling

“

- [Instructor] Segmentation and profiling of data is one of the primary goals of exploratory data analysis. Data is summarized through multiple profiling variables and analysis is done to understand causal relationships. In this example, we are going to find conversion ratio based on the discount percentage offered. Conversion ratio is the total number of customers who converted divided by the total number of email offers that was sent. In order to do this analysis, we first summarize data using the groupby to find total offers and total conversions by the discount percentage. We then merge the data into a single DataFrame. Then we compute conversion ratio by dividing the number of conversions by the number of offers. We finally print the DataFrame. The same data is then used to create a bar graph to show conversion ratios by discount rate. From the bar graph, it is easy to interpret that higher the discount rate, the higher the conversion rate.

Contents