groupby-function

To get acquaintance of me

Fast groupby-apply operations in python.

This Library Management System project demonstrates how a real-world library can manage books, members, and borrow transactions efficiently using SQL.

A SQL-based Employee Management System demonstrating database design, table relationships, salary analysis, and department-wise reporting.

Airbnb project is intended to analyze Airbnb's business in the New York area. It helps customers compare prices, and see availabilities, locations, and reviews.

Content: Plotting_line_&_bar_graphs_using_plt_&_sns, labelling_the_axes_&_titles, groupby_function, count_value_function, dropping_a_column, Exploratory_data_analysis_(EDA), Data_preprocessing

This SQL Case study was provided by Ankit Bansal on his Youtube channel

The School District Analysis uses Python, Anaconda, Jupyter Notebook, the Pandas library specifically DataFrames, and NumPy to perform analysis on school data for fifteen different high schools across four different grades by merging the data into several Pandas DataFrames. Using the Pandas loc method, Pandas groupby function and bins, the avera…

A comprehensive repository of SQL interview questions covering basic to advanced topics, including queries on joins, aggregations, subqueries, and performance optimization. Ideal for interview preparation and skill enhancement.