No | Description | Difficult level | category | Leetcode Link | Solution Link | completion status | Other |
---|---|---|---|---|---|---|---|
1 | Write a solution to find all the authors who viewed at least one of their own articles. | Easy | Filter, Join | 1148. Article Views I | article_views_I.py | ✅ | |
2 | Write a solution to find the IDs of the invalid tweets. The tweet is invalid if the number of characters used in the content of the tweet is strictly greater than 15. | Easy | Filter | 1683. Invalid Tweets_ | 2.InvalidTweets.py | ✅ | |
3 | calculate the bonus, the bonus of an employee is 100% of their salary if the ID of the employee is an odd number and the employee's name does not start with the character 'M'. The bonus of an employee is 0 otherwise. | Easy | apply | 1873. Calculate Special Bonus_ | 3.calculate_special_bonus.py | ✅ | |
4 | Write a solution to fix the names so that only the first character is uppercase and the rest are lowercase. | Easy | apply | 1667. Fix Names in a Table)_ | 4.FixName.py | ✅ | |
5 | Write a solution to find the users who have valid emails | Easy | regex, apply | 1517. Find Users With Valid E-Mails_ | Find_users_with_valid_email.py | ✅ | |
6 | Write a solution to find the patient_id, patient_name, and conditions of the patients who have Type I Diabetes. Type I Diabetes always starts with DIAB1 prefix. | Easy | regex, apply, string | 1527. Patients With a Condition | Create_Patients_With_diabetes.py | ✅ | |
7 | Write a solution to delete all duplicate emails, keeping only one unique email with the smallest id | Easy | drop | 196. Delete Duplicate Emails | drop_duplicate_emails.py | ✅ | |
8 | Write a solution to find the number of files that have at least one occurrence of the words 'bull' and 'bear' as a standalone word,id | Medium | apply, aggregation | 2738. Count Occurrences in Text | CountOccuranceText.py | ✅ | |
9 | Write a solution to find the nth highest salary from the Employee table. If there is no nth highest salary, return null | Medium | drop_duplicate, sort | 177. Nth Highest Salary | NthHigestSalary.py | ✅ | |
10 | Write a solution to find the second highest salary from the Employee table. If there is no second highest salary, return null (return None in Pandas). | Medium | drop_duplicate, sort | 176. Second Highest Salary | secondHighestSalary.py | ✅ | |
11 | Write a solution to find employees who have the highest salary in each of the departments. | Medium | Join, Group by | 184. Department Highest Salary | department_highest_salary.py | ✅ | |
12 | Write a solution to find the rank of the scores. The ranking should be calculated according to the following rules: | Medium | Join, rank | 178. Rank Scores | rank_scores.py | ✅ |
cr21 / leetpandas Goto Github PK
View Code? Open in Web Editor NEWPandas solution for Leetcode SQL 50
License: MIT License