To get acquaintance of me

Fast groupby-apply operations in python.

No description provided.

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

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

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.

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 average math, reading, and overall scores and passing rates were identified by student budget, by school size, and by school type.

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.

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