· Outline for An Exploratory of Public Opinion about Online Shopping During COVID-19 1) Define your data sources and why you are using them. what are the key fields you will be using? 1/4 page 5 marks...

1 answer below »

· Outline for An Exploratory of Public Opinion about Online Shopping During COVID-19
1) Define your data sources and why you are using them.
     what are the key fields you will be using?  1/4 page 5 marks
2) how will you be extracting the data.  1/4 page - 5 marks
3)how will you create the final analytical file and what are the key fields you will be using in your analysis  1/4 page- 5  marks
4) What types of analyses will you run and why - 1/2 page   5marks
5)   Key Reports and Findings-  3 pages-30 marks
6) Appendix- all reports that you produced should be there along with your findings. Again, the key reports and findings should come from this appendix. Add bullet points for each source/article    -50 marks
If you have any questions, please do not hesitate to ask.  please do not go over the page limit or you will be penalized.
· outline for the museum project
1) Define your data sources and why you are using them.
     what are the key fields you will be using?  1/4 page 5 marks
2) how will you be extracting the data.  1/4 page - 5 marks
3)how will you create the final analytical file and what are the key fields you will be using in your analysis  1/4 page- 5  marks
4) What types of analyses will you run and why - 1/2 page   5marks
5)   Key Reports and findings-  2 pages-30 marks
6) Appendix- all reports that you produced should be there along with your findings. Again, the key reports and findings should come from this appendix. Add bullet points for each source/article       -50 marks
If you have any questions, please do not hesitate to ask.  please do not go over the page limit or you will be penalized.
Basically, you need to do 2 written reports (Word) for 2 projects. Follow the outline. The reports should focus on data analysis. You need to collect data from different sources(Eg. Twitter, Facebook, Websites…) and conduct data analysis using Python/SQL/Tableau then show the results in part 5) in both projects.
Project 1: Talk about online shopping during Covid in general, use data to demonstrate your thinking
Project 2: Talk about how digital transformation affected the museum industry and the visitor experience. (During Covid, a lot of museums went online and started offering an online experience. You can find a lot of info about the artifacts/arts online these days). Use data to demonstrate your thinking.
Complete these 2 reports in 2 different Word files. Use MLA style.
I also uploaded some supporting files to help you finish these 2 projects. Good luck!
Answered 3 days AfterApr 13, 2022

Solution

Chirag answered on Apr 16 2022
10 Votes
An Exploratory of Public Opinion about Online Shopping During COVID-19
· Data Sources
For performing the exploratory data analysis we first have to collect some real data that we can use for for the purpose. Here we have collected the data from the Kaggle and statista-. Among all the available data we are using some key fields which are as follows: product categories, customer id, state, market, sales, quantity, profit, etc.
· Extracting the data
On the website of Kaggle we have searched for the relevant data to get the analysis of the public opinion about online shopping during covid - Also how online shopping had made a difference in the market during covid- which one (online or offline was more likable by people). Over the platform we got some relevant data. Then we looked for how we can extract this data so that we can do analysis over it. Over the data there is an option to extract or download the data in the csv format. There were two files available for dataset – one is csv file and other is excel data, so we have downloaded the both files – that we can use for further analysis of insights, patterns in online vs offline shopping during covid so that more conclusions can be made over what people are liking and what is their opinion.
· Creating final analytical file
We will create final analytical file using python. First we will read the csv file into the python environment, There we will be doing data cleaning and data pre-processing so that our analysis is perfectly showing outputs based on the good data and not on random and unnecessary stuffs. Although our file have a huge number of columns but we will be using some major key columns to be more precise about the kind of findings we are looking for. The final key columns that we will be using are product categories, customer id, state, market, sales, quantity, profit, etc.
Then we will use seaborn and matplotlib along with pandas for the final analysis.
· Type of analysis
We will run kind of analysis that will help us to understand people’s choice, perspective, behaviours, liking towards online and offline shopping. We will do analysis to detect that when people have shopped more (online or offline). What other factors are there that are influencing people’s shopping behaviour during online and offline scenarios. Also, we will try to look at descriptive statistical analysis of the data to check what kind of data distribution we have in our data.
Other than that we will try to visualize some of the key fields available in the data so derive conclusions. For visualization, python modules like seaborn and matplotlib will...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here