{"id":4486,"date":"2021-07-14T00:00:23","date_gmt":"2021-07-13T15:00:23","guid":{"rendered":"https:\/\/itips.krsw.biz\/?p=4486"},"modified":"2025-06-09T22:29:36","modified_gmt":"2025-06-09T13:29:36","slug":"pandas-dataframe-how-to-drop-none-data","status":"publish","type":"post","link":"https:\/\/itips.krsw.biz\/en\/pandas-dataframe-how-to-drop-none-data\/","title":{"rendered":"How to remove none from pandas DataFrame"},"content":{"rendered":"<p><img decoding=\"async\" src=\"https:\/\/itips.krsw.biz\/wp-content\/uploads\/2020\/10\/h2-python-800x450.jpg\" alt=\"How to remove none from pandas DataFrame\" \/><\/p>\n<p>Pandas is very useful to handle table data.<\/p>\n<p>In table data, sometimes it contains <code>None<\/code> data.<\/p>\n<p>In that case we would like to remove <code>None<\/code> from specific column.<\/p>\n<p>So how can we remove <code>None<\/code> ?<\/p>\n<p>Today I introduce <strong>&quot;<span class=\"st-mymarker-s\">How to remove none from pandas DataFrame<\/span>&quot;<\/strong>.<\/p>\n<div class=\"st-mybox  has-title \" style=\"background:#ffffff;border-color:#BDBDBD;border-width:2px;border-radius:5px;margin: 25px 0;\"><p class=\"st-mybox-title\" style=\"color:#757575;font-weight:bold;background: #ffffff;\"><i class=\"fa fa-check-circle st-css-no\" aria-hidden=\"true\"><\/i>Author<\/p><div class=\"st-in-mybox\"><br \/>\n<div class=\"st-kaiwa-box kaiwaicon2 clearfix\"><div class=\"st-kaiwa-face\"><img decoding=\"async\" src=\"https:\/\/itips.krsw.biz\/wp-content\/uploads\/2022\/06\/karasan_smile_200px_b.gif\" width=\"60px\"><div class=\"st-kaiwa-face-name\"><\/div><\/div><div class=\"st-kaiwa-area\"><div class=\"st-kaiwa-hukidashi\">Mid-carieer engineer (AI, system). Good at Python and SQL. Through system engineer experience, I also have a lot of knowledge like server.<\/div><\/div><\/div><br \/>\n<\/div><\/div>\n<div class=\"st-minihukidashi-box \" ><p class=\"st-minihukidashi\" style=\"background:#3F51B5;color:#fff;margin: 0 0 0 -6px;font-size:80%;border-radius:30px;\"><span class=\"st-minihukidashi-arrow\" style=\"border-top-color: #3F51B5;\"><\/span><span class=\"st-minihukidashi-flexbox\">Advantage to read<\/span><\/p><\/div>\n<div class=\"clip-memobox \" style=\"background:#E8EAF6;color:#000000;\"><div class=\"clip-fonticon\" style=\"font-size:200%;color:#3F51B5;\"><i class=\"fa fa-thumbs-o-up st-css-no\" aria-hidden=\"true\"><\/i><\/div><div class=\"clip-memotext\" style=\"border-color:#3F51B5;\"><p style=\"color:#000000;\">You can understand \"How to remove none from pandas DataFrame\".<\/p><\/div><\/div>\n<p><!--more--><\/p>\n<p><\/br><\/p>\n<h2>How to remove none from pandas DataFrame<\/h2>\n<p><img decoding=\"async\" src=\"https:\/\/itips.krsw.biz\/wp-content\/uploads\/2020\/10\/h2-how-800x450.jpg\" alt=\"\" \/><\/p>\n<p>In order to remove None data, use <code>dropna()<\/code> method.<\/p>\n<p>As its name, <code>dropna()<\/code> drops <code>None<\/code> data.<\/p>\n<p>We can use it like below.<\/p>\n<pre class=\"prettyprint lang-python\">\nimport pandas as pd\n\ndata_list1 = &#091;\n&#091;1,2,None&#093;,\n&#091;2,None,4&#093;,\n&#091;None,4,5&#093;,\n&#091;4,5,6&#093;\n&#093;\ncol_list1 = &#091;&#34;c1&#34;,&#34;c2&#34;,&#34;c3&#34;&#093;\ndf1 = pd.DataFrame(data=data_list1, columns=col_list1)\nprint(df1)\n\n#     c1   c2   c3\n# 0  1.0  2.0  NaN\n# 1  2.0  NaN  4.0\n# 2  NaN  4.0  5.0\n# 3  4.0  5.0  6.0\n\ndf2 = df1.dropna()\n\nprint(df2)\n\n#     c1   c2   c3\n# 3  4.0  5.0  6.0\n<\/pre>\n<p><\/br><\/p>\n<p>With using <code>dropna()<\/code>, we could extract rows that does not have <code>None<\/code>.<\/p>\n<p>Then how can we handle more complex data ?<\/p>\n<p><\/br><\/br><\/p>\n<h3>How to remove data that have none in specific column<\/h3>\n<p><img decoding=\"async\" src=\"https:\/\/itips.krsw.biz\/wp-content\/uploads\/2021\/04\/select_1618573367-800x444.jpg\" alt=\"\" \/><\/p>\n<p>We could remove data that has <code>None<\/code>.<\/p>\n<p>Then how can we check <code>None<\/code> <span class=\"rmarker-s\">in specific column ?<\/span><\/p>\n<p>In order to set column condition, use <code>subset<\/code>.<\/p>\n<p>You can set column names in <code>subset<\/code> like below.<\/p>\n<pre class=\"prettyprint lang-python\">\ndf3 = df1.dropna(subset=&#091;&#34;c1&#34;,&#34;c2&#34;&#093;)\nprint(df3)\n\n#     c1   c2   c3\n# 0  1.0  2.0  NaN\n# 3  4.0  5.0  6.0\n<\/pre>\n<p><\/br><\/br><\/p>\n<h3>How to remove data that has none in all columns<\/h3>\n<p><img decoding=\"async\" src=\"https:\/\/itips.krsw.biz\/wp-content\/uploads\/2021\/04\/camera_video_1618921225-800x533.jpg\" alt=\"\" \/><\/p>\n<p>So how can we remove data that has none <span class=\"rmarker-s\">in all columns<\/span> ?<\/p>\n<p>This case, use <code>how=&quot;all&quot;<\/code>.<\/p>\n<p>If you set <code>how=&quot;all&quot;<\/code>, you can get data without rows that has none in all columns.<\/p>\n<pre class=\"prettyprint lang-python\">\ndata_list1 = &#091;\n&#091;1,2,None&#093;,\n&#091;2,None,4&#093;,\n&#091;None,None,None&#093;,\n&#091;4,5,6&#093;\n&#093;\n\ncol_list1 = &#091;&#34;c1&#34;,&#34;c2&#34;,&#34;c3&#34;&#093;\ndf1 = pd.DataFrame(data=data_list1, columns=col_list1)\nprint(df1)\n\n#     c1   c2   c3\n# 0  1.0  2.0  NaN\n# 1  2.0  NaN  4.0\n# 2  NaN  NaN  NaN\n# 3  4.0  5.0  6.0\n\ndf2 = df1.dropna()\nprint(df2)\n\n#     c1   c2   c3\n# 3  4.0  5.0  6.0\n\ndf4 = df1.dropna(how=&#34;all&#34;)\nprint(df4)\n\n#     c1   c2   c3\n# 0  1.0  2.0  NaN\n# 1  2.0  NaN  4.0\n# 3  4.0  5.0  6.0\n<\/pre>\n<p><\/br><\/br><\/p>\n<h3>How to remove cplumn that has none<\/h3>\n<p><img decoding=\"async\" src=\"https:\/\/itips.krsw.biz\/wp-content\/uploads\/2020\/04\/answer_1586182862-800x533.jpg\" alt=\"\" \/><\/p>\n<p>With using <code>dropna()<\/code>, we could remove rows that has <code>None<\/code>.<\/p>\n<p>Then how can we drop <span class=\"rmarker-s\">columns<\/span> ?<\/p>\n<p>In order to remove column, use <code>axis=1<\/code> option.<\/p>\n<pre class=\"prettyprint lang-python\">\ndata_list1 = &#091;\n&#091;1,2,None&#093;,\n&#091;2,None,4&#093;,\n&#091;3,4,5&#093;,\n&#091;4,5,6&#093;\n&#093;\ncol_list1 = &#091;&#34;c1&#34;,&#34;c2&#34;,&#34;c3&#34;&#093;\ndf1 = pd.DataFrame(data=data_list1, columns=col_list1)\nprint(df1)\n\n#     c1   c2   c3\n# 0  1.0  2.0  NaN\n# 1  2.0  NaN  4.0\n# 2  3.0  4.0  5.0\n# 3  4.0  5.0  6.0\n\ndf5 = df1.dropna(axis=1)\nprint(df5)\n\n#    c1\n# 0   1\n# 1   2\n# 2   3\n# 3   4\n<\/pre>\n<p><\/br><\/p>\n<p><code>axis=1<\/code> \u3092\u6307\u5b9a\u3059\u308b\u3053\u3068\u3067None\u3092\u542b\u3080\u5217\u304c\u9664\u5916\u3055\u308c\u305f\u3002<\/p>\n<p><\/br><\/br><\/p>\n<h2>\u3000Conclusion<\/h2>\n<p><img decoding=\"async\" src=\"https:\/\/itips.krsw.biz\/wp-content\/uploads\/2020\/11\/h2-conclusion-800x450.jpg\" alt=\"\" \/><\/p>\n<p>Today I described about <strong>&quot;<span class=\"st-mymarker-s\">How to remove none from pandas DataFrame<\/span>&quot;<\/strong>.<\/p>\n<p>In order to remove <code>None<\/code>, we can use <code>dropna()<\/code>.<\/p>\n<p>And we can use these options.<\/p>\n<div class=\"st-mybox  has-title \" style=\"background:#ffffff;border-color:#BDBDBD;border-width:2px;border-radius:5px;margin: 25px 0;\"><p class=\"st-mybox-title\" style=\"color:#757575;font-weight:bold;background: #ffffff;\"><i class=\"fa fa-check-circle st-css-no\" aria-hidden=\"true\"><\/i>dropna options<\/p><div class=\"st-in-mybox\">\n<li>Filter by specific columns: <code>subset=[&quot;column name&quot;]<\/code><\/li>\n<li>Remove rows that has None in all columns: <code>how=&quot;all&quot;<\/code><\/li>\n<li>Remove columns: <code>axis=1<\/code><\/li>\n<\/div><\/div>\n<p><\/br><\/p>\n<div class=\"st-mybox  has-title st-mybox-class\" style=\"background:#fafafa;border-width:1px;border-radius:5px;margin: 25px 0 25px 0;\"><p class=\"st-mybox-title\" style=\"color:#757575;font-weight:bold;text-shadow: #fff 3px 0px 0px, #fff 2.83487px 0.981584px 0px, #fff 2.35766px 1.85511px 0px, #fff 1.62091px 2.52441px 0px, #fff 0.705713px 2.91581px 0px, #fff -0.287171px 2.98622px 0px, #fff -1.24844px 2.72789px 0px, #fff -2.07227px 2.16926px 0px, #fff -2.66798px 1.37182px 0px, #fff -2.96998px 0.42336px 0px, #fff -2.94502px -0.571704px 0px, #fff -2.59586px -1.50383px 0px, #fff -1.96093px -2.27041px 0px, #fff -1.11013px -2.78704px 0px, #fff -0.137119px -2.99686px 0px, #fff 0.850987px -2.87677px 0px, #fff 1.74541px -2.43999px 0px, #fff 2.44769px -1.73459px 0px, #fff 2.88051px -0.838246px 0px;\"><i class=\"fa fa-file-text-o st-css-no\" aria-hidden=\"true\"><\/i>Reference<\/p><div class=\"st-in-mybox\">\n<li><a href=\"https:\/\/pandas.pydata.org\/pandas-docs\/stable\/reference\/api\/pandas.DataFrame.dropna.html\">pandas.DataFrame.dropna \u2014 pandas 1.2.4 documentation<\/a><\/li>\n<\/div><\/div>\n<p><\/br><\/p>\n<div class=\"st-kaiwa-box kaiwaicon2 clearfix\"><div class=\"st-kaiwa-face\"><img decoding=\"async\" src=\"https:\/\/itips.krsw.biz\/wp-content\/uploads\/2022\/06\/karasan_smile_200px_b.gif\" width=\"60px\"><div class=\"st-kaiwa-face-name\"><\/div><\/div><div class=\"st-kaiwa-area\"><div class=\"st-kaiwa-hukidashi\">It is useful. So I'd like to remember it.<\/div><\/div><\/div>\n<p><\/br><\/br><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Pandas is very useful to handle table data. In table data, sometimes it contains None data. In that  &#8230; <\/p>\n","protected":false},"author":1,"featured_media":2919,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_locale":"en_US","_original_post":"https:\/\/itips.krsw.biz\/?p=4233","footnotes":""},"categories":[6],"tags":[35],"class_list":["post-4486","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-python","tag-pandas","en-US"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.3 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>How to remove none from pandas DataFrame - ITips\u30b7\u30b9\u30c6\u30e0\u30bd\u30ea\u30e5\u30fc\u30b7\u30e7\u30f3\u30ba<\/title>\n<meta name=\"description\" content=\"Pandas is very useful to handle table data.In table data, sometimes it contains None data.In that case we would like to remove None from specific column.So how can we remove None ?Today I introduce &quot;How to remove none from pandas DataFrame&quot;.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/itips.krsw.biz\/en\/pandas-dataframe-how-to-drop-none-data\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to remove none from pandas DataFrame - ITips\u30b7\u30b9\u30c6\u30e0\u30bd\u30ea\u30e5\u30fc\u30b7\u30e7\u30f3\u30ba\" \/>\n<meta property=\"og:description\" content=\"Pandas is very useful to handle table data.In table data, sometimes it contains None data.In that case we would like to remove None from specific column.So how can we remove None ?Today I introduce &quot;How to remove none from pandas DataFrame&quot;.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/itips.krsw.biz\/en\/pandas-dataframe-how-to-drop-none-data\/\" \/>\n<meta property=\"og:site_name\" content=\"ITips\u30b7\u30b9\u30c6\u30e0\u30bd\u30ea\u30e5\u30fc\u30b7\u30e7\u30f3\u30ba\" \/>\n<meta property=\"article:published_time\" content=\"2021-07-13T15:00:23+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-06-09T13:29:36+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/itips.krsw.biz\/wp-content\/uploads\/2020\/10\/h2-python.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1920\" \/>\n\t<meta property=\"og:image:height\" content=\"1080\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"ITips\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@https:\/\/twitter.com\/karasan_itips\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"ITips\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"10 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/itips.krsw.biz\\\/en\\\/pandas-dataframe-how-to-drop-none-data\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/itips.krsw.biz\\\/en\\\/pandas-dataframe-how-to-drop-none-data\\\/\"},\"author\":{\"name\":\"ITips\",\"@id\":\"https:\\\/\\\/itips.krsw.biz\\\/#\\\/schema\\\/person\\\/981ee81393a64c1b43f0b62d91998f0c\"},\"headline\":\"How to remove none from pandas DataFrame\",\"datePublished\":\"2021-07-13T15:00:23+00:00\",\"dateModified\":\"2025-06-09T13:29:36+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/itips.krsw.biz\\\/en\\\/pandas-dataframe-how-to-drop-none-data\\\/\"},\"wordCount\":372,\"image\":{\"@id\":\"https:\\\/\\\/itips.krsw.biz\\\/en\\\/pandas-dataframe-how-to-drop-none-data\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/itips.krsw.biz\\\/wp-content\\\/uploads\\\/2020\\\/10\\\/h2-python.jpg\",\"keywords\":[\"pandas\"],\"articleSection\":[\"Python\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/itips.krsw.biz\\\/en\\\/pandas-dataframe-how-to-drop-none-data\\\/\",\"url\":\"https:\\\/\\\/itips.krsw.biz\\\/en\\\/pandas-dataframe-how-to-drop-none-data\\\/\",\"name\":\"How to remove none from pandas DataFrame - ITips\u30b7\u30b9\u30c6\u30e0\u30bd\u30ea\u30e5\u30fc\u30b7\u30e7\u30f3\u30ba\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/itips.krsw.biz\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/itips.krsw.biz\\\/en\\\/pandas-dataframe-how-to-drop-none-data\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/itips.krsw.biz\\\/en\\\/pandas-dataframe-how-to-drop-none-data\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/itips.krsw.biz\\\/wp-content\\\/uploads\\\/2020\\\/10\\\/h2-python.jpg\",\"datePublished\":\"2021-07-13T15:00:23+00:00\",\"dateModified\":\"2025-06-09T13:29:36+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/itips.krsw.biz\\\/#\\\/schema\\\/person\\\/981ee81393a64c1b43f0b62d91998f0c\"},\"description\":\"Pandas is very useful to handle table data.In table data, sometimes it contains None data.In that case we would like to remove None from specific column.So how can we remove None ?Today I introduce \\\"How to remove none from pandas DataFrame\\\".\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/itips.krsw.biz\\\/en\\\/pandas-dataframe-how-to-drop-none-data\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/itips.krsw.biz\\\/en\\\/pandas-dataframe-how-to-drop-none-data\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/itips.krsw.biz\\\/en\\\/pandas-dataframe-how-to-drop-none-data\\\/#primaryimage\",\"url\":\"https:\\\/\\\/itips.krsw.biz\\\/wp-content\\\/uploads\\\/2020\\\/10\\\/h2-python.jpg\",\"contentUrl\":\"https:\\\/\\\/itips.krsw.biz\\\/wp-content\\\/uploads\\\/2020\\\/10\\\/h2-python.jpg\",\"width\":1920,\"height\":1080},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/itips.krsw.biz\\\/en\\\/pandas-dataframe-how-to-drop-none-data\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u30db\u30fc\u30e0\",\"item\":\"https:\\\/\\\/itips.krsw.biz\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to remove none from pandas DataFrame\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/itips.krsw.biz\\\/#website\",\"url\":\"https:\\\/\\\/itips.krsw.biz\\\/\",\"name\":\"ITips\u30b7\u30b9\u30c6\u30e0\u30bd\u30ea\u30e5\u30fc\u30b7\u30e7\u30f3\u30ba\",\"description\":\"\u4e8b\u696d\u306b\u3068\u3063\u3066\u91cd\u8981\u306a\u60c5\u5831\u30b7\u30b9\u30c6\u30e0\u306e\u8ab2\u984c\u3092\u89e3\u6c7a\u3057\u307e\u3059\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/itips.krsw.biz\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/itips.krsw.biz\\\/#\\\/schema\\\/person\\\/981ee81393a64c1b43f0b62d91998f0c\",\"name\":\"ITips\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/a89ef68c98cf6b05d7754a22b3e650bab179284eafbaa216db990ab3650cd763?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/a89ef68c98cf6b05d7754a22b3e650bab179284eafbaa216db990ab3650cd763?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/a89ef68c98cf6b05d7754a22b3e650bab179284eafbaa216db990ab3650cd763?s=96&d=mm&r=g\",\"caption\":\"ITips\"},\"description\":\"\u30b7\u30b9\u30c6\u30e0\u30a8\u30f3\u30b8\u30cb\u30a2\u3001AI\u30a8\u30f3\u30b8\u30cb\u30a2\u3068\u3001IT\u696d\u754c\u306710\u5e74\u4ee5\u4e0a\u50cd\u3044\u3066\u3044\u308b\u4e2d\u5805\u3002Python\u3068SQL\u304c\u5f97\u610f\u3002 System engineer AI engineer, Data scientist. Mid-carrier IT person. Good at Python and SQL.\",\"sameAs\":[\"https:\\\/\\\/www.pinterest.jp\\\/it_karasan\\\/\",\"https:\\\/\\\/x.com\\\/https:\\\/\\\/twitter.com\\\/karasan_itips\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to remove none from pandas DataFrame - ITips\u30b7\u30b9\u30c6\u30e0\u30bd\u30ea\u30e5\u30fc\u30b7\u30e7\u30f3\u30ba","description":"Pandas is very useful to handle table data.In table data, sometimes it contains None data.In that case we would like to remove None from specific column.So how can we remove None ?Today I introduce \"How to remove none from pandas DataFrame\".","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:\/\/itips.krsw.biz\/en\/pandas-dataframe-how-to-drop-none-data\/","og_locale":"en_US","og_type":"article","og_title":"How to remove none from pandas DataFrame - ITips\u30b7\u30b9\u30c6\u30e0\u30bd\u30ea\u30e5\u30fc\u30b7\u30e7\u30f3\u30ba","og_description":"Pandas is very useful to handle table data.In table data, sometimes it contains None data.In that case we would like to remove None from specific column.So how can we remove None ?Today I introduce \"How to remove none from pandas DataFrame\".","og_url":"https:\/\/itips.krsw.biz\/en\/pandas-dataframe-how-to-drop-none-data\/","og_site_name":"ITips\u30b7\u30b9\u30c6\u30e0\u30bd\u30ea\u30e5\u30fc\u30b7\u30e7\u30f3\u30ba","article_published_time":"2021-07-13T15:00:23+00:00","article_modified_time":"2025-06-09T13:29:36+00:00","og_image":[{"width":1920,"height":1080,"url":"https:\/\/itips.krsw.biz\/wp-content\/uploads\/2020\/10\/h2-python.jpg","type":"image\/jpeg"}],"author":"ITips","twitter_card":"summary_large_image","twitter_creator":"@https:\/\/twitter.com\/karasan_itips","twitter_misc":{"Written by":"ITips","Est. reading time":"10 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/itips.krsw.biz\/en\/pandas-dataframe-how-to-drop-none-data\/#article","isPartOf":{"@id":"https:\/\/itips.krsw.biz\/en\/pandas-dataframe-how-to-drop-none-data\/"},"author":{"name":"ITips","@id":"https:\/\/itips.krsw.biz\/#\/schema\/person\/981ee81393a64c1b43f0b62d91998f0c"},"headline":"How to remove none from pandas DataFrame","datePublished":"2021-07-13T15:00:23+00:00","dateModified":"2025-06-09T13:29:36+00:00","mainEntityOfPage":{"@id":"https:\/\/itips.krsw.biz\/en\/pandas-dataframe-how-to-drop-none-data\/"},"wordCount":372,"image":{"@id":"https:\/\/itips.krsw.biz\/en\/pandas-dataframe-how-to-drop-none-data\/#primaryimage"},"thumbnailUrl":"https:\/\/itips.krsw.biz\/wp-content\/uploads\/2020\/10\/h2-python.jpg","keywords":["pandas"],"articleSection":["Python"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/itips.krsw.biz\/en\/pandas-dataframe-how-to-drop-none-data\/","url":"https:\/\/itips.krsw.biz\/en\/pandas-dataframe-how-to-drop-none-data\/","name":"How to remove none from pandas DataFrame - ITips\u30b7\u30b9\u30c6\u30e0\u30bd\u30ea\u30e5\u30fc\u30b7\u30e7\u30f3\u30ba","isPartOf":{"@id":"https:\/\/itips.krsw.biz\/#website"},"primaryImageOfPage":{"@id":"https:\/\/itips.krsw.biz\/en\/pandas-dataframe-how-to-drop-none-data\/#primaryimage"},"image":{"@id":"https:\/\/itips.krsw.biz\/en\/pandas-dataframe-how-to-drop-none-data\/#primaryimage"},"thumbnailUrl":"https:\/\/itips.krsw.biz\/wp-content\/uploads\/2020\/10\/h2-python.jpg","datePublished":"2021-07-13T15:00:23+00:00","dateModified":"2025-06-09T13:29:36+00:00","author":{"@id":"https:\/\/itips.krsw.biz\/#\/schema\/person\/981ee81393a64c1b43f0b62d91998f0c"},"description":"Pandas is very useful to handle table data.In table data, sometimes it contains None data.In that case we would like to remove None from specific column.So how can we remove None ?Today I introduce \"How to remove none from pandas DataFrame\".","breadcrumb":{"@id":"https:\/\/itips.krsw.biz\/en\/pandas-dataframe-how-to-drop-none-data\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/itips.krsw.biz\/en\/pandas-dataframe-how-to-drop-none-data\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/itips.krsw.biz\/en\/pandas-dataframe-how-to-drop-none-data\/#primaryimage","url":"https:\/\/itips.krsw.biz\/wp-content\/uploads\/2020\/10\/h2-python.jpg","contentUrl":"https:\/\/itips.krsw.biz\/wp-content\/uploads\/2020\/10\/h2-python.jpg","width":1920,"height":1080},{"@type":"BreadcrumbList","@id":"https:\/\/itips.krsw.biz\/en\/pandas-dataframe-how-to-drop-none-data\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u30db\u30fc\u30e0","item":"https:\/\/itips.krsw.biz\/"},{"@type":"ListItem","position":2,"name":"How to remove none from pandas DataFrame"}]},{"@type":"WebSite","@id":"https:\/\/itips.krsw.biz\/#website","url":"https:\/\/itips.krsw.biz\/","name":"ITips\u30b7\u30b9\u30c6\u30e0\u30bd\u30ea\u30e5\u30fc\u30b7\u30e7\u30f3\u30ba","description":"\u4e8b\u696d\u306b\u3068\u3063\u3066\u91cd\u8981\u306a\u60c5\u5831\u30b7\u30b9\u30c6\u30e0\u306e\u8ab2\u984c\u3092\u89e3\u6c7a\u3057\u307e\u3059","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/itips.krsw.biz\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/itips.krsw.biz\/#\/schema\/person\/981ee81393a64c1b43f0b62d91998f0c","name":"ITips","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/a89ef68c98cf6b05d7754a22b3e650bab179284eafbaa216db990ab3650cd763?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/a89ef68c98cf6b05d7754a22b3e650bab179284eafbaa216db990ab3650cd763?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/a89ef68c98cf6b05d7754a22b3e650bab179284eafbaa216db990ab3650cd763?s=96&d=mm&r=g","caption":"ITips"},"description":"\u30b7\u30b9\u30c6\u30e0\u30a8\u30f3\u30b8\u30cb\u30a2\u3001AI\u30a8\u30f3\u30b8\u30cb\u30a2\u3068\u3001IT\u696d\u754c\u306710\u5e74\u4ee5\u4e0a\u50cd\u3044\u3066\u3044\u308b\u4e2d\u5805\u3002Python\u3068SQL\u304c\u5f97\u610f\u3002 System engineer AI engineer, Data scientist. Mid-carrier IT person. Good at Python and SQL.","sameAs":["https:\/\/www.pinterest.jp\/it_karasan\/","https:\/\/x.com\/https:\/\/twitter.com\/karasan_itips"]}]}},"_links":{"self":[{"href":"https:\/\/itips.krsw.biz\/wp-json\/wp\/v2\/posts\/4486","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/itips.krsw.biz\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/itips.krsw.biz\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/itips.krsw.biz\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/itips.krsw.biz\/wp-json\/wp\/v2\/comments?post=4486"}],"version-history":[{"count":10,"href":"https:\/\/itips.krsw.biz\/wp-json\/wp\/v2\/posts\/4486\/revisions"}],"predecessor-version":[{"id":7032,"href":"https:\/\/itips.krsw.biz\/wp-json\/wp\/v2\/posts\/4486\/revisions\/7032"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/itips.krsw.biz\/wp-json\/wp\/v2\/media\/2919"}],"wp:attachment":[{"href":"https:\/\/itips.krsw.biz\/wp-json\/wp\/v2\/media?parent=4486"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/itips.krsw.biz\/wp-json\/wp\/v2\/categories?post=4486"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/itips.krsw.biz\/wp-json\/wp\/v2\/tags?post=4486"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}