Data Mining & Python for Marketing Analytics

What is the main goal of data mining in marketing analytics?

• Forecast stock prices

• Improve UI design

• Extract patterns from data to make better marketing decisions

• Compress files

Which of these is an example of unstructured data?

• Sales spreadsheet

• Customer age list

• Product reviews

• Revenue chart

How would you manually extract product reviews from a website?

• Use pandas

• Write SQL queries

• Copy and paste text from the website

• Use matplotlib

What is the first step in cleaning text data for analysis?

• Draw a plot

• Remove punctuation and special characters

• Convert to CSV

• Send it to Excel

What does this Python function do?

df['Ratings'] = df['rating'].apply(lambda x: float(x.split()[0]))

• Tokenizes review text

• Extracts rating score from a string

• Removes null values

• Creates a pivot table

Which Python library is commonly used for text preprocessing?

• pandas

• matplotlib

• NLTK

• seaborn

What is the output of

df.groupby('Ram')['Ratings'].mean()?

• List of products by color

• Average rating for each RAM size

• Total number of reviews

• Maximum rating

Why is extracting product variants from the product name useful?

• It helps identify the file format

• It shows sales trends by variant

• It hides the product model

• It's required by matplotlib