This is an exmple of how to conduct basic Exploratory Data Analysis, or EDA, is an important step in any Data Analysis or Data Science project. EDA is the process of investigating the dataset to discover patterns, and anomalies (outliers), and form hypotheses based on our understanding of the dataset.
This was conducted using as Python by the pandas library. Using a monthly Stock market dataset of Five companies IBMStock,GEStock, ProcterGambleStock, CocaColaStock, BoeingStock from 1970
- Which stock price fell the most right after the tech bubble of March 2000?
- What stock had the highest maximum price between 1995-2005?
- Which stock seemed to provide the best return (i.e. increase in price) between 2004-2005?
- Between 1995-2005, which company had the biggest delta between the maximum and minimum stock price?
- For IBM, compare the average stock price for each month to the its overall average stock price and identify all the months for which IBM historically had a higher stock price (we call this over- indexing)? Which month over-indexed the most?
- What trend do you see for the months of December vs January for each company? Is there an over-arching trend that applies to all companies when comparing all historical December vs January stock prices?