Data Analytics & Visualization using Google Colab
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.
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.
Related categories:
Data Processing
Statistical Analysis
Data Science
Data Analytics
NumPy
Data Visualization
Data Analysis
Pandas