{"id":27523,"date":"2024-03-16T08:36:41","date_gmt":"2024-03-16T08:36:41","guid":{"rendered":"https:\/\/www.silicloud.com\/blog\/how-to-filter-rows-that-meet-certain-conditions-in-pandas\/"},"modified":"2024-03-22T11:14:35","modified_gmt":"2024-03-22T11:14:35","slug":"how-to-filter-rows-that-meet-certain-conditions-in-pandas","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/blog\/how-to-filter-rows-that-meet-certain-conditions-in-pandas\/","title":{"rendered":"How to filter rows that meet certain conditions in pandas?"},"content":{"rendered":"<p>To filter rows that meet certain criteria, you can use boolean indexing. Boolean indexing is a method of selecting rows based on boolean values.<\/p>\n<p>First, create a boolean condition that will return a boolean value for each row of the DataFrame, indicating whether the row meets the condition. Then pass this boolean condition as an index to the DataFrame to filter out the rows that meet the condition.<\/p>\n<p>Here is an example of filtering rows where the &#8216;Score&#8217; column is greater than or equal to 80.<\/p>\n<pre class=\"post-pre\"><code><span class=\"hljs-keyword\">import<\/span> pandas <span class=\"hljs-keyword\">as<\/span> pd\r\n\r\ndf = pd.DataFrame({<span class=\"hljs-string\">'Name'<\/span>: [<span class=\"hljs-string\">'Alice'<\/span>, <span class=\"hljs-string\">'Bob'<\/span>, <span class=\"hljs-string\">'Charlie'<\/span>],\r\n                   <span class=\"hljs-string\">'Score'<\/span>: [<span class=\"hljs-number\">85<\/span>, <span class=\"hljs-number\">70<\/span>, <span class=\"hljs-number\">90<\/span>]})\r\n\r\ncondition = df[<span class=\"hljs-string\">'Score'<\/span>] &gt;= <span class=\"hljs-number\">80<\/span>\r\nfiltered_df = df[condition]\r\n\r\n<span class=\"hljs-built_in\">print<\/span>(filtered_df)\r\n<\/code><\/pre>\n<p>The output is:<\/p>\n<pre class=\"post-pre\"><code>      Name  Score\r\n0    Alice     85\r\n2  Charlie     90\r\n<\/code><\/pre>\n<p>In the example above, a boolean condition was first created as condition = df[&#8216;Score&#8217;] >= 80, this condition was then passed as an index to the DataFrame df[condition], resulting in the rows that meet the condition.<\/p>\n<p>You can customize the criteria to filter rows that meet your needs.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>To filter rows that meet certain criteria, you can use boolean indexing. Boolean indexing is a method of selecting rows based on boolean values. First, create a boolean condition that will return a boolean value for each row of the DataFrame, indicating whether the row meets the condition. Then pass this boolean condition as an [&hellip;]<\/p>\n","protected":false},"author":9,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_import_markdown_pro_load_document_selector":0,"_import_markdown_pro_submit_text_textarea":"","footnotes":""},"categories":[1],"tags":[],"class_list":["post-27523","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.5 (Yoast SEO v21.5) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to filter rows that meet certain conditions in pandas? - Blog - Silicon Cloud<\/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:\/\/www.silicloud.com\/blog\/how-to-filter-rows-that-meet-certain-conditions-in-pandas\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to filter rows that meet certain conditions in pandas?\" \/>\n<meta property=\"og:description\" content=\"To filter rows that meet certain criteria, you can use boolean indexing. Boolean indexing is a method of selecting rows based on boolean values. First, create a boolean condition that will return a boolean value for each row of the DataFrame, indicating whether the row meets the condition. Then pass this boolean condition as an [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/blog\/how-to-filter-rows-that-meet-certain-conditions-in-pandas\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\" \/>\n<meta property=\"article:published_time\" content=\"2024-03-16T08:36:41+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-22T11:14:35+00:00\" \/>\n<meta name=\"author\" content=\"Ava Mitchell\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:site\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Ava Mitchell\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-filter-rows-that-meet-certain-conditions-in-pandas\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-filter-rows-that-meet-certain-conditions-in-pandas\/\"},\"author\":{\"name\":\"Ava Mitchell\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/a3e2658c2cb9fb2be95ae0a8861f4a64\"},\"headline\":\"How to filter rows that meet certain conditions in pandas?\",\"datePublished\":\"2024-03-16T08:36:41+00:00\",\"dateModified\":\"2024-03-22T11:14:35+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-filter-rows-that-meet-certain-conditions-in-pandas\/\"},\"wordCount\":145,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-filter-rows-that-meet-certain-conditions-in-pandas\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/how-to-filter-rows-that-meet-certain-conditions-in-pandas\/\",\"name\":\"How to filter rows that meet certain conditions in pandas? - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\"},\"datePublished\":\"2024-03-16T08:36:41+00:00\",\"dateModified\":\"2024-03-22T11:14:35+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-filter-rows-that-meet-certain-conditions-in-pandas\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/blog\/how-to-filter-rows-that-meet-certain-conditions-in-pandas\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-filter-rows-that-meet-certain-conditions-in-pandas\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.silicloud.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to filter rows that meet certain conditions in pandas?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"name\":\"Silicon Cloud Blog\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\",\"name\":\"Silicon Cloud Blog\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"contentUrl\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"width\":1024,\"height\":1024,\"caption\":\"Silicon Cloud Blog\"},\"image\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\",\"https:\/\/twitter.com\/SiliCloudGlobal\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/a3e2658c2cb9fb2be95ae0a8861f4a64\",\"name\":\"Ava Mitchell\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/15c63cd0564b4a2e07d611bcdffa296f6ea80e8db07c3091f43a84010514899d?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/15c63cd0564b4a2e07d611bcdffa296f6ea80e8db07c3091f43a84010514899d?s=96&d=mm&r=g\",\"caption\":\"Ava Mitchell\"},\"url\":\"https:\/\/www.silicloud.com\/blog\/author\/avamitchell\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"How to filter rows that meet certain conditions in pandas? - Blog - Silicon Cloud","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:\/\/www.silicloud.com\/blog\/how-to-filter-rows-that-meet-certain-conditions-in-pandas\/","og_locale":"en_US","og_type":"article","og_title":"How to filter rows that meet certain conditions in pandas?","og_description":"To filter rows that meet certain criteria, you can use boolean indexing. Boolean indexing is a method of selecting rows based on boolean values. First, create a boolean condition that will return a boolean value for each row of the DataFrame, indicating whether the row meets the condition. Then pass this boolean condition as an [&hellip;]","og_url":"https:\/\/www.silicloud.com\/blog\/how-to-filter-rows-that-meet-certain-conditions-in-pandas\/","og_site_name":"Blog - Silicon Cloud","article_publisher":"https:\/\/www.facebook.com\/SiliCloudGlobal\/","article_published_time":"2024-03-16T08:36:41+00:00","article_modified_time":"2024-03-22T11:14:35+00:00","author":"Ava Mitchell","twitter_card":"summary_large_image","twitter_creator":"@SiliCloudGlobal","twitter_site":"@SiliCloudGlobal","twitter_misc":{"Written by":"Ava Mitchell","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.silicloud.com\/blog\/how-to-filter-rows-that-meet-certain-conditions-in-pandas\/#article","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-filter-rows-that-meet-certain-conditions-in-pandas\/"},"author":{"name":"Ava Mitchell","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/a3e2658c2cb9fb2be95ae0a8861f4a64"},"headline":"How to filter rows that meet certain conditions in pandas?","datePublished":"2024-03-16T08:36:41+00:00","dateModified":"2024-03-22T11:14:35+00:00","mainEntityOfPage":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-filter-rows-that-meet-certain-conditions-in-pandas\/"},"wordCount":145,"commentCount":0,"publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/blog\/how-to-filter-rows-that-meet-certain-conditions-in-pandas\/","url":"https:\/\/www.silicloud.com\/blog\/how-to-filter-rows-that-meet-certain-conditions-in-pandas\/","name":"How to filter rows that meet certain conditions in pandas? - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/#website"},"datePublished":"2024-03-16T08:36:41+00:00","dateModified":"2024-03-22T11:14:35+00:00","breadcrumb":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-filter-rows-that-meet-certain-conditions-in-pandas\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/blog\/how-to-filter-rows-that-meet-certain-conditions-in-pandas\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/blog\/how-to-filter-rows-that-meet-certain-conditions-in-pandas\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.silicloud.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How to filter rows that meet certain conditions in pandas?"}]},{"@type":"WebSite","@id":"https:\/\/www.silicloud.com\/blog\/#website","url":"https:\/\/www.silicloud.com\/blog\/","name":"Silicon Cloud Blog","description":"","publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.silicloud.com\/blog\/#organization","name":"Silicon Cloud Blog","url":"https:\/\/www.silicloud.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","contentUrl":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","width":1024,"height":1024,"caption":"Silicon Cloud Blog"},"image":{"@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/SiliCloudGlobal\/","https:\/\/twitter.com\/SiliCloudGlobal"]},{"@type":"Person","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/a3e2658c2cb9fb2be95ae0a8861f4a64","name":"Ava Mitchell","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/15c63cd0564b4a2e07d611bcdffa296f6ea80e8db07c3091f43a84010514899d?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/15c63cd0564b4a2e07d611bcdffa296f6ea80e8db07c3091f43a84010514899d?s=96&d=mm&r=g","caption":"Ava Mitchell"},"url":"https:\/\/www.silicloud.com\/blog\/author\/avamitchell\/"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/27523","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/users\/9"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/comments?post=27523"}],"version-history":[{"count":1,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/27523\/revisions"}],"predecessor-version":[{"id":61759,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/27523\/revisions\/61759"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/media?parent=27523"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/categories?post=27523"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/tags?post=27523"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}