Udemyintermediatehi

Data Analysis Project on Electoral Bond in Python Colab

Level up your Python skills! This intermediate course builds on existing knowledge for practical application. Master advanced Python concepts and techniques.

Related:PandasNumPy
5.0(2)
104students
2h 19m
Certificate
Rohit Kumar
Rohit KumarInstructor at Udemy on IT sector

Course Content

Data Analysis Project on Electoral Bond in Python Colab is an intermediate-level Udemy course taught by Rohit Kumar. It runs 2h 19m, is taught in Hindi, and includes a certificate of completion. Learners rate it 5.0 out of 5 from 2 reviews, with 104 students enrolled. It is a paid course, first published January 2025.

Explore comprehensive insights into bond purchase and redemption data from April 2019 to January 2024, sourced directly from SBI Bank and the Election Commission of India. This analysis reveals key trends in bond investments and political party encashments.

Data Overview:

  • Data Source: SBI Bank – Election Commission of India
  • Time Period: April 2019 – January 2024
  • Datasets Included:
    • Purchase Data: Detailed records of bond purchases, including buyer information and purchase dates.
    • Redemption Data: Information on bond redemptions, including buyer details and redemption dates.

Key Findings:

  • Purchase & Redemption Timeline: A strong correlation exists, with no bond redemption occurring more than 15 days after the initial bond purchase.
  • Data Integration & Validation: Rigorous data merging and validation processes were employed. The "Prefix" and "Bond Number" columns were combined to establish a unique identifier for both datasets.
    • Following the merge, discrepancies were identified: 1,680 unmatched entries in purchase data and 130 unmatched entries in redemption data.
    • Data type standardization and consistent naming conventions were implemented to ensure data integrity.
  • Top Purchasers (2019-2024): Identify the leading entities involved in bond investments:
    • Future Gaming and Hotel Services
    • Megha Engineering and Infrastructure
    • Qwik Supply Chain Private Limited
    • Haldi Energy
    • Vedanta Limited
  • Denomination Insights: Bonds with a ₹1 crore denomination represent the most prevalent type of bond investment throughout the entire period.
  • Time-Based Trends: Understand the seasonality of bond purchases and redemptions:
    • Peak Purchase Months: January, April, and October.
    • Peak Purchase Years: 2022 and 2023.
    • Redemption Patterns: The majority of bonds were redeemed within 5 days of the purchase date.
  • Political Party Encashments: Analyze bond encashment patterns by political party:
    • BJP (Bharatiya Janata Party)
    • Trinamool Congress
    • Indian National Congress

Data Exploration:

Advanced data exploration techniques were utilized to uncover deeper insights:

  • New columns were created for day names, months, and years to facilitate detailed analysis.
  • Crosstab analysis was employed to examine the relationship between purchase trends and the sum of political party denomination amounts.
$ whoami — the devs behind tutorialsearch.io

Want AI in your product? Hire the team behind TutorialSearch.io

LLM features, RAG, agents and automation wired into a real product — built by the devs who shipped this site.

5.0(2)
11h 45m
beginner
5.0(5)
22h 45m
all