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.

Company: Full name of the company
Company Path: Website URL of the company
Industry: Associated industry of the company
Country: Location of the company
Employees: Total number of employees of the company
Market Cap: Market capital of the company (as of Mar 2024)
Revenue: Company's current revenue (31 Mar 2023 - 31 Mar 2024)
Earnings: Company's current earnings (31 Mar 2023 - 31 Mar 2024)
Operating Margin: Company's current operating margin (at the end of 2023)
Total Assets: Company's total assets (as of Mar 2024)
Total Liabilities: Company's total liabilities
Total Debt: Company's total debt
Net Assets: Company’s net assets
PE Ratio: Company's current price-to-earnings ratio (31 Mar 2023 - 31 Mar 2024)
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.

Tables

Scraped Company Data

@kaggle.zibranzarif_industry_market_cap_analysis_dataset.scraped_company_data

130.43 KB
1500 rows
15 columns


CREATE TABLE scraped_company_data (
  "company" VARCHAR,
  "company_path" VARCHAR,
  "industry" VARCHAR,
  "country" VARCHAR,
  "employees" BIGINT,
  "marketcap" VARCHAR,
  "revenue" VARCHAR,
  "earnings" VARCHAR,
  "operating_margin" VARCHAR,
  "total_assets" VARCHAR,
  "total_liabilities" VARCHAR,
  "total_debt" VARCHAR,
  "net_assets" VARCHAR,
  "pe_ratio" VARCHAR,
  "ps_ratio" VARCHAR
);

Transformed Company Data

@kaggle.zibranzarif_industry_market_cap_analysis_dataset.transformed_company_data

138.75 KB
1500 rows
15 columns


CREATE TABLE transformed_company_data (
  "company" VARCHAR,
  "company_path" VARCHAR,
  "industry" VARCHAR,
  "country" VARCHAR,
  "employees" BIGINT,
  "marketcap" DOUBLE,
  "revenue" DOUBLE,
  "earnings" DOUBLE,
  "operating_margin" DOUBLE,
  "total_assets" DOUBLE,
  "total_liabilities" DOUBLE,
  "total_debt" DOUBLE,
  "net_assets" DOUBLE,
  "pe_ratio" DOUBLE,
  "ps_ratio" DOUBLE
);