LeetCode - Analytics

Here are a collection of LeetCode problems around data analytics.

How to Use

Instructions for decorating leetcode lists with logged-in user data.

Install this user script to enhance the lists below: blog.leetcode.user.js

The user script will request access to a LeetCode URL to fetch your logged-in user’s problem data.

LeetCode Problem Data: https://leetcode.com/api/problems/algorithms/

To generate more lists of problem slugs, use this JavaScript query in your browser’s developer console from any page containing links to LeetCode problems:

[...document.querySelectorAll('a')]
    .map(       li => li.href.match(/\/problems\/([^\/]+)\//))
    .filter(    match => match)
    .map(       match => match[1])

More user scripts at: UserScripts

Introduction to Pandas

1-bit-and-2-bit-characters
create-a-dataframe-from-list
get-the-size-of-a-dataframe
display-the-first-three-rows
select-data
create-a-new-column
drop-duplicate-rows
drop-missing-data
modify-columns
rename-columns
change-data-type
fill-missing-data
reshape-data-concatenate
reshape-data-pivot
reshape-data-melt
method-chaining

30 Days of Pandas

Data Filtering

big-countries
recyclable-and-low-fat-products
customers-who-never-order
article-views-i

String Methods

invalid-tweets
calculate-special-bonus
fix-names-in-a-table
find-users-with-valid-e-mails
patients-with-a-condition

Strengthen Your Learning by Solving this Question

count-occurrences-in-text

Data Manipulation

nth-highest-salary
second-highest-salary
department-highest-salary
rank-scores
delete-duplicate-emails
rearrange-products-table

Statistics

the-number-of-rich-customers
immediate-food-delivery-i
count-salary-categories

Strengthen Your Learning by Solving this Question

ads-performance

Data Aggregation

find-total-time-spent-by-each-employee
game-play-analysis-i
number-of-unique-subjects-taught-by-each-teacher
classes-with-at-least-5-students
customer-placing-the-largest-number-of-orders
group-sold-products-by-the-date
daily-leads-and-partners

Data Integration

actors-and-directors-who-cooperated-at-least-three-times
replace-employee-id-with-the-unique-identifier
students-and-examinations
managers-with-at-least-5-direct-reports
sales-person

Strengthen Your Learning by Solving this Question

accepted-candidates-from-the-interviews