Question: Using R studio show Code For this module we will be using the completejottrney data sets. However, rather than use the salu ple transaction data

Using R studio show Code

Using R studio show Code For this module we will be using

For this module we will be using the completejottrney data sets. However, rather than use the salu ple transaction data {transactionsamplej we will be using the entire transaction data set provided by get_ transact ionsII} and the entire promotions data set provided by get_promotions t). 1. 6. Using the transactions and demographics data, how many oi" the 1146917\")? transactions do we have demographic information lor'? How many of the transactions do we not have demographic i11lor111atio11 on'.' . Using the transactions and demographics data, compute the total eales_va1ue by age category to identify which age group generates the most sales. Identify all households thal. have total sales (salee_va1ne) ol' 5']le or more. Using the demographics data, how many ol1.he.-aa households do we have demographic data on? How many do we not have demographic on? For those thal. we do have demographics on, which income range produces the most households thal. spend $100\" or Inore'.' . Using the promotions and transactions data. compute the total sales for all products that. were in a display in the front of the store (display_1ocation 1}. Now compute the total sales For each product displayed in the front of the store [display_location = l} and identify the product_id that had the largest total sales. Warning - you may run into memory problems because you are trying to join two very large data sets. I recommend that. you iirst lilter the promotions before joining. Using the coupons and products data._ identify which product_category is related to the coupon where campaign_id is equal to 18 and coupon_|ipc is equal to llHilKiU-lQZlH? Identify all diil'erent products that GURU-Lil] \"pizza\" in their produot_type description. Which of these products produces the greatest amount. of total sales [compute total sales by product l1) and product type}? Identify all products that. are categorized [product_category} as \"pi-raga\" bul. are considered a \"snack\" or \"appetiaer\" (via prodncLJype). Which of these products {product_id} have the most number of sales [measured by quantity)? Identify all products that contain \"peanut. butter\" in their product_ type. How many unique products does this nesult in? For these products: compute the total salee_value by month lacs-ed on the transaction_timesta|np. Which month pnoduces the most sales value for these products'.P Which month produces the least sales value for these products'.P

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!