Great Lakes Christian College
Latest uploads at Great Lakes Christian College. Looking for notes at Great Lakes Christian College? We have lots of notes, study guides and study notes available for your school.
-
17
- 0
- 0
All courses for Great Lakes Christian College
Latest notes & summaries Great Lakes Christian College
MARKETING & 
RETAIL 
ANALYTICS 
MILESTONE - 2 
SANDYA VB 
 
z 
PROBLEM STATEMENT 
▪ A Grocery Store shared the transactional data with 
you. Your job is to identify the most popular combos 
that can be suggested to the Grocery Store chain after 
a thorough analysis of the most commonly occurring 
sets of items in the customer orders. The Store 
doesn’t have any combo offers. Can you suggest the 
best combos & offers? 
▪ DATA: dataset_ 
z 
TOOLS USED 
▪ TABLEAU Tool: Used for Exploratory ...
QM 501 Project-Time series Forecasting- Final 2023& study guide with complete solution
PROBLEM STATEMENT 
▪ An automobile parts manufacturing company has collected data 
of transactions for 3 years. They do not have any in-house data 
science team, thus they have hired you as their consultant. Your 
job is to use your magical data science skills to provide them 
with suitable insights about their data and their customers. 
▪ DATA: Sales_D 
z 
DATA DICTIONARY 
ORDERNUMBER : Order Number CUSTOMERNAM 
E : customer 
QUANTITYORDERED 
: 
Quantity ordered PHONE : Phone of the custome...
PROBLEM STATEMENT 
▪ An automobile parts manufacturing company has collected data 
of transactions for 3 years. They do not have any in-house data 
science team, thus they have hired you as their consultant. Your 
job is to use your magical data science skills to provide them 
with suitable insights about their data and their customers. 
▪ DATA: Sales_Dat
Problem: 
For this particular assignment, the data of different types 
of wine sales in the 20th century is to be analysed. Both 
of these data are from the same company but of different 
wines. As an analyst in the ABC Estate Wines, you are 
tasked to analyse and forecast Wine Sales in the 20th 
century. 
Dataset - R 
In [1]: import numpy as np 
import pandas as pd 
import seaborn as sns 
from matplotlib import pyplot as plt 
from import rcParams 
rcParams['ze'] = 13, 6 
1. Read the data as ...
DATA SCIEN Predictive Modeling P
import pandas as pd 
import numpy as np 
from sklearn import preprocessing 
from _selection import train_test_split 
from _bayes import GaussianNB 
from cs import accuracy_score 
import seaborn as sns 
import t as plt 
from import zscore 
import warnings 
rwarnings( "ignore") 
from r_model import LinearRegression 
from er import KMeans 
from cs import mean_squared_error 
from ers_influence import variance_inflation_fac 
tor 
import math 
from r_model import LogisticRegression 
from sklearn im...
1. Read the data as an appropriate Time Series data and plot the data. 
 The two datasets: Rose and Sparkling are imported using the read command. And convert to time series 
data using 
date_range function: 
date = _range(start='01/01/1980', end='08/01/1995', freq='M')date 
df['Time_Stamp'] = pd.DataFrame(date,columns=['Month']) 
() 
o/p: 
ROSE WINE YEAR WISE SALES 
• From the above plot we observe that there is a 
decreasing trend in the initial years and stabilizes 
over the years...
Time Series Project 
1. 
Imported the series in two ways, each row has an associated date. This is 
in fact not a column, but instead a time index for value. As an index, we 
see single value of wine sales across times. While uploading in df_1 we 
have passed the argument of parse dates=true and squeeze=true, 
indicating the first column as dates and it needs to be parsed, through 
squeeze we indicating one column and a series. 
While df_2 is upload without any argument we are adding time stamp ...
MARKETING & 
RETAIL 
ANALYTICS 
MILESTONE - 2 
▪ A Grocery Store shared the transactional data with 
you. Your job is to identify the most popular combos 
that can be suggested to the Grocery Store chain after 
a thorough analysis of the most commonly occurring 
sets of items in the customer orders. The Store 
doesn’t have any combo offers. Can you suggest the 
best combos & offers? 
▪ DATA: dataset_ 
z 
TOOLS USED 
▪ TABLEAU Tool: Used for Exploratory Analysis 
Link: 
▪ PYTHON Tool: U...