Submission:

Submit a single doc$/$pdf file that has Spark codes and an English description of what your code is

doing. Also, include screenshots of your code and the output in the file. Perform the commands on

"pyspark" console.

$-------------------------------------------$

$--$ Part I $(40$pts$)--$

$-------------------------------------------$

This dataset provides a curated subset of the anonymized Google Analytics event data for three

months of Google Merchandise Store. The data includes information on items sold in the store and

how much money was spent by users over time. It is both comprehensive enough to invite real

analysis yet simple enough to facilitate teaching.

Find events.csv$,$ itmes.csv and users.csv files from the course shell and answer the following

questions:

Q$1.$ How Many Google items were purchased in November $2020?(10$ pts$)$

Q$2.$ How many mobile devices were purchased in December? $(10$ pts$)$

Q$3.$ Sort the countries based on their sold items in descending order? $(10$ pts$)$

Q$4.$ What are the price range for US devices being purchased? $(10$ pts$)$

Q$5.$ Which country has the highest income from sold devices? $(10$ pts$)$ solev the $5$ question using these csv files in a hadoop environments using spark,spark streaming and spark sql

items

A B C D id Itv date $00$ ####### $10$ ######## $20$ ######## $3231$ ####### $4102$ ######## $50$ ####### $675$ ####### $755$ ####### $820$ ####### $941$ ######## $100$ ####### $110$ ####### $120$ ####### $130$ ######## $143360$ ####### $15704$ ####### $160$ ####### $17378$ ######## $180$ ####### $190$ ####### $200$ ####### $210$ ######## $220$ ####### $23167$ ####### $240$ ######## $250$ ######## $260$ ######## $270$ ######## $28285$ ####### $290$ ######## $300$ ######## $31111$ ######## $320$ ######## $330$ ####### $340$ ########