A complete data-driven project that explores the evolution of Indian cinema by analyzing 250+ top-rated movies from IMDb using Python and Power BI.
To uncover insightful patterns and audience preferences in India’s most iconic films by analyzing:
- ⭐ IMDb Ratings & Audience Votes
- 📅 Year-wise Trends
- 🗣️ Language & Genre Preferences
- 🏭 Industry Contributions
- 🎯 Movie Clusters Based on Popularity & Performance
| Feature | Detail |
|---|---|
| 📁 Dataset | IMDb Top 250 Indian Movies |
| 📆 Duration | 1955 – 2024 |
| 📄 File Size | ~250 Rows × 8 Columns |
| 📍 Source | Curated IMDb List |
🔗 movie_analysis.py (Jupyter Notebook)
🔗 📄 PDF Summary of Python Analysis
- Removed commas & symbols from vote/rating fields
- Fixed null values, typos, and date formats
- Converted datatypes for numeric operations
| Metric | Value |
|---|---|
| 🎭 Most Common Genre | Drama |
| 🗣️ Top Language | Hindi (102) |
| 🌟 Avg. IMDb Rating | 8.19 |
- 📅 Peak Years: 2018 & 2021 (highest releases)
- 🏆 Top Rated: Mayabazar, Sandesham – IMDb 9.1
- 🗳️ Most Voted: Jai Bhim – 3.3K+ reviews
| Industry | Award Share |
|---|---|
| Bollywood | 59.4% |
| Kollywood | ~20% |
| Tollywood | ~15% |
🔗 📊 Power BI Dashboard File (.pbix)
- 🎬 Top-Rated & Most Voted Movies
- 📅 Release Trends Over Time
- 🗣️ Language and Industry Filters
- 📈 Genre-Based Heatmaps
- 🧠 Insight Cards for Quick Understanding
| Metric | Highlight |
|---|---|
| 🥇 Top Industry | Bollywood – 59.4% award share |
| 📅 Peak Years | 2018 & 2021 – most releases |
| 🌟 Top Rated | Mayabazar, Sandesham (9.1 IMDb) |
| 🗳️ Most Voted | Jai Bhim (3.3K+ reviews) |
| 🗣️ Top Language | Hindi – 102 Movies |
| 🎭 Popular Genre | Drama – most recurring genre |
| File Name | Description |
|---|---|
IMDB_Movies_India.csv |
Cleaned data (1955–2024) |
movie_analysis.py |
Python code for data cleaning + EDA |
Movie_Analysis_In_Python.pdf |
PDF overview of Python analysis |
Indian_Movie_Dashboard.pbix |
Power BI dashboard file |
Indian_Movie_Dashboard.png |
Static preview image of the dashboard |
| Tool | Purpose |
|---|---|
| 🐍 Python | Data cleaning, trend analysis, clustering |
| 📄 Excel | Validation, preprocessing |
| 📊 Power BI | Data storytelling, dashboard creation |
This project blends data with cinema to reveal:
- How Indian cinema has changed over time
- What makes a movie resonate with audiences
- Which industries, genres, and years delivered standout content
📊 Whether you're a data lover or a movie fan, this dashboard makes it easy to explore India’s cinematic journey — one insight at a time.
| Platform | Link |
|---|---|
| niravtrivedi069@gmail.com | |
| linkedin.com/in/trivedi-nirav-a1760424b | |
| 💻 GitHub | github.com/niravtrivedi23 |
🎥 "Every movie tells a story — and so does the data behind it."
Let’s connect and explore the insights hidden in every frame!