 Hello, Welcome to SSUnitex to see this side and this is continuation of PySpark tutorial. So in this video we are going to see about the subtract and accept all. So what are the difference between these two functions as well. So as per the today's azenda first we will see about the subtract then we will see about accept all and last we will see what is the difference between these two. So what subtract function will does. So subtract function return a new data frame with the rows in the first data frame that are not present in the second data frame. So this is something like you can imagine not in operating in SQL server. So we are having one data frame and it is switching all the rows from there those are not available in the second data frame. Next is the accept all. So accept all function also return the new data frame with the rows from the first data frame that are not present in the second data frame and it does not remove the duplicate. So let's assume if any row is having the duplicate in the first data frame then it will be going to return both the rows. But in case of the subtract it will be returning only a single. So we can say subtract is accept plus distinct. Now let me quickly go inside the browser and we will try to see in practical. So here I am going to create two data frames data frame and data frame one. So let me try to execute this query. So we can see here we are having two data frames output first is having total six rows and second is having total three rows. So while we are going to use the subtract so it will be going to pick ID two and three because these two IDs are not present in data frame two. So let me quickly use data frame dot then we can use subtract. And under that we can pass another data frame that is data frame one. Let me use display of this. Let me execute and we'll see the output of this. So here we should be able to see total two rows like employee ID two and employee ID three. If we are going to use accept all then it will be also written ID two and three. But as we can see in data frame we are having duplicate on ID two. So it will be returning those two rows here. So this is the only difference between these two. So I hope guys you have understood about subtract and accept all. And what is the difference between these two. Thank you so much for watching this video. See you in the next video.