📊 Indian Equity Market Analysis Dataset 🔍 Overview
This dataset provides a consolidated snapshot of 31 leading Indian companies, with a primary focus on large-cap firms. It is designed to support fundamental analysis, sector comparison, and valuation studies by combining financial metrics, leadership details, and historical company information in a single spreadsheet.
This dataset is ideal for data analytics learners, finance enthusiasts, and beginner investors who want to practice market analysis using structured data.
📁 Dataset Contents
The spreadsheet includes key company-level information such as:
Financial performance indicators
Leadership details
Incorporation history
Valuation metrics
Together, these features enable comparative analysis across sectors and companies.
📖 Data Dictionary Column Description Company Name Official name of the corporation Sector Primary industry (e.g., IT, Banking, FMCG) CEO Current CEO or Managing Director Founding Date Date of incorporation or establishment Market Cap (₹ Cr) Total market value of outstanding shares (INR Crores) Revenue (₹ Cr) Total income from operations Profit Net income after expenses and taxes P/E Ratio Price-to-Earnings ratio for valuation insight Last Results Date Most recent financial results announcement ⭐ Notable Features 🎨 Visual Heatmapping
Market Cap and Revenue columns use color scales
Helps quickly identify company size and financial weight
📅 Chronological Sorting
Founding dates highlighted for easy historical comparison
💡 Valuation Insights
P/E ratios allow quick identification of potentially under- or over-valued stocks
🛠️ Potential Use Cases
Fundamental equity analysis
Sector comparison projects
Excel/Power BI practice
Financial ratio analysis
Data visualization exercises
Beginner stock market research
Data Verification Recommended: Sector and CEO information may change due to corporate restructuring. Always verify with official NSE/BSE filings before making decisions.
Educational Purpose: This dataset is intended for learning and analysis practice, not financial advice.
👨💻 Author
Shorya Bisht Data Science Enthusiast | Analytics Learner
🔗 LinkedIn: https://www.linkedin.com/in/shorya-bisht-a20144349/