Purna alluvial basin is characterized by low to high level groundwater salinity having adverse effect in a large area, however, the basin still lacks one-time data of any season regarding hydrogeochemistry and quality assessment for drinking and irrigation purposes. The present work is aimed to determine various weathering indices and estimation of groundwater quality for irrigation purpose. The interpretations are based on the study of total 158 samples, collected from dug wells (60) and bore wells (98) during both pre and post-monsoon periods of the year 2009. The plots between $\rm{Ca+Mg}\,vs. \rm{SO_{4}+HCO_{3}}$, $\rm{Na}\,vs. \rm{Cl}$ and $\rm{Na}\,vs. \rm{HCO_{3}}$ reveal that most of the samples fall below the equiline that indicates prevalence of silicate weathering. The USSL diagram (Wilcox diagram) demonstrates higher concentration of points in the fields of C2S1 and C3S1 for both the aquifers, indicating high salinity and low to medium sodium water; however, a few sample points positioned in C3S4 and C4S4 fields indicate high salinity but medium to high sodium. The values of Na%, RSC, Kelley ratio and magnesium ratio for most of samples exhibit doubtful to unsuitable categories of groundwater for irrigation from both the aquifers during pre- and post-monsoon periods. The vast data bank generated for entire basin is significant for government and non-government organizations for future planning and management.