Data Analytics & Visualization using Google Colab

Job ID: 40512354

Budget: $10 – $30 USD

Math for Data Analytics and Visualizing Distribution
1. Consider the following matrix:

Matrix
57 67 35 47
59 62 77 22
24 44 72 21

-What are its dimensions?
-Create a numpy array corresponding to this matrix.
-Create a numpy array of shape (5,3) and fill it with random integers.

2. Using pandas,

-Load the Walmart sales dataset
-Select store 1 and plot its weekly sales over time. Make sure to adhere to visualization guidelines in your plot.
-Identify trends, peaks, and valleys in the sales.
-Modify your plot to also display the occurrence of holidays.

3. Using the Walmart sales data for store 1, you will now create a simple probabilistic model for sales

-Create an additional column, named ‘Week Number’ in your dataframe that translates the ‘Date’ to the week of the year.
-(For example, 2/5/2010 should be 5, and 7/29/2011 should be 30. Hint: pd.to_datetime(*Date Column*, format='%d-%m-%Y').dt.isocalendar().week)
-Compute the average sales per week of the year.
-Plot the result.
-Identify trends, peaks, and valleys in the plot.