Exploring Dow Jones
The Dow Jones Industrial Average, is a stock market index of 30 prominent companies listed on stock exchanges in the US. In this project, I obtain the various data of the companies in the index via web scraping (Pandas and Yahoo Finance), clean the data and create a database using Python. Finally, interactive dashboards are created using Microsoft Power BI and Tableau.
A sample output is shown below.
Few rows and columns from the created data table is shown below.
| zip | sector | fullTimeEmployees | city | state | country | website | |
|---|---|---|---|---|---|---|---|
| 1 | 10285 | Financial Services | 64000 | New York | NY | United States | https://www.americanexpress.com |
| 2 | 91320-1799 | Healthcare | 24200 | Thousand Oaks | CA | United States | https://www.amgen.com |
| 3 | 95014 | Technology | 154000 | Cupertino | CA | United States | https://www.apple.com |
| 4 | 60606-1596 | Industrials | 142000 | Chicago | IL | United States | https://www.boeing.com |