 Hello, welcome to SSUnitex social decide and this is continuation of PySpark tutorial. So in this video we are going to see how we can use the in and not in operators inside the PySpark. So let me quickly go inside the browser and we will try to see in practical. So here we are having this data frame which is the DF and it is containing this sales data. So the requirement is we just want to filter out the rows if your item name is having total income and total expenditure. If your data frame is containing these two rows then we just want to filter out. So for this as inside the SQL we have to use the in operator. So similarly inside the PySpark we have to use the in operator as well. So how we can use it? So first let me try to use the DF dot as we are going to apply the filter. So we have to use the filter here. Now inside this bracket again we have to use the data frame and on which column we want to use the in operator. So we want an in operator on the item name column. Next here we have to use the in operator. So we should be going to use the is in. So we have to use the is in. Now let me try to add these two values by which we just want to do the filter. So we just want to do the filter on this total income and the second value that should be total expenditure. So let me try to use expenditure here and let me put this inside one of the data frame which is the DF1. Let me use the display command and use the DF1 and try to execute. So here as inside the rows of the output we can see total income and total expenditure rows are here. Now if the requirement is reverse we want all the rows except the total income and total expenditure. So we should be going to use the not in operator. So directly we don't have any operator by which we can use the not in. So what we have to do we have to use the not symbol under this filter. So once the filter is going to start with the bracket then we have to use the not. So what this not will be doing it will be going to return all the values except this value that we are going to filter out. So it will be going to filter without total income and expenditure. Now let me try to execute and we will see. So it should be going to return all the rows except those two that we can see. All values are here and we don't see the value for the total income and expenditure. So I hope guys you have understood how we can use the in and not in operator. Thank you so much for watching this video. See you in the next video.