Content

---

1. Pyspark CheatSheet
2. Beginner Core Dataframe Operations
3. Intermediate Operations
4. Expert Complex Transformations
5. Stratascratch problems
6. LeetcodeSQL50 problems

---

Pyspark CheatSheet link:

Pyspark CheatSheet

---

Below are my soluntions to the Pyspark Problems....

StrataScratch

ID	QUESTION	LEVEL	IMAGE
1	Finding Updated Records	Easy	Output
2	Average Salaries	Easy	Output
3	Customer Details	Easy	Output
4	Unique Users Per Client Per Month	Easy	Output
5	MacBookPro User Event Count	Easy	Output
6	April Admin Employees	Easy	Output
7	Artist Appearance count	Easy	Output
8	Top Ranked Songs	Easy	Output
9	Number of Bathrooms and Bedrooms	Easy	Output
10	Workers By Department Since April	Easy	Output
11	Bikes_Last_Used	Easy	Output
12	Most Profitable Financial Company	Easy	Output
13	Churro Activity Date	Easy	Output
14	Workers With Highest Salaries	Easy	Output
15	Number of Violations	Easy	Output
16	Number of Shipments Per Month	Easy	Output
17	Lyft Driver Wages	Easy	Output
18	Order Details	Easy	Output
19	Popularity of Hack	Easy	Output
20	Salaries Differences	Easy	Output
21	Top 10 Songs 2010	Medium	Output
22	Activity Rank	Medium	Output
23	Meta/Facebook Accounts	Medium	Output
24	Customers Revenue IN March	Medium	Output
25	Second Highest Salary	Medium	Output
26	Employee And Manager Salaries	Medium	Output
27	Flags Per Video	Medium	Output
28	Host Popularity Rental Houses	Medium	Output
29	No Order Customers	Medium	Output
30	Find Students at Median Writing	Medium	Output

---

Below are my soluntions to the Pyspark Problems....

LEETCODE SQL50

ID	QUESTION	LEVEL	CODE	IMAGE
1	Recyclable and Low Fat Products	Easy	Code	Page 1 , Page 2
2	Find Customer Reference	Easy	Code	Page 1 , Page 2
3	Big Countries	Easy	Code	Page 1 , Page 2
4	Article Views I	Easy	Code	Page 1 , Page 2
5	Invalid Tweets	Easy	Code	Page 1 , Page 2
6	Replace Employee ID with Unique Identifier	Easy	Code	Page 1 , Page 2
7	Product Sales Analysis I	Easy	Code	Page 1 , Page 2
8	Customer Visits with No Transactions	Easy	Code	Page 1 , Page 2
9	Rising Temperature	Easy	Code	Page 1 , Page 2
10	Average Time of Process Per Machine	Easy	Code	Page 1 , Page 2
11	Employee Bonus	Easy	Code	Page 1 , Page 2
12	Students And Examinations	Easy	Code	Page 1 , Page 2 , Page 3
13	Managers With Atleast Five Direct Reports	Easy	Code	Page 1 , Page 2
14	Confirmation Rate	Medium	Code	Page 1 , Page 2 , Page 3
15	Not Boring Movies	Easy	Code	Page 1 , Page 2
16	Project Employees I	Easy	Code	Page 1 , Page 2 , Page 3
17	Percentage Of Users	Easy	Code	Page 1 , Page 2 , Page 3
18	Monthly Transactions I	Medium	Code	Page 1 , Page 2
19	Find Followers Count	Easy	Code	Page 1 , Page 2
20	Biggest Single Number	Easy	Code	Page 1 , Page 2
21	Gampe Play Analysis IV	Medium	Code	Page 1 , Page 2 , Page 3
22	Number of Unique Subjects Taught By Each Teacher	Easy	Code	Page 1 , Page 2
23	User Activity For Past 30 Days I	Easy	Code	Page 1 , Page 2 , Page 3
24	Product Sales Analysis III	Medium	Code	Page 1 , Page 2 , Page 3
25	Classes with Atleast Five Students	Easy	Code	Page 1 , Page 2
26	Movie Ratings	Medium	Code	Page 1 , Page 2 , Page 3 , Page 4
27	Count Salary Categories	Medium	Code	Page 1 , Page 2 , Page 3
28	Employee Whose Manager Left The Company	Easy	Code	page 1 , Page 2 , Page 3
29	Department Top Three Salaries	Hard	Code	Page 0 , Page 1 , Page 2
30	Delete Duplicate Emails	Easy	Code	Page 0 , Page 1 , Page 2
31	Fix Names in a Table	Easy	Code	Page 0 , Page 1
32	List the Products Ordered In a Period	Easy	Code	Page 0 , Page 1 , Page 2
33	Patients with a Condition	Easy	Code	Page 0 , Page 1 , Page 2
34	Second Highest Salary	Easy	Code	Page 0 , Page 1 , Page 2
35	Product Price At Given Date	Medium	Code	Page 0 , Page 1 , Page 2
36	Consecutive Numbers	Medium	Code	Page 0 , Page 1 , Page 2
37	Triangle Judegement	Easy	Code	Page 0 , Page 1 , Page 2
38	Find Users With Valid E-Mails	Easy	Code	Page 0 , Page 1, Page 2
39	Group Sold Products By The Date	Easy	Code	Page 0 , Page 1 , Page 2
40	Friend Requests II: Who Has The Most Friends	Medium	Code	Page 0 , Page 1 , Page 2

---

Beginner level Core Operations

ID	QUESTION	IMAGE
1	How to load CSV File into DataFrame	Output
2	How to print the employee schema	Output
3	How to count number of rows and columns in employees data	Output
4	How to count employees in each department	Output
5	Find the average salary per department	Output
6	Filter employees hired after 2020	Output
7	Find the employees by salary in descending order	Output
8	How to Rename a column	Output
9	How to Remove duplicate records	Output
10	How to handle null values	Output
11	How to add new column by showing salary in thousands	Output