About Dataset

Context

This dataset contains financial information of 1500 companies across 8 different industries scraped from companiesmarketcap.com on May 2024. It contains information about the company's name, industry, country, employees, marketcap, revenue, earnings, etc.

• The scraped program of this dataset can be found in Industry Market Cap Analysis Github repository.
• Tableau visualization of this dataset can also be found in Industry Market Cap: Visualization

Content

The dataset contains 2 files with the same column names. scraped_company_data.csv file is further transformed and cleaned to produce the finaltransformed_company_data.csvfile.

1. Company: Full name of the company
2. Company Path: Website URL of the company
3. Industry: Associated industry of the company
4. Country: Location of the company
5. Employees: Total number of employees of the company
6. Market Cap: Market capital of the company (as of Mar 2024)
7. Revenue: Company's current revenue (31 Mar 2023 - 31 Mar 2024)
8. Earnings: Company's current earnings (31 Mar 2023 - 31 Mar 2024)
9. Operating Margin: Company's current operating margin (at the end of 2023)
10. Total Assets: Company's total assets (as of Mar 2024)
11. Total Liabilities: Company's total liabilities
12. Total Debt: Company's total debt
13. Net Assets: Company’s net assets
14. PE Ratio: Company's current price-to-earnings ratio (31 Mar 2023 - 31 Mar 2024)
15. PS Ratio: Company's current price-to-sales ratio (31 Mar 2023 - 31 Mar 2024)

Acknowledgements

The website companiesmarketcap.com was used to scrape this dataset. Please include citations for this dataset if you use it in your own research.

Inspiration

The dataset can be used to find industries with the highest average market value, most profitable industries, most growth-oriented sectors, etc. More interesting insights can be found in this README file.