Skip to content

Latest commit

 

History

History
148 lines (102 loc) · 7.88 KB

README.md

File metadata and controls

148 lines (102 loc) · 7.88 KB
Raw

🐼 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!