38. user defined function in pyspark | UDF(user defined function) in PySpark | Azure Databricks

Azure Databricks #spark #pyspark #azuredatabricks #azure
In this video, I discussed How to use user defined function (udf).

1.schema comparison in pyspark
2. How to user defined function (udf) in pyspark

Create dataframe:
======================================================
data1=[(1,"Ram","Male",100),(2,"Radhe","Female",200),(3,"John","Male",250)]
data2=[(101,"John","Male",100),(102,"Joanne","Female",250),(103,"Smith","Male",250)]
data3=[(1001,"Maxwell","IT",200),(2,"MSD","HR",350),(3,"Virat","IT",300)]
schema1=["Id","Name","Gender","Salary"]
schema2=["Id","Name","Gender","Salary"]
schema3=["Id","Name","DeptName","Salary"]
df1=spark.createDataFrame(data1,schema1)
df2=spark.createDataFrame(data2,schema2)
df3=spark.createDataFrame(data3,schema3)
display(df1)
display(df2)
display(df3)
-----------------------------------------------------------------------------------------------------------------------
def schemacompare(df1,df2):
allcol=df1.columns+df2.columns
uniquecol=list(set(allcol))
for i in uniquecol:
from pyspark.sql.functions import lit
if i not in df1.columns:
df1=df1.withColumn(i,lit(None))
if i not in df2.columns:
df2=df2.withColumn(i,lit(None))
return df1,df2
---------------------------------------------------------------------------------------------------------------------
df1,df2=schemacompare(df1,df3)
display(df1)
display(df2)
-------------------------------------------------------------------------------------------------------------------

============================================================
37. schema comparison in pyspark | How to Compare Two DataFrames in PySpark | pyspark interview:
https://youtu.be/OGJWwJ6VqOQ
Learn PySpark, an interface for Apache Spark in Python. PySpark is often used for large-scale data processing and machine learning.

Azure Databricks Tutorial Platlist:
https://youtube.com/playlist?list=PLNRxk1s77zfgubs75vVMzHhPIhWqRo79C

Azure data factory tutorial playlist:
https://youtube.com/playlist?list=PLNRxk1s77zfjX_3ktp5sKsOh4Q2cWMMDX

ADF interview question & answer:
https://youtube.com/playlist?list=PLNRxk1s77zfgXfQKyScXtbn2MdFkvJtgH

1. pyspark introduction | pyspark tutorial for beginners | pyspark tutorial for data engineers:
https://youtu.be/hBDLfBILAuQ

2. what is dataframe in pyspark | dataframe in azure databricks | pyspark tutorial for data engineer:
https://youtu.be/VNNlNlVKn98

3. How to read write csv file in PySpark | Databricks Tutorial | pyspark tutorial for data engineer:
https://youtu.be/9kwxwCww4zI

4. Different types of write modes in Dataframe using PySpark | pyspark tutorial for data engineers:
https://youtu.be/-0_LkRtD3Bo

5. read data from parquet file in pyspark | write data to parquet file in pyspark:
https://youtu.be/B6wrbfLbaX0

6. datatypes in PySpark | pyspark data types | pyspark tutorial for beginners:
https://youtu.be/LqTUjOOHwQU

7. how to define the schema in pyspark | structtype & structfield in pyspark | Pyspark tutorial:
https://youtu.be/SqDlX_B7NmI

8. how to read CSV file using PySpark | How to read csv file with schema option in pyspark:
https://youtu.be/s1HHtTVg9xU

9. read json file in pyspark | read nested json file in pyspark | read multiline json file:
https://youtu.be/dOkPf_zVqaw

10. add, modify, rename and drop columns in dataframe | withcolumn and withcolumnrename in pyspark:
https://youtu.be/2SzrgwVhsy0

11. filter in pyspark | how to filter dataframe using like operator | like in pyspark:
https://youtu.be/4Hk8xmDPFZA

12. startswith in pyspark | endswith in pyspark | contains in pyspark | pyspark tutorial:
https://youtu.be/8Bep9kk4JB8

13. isin in pyspark and not isin in pyspark | in and not in in pyspark | pyspark tutorial:
https://youtu.be/bY86Et-uIcA

14. select in PySpark | alias in pyspark | azure Databricks #spark #pyspark #azuredatabricks #azure
https://youtu.be/Ih9IlDO63CY

15. when in pyspark | otherwise in pyspark | alias in pyspark | case statement in pyspark:
https://youtu.be/d1GVRCXZ64o

16. Null handling in pySpark DataFrame | isNull function in pyspark | isNotNull function in pyspark:
https://youtu.be/si4bhjK1uB8

17. fill() & fillna() functions in PySpark | how to replace null values in pyspark | Azure Databrick:
https://youtu.be/OgAry0H_P9c

18. GroupBy function in PySpark | agg function in pyspark | aggregate function in pyspark:
https://youtu.be/_IaHywzYYFc

19. count function in pyspark | countDistinct function in pyspark | pyspark tutorial for beginners:
https://youtu.be/wDNSgMkkwPM

20. orderBy in pyspark | sort in pyspark | difference between orderby and sort in pyspark:
https://youtu.be/L3d6Eaxurz0

21. distinct and dropduplicates in pyspark | how to remove duplicate in pyspark | pyspark tutorial:
https://youtu.be/HY54i2m4C0M

Видео 38. user defined function in pyspark | UDF(user defined function) in PySpark | Azure Databricks канала SS UNITECH