Top 50 Indian Companies
Explore largest companies by revenue in 2021 according to the Fortune India 500.
@kaggle.ketkijain_top_50_indian_companies
Explore largest companies by revenue in 2021 according to the Fortune India 500.
@kaggle.ketkijain_top_50_indian_companies
### Content
This list is based on the Fortune 500, which ranks the world's 2,000 largest publicly traded companies. The Fortune 500 list takes into account a multitude of factors, including the revenue, net profit, total assets and market value of each company; each factor is given a weighted rank in terms of importance when considering the overall ranking.
### Variables:
Rank: The company's position on the Fortune India 500 list, indicating its relative size and importance within India.
Name: The official name of the Indian company.
Industry: The sector in which the company operates (e.g., finance, technology, manufacturing).
Revenue (in ₹ Crore): The company's total income in billions of rupees for the year (likely 2021, based on the context of Fortune India 500).
Revenue Growth: The year-over-year change in the company's revenue (percentage provided in the data).
Profit (in ₹ Crore): The company's net profit in billions of rupees for the year (likely 2021). (Change from Profits to Profit)
Headquarters: The city and state where the company's main office is located. (Change from country to state)
State-Controlled: An indicator (Yes/No) signifying whether the Indian government has a controlling stake in the company.
CREATE TABLE top_company (
"rank" BIGINT,
"name" VARCHAR,
"industry" VARCHAR,
"revenue_in_crore" BIGINT -- Revenue (in ₹ Crore),
"revenue_growth" VARCHAR,
"profits_in_crore" VARCHAR -- Profits (in ₹ Crore),
"headquarters" VARCHAR,
"state_controlled" VARCHAR
);Anyone who has the link will be able to view this.