read third quarter of the table in pyspark | ntile function in pyspark | offset in pyspark

ntile in pyspark | offset in pyspark | read third quarter of the table in pyspark | #interview | #dataengineers | #datascience | #dataanalytics

Create DataFrame Code :
====================
emp_data = [("Alice", 28),
("Bob", 35),
("Charlie", 42),
("David", 25),
("Eva", 31),
("Frank", 38),
("Grace", 45),
("Henry", 29)]

emp_schema = "name string , age int"

# Create Dataframe


top interview question and answer in pyspark :

#ntile #offset #limit #fang #pyspark #sql #interview #dataengineers #dataanalytics #datascience #StrataScratch #Facebook #data #dataengineeringinterview #codechallenge #datascientist #pyspark #CodingInterview
#dsafordataguy #dewithdhairy #DEwithDhairy #dhiarjgupta #leetcode #topinterviewquestion

[anandgupta]

This is really amazing video and please keep it up

[mohitmotwani]

df\
.withColumn("row_num",
> 0.5) & ((col("row_num")/df.count()) <= 0.75)) \
.drop("row_num") \
.show()