Context

List of companies available in India with some additional details.

Content

This dataset contain a list of companies along with additional details like (name, type, average rating, review count, company age, company headquarters and number of employee working on that company). The whole list of company is web scrapped from the website AmbitionBox.com.

Acknowledgements

Data Source: https://www.ambitionbox.com/list-of-companies This dataset wouldn't be made without data available at ambitionbox.com. So a big thanks to the whole team of ambitionbox from the whole kaggle community.

Inspiration

My intension to create this dataset was to enlist the companies available in India and do some analysis on that.

All India Steel & Steel Products Companies Database in Excel – Verified Steel Manufacturers & SuppliersThe All India Steel & Steel Products Companies Database is a verified, meticulously curated, and regularly updated Excel directory of active steel manufacturers, suppliers, distributors...

To create the dataset, the top 10 countries leading in the incidence of COVID-19 in the world were selected as of October 22, 2020 (on the eve of the second full of pandemics), which are presented in the Global 500 ranking for 2020: USA, India, Brazil, Russia, Spain, France and Mexico. For each of these countries, no more than 10 of the largest transnational corporations included in the Global 500 rating for 2020 and 2019 were selected separately. The arithmetic averages were calculated and the change (increase) in indicators such as profitability and profitability of enterprises, their ranking position (competitiveness), asset value and number of employees. The arithmetic mean values of these indicators for all countries of the sample were found, characterizing the situation in international entrepreneurship as a whole in the context of the COVID-19 crisis in 2020 on the eve of the second wave of the pandemic. The data is collected in a general Microsoft Excel table. Dataset is a unique database that combines COVID-19 statistics and entrepreneurship statistics. The dataset is flexible data that can be supplemented with data from other countries and newer statistics on the COVID-19 pandemic. Due to the fact that the data in the dataset are not ready-made numbers, but formulas, when adding and / or changing the values in the original table at the beginning of the dataset, most of the subsequent tables will be automatically recalculated and the graphs will be updated. This allows the dataset to be used not just as an array of data, but as an analytical tool for automating scientific research on the impact of the COVID-19 pandemic and crisis on international entrepreneurship. The dataset includes not only tabular data, but also charts that provide data visualization. The dataset contains not only actual, but also forecast data on morbidity and mortality from COVID-19 for the period of the second wave of the pandemic in 2020. The forecasts are presented in the form of a normal distribution of predicted values and the probability of their occurrence in practice. This allows for a broad scenario analysis of the impact of the COVID-19 pandemic and crisis on international entrepreneurship, substituting various predicted morbidity and mortality rates in risk assessment tables and obtaining automatically calculated consequences (changes) on the characteristics of international entrepreneurship. It is also possible to substitute the actual values identified in the process and following the results of the second wave of the pandemic to check the reliability of pre-made forecasts and conduct a plan-fact analysis. The dataset contains not only the numerical values of the initial and predicted values of the set of studied indicators, but also their qualitative interpretation, reflecting the presence and level of risks of a pandemic and COVID-19 crisis for international entrepreneurship.

Shark Tank India Data set.

Shark Tank India - Season 1 to season 4 information, with 80 fields/columns and 630+ records.

All seasons/episodes of 🦈 SHARKTANK INDIA 🇮🇳 were broadcasted on SonyLiv OTT/Sony TV.

Here is the data dictionary for (Indian) Shark Tank season's dataset.

• Season Number - Season number
• Startup Name - Company name or product name
• Episode Number - Episode number within the season
• Pitch Number - Overall pitch number
• Season Start - Season first aired date
• Season End - Season last aired date
• Original Air Date - Episode original/first aired date, on OTT/TV
• Episode Title - Episode title in SonyLiv
• Anchor - Name of the episode presenter/host
• Industry - Industry name or type
• Business Description - Business Description
• Company Website - Company Website URL
• Started in - Year in which startup was started/incorporated
• Number of Presenters - Number of presenters
• Male Presenters - Number of male presenters
• Female Presenters - Number of female presenters
• Transgender Presenters - Number of transgender/LGBTQ presenters
• Couple Presenters - Are presenters wife/husband ? 1-yes, 0-no
• Pitchers Average Age - All pitchers average age, <30 young, 30-50 middle, >50 old
• Pitchers City - Presenter's town/city or place where company head office exists
• Pitchers State - Indian state pitcher hails from or state where company head office exists
• Yearly Revenue - Yearly revenue, in lakhs INR, -1 means negative revenue, 0 means pre-revenue
• Monthly Sales - Total monthly sales, in lakhs
• Gross Margin - Gross margin/profit of company, in percentages
• Net Margin - Net margin/profit of company, in percentages
• EBITDA - Earnings Before Interest, Taxes, Depreciation, and Amortization
• Cash Burn - In loss in current year; burning/paying money from their pocket (yes/no)
• SKUs - Stock Keeping Units or number of varieties, at the time of pitch
• Has Patents - Pitcher has Patents/Intellectual property (filed/granted), at the time of pitch
• Bootstrapped - Startup is bootstrapped or not (yes/no)
• Part of Match off - Competition between two similar brands, pitched at same time
• Original Ask Amount - Original Ask Amount, in lakhs INR
• Original Offered Equity - Original Offered Equity, in percentages
• Valuation Requested - Valuation Requested, in lakhs INR
• Received Offer - Received offer or not, 1-received, 0-not received
• Accepted Offer - Accepted offer or not, 1-accepted, 0-rejected
• Total Deal Amount - Total Deal Amount, in lakhs INR
• Total Deal Equity - Total Deal Equity, in percentages
• Total Deal Debt - Total Deal debt/loan amount, in lakhs INR
• Debt Interest - Debt interest rate, in percentages
• Deal Valuation - Deal Valuation, in lakhs INR
• Number of sharks in deal - Number of sharks involved in deal
• Deal has conditions - Deal has conditions or not? (yes or no)
• Royalty Percentage - Royalty percentage, if it's royalty deal
• Royalty Recouped Amount - Royalty recouped amount, if it's royalty deal, in lakhs
• Advisory Shares Equity - Deal with Advisory shares or equity, in percentages
• Namita Investment Amount - Namita Investment Amount, in lakhs INR
• Namita Investment Equity - Namita Investment Equity, in percentages
• Namita Debt Amount - Namita Debt Amount, in lakhs INR
• Vineeta Investment Amount - Vineeta Investment Amount, in lakhs INR
• Vineeta Investment Equity - Vineeta Investment Equity, in percentages
• Vineeta Debt Amount - Vineeta Debt Amount, in lakhs INR
• Anupam Investment Amount - Anupam Investment Amount, in lakhs INR
• Anupam Investment Equity - Anupam Investment Equity, in percentages
• Anupam Debt Amount - Anupam Debt Amount, in lakhs INR
• Aman Investment Amount - Aman Investment Amount, in lakhs INR
• Aman Investment Equity - Aman Investment Equity, in percentages
• Aman Debt Amount - Aman Debt Amount, in lakhs INR
• Peyush Investment Amount - Peyush Investment Amount, in lakhs INR
• Peyush Investment Equity - Peyush Investment Equity, in percentages
• Peyush Debt Amount - Peyush Debt Amount, in lakhs INR
• Ritesh Investment Amount - Ritesh Investment Amount, in lakhs INR
• Ritesh Investment Equity - Ritesh Investment Equity, in percentages
• Ritesh Debt Amount - Ritesh Debt Amount, in lakhs INR
• Amit Investment Amount - Amit Investment Amount, in lakhs INR
• Amit Investment Equity - Amit Investment Equity, in percentages
• Amit Debt Amount - Amit Debt Amount, in lakhs INR
• Guest Investment Amount - Guest Investment Amount, in lakhs INR
• Guest Investment Equity - Guest Investment Equity, in percentages
• Guest Debt Amount - Guest Debt Amount, in lakhs INR
• Invested Guest Name - Name of the guest(s) who invested in deal
• All Guest Names - Name of all guests, who are present in episode
• Namita Present - Whether Namita present in episode or not
• Vineeta Present - Whether Vineeta present in episode or not
• Anupam ...

Excel Services India Export Import Data. Follow the Eximpedia platform for HS code, importer-exporter records, and customs shipment details.

Excel Logitrade India Export Import Data. Follow the Eximpedia platform for HS code, importer-exporter records, and customs shipment details.

Regreen Excel Epc India Private Limited Export Import Data. Follow the Eximpedia platform for HS code, importer-exporter records, and customs shipment details.

Context

This public dataset contains data concerning the public and private insurance companies provided by IRDAI(Insurance Regulatory and Development Authority of India) from 2013-2022. This is a multi-index data and can be a great practice to hone manipulation of pandas multi-index dataframes. Mainly, the business of the companies (total premiums and number of policies), subscription information(number of people subscribed), Claims incurred and the Network hospitals enrolled by Third Party Administrators are attributes focused by the dataset.

Content

The Excel file contains the following data | Table No.| Contents| | --- | --- | |**A**|**III.A: HEALTH INSURANCE BUSINESS OF GENERAL AND HEALTH INSURERS**| |62| Health Insurance - Number of Policies, Number of Persons Covered and Gross Premium| |63| Personal Accident Insurance - Number of Policies, Number of Persons Covered and Gross Premium| |64| Overseas Travel Insurance - Number of Policies, Number of Persons Covered and Gross Premium| |65| Domestic Travel Insurance - Number of Policies, Number of Persons Covered and Gross Premium| |66| Health Insurance - Net Premium Earned, Incurred Claims and Incurred Claims Ratio| |67| Personal Accident Insurance - Net Premium Earned, Incurred Claims and Incurred Claims Ratio| |68| Overseas Travel Insurance - Net Earned Premium, Incurred Claims and Incurred Claims Ratio| |69| Domestic Travel Insurance - Net Earned Premium, Incurred Claims and Incurred Claims Ratio| |70| Details of Claims Development and Aging - Health Insurance Business| |71| State-wise Health Insurance Business| |72| State-wise Individual Health Insurance Business| |73| State-wise Personal Accident Insurance Business| |74| State-wise Overseas Insurance Business| |75| State-wise Domestic Insurance Business| |76| State-wise Claims Settlement under Health Insurance Business| |**B**|**III.B: HEALTH INSURANCE BUSINESS OF LIFE INSURERS**| |77| Health Insurance Business in respect of Products offered by Life Insurers - New Busienss| |78| Health Insurance Business in respect of Products offered by Life insurers - Renewal Business| |79| Health Insurance Business in respect of Riders attached to Life Insurance Products - New Business| |80| Health Insurance Business in respect of Riders attached to Life Insurance Products - Renewal Business| |**C**|**III.C: OTHERS**| |81| Network Hospital Enrolled by TPAs| |82| State-wise Details on Number of Network Providers |

Indian Footwear Market size was valued at USD 15.1 billion in 2022 and is poised to grow from USD 17.05 billion in 2023 to USD 45 billion by 2031, growing at a CAGR of 12.9% in the forecast period (2024-2031).

Aspire Grand Excel Automation India Export Import Data. Follow the Eximpedia platform for HS code, importer-exporter records, and customs shipment details.

Excel Impex Private Limited India Export Import Data. Follow the Eximpedia platform for HS code, importer-exporter records, and customs shipment details.

Excel Industries Limited Mumbai India Export Import Data. Follow the Eximpedia platform for HS code, importer-exporter records, and customs shipment details.

Excel Pack Privet Limited India Export Import Data. Follow the Eximpedia platform for HS code, importer-exporter records, and customs shipment details.

Excel Hone Manufacturing India Private Limited Export Import Data. Follow the Eximpedia platform for HS code, importer-exporter records, and customs shipment details.

Excel Hydro Pneumatics India Export Import Data. Follow the Eximpedia platform for HS code, importer-exporter records, and customs shipment details.

Originally based on the International Standard Industrial Classification (ISIC), the NIC-2008 is widely used by government agencies and private organizations for statistical, analytical, and business purposes. NIC-2008 was developed by the Government of India and follows the structure of the ISIC system, with some adjustments made to suit the Indian context. I generated this csv for a learning project.

For SICs of other nations, please refer to regional govt website and for general understanding, use wikipedia.org/wiki/Standard_Industrial_Classification

I originally took the 'National Industrial Classification 2008 (Excel Format)' from Ministry of Statistics & Programme Implementation website mospi.gov.in/classification/national-industrial-classification

But it only had (niccode and nicdesc), making it less intuitive for detailed analysis and lacked grouping.

I checked Open Government Data (OGD) Platform data.gov.in/search but could not find exactly what I was looking for.

I proceeded to use a scraped listing from dge.gov.in/dge/national-industrial-classification which I consolidated into csv/xlsx format for further usage in my project. That consolidated file is what I am providing here. It bridges the gap between the official enquriy and practical usability for data-driven tasks.

Comprehensive Hierarchical Segmentation:

Applications: 1. Market Research: Understand industry classifications relevant to your domain. 2. Statistical Analysis: Perform cross-sectional or longitudinal analyses across industries. 3. Business Strategy: Identify target sectors of business. 4. Policy and Government Programs: Pinpoint industries for compliance or government funding opportunities.

If you require to use the same data but would like to scrape the data on your own for personal use, I will provide a python script in 'Code' section which you can use to scrape the same data for personal use.

Since this data is not taken from data.gov.in, I do not believe that this data falls under 'Open Government Data' License hence I am marking this as 'Other'. This csv file is ideal for personal projects but for business purposes or other commercial use, please verify whether this data falls under National Data Sharing and Accessibility Policy (NDSAP) / CC BY-NC 4.0 or others.

Excel Industries Limited India Export Import Data. Follow the Eximpedia platform for HS code, importer-exporter records, and customs shipment details.

Excel Pack Private Limited India Export Import Data. Follow the Eximpedia platform for HS code, importer-exporter records, and customs shipment details.

Regreen Excel Epc India Limited Export Import Data. Follow the Eximpedia platform for HS code, importer-exporter records, and customs shipment details.

Greetings , fellow analysts !

(NOTE : This is a random dataset generated using python. It bears no resemblance to any real entity in the corporate world. Any resemblance is a matter of coincidence.)

REC-SSEC Bank is a govt-aided bank operating in the Indian Peninsula. They have regional branches in over 40+ regions of the country. You have been provided with a massive excel sheet containing the transaction details, the total transaction amount and their location and total transaction count.

The dataset is described as follows :

1. Date - The date on which the transaction took place. 2.Domain - Where or which type of Business entity made the transaction. 3.Location - Where the data is collected from 4.Value - Total value of transaction
2. Count of transaction .

For example , in the very first row , the data can be read as : " On the first of January, 2022 , 1932 transactions of summing upto INR 365554 from Bhuj were reported " NOTE : There are about 2750 transactions every single day. All of this has been given to you.

The bank wants you to answer the following questions :

1. What is the average transaction value everyday for each domain over the year.
2. What is the average transaction value for every city/location over the year
3. The bank CEO , Mr: Hariharan , wants to promote the ease of transaction for the highest active domain. If the domains could be sorted into a priority, what would be the priority list ?
4. What's the average transaction count for each city ?