Question: Please suggest steps 6 and 7 (best cleansing and visualization tools) for the below project with a brief explanation. 1. Project Description: Our group project
Please suggest steps 6 and 7 (best cleansing and visualization tools) for the below project with a brief explanation.
1. Project Description: Our group project will focus on visualizing the impact of COVID-19 on the US Stock Market. The project will analyze stock market fluctuations during the pandemic, highlighting key trends, sector-wise performance, and major events that influenced market movements. Using historical stock data from major indices such as the S&P 500, NASDAQ, and Dow Jones, we will create visualizations that showcase volatility, recovery patterns, and investor sentiment during different phases of the pandemic.
2. Objective: The objective of this project is to analyze and visualize how the US Stock Market reacted to COVID-19, including sharp declines, recovery trends, and sector-specific variations. By leveraging data visualization, we aim to:
- Identify Market Trends - Show how the stock market performed during key periods of the pandemic (e.g., initial crash in March 2020, vaccine announcements, stimulus packages).
- Sector-Wise Analysis - Compare industries such as technology, healthcare, travel, and retail to assess which sectors benefited or suffered the most.
- Volatility and Investor Sentiment - Use metrics like market volatility (VIX), trading volume, and stock price fluctuations to understand investor behavior during uncertainty.
- Policy and Event Impact - Correlate stock performance with major events like lockdowns, government stimulus, and vaccine rollouts.
By visualizing this dataset, we aim to provide a clear, data-driven representation of the market's response to an unprecedented global crisis, helping investors and researchers understand historical patterns for future decision-making.
3. Hypothesis:
- Technology sector stocks, particularly those related to remote work and e-commerce, will show significantly higher growth rates compared to traditional retail and travel stocks during the peak of the pandemic (2020-2021).
- Healthcare and pharmaceutical companies involved in vaccine development will experience substantial stock price increases, outperforming the overall market in the years following the initial outbreak (2021-2023).
- The energy sector, especially oil and gas companies, will exhibit a sharp decline in stock prices during the early stages of the pandemic due to reduced global travel and economic activity, followed by a gradual recovery as restrictions ease.
- Companies with strong online presence and digital transformation capabilities will demonstrate more stable stock performance and faster recovery compared to those relying heavily on physical operations
- The financial sector, particularly banks, will show increased volatility and slower recovery compared to the overall market due to low interest rates and increased loan default risks during the pandemic period
4. Data Sources: Explain the dataset (s) attributes and provide the data link (s) for primary and secondary (if any) dataset (s).
5. Number of Records: How many records in the dataset? There dataset should be at least 2,500 records in your dataset. However, should you not get enough COVID data records in your idea relevant dataset, you may work with a smaller number of records with your instructor's permission.
6. Data Cleansing Tool: What data cleansing tool will you use? Why will your group use this tool?
7. Visualization Tool: What visualization tool will you use? Why will your group use this tool?
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
