{"id":5694,"date":"2021-05-16T10:44:18","date_gmt":"2021-05-16T05:14:18","guid":{"rendered":"https:\/\/python-programs.com\/?p=5694"},"modified":"2021-11-22T18:45:26","modified_gmt":"2021-11-22T13:15:26","slug":"pandas-check-if-a-value-exists-in-a-dataframe-using-in-not-in-operator-isin","status":"publish","type":"post","link":"https:\/\/python-programs.com\/pandas-check-if-a-value-exists-in-a-dataframe-using-in-not-in-operator-isin\/","title":{"rendered":"Pandas : Check if a value exists in a DataFrame using in &#038; not in operator | isin()"},"content":{"rendered":"<h2>How to check if a value exists in a DataFrame using in and not in operator | isin() in Python ?<\/h2>\n<p>In this article we are going to discuss different ways to check if a value is present in the dataframe.<\/p>\n<p>We will be using the following dataset as example<\/p>\n<pre>       Name\u00a0       Age\u00a0\u00a0\u00a0\u00a0\u00a0   City\u00a0          Marks\r\n0\u00a0\u00a0\u00a0\u00a0 Jill\u00a0\u00a0           16\u00a0\u00a0\u00a0\u00a0     Tokyo\u00a0\u00a0\u00a0         154\r\n1\u00a0\u00a0   Rachel\u00a0\u00a0     38\u00a0\u00a0\u00a0\u00a0    Texas\u00a0\u00a0\u00a0          170\r\n2\u00a0\u00a0\u00a0  Kirti\u00a0\u00a0         39\u00a0        New York\u00a0\u00a0\u00a0\u00a0  88\r\n3\u00a0\u00a0\u00a0  Veena\u00a0\u00a0      40\u00a0\u00a0\u00a0\u00a0    Texas\u00a0\u00a0\u00a0         190\r\n4\u00a0    Lucifer\u00a0\u00a0     35\u00a0\u00a0\u00a0\u00a0    Texas\u00a0\u00a0\u00a0\u00a0         59\r\n5\u00a0\u00a0\u00a0  Pablo\u00a0\u00a0      30\u00a0       New York\u00a0\u00a0\u00a0    123\r\n6\u00a0\u00a0   Lionel\u00a0\u00a0      45\u00a0       Colombia\u00a0\u00a0\u00a0   189<\/pre>\n<h3>Check if a single element exists in DataFrame using in &amp; not in operators :<\/h3>\n<p>Dataframe class has a member <code>Dataframe.values<\/code> \u00a0that gives us all the values in an numpy representation. We will be using that with the in and not operator to check if the value is present in the dataframe.<\/p>\n<h4>Using in operator to check if an element exists in dataframe :<\/h4>\n<p>We will be checking if the value 190 exists in the dataset using <code>in<\/code> operator.<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"python\">#Program :\r\n\r\nimport pandas as pd\r\n#Example data\r\nemployees = [\r\n('Jill',    16,     'Tokyo',    154),\r\n('Rachel',  38,     'Texas',    170),\r\n('Kirti',   39,     'New York',  88),\r\n('Veena',   40,     'Texas',    190),\r\n('Lucifer', 35, 'Texas',     59),\r\n('Pablo',   30,     'New York', 123),\r\n('Lionel',  45,     'Colombia', 189)]\r\n\r\n# DataFrame object was created\r\ndfObj = pd.DataFrame(employees, columns=['Name', 'Age', 'City', 'Marks'])\r\nif 190 in dfObj.values:\r\n    print('Element exists in Dataframe')\r\n<\/pre>\n<pre>Output :\r\nElement exists in Dataframe<\/pre>\n<h4>Using not in operator to check if an element doesn\u2019t exists in dataframe :<\/h4>\n<p>We will be checking if \u2018Leo\u2019 is present in the dataframe using <code>not<\/code> operator.<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"python\"># Program :\r\n\r\nimport pandas as pd\r\n#Example data\r\nemployees = [\r\n('Jill',    16,     'Tokyo',    154),\r\n('Rachel',  38,     'Texas',    170),\r\n('Kirti',   39,     'New York',  88),\r\n('Veena',   40,     'Texas',    190),\r\n('Lucifer', 35, 'Texas',     59),\r\n('Pablo',   30,     'New York', 123),\r\n('Lionel',  45,     'Colombia', 189)]\r\n# DataFrame object was created\r\ndfObj = pd.DataFrame(employees, columns=['Name', 'Age', 'City', 'Marks'])\r\nif 'Leo' not in dfObj.values:\r\n    print('Element does not exists in Dataframe')\r\n\r\n<\/pre>\n<pre>Output :\r\nElement does not exists in Dataframe<\/pre>\n<h4><strong>Checking if multiple elements exists in DataFrame or not using in operator :<\/strong><\/h4>\n<p>To check for multiple elements, we have to write a function.<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"python\"># Program :\r\n\r\nimport pandas as pd\r\n\r\ndef checkForValues(_dfObj, listOfValues):\r\n    #The function would check for the list of values in our dataset\r\n    result = {}\r\n    #Iterate through the elementes\r\n    for elem in listOfValues:\r\n        # Check if the element exists in the dataframe values\r\n        if elem in _dfObj.values:\r\n            result[elem] = True\r\n        else:\r\n            result[elem] = False\r\n    # Returns a dictionary containig the vvalues and their existence in boolean        \r\n    return result\r\n\r\n#Example data\r\nemployees = [\r\n('Jill',    16,     'Tokyo',    154),\r\n('Rachel',  38,     'Texas',    170),\r\n('Kirti',   39,     'New York',  88),\r\n('Veena',   40,     'Texas',    190),\r\n('Lucifer', 35,     'Texas',     59),\r\n('Pablo',   30,     'New York', 123),\r\n('Lionel',  45,     'Colombia', 189)]\r\n# DataFrame object was created\r\ndfObj = pd.DataFrame(employees, columns=['Name', 'Age', 'City', 'Marks'])\r\n\r\n#Check for the existence of values\r\nTresult = checkForValues(dfObj, [30, 'leo', 190])\r\nprint('The values existence inside the dataframe are ')\r\nprint(Tresult)\r\n<\/pre>\n<pre>Output :\r\nThe values existence inside the dataframe are\r\n{30: True, 'leo': False, 190: True}<\/pre>\n<p>Rather than writing a whole function, we can also achieve this using a smaller method using dictionary comprehension.<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"python\"># Program :\r\n\r\nimport pandas as pd\r\n\r\n#Example data\r\nemployees = [\r\n('Jill',    16,     'Tokyo',    154),\r\n('Rachel',  38,     'Texas',    170),\r\n('Kirti',   39,     'New York',  88),\r\n('Veena',   40,     'Texas',    190),\r\n('Lucifer', 35,     'Texas',     59),\r\n('Pablo',   30,     'New York', 123),\r\n('Lionel',  45,     'Colombia', 189)]\r\n# DataFrame object was created\r\ndfObj = pd.DataFrame(employees, columns=['Name', 'Age', 'City', 'Marks'])\r\nlistOfValues = [30, 'leo', 190]\r\n#using dictionary comprehension check for given values\r\nresult = {elem: True if elem in dfObj.values else False for elem in listOfValues}\r\nprint('The values existence inside the dataframe are ')\r\nprint(result)\r\n<\/pre>\n<pre>Output :\r\nThe values existence inside the dataframe are\r\n{30: True, 'leo': False, 190: True}<\/pre>\n<h3>Checking if elements exists in DataFrame using isin() function :<\/h3>\n<p>We can also check if a value exists inside a dataframe or not using the <code>isin( )<\/code> function.<\/p>\n<pre>Syntax : DataFrame.isin(self, values)<\/pre>\n<p>Where,<\/p>\n<ul>\n<li><strong>Values :<\/strong> It takes the values to check for inside the dataframe.<\/li>\n<\/ul>\n<h4>Checking if a single element exist in Dataframe using isin() :<\/h4>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"python\"># Program :\r\n\r\nimport pandas as pd\r\n\r\n#Example data\r\nemployees = [\r\n('Jill',    16,     'Tokyo',    154),\r\n('Rachel',  38,     'Texas',    170),\r\n('Kirti',   39,     'New York',  88),\r\n('Veena',   40,     'Texas',    190),\r\n('Lucifer', 35,     'Texas',     59),\r\n('Pablo',   30,     'New York', 123),\r\n('Lionel',  45,     'Colombia', 189)]\r\n# DataFrame object was created\r\ndfObj = pd.DataFrame(employees, columns=['Name', 'Age', 'City', 'Marks'])\r\n#Checking ofr a single element susing isin( ) function\r\nboolDf = dfObj.isin([38])\r\nprint(boolDf)\r\n<\/pre>\n<pre>Output :\r\n  \u00a0Name\u00a0 Age\u00a0\u00a0 City\u00a0 Marks\r\n0\u00a0 False\u00a0 False\u00a0 False\u00a0 False\r\n1\u00a0 False\u00a0\u00a0 True\u00a0 False\u00a0 False\r\n2\u00a0 False\u00a0 False\u00a0 False\u00a0 False\r\n3\u00a0 False\u00a0 False\u00a0 False\u00a0 False\r\n4\u00a0 False\u00a0 False\u00a0 False\u00a0 False\r\n5\u00a0 False\u00a0 False\u00a0 False\u00a0 False\r\n6\u00a0 False\u00a0 False\u00a0 False\u00a0 False<\/pre>\n<p>Here the <code>isin( )<\/code> operator returned a boolean dataframe of the same number of elements, where the elements that matched our values is True and rest all are false.<\/p>\n<p>We can add this to the <code>any( )<\/code> function that only shows the true values and pass it into another <code>any( )<\/code> function making it a series to pinpoint if our element exists or not.<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"python\"># Program :\r\n\r\nimport pandas as pd\r\n\r\n#Example data\r\nemployees = [\r\n('Jill',    16,     'Tokyo',    154),\r\n('Rachel',  38,     'Texas',    170),\r\n('Kirti',   39,     'New York',  88),\r\n('Veena',   40,     'Texas',    190),\r\n('Lucifer', 35,     'Texas',     59),\r\n('Pablo',   30,     'New York', 123),\r\n('Lionel',  45,     'Colombia', 189)]\r\n# DataFrame object was created\r\ndfObj = pd.DataFrame(employees, columns=['Name', 'Age', 'City', 'Marks'])\r\n# Check if the value is inisde the dataframe using both isin() and any( ) function\r\nresult = dfObj.isin(['Lionel']).any().any()\r\nif result:\r\n    print('The value exists inside the datframe')\r\n<\/pre>\n<pre>Output :\r\nAny of the Element exists in Dataframe<\/pre>\n<h4>Checking if any of the given values exists in the Dataframe :<\/h4>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"python\"># Program :\r\n\r\nimport pandas as pd\r\n\r\n#Example data\r\nemployees = [\r\n('Jill',    16,     'Tokyo',    154),\r\n('Rachel',  38,     'Texas',    170),\r\n('Kirti',   39,     'New York',  88),\r\n('Veena',   40,     'Texas',    190),\r\n('Lucifer', 35,     'Texas',     59),\r\n('Pablo',   30,     'New York', 123),\r\n('Lionel',  45,     'Colombia', 189)]\r\n# DataFrame object was created\r\ndfObj = pd.DataFrame(employees, columns=['Name', 'Age', 'City', 'Marks'])\r\n# Check if all the values are inisde the dataframe using both isin() and any( ) function\r\nresult = dfObj.isin([81, 'Lionel', 190,]).any().any()\r\nif result:\r\n    print('Any of the Element exists in Dataframe')\r\n<\/pre>\n<pre>Output :\r\nAny of the Element exists in Dataframe<\/pre>\n<p>This program only prints if any of the given values are existing inside the dataframe.<\/p>\n<p>Want to expert in the python programming language? Exploring\u00a0<a href=\"https:\/\/python-programs.com\/python-data-analysis-using-pandas\/\">Python Data Analysis using Pandas<\/a>\u00a0tutorial changes your knowledge from basic to advance level in python concepts.<\/p>\n<p><strong>Read more Articles on Python Data Analysis Using Padas \u2013 Find Elements in a Dataframe<\/strong><\/p>\n<ul>\n<li><a href=\"https:\/\/python-programs.com\/pandas-sort-rows-or-columns-in-dataframe-based-on-values-using-dataframe-sort_values\/\">Find &amp; Drop duplicate columns in a DataFrame<\/a><\/li>\n<li><a href=\"https:\/\/python-programs.com\/pandas-4-ways-to-check-if-a-dataframe-is-empty-in-python\/\">Check if a DataFrame is empty in Python<\/a><\/li>\n<li><a href=\"https:\/\/python-programs.com\/pandas-find-duplicate-rows-in-a-dataframe-based-on-all-or-selected-columns-using-dataframe-duplicated-in-python\/\">Find duplicate rows in a Dataframe based on all or selected columns using DataFrame.duplicated() in Python<\/a><\/li>\n<li><a href=\"https:\/\/python-programs.com\/pandas-find-maximum-values-position-in-columns-or-rows-of-a-dataframe\/\">Find maximum values &amp; position in columns or rows of a Dataframe<\/a><\/li>\n<li><a href=\"https:\/\/python-programs.com\/python-find-indexes-of-an-element-in-pandas-dataframe\/\">Find indexes of an element in pandas dataframe<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>How to check if a value exists in a DataFrame using in and not in operator | isin() in Python ? In this article we are going to discuss different ways to check if a value is present in the dataframe. We will be using the following dataset as example Name\u00a0 Age\u00a0\u00a0\u00a0\u00a0\u00a0 City\u00a0 Marks 0\u00a0\u00a0\u00a0\u00a0 &hellip;<\/p>\n<p class=\"read-more\"> <a class=\"\" href=\"https:\/\/python-programs.com\/pandas-check-if-a-value-exists-in-a-dataframe-using-in-not-in-operator-isin\/\"> <span class=\"screen-reader-text\">Pandas : Check if a value exists in a DataFrame using in &#038; not in operator | isin()<\/span> Read More &raquo;<\/a><\/p>\n","protected":false},"author":9,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"spay_email":"","jetpack_publicize_message":"","jetpack_is_tweetstorm":false,"jetpack_publicize_feature_enabled":true},"categories":[5],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v18.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Pandas : Check if a value exists in a DataFrame using in &amp; not in operator | isin() - Python Programs<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/python-programs.com\/pandas-check-if-a-value-exists-in-a-dataframe-using-in-not-in-operator-isin\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Pandas : Check if a value exists in a DataFrame using in &amp; not in operator | isin() - Python Programs\" \/>\n<meta property=\"og:description\" content=\"How to check if a value exists in a DataFrame using in and not in operator | isin() in Python ? In this article we are going to discuss different ways to check if a value is present in the dataframe. We will be using the following dataset as example Name\u00a0 Age\u00a0\u00a0\u00a0\u00a0\u00a0 City\u00a0 Marks 0\u00a0\u00a0\u00a0\u00a0 &hellip; Pandas : Check if a value exists in a DataFrame using in &#038; not in operator | isin() Read More &raquo;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/python-programs.com\/pandas-check-if-a-value-exists-in-a-dataframe-using-in-not-in-operator-isin\/\" \/>\n<meta property=\"og:site_name\" content=\"Python Programs\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/btechgeeks\" \/>\n<meta property=\"article:published_time\" content=\"2021-05-16T05:14:18+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-11-22T13:15:26+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@btech_geeks\" \/>\n<meta name=\"twitter:site\" content=\"@btech_geeks\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Satyabrata Jena\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Organization\",\"@id\":\"https:\/\/python-programs.com\/#organization\",\"name\":\"BTech Geeks\",\"url\":\"https:\/\/python-programs.com\/\",\"sameAs\":[\"https:\/\/www.instagram.com\/btechgeeks\/\",\"https:\/\/www.linkedin.com\/in\/btechgeeks\",\"https:\/\/in.pinterest.com\/btechgeek\/\",\"https:\/\/www.youtube.com\/channel\/UC9MlCqdJ3lKqz2p5114SDIg\",\"https:\/\/www.facebook.com\/btechgeeks\",\"https:\/\/twitter.com\/btech_geeks\"],\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/python-programs.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/python-programs.com\/wp-content\/uploads\/2020\/11\/BTechGeeks.png\",\"contentUrl\":\"https:\/\/python-programs.com\/wp-content\/uploads\/2020\/11\/BTechGeeks.png\",\"width\":350,\"height\":70,\"caption\":\"BTech Geeks\"},\"image\":{\"@id\":\"https:\/\/python-programs.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/python-programs.com\/#website\",\"url\":\"https:\/\/python-programs.com\/\",\"name\":\"Python Programs\",\"description\":\"Python Programs with Examples, How To Guides on Python\",\"publisher\":{\"@id\":\"https:\/\/python-programs.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/python-programs.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/python-programs.com\/pandas-check-if-a-value-exists-in-a-dataframe-using-in-not-in-operator-isin\/#webpage\",\"url\":\"https:\/\/python-programs.com\/pandas-check-if-a-value-exists-in-a-dataframe-using-in-not-in-operator-isin\/\",\"name\":\"Pandas : Check if a value exists in a DataFrame using in & not in operator | isin() - Python Programs\",\"isPartOf\":{\"@id\":\"https:\/\/python-programs.com\/#website\"},\"datePublished\":\"2021-05-16T05:14:18+00:00\",\"dateModified\":\"2021-11-22T13:15:26+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/python-programs.com\/pandas-check-if-a-value-exists-in-a-dataframe-using-in-not-in-operator-isin\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/python-programs.com\/pandas-check-if-a-value-exists-in-a-dataframe-using-in-not-in-operator-isin\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/python-programs.com\/pandas-check-if-a-value-exists-in-a-dataframe-using-in-not-in-operator-isin\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/python-programs.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Pandas : Check if a value exists in a DataFrame using in &#038; not in operator | isin()\"}]},{\"@type\":\"Article\",\"@id\":\"https:\/\/python-programs.com\/pandas-check-if-a-value-exists-in-a-dataframe-using-in-not-in-operator-isin\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/python-programs.com\/pandas-check-if-a-value-exists-in-a-dataframe-using-in-not-in-operator-isin\/#webpage\"},\"author\":{\"@id\":\"https:\/\/python-programs.com\/#\/schema\/person\/0f6d731bda7051ce3586f71299f391cd\"},\"headline\":\"Pandas : Check if a value exists in a DataFrame using in &#038; not in operator | isin()\",\"datePublished\":\"2021-05-16T05:14:18+00:00\",\"dateModified\":\"2021-11-22T13:15:26+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/python-programs.com\/pandas-check-if-a-value-exists-in-a-dataframe-using-in-not-in-operator-isin\/#webpage\"},\"wordCount\":429,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/python-programs.com\/#organization\"},\"articleSection\":[\"Python\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/python-programs.com\/pandas-check-if-a-value-exists-in-a-dataframe-using-in-not-in-operator-isin\/#respond\"]}]},{\"@type\":\"Person\",\"@id\":\"https:\/\/python-programs.com\/#\/schema\/person\/0f6d731bda7051ce3586f71299f391cd\",\"name\":\"Satyabrata Jena\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/python-programs.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c1bf8033ec357d085f41815bee1625cc?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c1bf8033ec357d085f41815bee1625cc?s=96&d=mm&r=g\",\"caption\":\"Satyabrata Jena\"},\"url\":\"https:\/\/python-programs.com\/author\/satyabrata\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Pandas : Check if a value exists in a DataFrame using in & not in operator | isin() - Python Programs","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/python-programs.com\/pandas-check-if-a-value-exists-in-a-dataframe-using-in-not-in-operator-isin\/","og_locale":"en_US","og_type":"article","og_title":"Pandas : Check if a value exists in a DataFrame using in & not in operator | isin() - Python Programs","og_description":"How to check if a value exists in a DataFrame using in and not in operator | isin() in Python ? In this article we are going to discuss different ways to check if a value is present in the dataframe. We will be using the following dataset as example Name\u00a0 Age\u00a0\u00a0\u00a0\u00a0\u00a0 City\u00a0 Marks 0\u00a0\u00a0\u00a0\u00a0 &hellip; Pandas : Check if a value exists in a DataFrame using in &#038; not in operator | isin() Read More &raquo;","og_url":"https:\/\/python-programs.com\/pandas-check-if-a-value-exists-in-a-dataframe-using-in-not-in-operator-isin\/","og_site_name":"Python Programs","article_publisher":"https:\/\/www.facebook.com\/btechgeeks","article_published_time":"2021-05-16T05:14:18+00:00","article_modified_time":"2021-11-22T13:15:26+00:00","twitter_card":"summary_large_image","twitter_creator":"@btech_geeks","twitter_site":"@btech_geeks","twitter_misc":{"Written by":"Satyabrata Jena","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Organization","@id":"https:\/\/python-programs.com\/#organization","name":"BTech Geeks","url":"https:\/\/python-programs.com\/","sameAs":["https:\/\/www.instagram.com\/btechgeeks\/","https:\/\/www.linkedin.com\/in\/btechgeeks","https:\/\/in.pinterest.com\/btechgeek\/","https:\/\/www.youtube.com\/channel\/UC9MlCqdJ3lKqz2p5114SDIg","https:\/\/www.facebook.com\/btechgeeks","https:\/\/twitter.com\/btech_geeks"],"logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/python-programs.com\/#\/schema\/logo\/image\/","url":"https:\/\/python-programs.com\/wp-content\/uploads\/2020\/11\/BTechGeeks.png","contentUrl":"https:\/\/python-programs.com\/wp-content\/uploads\/2020\/11\/BTechGeeks.png","width":350,"height":70,"caption":"BTech Geeks"},"image":{"@id":"https:\/\/python-programs.com\/#\/schema\/logo\/image\/"}},{"@type":"WebSite","@id":"https:\/\/python-programs.com\/#website","url":"https:\/\/python-programs.com\/","name":"Python Programs","description":"Python Programs with Examples, How To Guides on Python","publisher":{"@id":"https:\/\/python-programs.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/python-programs.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/python-programs.com\/pandas-check-if-a-value-exists-in-a-dataframe-using-in-not-in-operator-isin\/#webpage","url":"https:\/\/python-programs.com\/pandas-check-if-a-value-exists-in-a-dataframe-using-in-not-in-operator-isin\/","name":"Pandas : Check if a value exists in a DataFrame using in & not in operator | isin() - Python Programs","isPartOf":{"@id":"https:\/\/python-programs.com\/#website"},"datePublished":"2021-05-16T05:14:18+00:00","dateModified":"2021-11-22T13:15:26+00:00","breadcrumb":{"@id":"https:\/\/python-programs.com\/pandas-check-if-a-value-exists-in-a-dataframe-using-in-not-in-operator-isin\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/python-programs.com\/pandas-check-if-a-value-exists-in-a-dataframe-using-in-not-in-operator-isin\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/python-programs.com\/pandas-check-if-a-value-exists-in-a-dataframe-using-in-not-in-operator-isin\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/python-programs.com\/"},{"@type":"ListItem","position":2,"name":"Pandas : Check if a value exists in a DataFrame using in &#038; not in operator | isin()"}]},{"@type":"Article","@id":"https:\/\/python-programs.com\/pandas-check-if-a-value-exists-in-a-dataframe-using-in-not-in-operator-isin\/#article","isPartOf":{"@id":"https:\/\/python-programs.com\/pandas-check-if-a-value-exists-in-a-dataframe-using-in-not-in-operator-isin\/#webpage"},"author":{"@id":"https:\/\/python-programs.com\/#\/schema\/person\/0f6d731bda7051ce3586f71299f391cd"},"headline":"Pandas : Check if a value exists in a DataFrame using in &#038; not in operator | isin()","datePublished":"2021-05-16T05:14:18+00:00","dateModified":"2021-11-22T13:15:26+00:00","mainEntityOfPage":{"@id":"https:\/\/python-programs.com\/pandas-check-if-a-value-exists-in-a-dataframe-using-in-not-in-operator-isin\/#webpage"},"wordCount":429,"commentCount":0,"publisher":{"@id":"https:\/\/python-programs.com\/#organization"},"articleSection":["Python"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/python-programs.com\/pandas-check-if-a-value-exists-in-a-dataframe-using-in-not-in-operator-isin\/#respond"]}]},{"@type":"Person","@id":"https:\/\/python-programs.com\/#\/schema\/person\/0f6d731bda7051ce3586f71299f391cd","name":"Satyabrata Jena","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/python-programs.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c1bf8033ec357d085f41815bee1625cc?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c1bf8033ec357d085f41815bee1625cc?s=96&d=mm&r=g","caption":"Satyabrata Jena"},"url":"https:\/\/python-programs.com\/author\/satyabrata\/"}]}},"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/python-programs.com\/wp-json\/wp\/v2\/posts\/5694"}],"collection":[{"href":"https:\/\/python-programs.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/python-programs.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/python-programs.com\/wp-json\/wp\/v2\/users\/9"}],"replies":[{"embeddable":true,"href":"https:\/\/python-programs.com\/wp-json\/wp\/v2\/comments?post=5694"}],"version-history":[{"count":4,"href":"https:\/\/python-programs.com\/wp-json\/wp\/v2\/posts\/5694\/revisions"}],"predecessor-version":[{"id":9089,"href":"https:\/\/python-programs.com\/wp-json\/wp\/v2\/posts\/5694\/revisions\/9089"}],"wp:attachment":[{"href":"https:\/\/python-programs.com\/wp-json\/wp\/v2\/media?parent=5694"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/python-programs.com\/wp-json\/wp\/v2\/categories?post=5694"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/python-programs.com\/wp-json\/wp\/v2\/tags?post=5694"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}