Book Image

Data Science for Marketing Analytics - Second Edition

By : Mirza Rahim Baig, Gururajan Govindan, Vishwesh Ravi Shrimali
Book Image

Data Science for Marketing Analytics - Second Edition

By: Mirza Rahim Baig, Gururajan Govindan, Vishwesh Ravi Shrimali

Overview of this book

Unleash the power of data to reach your marketing goals with this practical guide to data science for business. This book will help you get started on your journey to becoming a master of marketing analytics with Python. You'll work with relevant datasets and build your practical skills by tackling engaging exercises and activities that simulate real-world market analysis projects. You'll learn to think like a data scientist, build your problem-solving skills, and discover how to look at data in new ways to deliver business insights and make intelligent data-driven decisions. As well as learning how to clean, explore, and visualize data, you'll implement machine learning algorithms and build models to make predictions. As you work through the book, you'll use Python tools to analyze sales, visualize advertising data, predict revenue, address customer churn, and implement customer segmentation to understand behavior. By the end of this book, you'll have the knowledge, skills, and confidence to implement data science and machine learning techniques to better understand your marketing data and improve your decision-making.
Table of Contents (11 chapters)
Preface

1. Data Preparation and Cleaning

Activity 1.01: Addressing Data Spilling

Solution:

  1. Import the pandas and copy libraries using the following commands:

    import pandas as pd

    import copy

  2. Create a new DataFrame, sales, and use the read_csv function to read the sales.csv file into it:

    sales = pd.read_csv("sales.csv")

    Note

    Make sure you change the path (emboldened) to the CSV file based on its location on your system. If you're running the Jupyter notebook from the same directory where the CSV file is stored, you can run the preceding code without any modification.

  3. Now, examine whether your data is properly loaded by checking the first five rows in the DataFrame. Do this using the head() command:

    sales.head()

    You should get the following output:

    Figure 1.60: First five rows of the DataFrame

  4. Look at the data types of sales using the following command:

    sales.dtypes

    You should get the following output:

    Figure 1.61: Looking at the data type of columns of sales.csv

    You can...