Solve using PySpark and Spark-SQL | Accenture Interview Question |

Write a Pyspark query to report the movies with an odd-numbered ID and a description that is not "boring".Return the result table in descending order by rating.

data=[(1, 'War','great 3D',8.9)
,(2, 'Science','fiction',8.5)
,(3, 'irish','boring',6.2)
,(4, 'Ice song','Fantacy',8.6)
,(5, 'House card','Interesting',9.1)]
schema="ID int,movie string,description string,rating double"

Course Link:

#pysparkinterview

#interviewquestion #pythonbeginners
#Geekcoders,#Sagarprajapati,#Freecontent,#Azure,#Dataengineer,#Python,SQL,Data,#Database,#Database,#Engineering,#Databricks,#Azuredatafactory,#Spark,#pythonlist

[vikaschavan]

I saw this question on leetcode sql question series.

[fit]

Bro can you please tell me which software you are using to record screen.

[caferacerkid]

result_df = df.filter((col("ID") % 2 != 0) & (col("description") !=
display(result_df)

[SzalonyEdek]

Cool. The second syntax is DataFrame, not PySpark, as a Pyspark it could be also DataSet or RDD

[AmitSingh-em]

my Solution:

% 2 != 0) & (col("description") != "boring")).orderBy("rating", ascending=False)

[RajeshKumar-retj]

Hey Sagar, Please make delta live table related project. Delta live table is most demanding.

[SomwritaDe]

from pyspark.sql.functions import col, upper
df_1 =
display(df_1)