📊 LeetCode 30 Days of Pandas - Solutions & Explanations 🚀

Welcome to the LeetCode 30 Days of Pandas repository! This repository contains 30 days of coding challenges using Pandas and SQL that will help you level up your data manipulation and analysis skills. These challenges are designed to be fun and educational, helping you practice real-world data problems and become proficient in Python and Pandas.

---

🌟 Table of Contents

• About
• Challenges
• How to Use This Repo
• Resources
• Contributing

---

📚 About

This repository includes 30 LeetCode-style Pandas problems, designed to improve your data analysis and manipulation skills using Pandas and SQL. Each challenge is crafted to help you tackle various problems you might encounter in the real world while working with datasets.

What You’ll Learn:

• Data cleaning and transformation using Pandas
• Advanced aggregation, filtering, and grouping techniques
• Time series analysis
• Handling missing and duplicate data
• Merging and joining datasets
• More...

---

📝 Challenges

Below are the challenges included in this repo. Each day, you'll find a specific challenge with its corresponding solution.

Day	Challenge Description	Notebook Link
1	Group Sold Products By The Date	1484_Group_Sold_Products_By_The_Date.ipynb
2	Actors and Directors Who Cooperated At Least Three Times	1050_Actors_and_Directors_Who_Cooperated_At_Least_Three_Times.ipynb
3	Article Views (I)	1148_Article_Views_I.ipynb
4	Recyclable and Low Fat Products	1157_Recyclable_and_Low_Fat_Products.ipynb
5	Students and Examinations	1280_Students_and_Examinations.ipynb
6	Replace Employee ID With The Unique Identifier	1378_Replace_Employee_ID_With_The_Unique_Identifier.ipynb
7	Find Users With Valid E-Mails	1517_Find_Users_With_Valid_E-Mails.ipynb
8	Patients With a Condition	1527_Patients_With_a_Condition.ipynb
9	Fix Names in a Table	1667_Fix_Names_in_a_Table.ipynb
10	Invalid Tweets	1683_Invalid_Tweets.ipynb
11	Daily Leads and Partners	1693_Daily_Leads_and_Partners.ipynb
12	Find Total Time Spent by Each Employee	1741_Find_Total_Time_Spent_by_Each_Employee.ipynb
13	Second Highest Salary	176_Second_Highest_Salary.ipynb
14	Nth Highest Salary	177_Nth_Highest_Salary.ipynb
15	Rank Scores	178_Rank_Scores.ipynb
16	Rearrange Products Table	1795_Rearrange_Products_Table.ipynb
17	Customers Who Never Order	183_Customers_Who_Never_Order.ipynb
18	Department Highest Salary	184_Department_Highest_Salary.ipynb
19	Calculate Special Bonus	1873_Calculate_Special_Bonus.ipynb
20	Count Salary Categories	1907_Count_Salary_Categories.ipynb
21	Delete Duplicate Emails	196_Delete_Duplicate_Emails.ipynb
22	Number of Unique Subjects Taught by Each Teacher	2356_Number_of_Unique_Subjects_Taught_by_Each_Teacher.ipynb
23	Game Play Analysis I	511_Game_Play_Analysis_I.ipynb
24	Customer Placing the Largest Number of Orders	586_Customer_Placing_the_Largest_Number_of_Orders.ipynb
25	Big Countries	595_Big_Countries.ipynb
26	Classes More Than Students	596_Classes_More_Than_Students.ipynb
27	(Additional Challenge)	Link
28	(Additional Challenge)	Link
29	(Additional Challenge)	Link
30	(Final Challenge)	Link

---

⚡ How to Use This Repo

1. Clone the repository:

   git clone https://github.com/MoreSangeet/Leetcode_30_Days_of_Pandas.git
   cd Leetcode_30_Days_of_Pandas

2. Open and run the notebooks: Start Jupyter Notebook and open each day's notebook to work through the challenges.

   jupyter notebook

3. Try solving the challenges yourself, and then check the solutions provided in the notebooks.

📚 Resources

Pandas Documentation: https://pandas.pydata.org

LeetCode: https://leetcode.com

Python Documentation: https://docs.python.org/3/

🤝 Contributing

We welcome contributions to enhance this project! If you have suggestions for more challenges, improvements, or bug fixes, feel free to open a Pull Request.

How to Contribute:

1. Fork this repository

2. Create a new branch (git checkout -b feature-name)

3. Make your changes and commit them (git commit -m 'Add new challenge')

4. Push to the branch (git push origin feature-name)

5. Open a pull request with a detailed explanation of your changes

✨ Happy Coding! 🚀