Government Schemes Analytics: Trends, Gaps, and Distribution Insights

By abhishek.verma75000 · May 5, 2026

This analysis of 3,473 government schemes presents a comprehensive view of policy distribution across categories, beneficiary groups, timelines, and…

The analysis successfully produced a bar chart and data table showing the number of unique schemes available in each category. You can see the full breakdown in the visualization above, which ranks all categories from highest to lowest by their unique scheme count.

A horizontal bar chart has been generated showing the top 10 target beneficiary groups served by government schemes. The visualization ranks each beneficiary group by the number of unique schemes dedicated to them, making it easy to compare which groups receive the most government attention and support.

Government schemes have been launched since 1959, with activity accelerating significantly in recent decades. A line chart shows the year-by-year trend, while a bar chart breaks down launches by decade. The 2010s were the most active decade with 72 schemes launched, and 2015 alone saw the highest single-year count of 26 schemes.

The analysis produced three visualizations comparing central and state government schemes: a bar chart showing the volume of records for each scheme type, a grouped bar chart breaking down the top 10 categories by scheme type, and a pie chart showing the proportion of unique schemes between central and state. These charts provide a comprehensive view of how the two scheme types differ in scale and focus areas.

The analysis reveals a significant coverage gap in scheme distribution across beneficiary groups and categories. Out of 2,190 possible beneficiary–category combinations (73 beneficiary groups × 30 categories), only 81 combinations (3.7%) actually have schemes assigned — leaving 2,109 combinations with zero coverage. Two visualizations were generated: a heatmap showing the full beneficiary × category matrix, and a bar chart highlighting the top 15 most concentrated combinations.

The analysis produced three visualizations breaking down how schemes are distributed across difficulty levels and which categories are most complex. Chart 1 shows the number of unique schemes at each difficulty level (Easy, Medium, Hard). Chart 2 provides a stacked bar chart of the top 10 categories broken down by difficulty level, showing how each category's Q&A entries are split. Chart 3 ranks the top 10 most complex categories using a weighted difficulty score (Easy=1, Medium=2, Hard=3), highlighting which categories contain proportionally more Hard-level content.

The analysis successfully produced a stacked bar chart visualizing how government scheme launches have evolved over the years, broken down by category. The chart shows the count of schemes per category for each launch year, making it easy to spot trends, peak years, and category dominance across different eras.

The analysis successfully identified the top 15 schemes by question count in the dataset. A horizontal bar chart was generated showing each scheme ranked by its number of entries, color-coded by whether it's a state or central government scheme. Each bar is labeled with the scheme name, category, launch year, and classification type, making it easy to compare schemes at a glance. Supporting data tables provide additional detail on category, launched year, state/central classification, target beneficiary, and difficulty level distribution for each of the top 15 schemes.

The analysis reveals how questions are distributed across difficulty levels and categories. On average, Easy difficulty schemes contain about 20 questions each, while Hard schemes average around 9 questions and Medium schemes average about 7 questions per scheme. A grouped bar chart has been generated showing the difficulty level distribution across the top 8 categories by question count, making it easy to compare how each category balances Easy, Medium, and Hard questions.

The analysis of 3,473 Indian government scheme launch years reveals a strong concentration in the 2014–2019 period. Three visualizations were generated: a histogram with KDE overlay showing the distribution shape, a box plot highlighting outlier years, and a bar chart breaking down schemes by policy period. Statistically, the mean launch year is 2013.69, the median and mode are both 2015, and the standard deviation is 6.82 years. The data spans from 1959 to 2023. Using IQR-based outlier detection, 763 schemes (about 22%) fall outside the bounds of [2011, 2019], indicating notable activity in earlier and more recent years. By policy period: 20.30% of schemes were launched before 2014, a dominant 70.92% between 2014–2019 (Modi 1.0), and 8.78% after 2019.

A word cloud has been successfully generated from the 'answer' column of your dataset. The visualization displays the most frequently occurring words in varying sizes, where larger words appear more often in the text data. The word cloud uses a viridis color scheme on a white background, making it easy to identify the dominant terms and themes in your answers.

The sentiment analysis of the 'answer' column reveals that the content is overwhelmingly neutral in tone. A bar chart was generated showing the distribution across all three sentiment categories.