Skip to content

LeetCode answers with explanation for "30 Days of Pandas" challenge.

Notifications You must be signed in to change notification settings

lymphoidcell/leetcode-pandas-sql

Repository files navigation

🐼 LeetCode Pandas Solutions

LeetCode answers for the 30 Days of Pandas challenge.
Solutions will be provided in both Pandas (Python) and SQL formats.

🔗 My LeetCode Profile


📚 Table of Contents

  1. Data Filtering
  2. String Methods
  3. Still String
  4. Data Manipulation
  5. Statistics
  6. Calculation
  7. Data Aggregation
  8. Data Integration
  9. Additional

🔍 Data Filtering

Day Problem Title
1 Big Countries
2 Recyclable and Low Fat Products
3 Customers Who Never Order
4 Article Views I

📝 String Methods

Day Problem Title
5 Invalid Tweets
6 Calculate Special Bonus
7 Fix Names in Tables
8 Find Users with Valid E-Mails
9 Patients with a Condition

🔤 Still String

Day Problem Title
10 Count Occurrences in Text

🛠️ Data Manipulation

Day Problem Title
11 Nth Highest Salary
12 Second Highest Salary
13 Department Highest Salary
14 Rank Scores
15 Delete Duplicate Emails
16 Rearrange Products Table

📊 Statistics

Day Problem Title
17 The Number of Rich Customers
18 Immediate Food Delivery I
19 Count Salary Categories

📐 Calculation

Day Problem Title
20 Ads Performance

📈 Data Aggregation

Day Problem Title
21 Find Total Time Spent by Each Employee
22 Game Play Analysis I
23 Number of Unique Subjects Taught by Each Teacher
24 Classes More than 5 Students
25 Customer Placing the Largest Number of Orders
26 Group Sold Products by the Date
27 Daily Leads and Partners

🔗 Data Integration

Day Problem Title
28 Actors and Directors Who Cooperated at Least Three Times
29 Replace Employee ID with the Unique Identifier
30 Students and Examinations
31 Managers with at least 5 Direct Reports
32 Sales Person

➕ Additional

Day Problem Title
33 Accepted Candidates from the Interviews

📫 Connect with Me


🧰 Tools & Technologies

  • Programming Languages: Python, SQL
  • Libraries & Frameworks: Pandas, NumPy
  • Version Control: Git, GitHub
  • Databases: MySQL, PostgreSQL

💡 About This Repository

This repository contains solutions to the "30 Days of Pandas" challenge on LeetCode. Each day focuses on different aspects of data manipulation and analysis using Pandas and SQL. The goal is to enhance proficiency in data handling, querying, and problem-solving using these powerful tools.

Feel free to explore the solutions, contribute, and collaborate!


📢 Stay Updated

Follow this repository to stay updated with the latest solutions and improvements. Contributions and feedback are always welcome!

About

LeetCode answers with explanation for "30 Days of Pandas" challenge.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages