🕷️ Crawler Inspector

URL Lookup

Direct Parameter Lookup

Raw Queries and Responses

1. Shard Calculation

Query:

Response:

Calculated Shard: 83 (from laksa109)

2. Crawled Status Check

Query:

curl -X POST \
  'http://laksa083.int.ahrefs:8124/' \
  -H 'Content-Type: text/plain' \
  -H 'X-ClickHouse-Database: crawler3' \
  -H 'Authorization: Basic YXBpOg==' \
  -d 'SELECT getAhrefsURLFromUnparsed(src_unparsed) AS found_url, ifNull(toUnixTimestamp(download_stamp), 0) AS crawl_time, ifNull(toUnixTimestamp(props_url_first_seen), 0) AS first_indexed_time, download_http_code AS http_code, src_unparsed AS src_unparsed, src_root_hash AS src_root_hash, history_drop_reason AS history_drop_reason, meta_title AS meta_title, meta_descriptions AS meta_descriptions, attrs_boilerpipe_text AS attrs_boilerpipe_text, attrs_markdown AS attrs_markdown, attrs_readable_markdown AS attrs_readable_markdown, meta_canonical AS meta_canonical FROM crawler3.page_info_local FINAL PREWHERE (src_root_hash, src_unparsed) IN ((getAhrefsRootHashFromUnparsed(getAhrefsUnparsedNoserviceFromURL(\'https://www.digitalocean.com/community/tutorials/pandas-dropna-drop-null-na-values-from-dataframe\')), getAhrefsUnparsedNoserviceFromURL(\'https://www.digitalocean.com/community/tutorials/pandas-dropna-drop-null-na-values-from-dataframe\'))) FORMAT JSONEachRow'

Response:

{"found_url":"https:\/\/www.digitalocean.com\/community\/tutorials\/pandas-dropna-drop-null-na-values-from-dataframe","crawl_time":1776169853,"first_indexed_time":1659587905,"http_code":200,"src_unparsed":"com,digitalocean!www,\/community\/tutorials\/pandas-dropna-drop-null-na-values-from-dataframe s443","src_root_hash":"13428457316079428483","history_drop_reason":null,"meta_title":"How To Use Python pandas dropna() to Drop NA Values from DataFrame | DigitalOcean","meta_descriptions":["Technical tutorials, Q&A, events — This is an inclusive place where developers can find or lend support and discover new ways to contribute to the community."],"attrs_boilerpipe_text":"Introduction\nIn this tutorial, you’ll learn how to use panda’s DataFrame\ndropna()\nfunction.\nNA\nvalues are “Not Available”. This can apply to\nNull\n,\nNone\n,\npandas.NaT\n, or\nnumpy.nan\n. Using\ndropna()\nwill drop the rows and columns with these values. This can be beneficial to provide you with only valid data.\nBy default, this function returns a new DataFrame and the source DataFrame remains unchanged.\nThis tutorial was verified with Python 3.10.9, pandas 1.5.2, and NumPy 1.24.1.\nSyntax\ndropna()\ntakes the following parameters:\ndropna\n(\nself\n,\naxis\n=\n0\n,\nhow\n=\n\"any\"\n,\nthresh\n=\nNone\n,\nsubset\n=\nNone\n,\ninplace\n=\nFalse\n)\naxis\n:\n{0 (or 'index'), 1 (or 'columns')}, default 0\nIf\n0\n, drop rows with missing values.\nIf\n1\n, drop columns with missing values.\nhow\n:\n{'any', 'all'}, default 'any'\nIf\n'any'\n, drop the row or column if any of the values is\nNA\n.\nIf\n'all'\n, drop the row or column if all of the values are\nNA\n.\nthresh\n: (optional) an\nint\nvalue to specify the threshold for the drop operation.\nsubset\n: (optional) column label or sequence of labels to specify rows or columns.\ninplace\n: (optional) a\nbool\nvalue.\nIf\nTrue\n, the source DataFrame is changed and\nNone\nis returned.\nConstructing Sample DataFrames\nConstruct a sample DataFrame that contains valid and invalid values:\ndropnaExample.py\nimport\npandas\nas\npd\nimport\nnumpy\nas\nnp\n\nd1\n=\n{\n'Name'\n:\n[\n'Shark'\n,\n'Whale'\n,\n'Jellyfish'\n,\n'Starfish'\n]\n,\n'ID'\n:\n[\n1\n,\n2\n,\n3\n,\n4\n]\n,\n'Population'\n:\n[\n100\n,\n200\n,\nnp\n.\nnan\n,\npd\n.\nNaT\n]\n,\n'Regions'\n:\n[\n1\n,\nNone\n,\npd\n.\nNaT\n,\npd\n.\nNaT\n]\n}\ndf1\n=\npd\n.\nDataFrame\n(\nd1\n)\nprint\n(\ndf1\n)\nThis code will print out the DataFrame:\nOutput\nName ID Population Regions\n0 Shark 1 100 1\n1 Whale 2 200 None\n2 Jellyfish 3 NaN NaT\n3 Starfish 4 NaT NaT\nThen add a second DataFrame with additional rows and columns with\nNA\nvalues:\nd2\n=\n{\n'Name'\n:\n[\n'Shark'\n,\n'Whale'\n,\n'Jellyfish'\n,\n'Starfish'\n,\npd\n.\nNaT\n]\n,\n'ID'\n:\n[\n1\n,\n2\n,\n3\n,\n4\n,\npd\n.\nNaT\n]\n,\n'Population'\n:\n[\n100\n,\n200\n,\nnp\n.\nnan\n,\npd\n.\nNaT\n,\npd\n.\nNaT\n]\n,\n'Regions'\n:\n[\n1\n,\nNone\n,\npd\n.\nNaT\n,\npd\n.\nNaT\n,\npd\n.\nNaT\n]\n,\n'Endangered'\n:\n[\npd\n.\nNaT\n,\npd\n.\nNaT\n,\npd\n.\nNaT\n,\npd\n.\nNaT\n,\npd\n.\nNaT\n]\n}\ndf2\n=\npd\n.\nDataFrame\n(\nd2\n)\nprint\n(\ndf2\n)\nThis will output a new DataFrame:\nOutput\nName ID Population Regions Endangered\n0 Shark 1 100 1 NaT\n1 Whale 2 200 None NaT\n2 Jellyfish 3 NaN NaT NaT\n3 Starfish 4 NaT NaT NaT\n4 NaT NaT NaT NaT NaT\nYou will use the preceding DataFrames in the examples that follow.\nDropping All Rows with Missing Values\nUse\ndropna()\nto remove rows with any\nNone\n,\nNaN\n, or\nNaT\nvalues:\ndropnaExample.py\ndfresult\n=\ndf1\n.\ndropna\n(\n)\nprint\n(\ndfresult\n)\nThis will output:\nOutput\nName ID Population Regions\n0 Shark 1 100 1\nA new DataFrame with a single row that didn’t contain any\nNA\nvalues.\nDropping All Columns with Missing Values\nUse\ndropna()\nwith\naxis=1\nto remove columns with any\nNone\n,\nNaN\n, or\nNaT\nvalues:\ndfresult\n=\ndf1\n.\ndropna\n(\naxis\n=\n1\n)\nprint\n(\ndfresult\n)\nThe columns with any\nNone\n,\nNaN\n, or\nNaT\nvalues will be dropped:\nOutput\nName ID\n0 Shark 1\n1 Whale 2\n2 Jellyfish 3\n3 Starfish 4\nA new DataFrame with a single column that contained non-\nNA\nvalues.\nDropping Rows or Columns if\nall\nthe Values are\nNull\nwith\nhow\nUse the second DataFrame and\nhow\n:\ndropnaExample.py\ndfresult\n=\ndf2\n.\ndropna\n(\nhow\n=\n'all'\n)\nprint\n(\ndfresult\n)\nThe rows with\nall\nvalues equal to\nNA\nwill be dropped:\nOutput\nName ID Population Regions Endangered\n0 Shark 1 100 1 NaT\n1 Whale 2 200 None NaT\n2 Jellyfish 3 NaN NaT NaT\n3 Starfish 4 NaT NaT NaT\nThe fifth row was dropped.\nNext, use\nhow\nand specify the\naxis\n:\ndropnaExample.py\ndfresult\n=\ndf2\n.\ndropna\n(\nhow\n=\n'all'\n,\naxis\n=\n1\n)\nprint\n(\ndfresult\n)\nThe columns with\nall\nvalues equal to\nNA\nwill be dropped:\nOutput\nName ID Population Regions\n0 Shark 1 100 1\n1 Whale 2 200 None\n2 Jellyfish 3 NaN NaT\n3 Starfish 4 NaT NaT\n4 NaT NaT NaT NaT\nThe fifth column was dropped.\nDropping Rows or Columns if a Threshold is Crossed with\nthresh\nUse the second DataFrame with\nthresh\nto drop rows that do not meet the threshold of at least\n3\nnon-\nNA\nvalues:\ndropnaExample.py\ndfresult\n=\ndf2\n.\ndropna\n(\nthresh\n=\n3\n)\nprint\n(\ndfresult\n)\nThe rows do not have at least\n3\nnon-\nNA\nwill be dropped:\nOutput\nName ID Population Regions Endangered\n0 Shark 1 100 1 NaT\n1 Whale 2 200 None NaT\nThe third, fourth, and fifth rows were dropped.\nDropping Rows or Columns for Specific\nsubsets\nUse the second DataFrame with\nsubset\nto drop rows with\nNA\nvalues in the\nPopulation\ncolumn:\ndropnaExample.py\ndfresult\n=\ndf2\n.\ndropna\n(\nsubset\n=\n[\n'Population'\n]\n)\nprint\n(\ndfresult\n)\nThe rows that have\nPopulation\nwith\nNA\nvalues will be dropped:\nOutput\nName ID Population Regions Endangered\n0 Shark 1 100 1 NaT\n1 Whale 2 200 None NaT\nThe third, fourth, and fifth rows were dropped.\nYou can also specify the\nindex\nvalues in the\nsubset\nwhen dropping columns from the DataFrame:\ndropnaExample.py\ndfresult\n=\ndf2\n.\ndropna\n(\nsubset\n=\n[\n1\n,\n2\n]\n,\naxis\n=\n1\n)\nprint\n(\ndfresult\n)\nThe columns that contain\nNA\nvalues in subset of rows\n1\nand\n2\n:\nOutput\nName ID\n0 Shark 1\n1 Whale 2\n2 Jellyfish 3\n3 Starfish 4\n4 NaT NaT\nThe third, fourth, and fifth columns were dropped.\nChanging the source DataFrame after Dropping Rows or Columns with\ninplace\nBy default,\ndropna()\ndoes not modify the source DataFrame. However, in some cases, you may wish to save memory when working with a large source DataFrame by using\ninplace\n.\ndropnaExample.py\ndf1\n.\ndropna\n(\ninplace\n=\nTrue\n)\nprint\n(\ndf1\n)\nThis code does not use a\ndfresult\nvariable.\nThis will output:\nOutput\nName ID Population Regions\n0 Shark 1 100 1\nThe original DataFrame has been modified.\nConclusion\nIn this article, you used the\ndropna()\nfunction to remove rows and columns with\nNA\nvalues.\nContinue your learning with more Python and pandas tutorials -\nPython pandas Module Tutorial\n,\npandas Drop Duplicate Rows\n.\nReferences\npandas DataFrame\ndropna()\nAPI Doc\nWas this helpful?\nThis work is licensed under a Creative Commons Attribution-NonCommercial- ShareAlike 4.0 International License.","attrs_markdown":"[DigitalOcean acquires Katanemo Labs, Inc. to accelerate AI development](https:\/\/www.digitalocean.com\/blog\/digitalocean-acquires-katanemo-labs-inc)\n\n[Now Available: Cloud Security Posture Management (CSPM)](https:\/\/www.digitalocean.com\/blog\/now-available-cloud-security-posture-management)\n\n[Now Available: OpenAI GPT-5.4 on the Gradient™ AI Platform](https:\/\/www.digitalocean.com\/blog\/whats-new-on-gradient-ai-platform#week-of-march-2)\n\n[Now Available: OpenAI GPT-5.3 Codex on the Gradient™ AI Platform](https:\/\/www.digitalocean.com\/blog\/whats-new-on-gradient-ai-platform#week-of-february-23rd)\n\n[Now Available: Claude Sonnet 4.6 on the Gradient™ AI Platform](https:\/\/www.digitalocean.com\/blog\/whats-new-on-gradient-ai-platform#week-of-february-17th)\n\n[Join us for Deploy in San Francisco, on April 28, 2026. Register now](https:\/\/www.digitalocean.com\/deploy)\n\n- [Blog](https:\/\/www.digitalocean.com\/blog)\n- [Docs](https:\/\/docs.digitalocean.com\/products)\n- [Careers](https:\/\/www.digitalocean.com\/careers)\n- [Get Support](https:\/\/www.digitalocean.com\/support)\n- [Contact Sales](https:\/\/www.digitalocean.com\/company\/contact\/sales?referrer=tophat)\n\n[DigitalOcean](https:\/\/www.digitalocean.com\/)\n\n- Products\n  Featured Products\n  \n  Gradient™ AI Agentic Inference Cloud\n  \n  Build, train, deploy apps\/agents and scale at will\n  \n  Compute\n  \n  Build, deploy, and scale cloud compute resources\n  \n  Containers and Images\n  \n  Safely store and manage containers and backups\n  \n  Managed Databases\n  \n  Fully managed resources running popular database engines\n  \n  Management and Dev Tools\n  \n  Control infrastructure and gather insights\n  \n  Networking\n  \n  Secure and control traffic to apps\n  \n  Security\n  \n  Store and access any amount of data reliably in the cloud\n  \n  Storage\n  \n  Store and access any amount of data reliably in the cloud\n  \n  [Browse all products](https:\/\/www.digitalocean.com\/products)\n  \n  ### Featured Products\n  [Gradient™ AI Agentic Cloud Build, train, deploy apps\/agents and scale at will](https:\/\/www.digitalocean.com\/products\/gradient)\n  \n  [Droplets Reliable, powerful, Linux-based virtual machines New updates](https:\/\/www.digitalocean.com\/products\/droplets)\n  \n  [Managed Databases Fully managed resources running popular database engines](https:\/\/www.digitalocean.com\/products\/managed-databases)\n  \n  [App Platform Publish code directly to DigitalOcean servers](https:\/\/www.digitalocean.com\/products\/app-platform)\n  \n  [Gradient™ AI GPU Droplets GPU-powered virtual machines to build and run AI apps](https:\/\/www.digitalocean.com\/products\/gradient\/gpu-droplets)\n  \n  [Kubernetes Fully managed, highly available K8s with autoscale.](https:\/\/www.digitalocean.com\/products\/kubernetes)\n  \n  [Browse all products](https:\/\/www.digitalocean.com\/products)\n- Solutions\n  AI\/ML\n  \n  CMS\n  \n  Data and IoT\n  \n  Developer Tools\n  \n  Gaming and Media\n  \n  GPU\n  \n  Hosting\n  \n  Security and Networking\n  \n  Startups and SMBs\n  \n  Web and App Platforms\n  \n  [See all solutions](https:\/\/www.digitalocean.com\/solutions)\n  \n  ### AI\/ML\n  [AI HR Knowledge Assistant Deploy AI tools developed for Human Resources](https:\/\/www.digitalocean.com\/solutions\/ai-hr-knowledge-assistant)\n  \n  [AI Code Copilot Write, complete, and review code faster](https:\/\/www.digitalocean.com\/solutions\/ai-code-copilot)\n  \n  [AI Support Ticket Triage Auto-classify and route customer support tickets](https:\/\/www.digitalocean.com\/solutions\/ai-support-ticket-triage)\n  \n  [AI Recommendation Engine Build tools to personalize user experiences](https:\/\/www.digitalocean.com\/solutions\/ai-recommendation-engine)\n  \n  [AI Agent Builder Create, deploy, and manage AI agents for anything](https:\/\/www.digitalocean.com\/solutions\/ai-agent-builder)\n  \n  [Multimodal AI Run models that process multiple data types](https:\/\/www.digitalocean.com\/solutions\/multimodal-ai)\n  \n  [Low-Latency Inference Run AI models quickly and efficiently](https:\/\/www.digitalocean.com\/solutions\/low-latency-inference)\n  \n  Not seeing what you are looking for?\n  \n  [Browse all AI\/ML solutions](https:\/\/www.digitalocean.com\/solutions)\n  \n  [Need help? Talk to an expert](https:\/\/www.digitalocean.com\/company\/contact\/sales?referrer=mainmenu\/solutions)\n  \n  [Get migration assistance](https:\/\/www.digitalocean.com\/migrate)\n- Developers\n  Community\n  \n  Documentation\n  \n  Developer Tools\n  \n  Get Involved\n  \n  Utilities and Help\n  \n  ### Community\n  [Blog The latest product releases and insights from our experts](https:\/\/www.digitalocean.com\/blog)\n  \n  [CSS Tricks All things web design](https:\/\/css-tricks.com\/)\n  \n  [The Wave Content to level up your business](https:\/\/www.digitalocean.com\/resources)\n  \n  [Tutorials Our extensive library of technical articles](https:\/\/www.digitalocean.com\/community\/tutorials)\n  \n  [Q\\&A Answers to your cloud and coding questions](https:\/\/www.digitalocean.com\/community\/questions)\n  \n  [YouTube Educational content and tutorials](https:\/\/youtube.com\/DigitalOcean)\n  \n  [Visit DigitalOcean's Community Site](https:\/\/www.digitalocean.com\/community)\n- Partners\n  Become a Partner\n  \n  Marketplace\n  \n  ### Become a Partner\n  [About Partner Pod Discounts, revenue share, and more for businesses](https:\/\/www.digitalocean.com\/partners\/pod)\n  \n  [AI Partner Program Boost your AI business](https:\/\/www.digitalocean.com\/partners\/ai-partner-program)\n  \n  [DigitalOcean Startups Resources and support to propel your startup](https:\/\/www.digitalocean.com\/startups)\n  \n  [Partners Directory Current list of DigitalOcean Partners](https:\/\/www.digitalocean.com\/partners\/directory)\n  \n  [Customer Stories Customers growing on DigitalOcean](https:\/\/www.digitalocean.com\/customers)\n  \n  [Need help? Talk to an expert](https:\/\/www.digitalocean.com\/company\/contact\/sales?referrer=mainmenu\/partners)\n  \n  [Become a Partner](https:\/\/www.digitalocean.com\/partners\/apply)\n- [Pricing](https:\/\/www.digitalocean.com\/pricing)\n\n- Log in\n  - [Community](https:\/\/www.digitalocean.com\/api\/dynamic-content\/v1\/login?success_redirect=https%3A%2F%2Fwww.digitalocean.com%2Fcommunity%2Ftutorials%2Fpandas-dropna-drop-null-na-values-from-dataframe&error_redirect=https%3A%2F%2Fwww.digitalocean.com%2Fauth-error&type=login)\n  - [DigitalOcean](https:\/\/cloud.digitalocean.com\/login)\n- Sign up\n  - [Community](https:\/\/www.digitalocean.com\/api\/dynamic-content\/v1\/login?success_redirect=https%3A%2F%2Fwww.digitalocean.com%2Fcommunity%2Ftutorials%2Fpandas-dropna-drop-null-na-values-from-dataframe&error_redirect=https%3A%2F%2Fwww.digitalocean.com%2Fauth-error&type=register)\n  - [DigitalOcean](https:\/\/cloud.digitalocean.com\/registrations\/new)\n\n- Log in\n  - [Community](https:\/\/www.digitalocean.com\/api\/dynamic-content\/v1\/login?success_redirect=https%3A%2F%2Fwww.digitalocean.com%2Fcommunity%2Ftutorials%2Fpandas-dropna-drop-null-na-values-from-dataframe&error_redirect=https%3A%2F%2Fwww.digitalocean.com%2Fauth-error&type=login)\n  - [DigitalOcean](https:\/\/cloud.digitalocean.com\/login)\n- Sign up\n  - [Community](https:\/\/www.digitalocean.com\/api\/dynamic-content\/v1\/login?success_redirect=https%3A%2F%2Fwww.digitalocean.com%2Fcommunity%2Ftutorials%2Fpandas-dropna-drop-null-na-values-from-dataframe&error_redirect=https%3A%2F%2Fwww.digitalocean.com%2Fauth-error&type=register)\n  - [DigitalOcean](https:\/\/cloud.digitalocean.com\/registrations\/new)\n\n- [Tutorials](https:\/\/www.digitalocean.com\/community\/tutorials)\n- [Questions](https:\/\/www.digitalocean.com\/community\/questions)\n- [Product Docs](https:\/\/docs.digitalocean.com\/)\n- Search Community\n\n## Report this\nWhat is the reason for this report?\n\nThis undefined is spam\n\nThis undefined is offensive\n\nThis undefined is off-topic\n\nThis undefined is other\n\nSubmit\n\n## Table of contents\n1. [Syntax](https:\/\/www.digitalocean.com\/community\/tutorials\/pandas-dropna-drop-null-na-values-from-dataframe#syntax)\n2. [Constructing Sample DataFrames](https:\/\/www.digitalocean.com\/community\/tutorials\/pandas-dropna-drop-null-na-values-from-dataframe#constructing-sample-dataframes)\n3. [Dropping All Rows with Missing Values](https:\/\/www.digitalocean.com\/community\/tutorials\/pandas-dropna-drop-null-na-values-from-dataframe#dropping-all-rows-with-missing-values)\n4. [Dropping All Columns with Missing Values](https:\/\/www.digitalocean.com\/community\/tutorials\/pandas-dropna-drop-null-na-values-from-dataframe#dropping-all-columns-with-missing-values)\n5. [Dropping Rows or Columns if all the Values are Null with how](https:\/\/www.digitalocean.com\/community\/tutorials\/pandas-dropna-drop-null-na-values-from-dataframe#dropping-rows-or-columns-if-all-the-values-are-null-with-how)\n6. [Dropping Rows or Columns if a Threshold is Crossed with thresh](https:\/\/www.digitalocean.com\/community\/tutorials\/pandas-dropna-drop-null-na-values-from-dataframe#dropping-rows-or-columns-if-a-threshold-is-crossed-with-thresh)\n7. [Dropping Rows or Columns for Specific subsets](https:\/\/www.digitalocean.com\/community\/tutorials\/pandas-dropna-drop-null-na-values-from-dataframe#dropping-rows-or-columns-for-specific-subsets)\n8. [Changing the source DataFrame after Dropping Rows or Columns with inplace](https:\/\/www.digitalocean.com\/community\/tutorials\/pandas-dropna-drop-null-na-values-from-dataframe#changing-the-source-dataframe-after-dropping-rows-or-columns-with-inplace)\n9. [Conclusion](https:\/\/www.digitalocean.com\/community\/tutorials\/pandas-dropna-drop-null-na-values-from-dataframe#conclusion)\n\n1. [Tutorials](https:\/\/www.digitalocean.com\/community\/tutorials?subtype=tutorial)\n2. [Pandas](https:\/\/www.digitalocean.com\/community\/tags\/pandas)\n3. How To Use Python pandas dropna() to Drop NA Values from DataFrame\n\n[Tutorial](https:\/\/www.digitalocean.com\/community\/tutorials?subtype=tutorial)\n\n# How To Use Python pandas dropna() to Drop NA Values from DataFrame\nPublished on August 3, 2022\n\n[Pandas](https:\/\/www.digitalocean.com\/community\/tags\/pandas)\n\n[Python](https:\/\/www.digitalocean.com\/community\/tags\/python)\n\n![Pankaj Kumar](https:\/\/www.gravatar.com\/avatar\/dcb62410bd20fd354c21af393bec6e67b235a09758848745cfd4405e05bba1f4?default=retro&size=256)![Bradley Kouchi](https:\/\/www.gravatar.com\/avatar\/1c15a76c8f5e79c35d1ce6c479888827d77e10dac512f9476549d036ca44fc17?default=retro&size=256)\n\nBy [Pankaj Kumar](https:\/\/www.digitalocean.com\/community\/users\/pankajkumarjournaldev) and [Bradley Kouchi](https:\/\/www.digitalocean.com\/community\/users\/bkouchido)\n\n![How To Use Python pandas dropna() to Drop NA Values from DataFrame](https:\/\/www.digitalocean.com\/api\/static-content\/v1\/images?src=https%3A%2F%2Fjournaldev.nyc3.cdn.digitaloceanspaces.com%2F2019%2F11%2Fpandas-dropna.png&width=1920)\n\nTable of contents\n\nPopular topics\n\n### [Introduction](https:\/\/www.digitalocean.com\/community\/tutorials\/pandas-dropna-drop-null-na-values-from-dataframe#introduction)\nIn this tutorial, you’ll learn how to use panda’s DataFrame `dropna()` function.\n\n`NA` values are “Not Available”. This can apply to `Null`, `None`, `pandas.NaT`, or `numpy.nan`. Using `dropna()` will drop the rows and columns with these values. This can be beneficial to provide you with only valid data.\n\nBy default, this function returns a new DataFrame and the source DataFrame remains unchanged.\n\nThis tutorial was verified with Python 3.10.9, pandas 1.5.2, and NumPy 1.24.1.\n\n## [Syntax](https:\/\/www.digitalocean.com\/community\/tutorials\/pandas-dropna-drop-null-na-values-from-dataframe#syntax)\n`dropna()` takes the following parameters:\n\n```\ndropna(self, axis=0, how=\"any\", thresh=None, subset=None, inplace=False)\n```\nCopy\n\n- `axis`: `{0 (or 'index'), 1 (or 'columns')}, default 0`\n- If `0`, drop rows with missing values.\n- If `1`, drop columns with missing values.\n- `how`: `{'any', 'all'}, default 'any'`\n- If `'any'`, drop the row or column if any of the values is `NA`.\n- If `'all'`, drop the row or column if all of the values are `NA`.\n- `thresh`: (optional) an `int` value to specify the threshold for the drop operation.\n- `subset`: (optional) column label or sequence of labels to specify rows or columns.\n- `inplace`: (optional) a `bool` value.\n- If `True`, the source DataFrame is changed and `None` is returned.\n\n## [Constructing Sample DataFrames](https:\/\/www.digitalocean.com\/community\/tutorials\/pandas-dropna-drop-null-na-values-from-dataframe#constructing-sample-dataframes)\nConstruct a sample DataFrame that contains valid and invalid values:\n\ndropnaExample.py\n\n```\nimport pandas as pd\nimport numpy as np\n\nd1 = {\n'Name': ['Shark', 'Whale', 'Jellyfish', 'Starfish'],\n'ID': [1, 2, 3, 4],\n'Population': [100, 200, np.nan, pd.NaT],\n'Regions': [1, None, pd.NaT, pd.NaT]\n}\n\ndf1 = pd.DataFrame(d1)\nprint(df1)\n```\nCopy\n\nThis code will print out the DataFrame:\n```\nOutputName ID Population Regions\n0 Shark 1 100 1\n1 Whale 2 200 None\n2 Jellyfish 3 NaN NaT\n3 Starfish 4 NaT NaT\n```\nThen add a second DataFrame with additional rows and columns with `NA` values:\n\n```\nd2 = {\n'Name': ['Shark', 'Whale', 'Jellyfish', 'Starfish', pd.NaT],\n'ID': [1, 2, 3, 4, pd.NaT],\n'Population': [100, 200, np.nan, pd.NaT, pd.NaT],\n'Regions': [1, None, pd.NaT, pd.NaT, pd.NaT],\n'Endangered': [pd.NaT, pd.NaT, pd.NaT, pd.NaT, pd.NaT]\n}\n\ndf2 = pd.DataFrame(d2)\nprint(df2)\n```\nCopy\n\nThis will output a new DataFrame:\n```\nOutputName ID Population Regions Endangered\n0 Shark 1 100 1 NaT\n1 Whale 2 200 None NaT\n2 Jellyfish 3 NaN NaT NaT\n3 Starfish 4 NaT NaT NaT\n4 NaT NaT NaT NaT NaT\n```\nYou will use the preceding DataFrames in the examples that follow.\n\n## [Dropping All Rows with Missing Values](https:\/\/www.digitalocean.com\/community\/tutorials\/pandas-dropna-drop-null-na-values-from-dataframe#dropping-all-rows-with-missing-values)\nUse `dropna()` to remove rows with any `None`, `NaN`, or `NaT` values:\n\ndropnaExample.py\n\n```\ndfresult = df1.dropna()\nprint(dfresult)\n```\nCopy\n\nThis will output:\n```\nOutputName ID Population Regions\n0 Shark 1 100 1\n```\nA new DataFrame with a single row that didn’t contain any `NA` values.\n\n## [Dropping All Columns with Missing Values](https:\/\/www.digitalocean.com\/community\/tutorials\/pandas-dropna-drop-null-na-values-from-dataframe#dropping-all-columns-with-missing-values)\nUse `dropna()` with `axis=1` to remove columns with any `None`, `NaN`, or `NaT` values:\n\n```\ndfresult = df1.dropna(axis=1)\nprint(dfresult)\n```\nCopy\n\nThe columns with any `None`, `NaN`, or `NaT` values will be dropped:\n```\nOutputName ID\n0 Shark 1\n1 Whale 2\n2 Jellyfish 3\n3 Starfish 4\n```\nA new DataFrame with a single column that contained non-`NA` values.\n\n## [Dropping Rows or Columns if `all` the Values are `Null` with `how`](https:\/\/www.digitalocean.com\/community\/tutorials\/pandas-dropna-drop-null-na-values-from-dataframe#dropping-rows-or-columns-if-all-the-values-are-null-with-how)\nUse the second DataFrame and `how`:\n\ndropnaExample.py\n\n```\ndfresult = df2.dropna(how='all')\nprint(dfresult)\n```\nCopy\n\nThe rows with `all` values equal to `NA` will be dropped:\n```\nOutputName ID Population Regions Endangered\n0 Shark 1 100 1 NaT\n1 Whale 2 200 None NaT\n2 Jellyfish 3 NaN NaT NaT\n3 Starfish 4 NaT NaT NaT\n```\nThe fifth row was dropped.\n\nNext, use `how` and specify the `axis`:\n\ndropnaExample.py\n\n```\ndfresult = df2.dropna(how='all', axis=1)\nprint(dfresult)\n```\nCopy\n\nThe columns with `all` values equal to `NA` will be dropped:\n```\nOutputName ID Population Regions\n0 Shark 1 100 1\n1 Whale 2 200 None\n2 Jellyfish 3 NaN NaT\n3 Starfish 4 NaT NaT\n4 NaT NaT NaT NaT\n```\nThe fifth column was dropped.\n\n## [Dropping Rows or Columns if a Threshold is Crossed with `thresh`](https:\/\/www.digitalocean.com\/community\/tutorials\/pandas-dropna-drop-null-na-values-from-dataframe#dropping-rows-or-columns-if-a-threshold-is-crossed-with-thresh)\nUse the second DataFrame with `thresh` to drop rows that do not meet the threshold of at least `3` non-`NA` values:\n\ndropnaExample.py\n\n```\ndfresult = df2.dropna(thresh=3)\nprint(dfresult)\n```\nCopy\n\nThe rows do not have at least `3` non-`NA` will be dropped:\n```\nOutputName ID Population Regions Endangered\n0 Shark 1 100 1 NaT\n1 Whale 2 200 None NaT\n```\nThe third, fourth, and fifth rows were dropped.\n\n## [Dropping Rows or Columns for Specific `subsets`](https:\/\/www.digitalocean.com\/community\/tutorials\/pandas-dropna-drop-null-na-values-from-dataframe#dropping-rows-or-columns-for-specific-subsets)\nUse the second DataFrame with `subset` to drop rows with `NA` values in the `Population` column:\n\ndropnaExample.py\n\n```\ndfresult = df2.dropna(subset=['Population'])\nprint(dfresult)\n```\nCopy\n\nThe rows that have `Population` with `NA` values will be dropped:\n```\nOutputName ID Population Regions Endangered\n0 Shark 1 100 1 NaT\n1 Whale 2 200 None NaT\n```\nThe third, fourth, and fifth rows were dropped.\n\nYou can also specify the `index` values in the `subset` when dropping columns from the DataFrame:\n\ndropnaExample.py\n\n```\ndfresult = df2.dropna(subset=[1, 2], axis=1)\nprint(dfresult)\n```\nCopy\n\nThe columns that contain `NA` values in subset of rows `1` and `2`:\n```\nOutputName ID\n0 Shark 1\n1 Whale 2\n2 Jellyfish 3\n3 Starfish 4\n4 NaT NaT\n```\nThe third, fourth, and fifth columns were dropped.\n\n## [Changing the source DataFrame after Dropping Rows or Columns with `inplace`](https:\/\/www.digitalocean.com\/community\/tutorials\/pandas-dropna-drop-null-na-values-from-dataframe#changing-the-source-dataframe-after-dropping-rows-or-columns-with-inplace)\nBy default, `dropna()` does not modify the source DataFrame. However, in some cases, you may wish to save memory when working with a large source DataFrame by using `inplace`.\n\ndropnaExample.py\n\n```\ndf1.dropna(inplace=True)\nprint(df1)\n```\nCopy\n\nThis code does not use a `dfresult` variable.\n\nThis will output:\n```\nOutputName ID Population Regions\n0 Shark 1 100 1\n```\nThe original DataFrame has been modified.\n\n## [Conclusion](https:\/\/www.digitalocean.com\/community\/tutorials\/pandas-dropna-drop-null-na-values-from-dataframe#conclusion)\nIn this article, you used the `dropna()` function to remove rows and columns with `NA` values.\n\nContinue your learning with more Python and pandas tutorials - [Python pandas Module Tutorial](https:\/\/www.digitalocean.com\/community\/tutorials\/python-pandas-module-tutorial), [pandas Drop Duplicate Rows](https:\/\/www.digitalocean.com\/community\/tutorials\/pandas-drop-duplicate-rows-drop_duplicates-function).\n\n**References**\n\n- [pandas DataFrame `dropna()` API Doc](https:\/\/pandas.pydata.org\/pandas-docs\/stable\/reference\/api\/pandas.DataFrame.dropna.html)\n\nThanks for learning with the DigitalOcean Community. Check out our offerings for compute, storage, networking, and managed databases.\n\n[Learn more about our products](https:\/\/www.digitalocean.com\/products \"Learn more about our products\")\n\n### About the author(s)\n![Pankaj Kumar](https:\/\/www.gravatar.com\/avatar\/dcb62410bd20fd354c21af393bec6e67b235a09758848745cfd4405e05bba1f4?default=retro&size=256)\n\nPankaj Kumar\n\nAuthor\n\n[See author profile](https:\/\/www.digitalocean.com\/community\/users\/pankajkumarjournaldev)\n\nJava and Python Developer for 20+ years, Open Source Enthusiast, Founder of https:\/\/www.askpython.com\/, https:\/\/www.linuxfordevices.com\/, and JournalDev.com (acquired by DigitalOcean). Passionate about writing technical articles and sharing knowledge with others. Love Java, Python, Unix and related technologies. Follow my X @PankajWebDev\n\n[See author profile](https:\/\/www.digitalocean.com\/community\/users\/pankajkumarjournaldev)\n\n![Bradley Kouchi](https:\/\/www.gravatar.com\/avatar\/1c15a76c8f5e79c35d1ce6c479888827d77e10dac512f9476549d036ca44fc17?default=retro&size=256)\n\nBradley Kouchi\n\nEditor\n\n[See author profile](https:\/\/www.digitalocean.com\/community\/users\/bkouchido)\n\n[See author profile](https:\/\/www.digitalocean.com\/community\/users\/bkouchido)\n\nCategory:\n\n[Tutorial](https:\/\/www.digitalocean.com\/community\/tutorials?subtype=tutorial)\n\nTags:\n\n[Pandas](https:\/\/www.digitalocean.com\/community\/tags\/pandas)\n\n[Python](https:\/\/www.digitalocean.com\/community\/tags\/python)\n\n#### Still looking for an answer?\n[Ask a question](https:\/\/www.digitalocean.com\/community\/questions)[Search for more help](https:\/\/www.digitalocean.com\/community)\n\nWas this helpful?\n\nYes\n\nNo\n\nComments(2)\n\nFollow-up questions(0)\n\n![JournalDev](https:\/\/www.gravatar.com\/avatar\/7c7a4546c8430a5a91a338a177bf8e7e8e153fe7eaee076acfa6d46029efef49?default=retro)\n\n[JournalDev](https:\/\/www.digitalocean.com\/community\/users\/journaldev)![DigitalOcean Employee badge](https:\/\/www.digitalocean.com\/api\/static-content\/v1\/images?src=%2F_next%2Fstatic%2Fmedia%2Fdo-logo.15453cf1.svg&width=32)\n\n[February 12, 2021](https:\/\/www.digitalocean.com\/community\/tutorials\/pandas-dropna-drop-null-na-values-from-dataframe?comment=177699)\n\nShow less\n\nthats very comprehensive. out of all drop explanation … this is the best thank you\n\n\\- johny\n\n![JournalDev](https:\/\/www.gravatar.com\/avatar\/7c7a4546c8430a5a91a338a177bf8e7e8e153fe7eaee076acfa6d46029efef49?default=retro)\n\n[JournalDev](https:\/\/www.digitalocean.com\/community\/users\/journaldev)![DigitalOcean Employee badge](https:\/\/www.digitalocean.com\/api\/static-content\/v1\/images?src=%2F_next%2Fstatic%2Fmedia%2Fdo-logo.15453cf1.svg&width=32)\n\n[May 11, 2021](https:\/\/www.digitalocean.com\/community\/tutorials\/pandas-dropna-drop-null-na-values-from-dataframe?comment=177700)\n\nShow less\n\nThank u bro, well explained in very simple way\n\n\\- KHAJA MOINUDDIN KHAN\n\n[![Creative Commons](https:\/\/www.digitalocean.com\/api\/static-content\/v1\/images?src=%2F_next%2Fstatic%2Fmedia%2Fcreativecommons.c0a877f1.png&width=384)](https:\/\/creativecommons.org\/licenses\/by-nc-sa\/4.0\/)This work is licensed under a Creative Commons Attribution-NonCommercial- ShareAlike 4.0 International License.\n\n## Deploy on DigitalOcean\nClick below to sign up for DigitalOcean's virtual machines, Databases, and AIML products.\n\n[Sign up](https:\/\/cloud.digitalocean.com\/registrations\/new?refcode=f6fcd01aaffb)\n\n## Popular Topics\n1. [AI\/ML](https:\/\/www.digitalocean.com\/community\/tags\/ai-ml)\n2. [Ubuntu](https:\/\/www.digitalocean.com\/community\/tags\/ubuntu)\n3. [Linux Basics](https:\/\/www.digitalocean.com\/community\/tags\/linux-basics)\n4. [JavaScript](https:\/\/www.digitalocean.com\/community\/tags\/javascript)\n5. [Python](https:\/\/www.digitalocean.com\/community\/tags\/python)\n6. [MySQL](https:\/\/www.digitalocean.com\/community\/tags\/mysql)\n7. [Docker](https:\/\/www.digitalocean.com\/community\/tags\/docker)\n8. [Kubernetes](https:\/\/www.digitalocean.com\/community\/tags\/kubernetes)\n9. [All tutorials](https:\/\/www.digitalocean.com\/community\/tutorials)\n10. [Talk to an expert](https:\/\/www.digitalocean.com\/company\/contact\/sales?referrer=tutorials)\n\n### Connect on Discord\nJoin the conversation in our Discord to connect with fellow developers\n\n[Visit Discord](https:\/\/discord.gg\/digitalocean)\n\n## Featured tutorials\n1. [SOLID Design Principles Explained: Building Better Software Architecture](https:\/\/www.digitalocean.com\/community\/tutorials\/s-o-l-i-d-the-first-five-principles-of-object-oriented-design)\n2. [How To Remove Docker Images, Containers, and Volumes](https:\/\/www.digitalocean.com\/community\/tutorials\/how-to-remove-docker-images-containers-and-volumes)\n3. [How to Create a MySQL User and Grant Privileges (Step-by-Step)](https:\/\/www.digitalocean.com\/community\/tutorials\/how-to-create-a-new-user-and-grant-permissions-in-mysql)\n\n- [All tutorials](https:\/\/www.digitalocean.com\/community\/tutorials)\n- [All topic tags](https:\/\/www.digitalocean.com\/community\/tags)\n##### Join the Tech Talk\n- [Syntax](https:\/\/www.digitalocean.com\/community\/tutorials\/pandas-dropna-drop-null-na-values-from-dataframe#syntax)\n- [Constructing Sample DataFrames](https:\/\/www.digitalocean.com\/community\/tutorials\/pandas-dropna-drop-null-na-values-from-dataframe#constructing-sample-dataframes)\n- [Dropping All Rows with Missing Values](https:\/\/www.digitalocean.com\/community\/tutorials\/pandas-dropna-drop-null-na-values-from-dataframe#dropping-all-rows-with-missing-values)\n- [Dropping All Columns with Missing Values](https:\/\/www.digitalocean.com\/community\/tutorials\/pandas-dropna-drop-null-na-values-from-dataframe#dropping-all-columns-with-missing-values)\n- [Dropping Rows or Columns if \\`all\\` the Values are \\`Null\\` with \\`how\\`](https:\/\/www.digitalocean.com\/community\/tutorials\/pandas-dropna-drop-null-na-values-from-dataframe#dropping-rows-or-columns-if-all-the-values-are-null-with-how)\n- [Dropping Rows or Columns if a Threshold is Crossed with \\`thresh\\`](https:\/\/www.digitalocean.com\/community\/tutorials\/pandas-dropna-drop-null-na-values-from-dataframe#dropping-rows-or-columns-if-a-threshold-is-crossed-with-thresh)\n- [Dropping Rows or Columns for Specific \\`subsets\\`](https:\/\/www.digitalocean.com\/community\/tutorials\/pandas-dropna-drop-null-na-values-from-dataframe#dropping-rows-or-columns-for-specific-subsets)\n- [Changing the source DataFrame after Dropping Rows or Columns with \\`inplace\\`](https:\/\/www.digitalocean.com\/community\/tutorials\/pandas-dropna-drop-null-na-values-from-dataframe#changing-the-source-dataframe-after-dropping-rows-or-columns-with-inplace)\n- [Conclusion](https:\/\/www.digitalocean.com\/community\/tutorials\/pandas-dropna-drop-null-na-values-from-dataframe#conclusion)\n\n- ## Deploy on DigitalOcean\n  Click below to sign up for DigitalOcean's virtual machines, Databases, and AIML products.\n  \n  [Sign up](https:\/\/cloud.digitalocean.com\/registrations\/new?refcode=f6fcd01aaffb)\n  \n  ## Popular Topics\n  1. [AI\/ML](https:\/\/www.digitalocean.com\/community\/tags\/ai-ml)\n  2. [Ubuntu](https:\/\/www.digitalocean.com\/community\/tags\/ubuntu)\n  3. [Linux Basics](https:\/\/www.digitalocean.com\/community\/tags\/linux-basics)\n  4. [JavaScript](https:\/\/www.digitalocean.com\/community\/tags\/javascript)\n  5. [Python](https:\/\/www.digitalocean.com\/community\/tags\/python)\n  6. [MySQL](https:\/\/www.digitalocean.com\/community\/tags\/mysql)\n  7. [Docker](https:\/\/www.digitalocean.com\/community\/tags\/docker)\n  8. [Kubernetes](https:\/\/www.digitalocean.com\/community\/tags\/kubernetes)\n  9. [All tutorials](https:\/\/www.digitalocean.com\/community\/tutorials)\n  10. [Talk to an expert](https:\/\/www.digitalocean.com\/company\/contact\/sales?referrer=tutorials)\n  \n  ### Connect on Discord\n  Join the conversation in our Discord to connect with fellow developers\n  \n  [Visit Discord](https:\/\/discord.gg\/digitalocean)\n  \n  ## Featured tutorials\n  1. [SOLID Design Principles Explained: Building Better Software Architecture](https:\/\/www.digitalocean.com\/community\/tutorials\/s-o-l-i-d-the-first-five-principles-of-object-oriented-design)\n  2. [How To Remove Docker Images, Containers, and Volumes](https:\/\/www.digitalocean.com\/community\/tutorials\/how-to-remove-docker-images-containers-and-volumes)\n  3. [How to Create a MySQL User and Grant Privileges (Step-by-Step)](https:\/\/www.digitalocean.com\/community\/tutorials\/how-to-create-a-new-user-and-grant-permissions-in-mysql)\n  \n  - [All tutorials](https:\/\/www.digitalocean.com\/community\/tutorials)\n  - [All topic tags](https:\/\/www.digitalocean.com\/community\/tags)\n\n![](https:\/\/www.digitalocean.com\/api\/static-content\/v1\/images?src=%2F_next%2Fstatic%2Fmedia%2Ftutorials-2-tulip.764b9f59.svg&width=1920)\n\n## Become a contributor for community\nGet paid to write technical tutorials and select a tech-focused charity to receive a matching donation.\n\n[Sign Up](https:\/\/www.digitalocean.com\/community\/pages\/write-for-digitalocean)\n\n![](https:\/\/www.digitalocean.com\/api\/static-content\/v1\/images?src=%2F_next%2Fstatic%2Fmedia%2Fdocs-2-kiwi.239a03ef.svg&width=1920)\n\n## DigitalOcean Documentation\nFull documentation for every DigitalOcean product.\n\n[Learn more](https:\/\/docs.digitalocean.com\/)\n\n![](https:\/\/www.digitalocean.com\/api\/static-content\/v1\/images?src=%2F_next%2Fstatic%2Fmedia%2Fblogs-1-lavender.495d1f00.svg&width=1920)\n\n## Resources for startups and AI-native businesses\nThe Wave has everything you need to know about building a business, from raising funding to marketing your product.\n\n[Learn more](https:\/\/www.digitalocean.com\/resources)\n\n## Get our newsletter\nStay up to date by signing up for DigitalOcean’s Infrastructure as a Newsletter.\n\nNew accounts only. By submitting your email you agree to our [Privacy Policy](https:\/\/www.digitalocean.com\/legal\/privacy-policy)\n\n## The developer cloud\nScale up as you grow — whether you're running one virtual machine or ten thousand.\n\n[View all products](https:\/\/www.digitalocean.com\/products)\n\n![](https:\/\/www.digitalocean.com\/api\/static-content\/v1\/images?src=%2F_next%2Fstatic%2Fmedia%2Fclouds-mobile.5d14bead.svg&width=3840)\n\n## Start building today\nFrom GPU-powered inference and Kubernetes to managed databases and storage, get everything you need to build, scale, and deploy intelligent applications.\n\n[Sign up](https:\/\/cloud.digitalocean.com\/registrations\/new)\n\n![](https:\/\/www.digitalocean.com\/api\/static-content\/v1\/images?src=%2F_next%2Fstatic%2Fmedia%2Fwaves-mobile.a054c63e.svg&width=3840)\n\n## Company\n- [About](https:\/\/www.digitalocean.com\/about)\n- [Leadership](https:\/\/www.digitalocean.com\/leadership\/executive-management)\n- [Blog](https:\/\/www.digitalocean.com\/blog)\n- [Careers](https:\/\/www.digitalocean.com\/careers)\n- [Customers](https:\/\/www.digitalocean.com\/customers)\n- [Partners](https:\/\/www.digitalocean.com\/partners)\n- [Referral Program](https:\/\/www.digitalocean.com\/referral-program)\n- [Affiliate Program](https:\/\/www.digitalocean.com\/affiliates)\n- [Press](https:\/\/www.digitalocean.com\/press)\n- [Legal](https:\/\/www.digitalocean.com\/legal)\n- [Privacy Policy](https:\/\/www.digitalocean.com\/legal\/privacy-policy)\n- [Security](https:\/\/www.digitalocean.com\/security)\n- [Investor Relations](https:\/\/investors.digitalocean.com\/)\n\n## Products\n- [Gradient™ AI GPU Droplets](https:\/\/www.digitalocean.com\/products\/gradient\/gpu-droplets)\n- [Gradient™ AI Bare Metal GPUs](https:\/\/www.digitalocean.com\/products\/gradient\/bare-metal-gpus)\n- [Gradient™ AI 1-Click Models](https:\/\/www.digitalocean.com\/products\/gradient\/1-click-models)\n- [Gradient™ AI Platform](https:\/\/www.digitalocean.com\/products\/gradient\/platform)\n- [Droplets](https:\/\/www.digitalocean.com\/products\/droplets)\n- [Kubernetes](https:\/\/www.digitalocean.com\/products\/kubernetes)\n- [Functions](https:\/\/www.digitalocean.com\/products\/functions)\n- [App Platform](https:\/\/www.digitalocean.com\/products\/app-platform)\n- [Load Balancers](https:\/\/www.digitalocean.com\/products\/load-balancers)\n- [Managed Databases](https:\/\/www.digitalocean.com\/products\/managed-databases)\n- [Spaces](https:\/\/www.digitalocean.com\/products\/spaces)\n- [Block Storage](https:\/\/www.digitalocean.com\/products\/block-storage)\n- [Network File Storage](https:\/\/www.digitalocean.com\/products\/storage\/network-file-storage)\n- [API](https:\/\/docs.digitalocean.com\/reference\/api)\n- [Uptime](https:\/\/www.digitalocean.com\/products\/uptime-monitoring)\n- [Cloud Security Posture Management (CSPM)](https:\/\/www.digitalocean.com\/products\/cloud-security-posture-management)\n- [Identity and Access Management (IAM)](https:\/\/www.digitalocean.com\/products\/identity-access-management)\n- [Cloudways](https:\/\/www.digitalocean.com\/products\/cloudways)\n- [View all Products](https:\/\/www.digitalocean.com\/products)\n\n## Resources\n- [Community Tutorials](https:\/\/www.digitalocean.com\/community\/tutorials)\n- [Community Q\\&A](https:\/\/www.digitalocean.com\/community\/questions)\n- [CSS-Tricks](https:\/\/css-tricks.com\/)\n- [Write for DOnations](https:\/\/www.digitalocean.com\/community\/pages\/write-for-digitalocean)\n- [Currents Research](https:\/\/www.digitalocean.com\/currents)\n- [DigitalOcean Startups](https:\/\/www.digitalocean.com\/startups)\n- [Wavemakers Program](https:\/\/www.digitalocean.com\/wavemakers)\n- [Compass Council](https:\/\/www.digitalocean.com\/research)\n- [Open Source](https:\/\/www.digitalocean.com\/open-source)\n- [Newsletter Signup](https:\/\/www.digitalocean.com\/community#iaan)\n- [Marketplace](https:\/\/www.digitalocean.com\/products\/marketplace)\n- [Pricing](https:\/\/www.digitalocean.com\/pricing)\n- [Pricing Calculator](https:\/\/www.digitalocean.com\/pricing\/calculator)\n- [Documentation](https:\/\/docs.digitalocean.com\/)\n- [Release Notes](https:\/\/docs.digitalocean.com\/release-notes)\n- [Code of Conduct](https:\/\/www.digitalocean.com\/community\/pages\/code-of-conduct)\n- [Shop Swag](http:\/\/store.digitalocean.com\/)\n\n## Solutions\n- [AI GPU Hosting](https:\/\/www.digitalocean.com\/solutions\/ai-gpu-hosting)\n- [H100 Cloud GPU](https:\/\/www.digitalocean.com\/solutions\/h100-cloud-gpu)\n- [AI Training GPU](https:\/\/www.digitalocean.com\/solutions\/ai-training-gpu)\n- [GPU Inference](https:\/\/www.digitalocean.com\/solutions\/gpu-inference)\n- [VPS Hosting](https:\/\/www.digitalocean.com\/solutions\/vps-hosting)\n- [Website Hosting](https:\/\/www.digitalocean.com\/solutions\/website-hosting)\n- [VPN](https:\/\/www.digitalocean.com\/solutions\/vpn)\n- [Docker Hosting](https:\/\/www.digitalocean.com\/solutions\/docker-hosting)\n- [Node.js Hosting](https:\/\/www.digitalocean.com\/solutions\/nodejs-hosting)\n- [Web Mobile Apps](https:\/\/www.digitalocean.com\/solutions\/web-mobile-apps)\n- [WordPress Hosting](https:\/\/www.digitalocean.com\/solutions\/wordpress-hosting)\n- [Virtual Machines](https:\/\/www.digitalocean.com\/solutions\/virtual-machines)\n- [View all Solutions](https:\/\/www.digitalocean.com\/solutions)\n\n## Contact\n- [Support](https:\/\/www.digitalocean.com\/support)\n- [Sales](https:\/\/www.digitalocean.com\/company\/contact\/sales?referrer=footer)\n- [Report Abuse](https:\/\/www.digitalocean.com\/company\/contact\/abuse)\n- [System Status](https:\/\/status.digitalocean.com\/)\n- [Share your ideas](https:\/\/ideas.digitalocean.com\/)\n\n## Company\n- [About](https:\/\/www.digitalocean.com\/about)\n- [Leadership](https:\/\/www.digitalocean.com\/leadership\/executive-management)\n- [Blog](https:\/\/www.digitalocean.com\/blog)\n- [Careers](https:\/\/www.digitalocean.com\/careers)\n- [Customers](https:\/\/www.digitalocean.com\/customers)\n- [Partners](https:\/\/www.digitalocean.com\/partners)\n- [Referral Program](https:\/\/www.digitalocean.com\/referral-program)\n- [Affiliate Program](https:\/\/www.digitalocean.com\/affiliates)\n- [Press](https:\/\/www.digitalocean.com\/press)\n- [Legal](https:\/\/www.digitalocean.com\/legal)\n- [Privacy Policy](https:\/\/www.digitalocean.com\/legal\/privacy-policy)\n- [Security](https:\/\/www.digitalocean.com\/security)\n- [Investor Relations](https:\/\/investors.digitalocean.com\/)\n\n## Products\n- [Gradient™ AI GPU Droplets](https:\/\/www.digitalocean.com\/products\/gradient\/gpu-droplets)\n- [Gradient™ AI Bare Metal GPUs](https:\/\/www.digitalocean.com\/products\/gradient\/bare-metal-gpus)\n- [Gradient™ AI 1-Click Models](https:\/\/www.digitalocean.com\/products\/gradient\/1-click-models)\n- [Gradient™ AI Platform](https:\/\/www.digitalocean.com\/products\/gradient\/platform)\n- [Droplets](https:\/\/www.digitalocean.com\/products\/droplets)\n- [Kubernetes](https:\/\/www.digitalocean.com\/products\/kubernetes)\n- [Functions](https:\/\/www.digitalocean.com\/products\/functions)\n- [App Platform](https:\/\/www.digitalocean.com\/products\/app-platform)\n- [Load Balancers](https:\/\/www.digitalocean.com\/products\/load-balancers)\n- [Managed Databases](https:\/\/www.digitalocean.com\/products\/managed-databases)\n- [Spaces](https:\/\/www.digitalocean.com\/products\/spaces)\n- [Block Storage](https:\/\/www.digitalocean.com\/products\/block-storage)\n- [Network File Storage](https:\/\/www.digitalocean.com\/products\/storage\/network-file-storage)\n- [API](https:\/\/docs.digitalocean.com\/reference\/api)\n- [Uptime](https:\/\/www.digitalocean.com\/products\/uptime-monitoring)\n- [Cloud Security Posture Management (CSPM)](https:\/\/www.digitalocean.com\/products\/cloud-security-posture-management)\n- [Identity and Access Management (IAM)](https:\/\/www.digitalocean.com\/products\/identity-access-management)\n- [Cloudways](https:\/\/www.digitalocean.com\/products\/cloudways)\n- [View all Products](https:\/\/www.digitalocean.com\/products)\n\n## Resources\n- [Community Tutorials](https:\/\/www.digitalocean.com\/community\/tutorials)\n- [Community Q\\&A](https:\/\/www.digitalocean.com\/community\/questions)\n- [CSS-Tricks](https:\/\/css-tricks.com\/)\n- [Write for DOnations](https:\/\/www.digitalocean.com\/community\/pages\/write-for-digitalocean)\n- [Currents Research](https:\/\/www.digitalocean.com\/currents)\n- [DigitalOcean Startups](https:\/\/www.digitalocean.com\/startups)\n- [Wavemakers Program](https:\/\/www.digitalocean.com\/wavemakers)\n- [Compass Council](https:\/\/www.digitalocean.com\/research)\n- [Open Source](https:\/\/www.digitalocean.com\/open-source)\n- [Newsletter Signup](https:\/\/www.digitalocean.com\/community#iaan)\n- [Marketplace](https:\/\/www.digitalocean.com\/products\/marketplace)\n- [Pricing](https:\/\/www.digitalocean.com\/pricing)\n- [Pricing Calculator](https:\/\/www.digitalocean.com\/pricing\/calculator)\n- [Documentation](https:\/\/docs.digitalocean.com\/)\n- [Release Notes](https:\/\/docs.digitalocean.com\/release-notes)\n- [Code of Conduct](https:\/\/www.digitalocean.com\/community\/pages\/code-of-conduct)\n- [Shop Swag](http:\/\/store.digitalocean.com\/)\n\n## Solutions\n- [AI GPU Hosting](https:\/\/www.digitalocean.com\/solutions\/ai-gpu-hosting)\n- [H100 Cloud GPU](https:\/\/www.digitalocean.com\/solutions\/h100-cloud-gpu)\n- [AI Training GPU](https:\/\/www.digitalocean.com\/solutions\/ai-training-gpu)\n- [GPU Inference](https:\/\/www.digitalocean.com\/solutions\/gpu-inference)\n- [VPS Hosting](https:\/\/www.digitalocean.com\/solutions\/vps-hosting)\n- [Website Hosting](https:\/\/www.digitalocean.com\/solutions\/website-hosting)\n- [VPN](https:\/\/www.digitalocean.com\/solutions\/vpn)\n- [Docker Hosting](https:\/\/www.digitalocean.com\/solutions\/docker-hosting)\n- [Node.js Hosting](https:\/\/www.digitalocean.com\/solutions\/nodejs-hosting)\n- [Web Mobile Apps](https:\/\/www.digitalocean.com\/solutions\/web-mobile-apps)\n- [WordPress Hosting](https:\/\/www.digitalocean.com\/solutions\/wordpress-hosting)\n- [Virtual Machines](https:\/\/www.digitalocean.com\/solutions\/virtual-machines)\n- [View all Solutions](https:\/\/www.digitalocean.com\/solutions)\n\n## Contact\n- [Support](https:\/\/www.digitalocean.com\/support)\n- [Sales](https:\/\/www.digitalocean.com\/company\/contact\/sales?referrer=footer)\n- [Report Abuse](https:\/\/www.digitalocean.com\/company\/contact\/abuse)\n- [System Status](https:\/\/status.digitalocean.com\/)\n- [Share your ideas](https:\/\/ideas.digitalocean.com\/)\n\n© 2026 DigitalOcean, LLC.[Sitemap](https:\/\/www.digitalocean.com\/sitemap).[Cookie Preferences]()\n\nThis site uses cookies and related technologies, as described in our [privacy policy](https:\/\/www.digitalocean.com\/legal\/privacy-policy\/), for purposes that may include site operation, analytics, enhanced user experience, or advertising. You may choose to consent to our use of these technologies, or manage your own preferences. Please visit our [cookie policy](https:\/\/www.digitalocean.com\/legal\/cookie-policy) for more information.\n\nAgree & Proceed\n\nDecline All\n\nManage Choices\n\nLoading...\n\n## Community\n## Product Docs\n## Marketplace\n## DigitalOcean Blog\n\nnavigate\n\ngo\n\nexit","attrs_readable_markdown":"### [Introduction](https:\/\/www.digitalocean.com\/community\/tutorials\/pandas-dropna-drop-null-na-values-from-dataframe#introduction)\nIn this tutorial, you’ll learn how to use panda’s DataFrame `dropna()` function.\n\n`NA` values are “Not Available”. This can apply to `Null`, `None`, `pandas.NaT`, or `numpy.nan`. Using `dropna()` will drop the rows and columns with these values. This can be beneficial to provide you with only valid data.\n\nBy default, this function returns a new DataFrame and the source DataFrame remains unchanged.\n\nThis tutorial was verified with Python 3.10.9, pandas 1.5.2, and NumPy 1.24.1.\n\n## [Syntax](https:\/\/www.digitalocean.com\/community\/tutorials\/pandas-dropna-drop-null-na-values-from-dataframe#syntax)\n`dropna()` takes the following parameters:\n```\ndropna(self, axis=0, how=\"any\", thresh=None, subset=None, inplace=False)\n```\n- `axis`: `{0 (or 'index'), 1 (or 'columns')}, default 0`\n- If `0`, drop rows with missing values.\n- If `1`, drop columns with missing values.\n- `how`: `{'any', 'all'}, default 'any'`\n- If `'any'`, drop the row or column if any of the values is `NA`.\n- If `'all'`, drop the row or column if all of the values are `NA`.\n- `thresh`: (optional) an `int` value to specify the threshold for the drop operation.\n- `subset`: (optional) column label or sequence of labels to specify rows or columns.\n- `inplace`: (optional) a `bool` value.\n- If `True`, the source DataFrame is changed and `None` is returned.\n\n## [Constructing Sample DataFrames](https:\/\/www.digitalocean.com\/community\/tutorials\/pandas-dropna-drop-null-na-values-from-dataframe#constructing-sample-dataframes)\nConstruct a sample DataFrame that contains valid and invalid values:\n\ndropnaExample.py\n```\nimport pandas as pd\nimport numpy as np\n\nd1 = {\n'Name': ['Shark', 'Whale', 'Jellyfish', 'Starfish'],\n'ID': [1, 2, 3, 4],\n'Population': [100, 200, np.nan, pd.NaT],\n'Regions': [1, None, pd.NaT, pd.NaT]\n}\n\ndf1 = pd.DataFrame(d1)\nprint(df1)\n```\nThis code will print out the DataFrame:\n```\nOutputName ID Population Regions\n0 Shark 1 100 1\n1 Whale 2 200 None\n2 Jellyfish 3 NaN NaT\n3 Starfish 4 NaT NaT\n```\nThen add a second DataFrame with additional rows and columns with `NA` values:\n```\nd2 = {\n'Name': ['Shark', 'Whale', 'Jellyfish', 'Starfish', pd.NaT],\n'ID': [1, 2, 3, 4, pd.NaT],\n'Population': [100, 200, np.nan, pd.NaT, pd.NaT],\n'Regions': [1, None, pd.NaT, pd.NaT, pd.NaT],\n'Endangered': [pd.NaT, pd.NaT, pd.NaT, pd.NaT, pd.NaT]\n}\n\ndf2 = pd.DataFrame(d2)\nprint(df2)\n```\nThis will output a new DataFrame:\n```\nOutputName ID Population Regions Endangered\n0 Shark 1 100 1 NaT\n1 Whale 2 200 None NaT\n2 Jellyfish 3 NaN NaT NaT\n3 Starfish 4 NaT NaT NaT\n4 NaT NaT NaT NaT NaT\n```\nYou will use the preceding DataFrames in the examples that follow.\n\n## [Dropping All Rows with Missing Values](https:\/\/www.digitalocean.com\/community\/tutorials\/pandas-dropna-drop-null-na-values-from-dataframe#dropping-all-rows-with-missing-values)\nUse `dropna()` to remove rows with any `None`, `NaN`, or `NaT` values:\n\ndropnaExample.py\n```\ndfresult = df1.dropna()\nprint(dfresult)\n```\nThis will output:\n```\nOutputName ID Population Regions\n0 Shark 1 100 1\n```\nA new DataFrame with a single row that didn’t contain any `NA` values.\n\n## [Dropping All Columns with Missing Values](https:\/\/www.digitalocean.com\/community\/tutorials\/pandas-dropna-drop-null-na-values-from-dataframe#dropping-all-columns-with-missing-values)\nUse `dropna()` with `axis=1` to remove columns with any `None`, `NaN`, or `NaT` values:\n```\ndfresult = df1.dropna(axis=1)\nprint(dfresult)\n```\nThe columns with any `None`, `NaN`, or `NaT` values will be dropped:\n```\nOutputName ID\n0 Shark 1\n1 Whale 2\n2 Jellyfish 3\n3 Starfish 4\n```\nA new DataFrame with a single column that contained non-`NA` values.\n\n## [Dropping Rows or Columns if `all` the Values are `Null` with `how`](https:\/\/www.digitalocean.com\/community\/tutorials\/pandas-dropna-drop-null-na-values-from-dataframe#dropping-rows-or-columns-if-all-the-values-are-null-with-how)\nUse the second DataFrame and `how`:\n\ndropnaExample.py\n```\ndfresult = df2.dropna(how='all')\nprint(dfresult)\n```\nThe rows with `all` values equal to `NA` will be dropped:\n```\nOutputName ID Population Regions Endangered\n0 Shark 1 100 1 NaT\n1 Whale 2 200 None NaT\n2 Jellyfish 3 NaN NaT NaT\n3 Starfish 4 NaT NaT NaT\n```\nThe fifth row was dropped.\n\nNext, use `how` and specify the `axis`:\n\ndropnaExample.py\n```\ndfresult = df2.dropna(how='all', axis=1)\nprint(dfresult)\n```\nThe columns with `all` values equal to `NA` will be dropped:\n```\nOutputName ID Population Regions\n0 Shark 1 100 1\n1 Whale 2 200 None\n2 Jellyfish 3 NaN NaT\n3 Starfish 4 NaT NaT\n4 NaT NaT NaT NaT\n```\nThe fifth column was dropped.\n\n## [Dropping Rows or Columns if a Threshold is Crossed with `thresh`](https:\/\/www.digitalocean.com\/community\/tutorials\/pandas-dropna-drop-null-na-values-from-dataframe#dropping-rows-or-columns-if-a-threshold-is-crossed-with-thresh)\nUse the second DataFrame with `thresh` to drop rows that do not meet the threshold of at least `3` non-`NA` values:\n\ndropnaExample.py\n```\ndfresult = df2.dropna(thresh=3)\nprint(dfresult)\n```\nThe rows do not have at least `3` non-`NA` will be dropped:\n```\nOutputName ID Population Regions Endangered\n0 Shark 1 100 1 NaT\n1 Whale 2 200 None NaT\n```\nThe third, fourth, and fifth rows were dropped.\n\n## [Dropping Rows or Columns for Specific `subsets`](https:\/\/www.digitalocean.com\/community\/tutorials\/pandas-dropna-drop-null-na-values-from-dataframe#dropping-rows-or-columns-for-specific-subsets)\nUse the second DataFrame with `subset` to drop rows with `NA` values in the `Population` column:\n\ndropnaExample.py\n```\ndfresult = df2.dropna(subset=['Population'])\nprint(dfresult)\n```\nThe rows that have `Population` with `NA` values will be dropped:\n```\nOutputName ID Population Regions Endangered\n0 Shark 1 100 1 NaT\n1 Whale 2 200 None NaT\n```\nThe third, fourth, and fifth rows were dropped.\n\nYou can also specify the `index` values in the `subset` when dropping columns from the DataFrame:\n\ndropnaExample.py\n```\ndfresult = df2.dropna(subset=[1, 2], axis=1)\nprint(dfresult)\n```\nThe columns that contain `NA` values in subset of rows `1` and `2`:\n```\nOutputName ID\n0 Shark 1\n1 Whale 2\n2 Jellyfish 3\n3 Starfish 4\n4 NaT NaT\n```\nThe third, fourth, and fifth columns were dropped.\n\n## [Changing the source DataFrame after Dropping Rows or Columns with `inplace`](https:\/\/www.digitalocean.com\/community\/tutorials\/pandas-dropna-drop-null-na-values-from-dataframe#changing-the-source-dataframe-after-dropping-rows-or-columns-with-inplace)\nBy default, `dropna()` does not modify the source DataFrame. However, in some cases, you may wish to save memory when working with a large source DataFrame by using `inplace`.\n\ndropnaExample.py\n```\ndf1.dropna(inplace=True)\nprint(df1)\n```\nThis code does not use a `dfresult` variable.\n\nThis will output:\n```\nOutputName ID Population Regions\n0 Shark 1 100 1\n```\nThe original DataFrame has been modified.\n\n## [Conclusion](https:\/\/www.digitalocean.com\/community\/tutorials\/pandas-dropna-drop-null-na-values-from-dataframe#conclusion)\nIn this article, you used the `dropna()` function to remove rows and columns with `NA` values.\n\nContinue your learning with more Python and pandas tutorials - [Python pandas Module Tutorial](https:\/\/www.digitalocean.com\/community\/tutorials\/python-pandas-module-tutorial), [pandas Drop Duplicate Rows](https:\/\/www.digitalocean.com\/community\/tutorials\/pandas-drop-duplicate-rows-drop_duplicates-function).\n\n**References**\n\n- [pandas DataFrame `dropna()` API Doc](https:\/\/pandas.pydata.org\/pandas-docs\/stable\/reference\/api\/pandas.DataFrame.dropna.html)\n\nWas this helpful?\n\n[![Creative Commons](https:\/\/www.digitalocean.com\/api\/static-content\/v1\/images?src=%2F_next%2Fstatic%2Fmedia%2Fcreativecommons.c0a877f1.png&width=384)](https:\/\/creativecommons.org\/licenses\/by-nc-sa\/4.0\/)This work is licensed under a Creative Commons Attribution-NonCommercial- ShareAlike 4.0 International License.","meta_canonical":null}

3. Robots.txt Check

Query:

Response:

4. Spam/Ban Check

Query:

Response:

5. Seen Status Check

ℹ️ Skipped - page is already crawled

📄

INDEXABLE

✅

CRAWLED

12 hours ago

🤖

ROBOTS ALLOWED

Page Info Filters

Filter	Status	Condition	Details
HTTP status	PASS	`download_http_code = 200`	HTTP 200
Age cutoff	PASS	`download_stamp > now() - 6 MONTH`	0 months ago
History drop	PASS	`isNull(history_drop_reason)`	No drop reason
Spam/ban	PASS	`fh_dont_index != 1 AND ml_spam_score = 0`	ml_spam_score=0
Canonical	PASS	`meta_canonical IS NULL OR = '' OR = src_unparsed`	Not set

Page Details

Property	Value
URL	https://www.digitalocean.com/community/tutorials/pandas-dropna-drop-null-na-values-from-dataframe
Last Crawled	2026-04-14 12:30:53 (12 hours ago)
First Indexed	2022-08-04 04:38:25 (3 years ago)
HTTP Status Code	200
Meta Title	How To Use Python pandas dropna() to Drop NA Values from DataFrame \| DigitalOcean
Meta Description	Technical tutorials, Q&A, events — This is an inclusive place where developers can find or lend support and discover new ways to contribute to the community.
Meta Canonical	null
Boilerpipe Text	Introduction In this tutorial, you’ll learn how to use panda’s DataFrame dropna() function. NA values are “Not Available”. This can apply to Null , None , pandas.NaT , or numpy.nan . Using dropna() will drop the rows and columns with these values. This can be beneficial to provide you with only valid data. By default, this function returns a new DataFrame and the source DataFrame remains unchanged. This tutorial was verified with Python 3.10.9, pandas 1.5.2, and NumPy 1.24.1. Syntax dropna() takes the following parameters: dropna ( self , axis = 0 , how = "any" , thresh = None , subset = None , inplace = False ) axis : {0 (or 'index'), 1 (or 'columns')}, default 0 If 0 , drop rows with missing values. If 1 , drop columns with missing values. how : {'any', 'all'}, default 'any' If 'any' , drop the row or column if any of the values is NA . If 'all' , drop the row or column if all of the values are NA . thresh : (optional) an int value to specify the threshold for the drop operation. subset : (optional) column label or sequence of labels to specify rows or columns. inplace : (optional) a bool value. If True , the source DataFrame is changed and None is returned. Constructing Sample DataFrames Construct a sample DataFrame that contains valid and invalid values: dropnaExample.py import pandas as pd import numpy as np d1 = { 'Name' : [ 'Shark' , 'Whale' , 'Jellyfish' , 'Starfish' ] , 'ID' : [ 1 , 2 , 3 , 4 ] , 'Population' : [ 100 , 200 , np . nan , pd . NaT ] , 'Regions' : [ 1 , None , pd . NaT , pd . NaT ] } df1 = pd . DataFrame ( d1 ) print ( df1 ) This code will print out the DataFrame: Output Name ID Population Regions 0 Shark 1 100 1 1 Whale 2 200 None 2 Jellyfish 3 NaN NaT 3 Starfish 4 NaT NaT Then add a second DataFrame with additional rows and columns with NA values: d2 = { 'Name' : [ 'Shark' , 'Whale' , 'Jellyfish' , 'Starfish' , pd . NaT ] , 'ID' : [ 1 , 2 , 3 , 4 , pd . NaT ] , 'Population' : [ 100 , 200 , np . nan , pd . NaT , pd . NaT ] , 'Regions' : [ 1 , None , pd . NaT , pd . NaT , pd . NaT ] , 'Endangered' : [ pd . NaT , pd . NaT , pd . NaT , pd . NaT , pd . NaT ] } df2 = pd . DataFrame ( d2 ) print ( df2 ) This will output a new DataFrame: Output Name ID Population Regions Endangered 0 Shark 1 100 1 NaT 1 Whale 2 200 None NaT 2 Jellyfish 3 NaN NaT NaT 3 Starfish 4 NaT NaT NaT 4 NaT NaT NaT NaT NaT You will use the preceding DataFrames in the examples that follow. Dropping All Rows with Missing Values Use dropna() to remove rows with any None , NaN , or NaT values: dropnaExample.py dfresult = df1 . dropna ( ) print ( dfresult ) This will output: Output Name ID Population Regions 0 Shark 1 100 1 A new DataFrame with a single row that didn’t contain any NA values. Dropping All Columns with Missing Values Use dropna() with axis=1 to remove columns with any None , NaN , or NaT values: dfresult = df1 . dropna ( axis = 1 ) print ( dfresult ) The columns with any None , NaN , or NaT values will be dropped: Output Name ID 0 Shark 1 1 Whale 2 2 Jellyfish 3 3 Starfish 4 A new DataFrame with a single column that contained non- NA values. Dropping Rows or Columns if all the Values are Null with how Use the second DataFrame and how : dropnaExample.py dfresult = df2 . dropna ( how = 'all' ) print ( dfresult ) The rows with all values equal to NA will be dropped: Output Name ID Population Regions Endangered 0 Shark 1 100 1 NaT 1 Whale 2 200 None NaT 2 Jellyfish 3 NaN NaT NaT 3 Starfish 4 NaT NaT NaT The fifth row was dropped. Next, use how and specify the axis : dropnaExample.py dfresult = df2 . dropna ( how = 'all' , axis = 1 ) print ( dfresult ) The columns with all values equal to NA will be dropped: Output Name ID Population Regions 0 Shark 1 100 1 1 Whale 2 200 None 2 Jellyfish 3 NaN NaT 3 Starfish 4 NaT NaT 4 NaT NaT NaT NaT The fifth column was dropped. Dropping Rows or Columns if a Threshold is Crossed with thresh Use the second DataFrame with thresh to drop rows that do not meet the threshold of at least 3 non- NA values: dropnaExample.py dfresult = df2 . dropna ( thresh = 3 ) print ( dfresult ) The rows do not have at least 3 non- NA will be dropped: Output Name ID Population Regions Endangered 0 Shark 1 100 1 NaT 1 Whale 2 200 None NaT The third, fourth, and fifth rows were dropped. Dropping Rows or Columns for Specific subsets Use the second DataFrame with subset to drop rows with NA values in the Population column: dropnaExample.py dfresult = df2 . dropna ( subset = [ 'Population' ] ) print ( dfresult ) The rows that have Population with NA values will be dropped: Output Name ID Population Regions Endangered 0 Shark 1 100 1 NaT 1 Whale 2 200 None NaT The third, fourth, and fifth rows were dropped. You can also specify the index values in the subset when dropping columns from the DataFrame: dropnaExample.py dfresult = df2 . dropna ( subset = [ 1 , 2 ] , axis = 1 ) print ( dfresult ) The columns that contain NA values in subset of rows 1 and 2 : Output Name ID 0 Shark 1 1 Whale 2 2 Jellyfish 3 3 Starfish 4 4 NaT NaT The third, fourth, and fifth columns were dropped. Changing the source DataFrame after Dropping Rows or Columns with inplace By default, dropna() does not modify the source DataFrame. However, in some cases, you may wish to save memory when working with a large source DataFrame by using inplace . dropnaExample.py df1 . dropna ( inplace = True ) print ( df1 ) This code does not use a dfresult variable. This will output: Output Name ID Population Regions 0 Shark 1 100 1 The original DataFrame has been modified. Conclusion In this article, you used the dropna() function to remove rows and columns with NA values. Continue your learning with more Python and pandas tutorials - Python pandas Module Tutorial , pandas Drop Duplicate Rows . References pandas DataFrame dropna() API Doc Was this helpful? This work is licensed under a Creative Commons Attribution-NonCommercial- ShareAlike 4.0 International License.
Markdown	[DigitalOcean acquires Katanemo Labs, Inc. to accelerate AI development](https://www.digitalocean.com/blog/digitalocean-acquires-katanemo-labs-inc) [Now Available: Cloud Security Posture Management (CSPM)](https://www.digitalocean.com/blog/now-available-cloud-security-posture-management) [Now Available: OpenAI GPT-5.4 on the Gradient™ AI Platform](https://www.digitalocean.com/blog/whats-new-on-gradient-ai-platform#week-of-march-2) [Now Available: OpenAI GPT-5.3 Codex on the Gradient™ AI Platform](https://www.digitalocean.com/blog/whats-new-on-gradient-ai-platform#week-of-february-23rd) [Now Available: Claude Sonnet 4.6 on the Gradient™ AI Platform](https://www.digitalocean.com/blog/whats-new-on-gradient-ai-platform#week-of-february-17th) [Join us for Deploy in San Francisco, on April 28, 2026. Register now](https://www.digitalocean.com/deploy) - [Blog](https://www.digitalocean.com/blog) - [Docs](https://docs.digitalocean.com/products) - [Careers](https://www.digitalocean.com/careers) - [Get Support](https://www.digitalocean.com/support) - [Contact Sales](https://www.digitalocean.com/company/contact/sales?referrer=tophat) [DigitalOcean](https://www.digitalocean.com/) - Products Featured Products Gradient™ AI Agentic Inference Cloud Build, train, deploy apps/agents and scale at will Compute Build, deploy, and scale cloud compute resources Containers and Images Safely store and manage containers and backups Managed Databases Fully managed resources running popular database engines Management and Dev Tools Control infrastructure and gather insights Networking Secure and control traffic to apps Security Store and access any amount of data reliably in the cloud Storage Store and access any amount of data reliably in the cloud [Browse all products](https://www.digitalocean.com/products) ### Featured Products [Gradient™ AI Agentic Cloud Build, train, deploy apps/agents and scale at will](https://www.digitalocean.com/products/gradient) [Droplets Reliable, powerful, Linux-based virtual machines New updates](https://www.digitalocean.com/products/droplets) [Managed Databases Fully managed resources running popular database engines](https://www.digitalocean.com/products/managed-databases) [App Platform Publish code directly to DigitalOcean servers](https://www.digitalocean.com/products/app-platform) [Gradient™ AI GPU Droplets GPU-powered virtual machines to build and run AI apps](https://www.digitalocean.com/products/gradient/gpu-droplets) [Kubernetes Fully managed, highly available K8s with autoscale.](https://www.digitalocean.com/products/kubernetes) [Browse all products](https://www.digitalocean.com/products) - Solutions AI/ML CMS Data and IoT Developer Tools Gaming and Media GPU Hosting Security and Networking Startups and SMBs Web and App Platforms [See all solutions](https://www.digitalocean.com/solutions) ### AI/ML [AI HR Knowledge Assistant Deploy AI tools developed for Human Resources](https://www.digitalocean.com/solutions/ai-hr-knowledge-assistant) [AI Code Copilot Write, complete, and review code faster](https://www.digitalocean.com/solutions/ai-code-copilot) [AI Support Ticket Triage Auto-classify and route customer support tickets](https://www.digitalocean.com/solutions/ai-support-ticket-triage) [AI Recommendation Engine Build tools to personalize user experiences](https://www.digitalocean.com/solutions/ai-recommendation-engine) [AI Agent Builder Create, deploy, and manage AI agents for anything](https://www.digitalocean.com/solutions/ai-agent-builder) [Multimodal AI Run models that process multiple data types](https://www.digitalocean.com/solutions/multimodal-ai) [Low-Latency Inference Run AI models quickly and efficiently](https://www.digitalocean.com/solutions/low-latency-inference) Not seeing what you are looking for? [Browse all AI/ML solutions](https://www.digitalocean.com/solutions) [Need help? Talk to an expert](https://www.digitalocean.com/company/contact/sales?referrer=mainmenu/solutions) [Get migration assistance](https://www.digitalocean.com/migrate) - Developers Community Documentation Developer Tools Get Involved Utilities and Help ### Community [Blog The latest product releases and insights from our experts](https://www.digitalocean.com/blog) [CSS Tricks All things web design](https://css-tricks.com/) [The Wave Content to level up your business](https://www.digitalocean.com/resources) [Tutorials Our extensive library of technical articles](https://www.digitalocean.com/community/tutorials) [Q\&A Answers to your cloud and coding questions](https://www.digitalocean.com/community/questions) [YouTube Educational content and tutorials](https://youtube.com/DigitalOcean) [Visit DigitalOcean's Community Site](https://www.digitalocean.com/community) - Partners Become a Partner Marketplace ### Become a Partner [About Partner Pod Discounts, revenue share, and more for businesses](https://www.digitalocean.com/partners/pod) [AI Partner Program Boost your AI business](https://www.digitalocean.com/partners/ai-partner-program) [DigitalOcean Startups Resources and support to propel your startup](https://www.digitalocean.com/startups) [Partners Directory Current list of DigitalOcean Partners](https://www.digitalocean.com/partners/directory) [Customer Stories Customers growing on DigitalOcean](https://www.digitalocean.com/customers) [Need help? Talk to an expert](https://www.digitalocean.com/company/contact/sales?referrer=mainmenu/partners) [Become a Partner](https://www.digitalocean.com/partners/apply) - [Pricing](https://www.digitalocean.com/pricing) - Log in - [Community](https://www.digitalocean.com/api/dynamic-content/v1/login?success_redirect=https%3A%2F%2Fwww.digitalocean.com%2Fcommunity%2Ftutorials%2Fpandas-dropna-drop-null-na-values-from-dataframe&error_redirect=https%3A%2F%2Fwww.digitalocean.com%2Fauth-error&type=login) - [DigitalOcean](https://cloud.digitalocean.com/login) - Sign up - [Community](https://www.digitalocean.com/api/dynamic-content/v1/login?success_redirect=https%3A%2F%2Fwww.digitalocean.com%2Fcommunity%2Ftutorials%2Fpandas-dropna-drop-null-na-values-from-dataframe&error_redirect=https%3A%2F%2Fwww.digitalocean.com%2Fauth-error&type=register) - [DigitalOcean](https://cloud.digitalocean.com/registrations/new) - Log in - [Community](https://www.digitalocean.com/api/dynamic-content/v1/login?success_redirect=https%3A%2F%2Fwww.digitalocean.com%2Fcommunity%2Ftutorials%2Fpandas-dropna-drop-null-na-values-from-dataframe&error_redirect=https%3A%2F%2Fwww.digitalocean.com%2Fauth-error&type=login) - [DigitalOcean](https://cloud.digitalocean.com/login) - Sign up - [Community](https://www.digitalocean.com/api/dynamic-content/v1/login?success_redirect=https%3A%2F%2Fwww.digitalocean.com%2Fcommunity%2Ftutorials%2Fpandas-dropna-drop-null-na-values-from-dataframe&error_redirect=https%3A%2F%2Fwww.digitalocean.com%2Fauth-error&type=register) - [DigitalOcean](https://cloud.digitalocean.com/registrations/new) - [Tutorials](https://www.digitalocean.com/community/tutorials) - [Questions](https://www.digitalocean.com/community/questions) - [Product Docs](https://docs.digitalocean.com/) - Search Community ## Report this What is the reason for this report? This undefined is spam This undefined is offensive This undefined is off-topic This undefined is other Submit ## Table of contents 1. [Syntax](https://www.digitalocean.com/community/tutorials/pandas-dropna-drop-null-na-values-from-dataframe#syntax) 2. [Constructing Sample DataFrames](https://www.digitalocean.com/community/tutorials/pandas-dropna-drop-null-na-values-from-dataframe#constructing-sample-dataframes) 3. [Dropping All Rows with Missing Values](https://www.digitalocean.com/community/tutorials/pandas-dropna-drop-null-na-values-from-dataframe#dropping-all-rows-with-missing-values) 4. [Dropping All Columns with Missing Values](https://www.digitalocean.com/community/tutorials/pandas-dropna-drop-null-na-values-from-dataframe#dropping-all-columns-with-missing-values) 5. [Dropping Rows or Columns if all the Values are Null with how](https://www.digitalocean.com/community/tutorials/pandas-dropna-drop-null-na-values-from-dataframe#dropping-rows-or-columns-if-all-the-values-are-null-with-how) 6. [Dropping Rows or Columns if a Threshold is Crossed with thresh](https://www.digitalocean.com/community/tutorials/pandas-dropna-drop-null-na-values-from-dataframe#dropping-rows-or-columns-if-a-threshold-is-crossed-with-thresh) 7. [Dropping Rows or Columns for Specific subsets](https://www.digitalocean.com/community/tutorials/pandas-dropna-drop-null-na-values-from-dataframe#dropping-rows-or-columns-for-specific-subsets) 8. [Changing the source DataFrame after Dropping Rows or Columns with inplace](https://www.digitalocean.com/community/tutorials/pandas-dropna-drop-null-na-values-from-dataframe#changing-the-source-dataframe-after-dropping-rows-or-columns-with-inplace) 9. [Conclusion](https://www.digitalocean.com/community/tutorials/pandas-dropna-drop-null-na-values-from-dataframe#conclusion) 1. [Tutorials](https://www.digitalocean.com/community/tutorials?subtype=tutorial) 2. [Pandas](https://www.digitalocean.com/community/tags/pandas) 3. How To Use Python pandas dropna() to Drop NA Values from DataFrame [Tutorial](https://www.digitalocean.com/community/tutorials?subtype=tutorial) # How To Use Python pandas dropna() to Drop NA Values from DataFrame Published on August 3, 2022 [Pandas](https://www.digitalocean.com/community/tags/pandas) [Python](https://www.digitalocean.com/community/tags/python) ![Pankaj Kumar](https://www.gravatar.com/avatar/dcb62410bd20fd354c21af393bec6e67b235a09758848745cfd4405e05bba1f4?default=retro&size=256)![Bradley Kouchi](https://www.gravatar.com/avatar/1c15a76c8f5e79c35d1ce6c479888827d77e10dac512f9476549d036ca44fc17?default=retro&size=256) By [Pankaj Kumar](https://www.digitalocean.com/community/users/pankajkumarjournaldev) and [Bradley Kouchi](https://www.digitalocean.com/community/users/bkouchido) ![How To Use Python pandas dropna() to Drop NA Values from DataFrame](https://www.digitalocean.com/api/static-content/v1/images?src=https%3A%2F%2Fjournaldev.nyc3.cdn.digitaloceanspaces.com%2F2019%2F11%2Fpandas-dropna.png&width=1920) Table of contents Popular topics ### [Introduction](https://www.digitalocean.com/community/tutorials/pandas-dropna-drop-null-na-values-from-dataframe#introduction) In this tutorial, you’ll learn how to use panda’s DataFrame `dropna()` function. `NA` values are “Not Available”. This can apply to `Null`, `None`, `pandas.NaT`, or `numpy.nan`. Using `dropna()` will drop the rows and columns with these values. This can be beneficial to provide you with only valid data. By default, this function returns a new DataFrame and the source DataFrame remains unchanged. This tutorial was verified with Python 3.10.9, pandas 1.5.2, and NumPy 1.24.1. ## [Syntax](https://www.digitalocean.com/community/tutorials/pandas-dropna-drop-null-na-values-from-dataframe#syntax) `dropna()` takes the following parameters: ``` dropna(self, axis=0, how="any", thresh=None, subset=None, inplace=False) ``` Copy - `axis`: `{0 (or 'index'), 1 (or 'columns')}, default 0` - If `0`, drop rows with missing values. - If `1`, drop columns with missing values. - `how`: `{'any', 'all'}, default 'any'` - If `'any'`, drop the row or column if any of the values is `NA`. - If `'all'`, drop the row or column if all of the values are `NA`. - `thresh`: (optional) an `int` value to specify the threshold for the drop operation. - `subset`: (optional) column label or sequence of labels to specify rows or columns. - `inplace`: (optional) a `bool` value. - If `True`, the source DataFrame is changed and `None` is returned. ## [Constructing Sample DataFrames](https://www.digitalocean.com/community/tutorials/pandas-dropna-drop-null-na-values-from-dataframe#constructing-sample-dataframes) Construct a sample DataFrame that contains valid and invalid values: dropnaExample.py ``` import pandas as pd import numpy as np d1 = { 'Name': ['Shark', 'Whale', 'Jellyfish', 'Starfish'], 'ID': [1, 2, 3, 4], 'Population': [100, 200, np.nan, pd.NaT], 'Regions': [1, None, pd.NaT, pd.NaT] } df1 = pd.DataFrame(d1) print(df1) ``` Copy This code will print out the DataFrame: ``` OutputName ID Population Regions 0 Shark 1 100 1 1 Whale 2 200 None 2 Jellyfish 3 NaN NaT 3 Starfish 4 NaT NaT ``` Then add a second DataFrame with additional rows and columns with `NA` values: ``` d2 = { 'Name': ['Shark', 'Whale', 'Jellyfish', 'Starfish', pd.NaT], 'ID': [1, 2, 3, 4, pd.NaT], 'Population': [100, 200, np.nan, pd.NaT, pd.NaT], 'Regions': [1, None, pd.NaT, pd.NaT, pd.NaT], 'Endangered': [pd.NaT, pd.NaT, pd.NaT, pd.NaT, pd.NaT] } df2 = pd.DataFrame(d2) print(df2) ``` Copy This will output a new DataFrame: ``` OutputName ID Population Regions Endangered 0 Shark 1 100 1 NaT 1 Whale 2 200 None NaT 2 Jellyfish 3 NaN NaT NaT 3 Starfish 4 NaT NaT NaT 4 NaT NaT NaT NaT NaT ``` You will use the preceding DataFrames in the examples that follow. ## [Dropping All Rows with Missing Values](https://www.digitalocean.com/community/tutorials/pandas-dropna-drop-null-na-values-from-dataframe#dropping-all-rows-with-missing-values) Use `dropna()` to remove rows with any `None`, `NaN`, or `NaT` values: dropnaExample.py ``` dfresult = df1.dropna() print(dfresult) ``` Copy This will output: ``` OutputName ID Population Regions 0 Shark 1 100 1 ``` A new DataFrame with a single row that didn’t contain any `NA` values. ## [Dropping All Columns with Missing Values](https://www.digitalocean.com/community/tutorials/pandas-dropna-drop-null-na-values-from-dataframe#dropping-all-columns-with-missing-values) Use `dropna()` with `axis=1` to remove columns with any `None`, `NaN`, or `NaT` values: ``` dfresult = df1.dropna(axis=1) print(dfresult) ``` Copy The columns with any `None`, `NaN`, or `NaT` values will be dropped: ``` OutputName ID 0 Shark 1 1 Whale 2 2 Jellyfish 3 3 Starfish 4 ``` A new DataFrame with a single column that contained non-`NA` values. ## [Dropping Rows or Columns if `all` the Values are `Null` with `how`](https://www.digitalocean.com/community/tutorials/pandas-dropna-drop-null-na-values-from-dataframe#dropping-rows-or-columns-if-all-the-values-are-null-with-how) Use the second DataFrame and `how`: dropnaExample.py ``` dfresult = df2.dropna(how='all') print(dfresult) ``` Copy The rows with `all` values equal to `NA` will be dropped: ``` OutputName ID Population Regions Endangered 0 Shark 1 100 1 NaT 1 Whale 2 200 None NaT 2 Jellyfish 3 NaN NaT NaT 3 Starfish 4 NaT NaT NaT ``` The fifth row was dropped. Next, use `how` and specify the `axis`: dropnaExample.py ``` dfresult = df2.dropna(how='all', axis=1) print(dfresult) ``` Copy The columns with `all` values equal to `NA` will be dropped: ``` OutputName ID Population Regions 0 Shark 1 100 1 1 Whale 2 200 None 2 Jellyfish 3 NaN NaT 3 Starfish 4 NaT NaT 4 NaT NaT NaT NaT ``` The fifth column was dropped. ## [Dropping Rows or Columns if a Threshold is Crossed with `thresh`](https://www.digitalocean.com/community/tutorials/pandas-dropna-drop-null-na-values-from-dataframe#dropping-rows-or-columns-if-a-threshold-is-crossed-with-thresh) Use the second DataFrame with `thresh` to drop rows that do not meet the threshold of at least `3` non-`NA` values: dropnaExample.py ``` dfresult = df2.dropna(thresh=3) print(dfresult) ``` Copy The rows do not have at least `3` non-`NA` will be dropped: ``` OutputName ID Population Regions Endangered 0 Shark 1 100 1 NaT 1 Whale 2 200 None NaT ``` The third, fourth, and fifth rows were dropped. ## [Dropping Rows or Columns for Specific `subsets`](https://www.digitalocean.com/community/tutorials/pandas-dropna-drop-null-na-values-from-dataframe#dropping-rows-or-columns-for-specific-subsets) Use the second DataFrame with `subset` to drop rows with `NA` values in the `Population` column: dropnaExample.py ``` dfresult = df2.dropna(subset=['Population']) print(dfresult) ``` Copy The rows that have `Population` with `NA` values will be dropped: ``` OutputName ID Population Regions Endangered 0 Shark 1 100 1 NaT 1 Whale 2 200 None NaT ``` The third, fourth, and fifth rows were dropped. You can also specify the `index` values in the `subset` when dropping columns from the DataFrame: dropnaExample.py ``` dfresult = df2.dropna(subset=[1, 2], axis=1) print(dfresult) ``` Copy The columns that contain `NA` values in subset of rows `1` and `2`: ``` OutputName ID 0 Shark 1 1 Whale 2 2 Jellyfish 3 3 Starfish 4 4 NaT NaT ``` The third, fourth, and fifth columns were dropped. ## [Changing the source DataFrame after Dropping Rows or Columns with `inplace`](https://www.digitalocean.com/community/tutorials/pandas-dropna-drop-null-na-values-from-dataframe#changing-the-source-dataframe-after-dropping-rows-or-columns-with-inplace) By default, `dropna()` does not modify the source DataFrame. However, in some cases, you may wish to save memory when working with a large source DataFrame by using `inplace`. dropnaExample.py ``` df1.dropna(inplace=True) print(df1) ``` Copy This code does not use a `dfresult` variable. This will output: ``` OutputName ID Population Regions 0 Shark 1 100 1 ``` The original DataFrame has been modified. ## [Conclusion](https://www.digitalocean.com/community/tutorials/pandas-dropna-drop-null-na-values-from-dataframe#conclusion) In this article, you used the `dropna()` function to remove rows and columns with `NA` values. Continue your learning with more Python and pandas tutorials - [Python pandas Module Tutorial](https://www.digitalocean.com/community/tutorials/python-pandas-module-tutorial), [pandas Drop Duplicate Rows](https://www.digitalocean.com/community/tutorials/pandas-drop-duplicate-rows-drop_duplicates-function). References - [pandas DataFrame `dropna()` API Doc](https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.DataFrame.dropna.html) Thanks for learning with the DigitalOcean Community. Check out our offerings for compute, storage, networking, and managed databases. [Learn more about our products](https://www.digitalocean.com/products "Learn more about our products") ### About the author(s) ![Pankaj Kumar](https://www.gravatar.com/avatar/dcb62410bd20fd354c21af393bec6e67b235a09758848745cfd4405e05bba1f4?default=retro&size=256) Pankaj Kumar Author [See author profile](https://www.digitalocean.com/community/users/pankajkumarjournaldev) Java and Python Developer for 20+ years, Open Source Enthusiast, Founder of https://www.askpython.com/, https://www.linuxfordevices.com/, and JournalDev.com (acquired by DigitalOcean). Passionate about writing technical articles and sharing knowledge with others. Love Java, Python, Unix and related technologies. Follow my X @PankajWebDev [See author profile](https://www.digitalocean.com/community/users/pankajkumarjournaldev) ![Bradley Kouchi](https://www.gravatar.com/avatar/1c15a76c8f5e79c35d1ce6c479888827d77e10dac512f9476549d036ca44fc17?default=retro&size=256) Bradley Kouchi Editor [See author profile](https://www.digitalocean.com/community/users/bkouchido) [See author profile](https://www.digitalocean.com/community/users/bkouchido) Category: [Tutorial](https://www.digitalocean.com/community/tutorials?subtype=tutorial) Tags: [Pandas](https://www.digitalocean.com/community/tags/pandas) [Python](https://www.digitalocean.com/community/tags/python) #### Still looking for an answer? [Ask a question](https://www.digitalocean.com/community/questions)[Search for more help](https://www.digitalocean.com/community) Was this helpful? Yes No Comments(2) Follow-up questions(0) ![JournalDev](https://www.gravatar.com/avatar/7c7a4546c8430a5a91a338a177bf8e7e8e153fe7eaee076acfa6d46029efef49?default=retro) [JournalDev](https://www.digitalocean.com/community/users/journaldev)![DigitalOcean Employee badge](https://www.digitalocean.com/api/static-content/v1/images?src=%2F_next%2Fstatic%2Fmedia%2Fdo-logo.15453cf1.svg&width=32) [February 12, 2021](https://www.digitalocean.com/community/tutorials/pandas-dropna-drop-null-na-values-from-dataframe?comment=177699) Show less thats very comprehensive. out of all drop explanation … this is the best thank you \- johny ![JournalDev](https://www.gravatar.com/avatar/7c7a4546c8430a5a91a338a177bf8e7e8e153fe7eaee076acfa6d46029efef49?default=retro) [JournalDev](https://www.digitalocean.com/community/users/journaldev)![DigitalOcean Employee badge](https://www.digitalocean.com/api/static-content/v1/images?src=%2F_next%2Fstatic%2Fmedia%2Fdo-logo.15453cf1.svg&width=32) [May 11, 2021](https://www.digitalocean.com/community/tutorials/pandas-dropna-drop-null-na-values-from-dataframe?comment=177700) Show less Thank u bro, well explained in very simple way \- KHAJA MOINUDDIN KHAN [![Creative Commons](https://www.digitalocean.com/api/static-content/v1/images?src=%2F_next%2Fstatic%2Fmedia%2Fcreativecommons.c0a877f1.png&width=384)](https://creativecommons.org/licenses/by-nc-sa/4.0/)This work is licensed under a Creative Commons Attribution-NonCommercial- ShareAlike 4.0 International License. ## Deploy on DigitalOcean Click below to sign up for DigitalOcean's virtual machines, Databases, and AIML products. [Sign up](https://cloud.digitalocean.com/registrations/new?refcode=f6fcd01aaffb) ## Popular Topics 1. [AI/ML](https://www.digitalocean.com/community/tags/ai-ml) 2. [Ubuntu](https://www.digitalocean.com/community/tags/ubuntu) 3. [Linux Basics](https://www.digitalocean.com/community/tags/linux-basics) 4. [JavaScript](https://www.digitalocean.com/community/tags/javascript) 5. [Python](https://www.digitalocean.com/community/tags/python) 6. [MySQL](https://www.digitalocean.com/community/tags/mysql) 7. [Docker](https://www.digitalocean.com/community/tags/docker) 8. [Kubernetes](https://www.digitalocean.com/community/tags/kubernetes) 9. [All tutorials](https://www.digitalocean.com/community/tutorials) 10. [Talk to an expert](https://www.digitalocean.com/company/contact/sales?referrer=tutorials) ### Connect on Discord Join the conversation in our Discord to connect with fellow developers [Visit Discord](https://discord.gg/digitalocean) ## Featured tutorials 1. [SOLID Design Principles Explained: Building Better Software Architecture](https://www.digitalocean.com/community/tutorials/s-o-l-i-d-the-first-five-principles-of-object-oriented-design) 2. [How To Remove Docker Images, Containers, and Volumes](https://www.digitalocean.com/community/tutorials/how-to-remove-docker-images-containers-and-volumes) 3. [How to Create a MySQL User and Grant Privileges (Step-by-Step)](https://www.digitalocean.com/community/tutorials/how-to-create-a-new-user-and-grant-permissions-in-mysql) - [All tutorials](https://www.digitalocean.com/community/tutorials) - [All topic tags](https://www.digitalocean.com/community/tags) ##### Join the Tech Talk - [Syntax](https://www.digitalocean.com/community/tutorials/pandas-dropna-drop-null-na-values-from-dataframe#syntax) - [Constructing Sample DataFrames](https://www.digitalocean.com/community/tutorials/pandas-dropna-drop-null-na-values-from-dataframe#constructing-sample-dataframes) - [Dropping All Rows with Missing Values](https://www.digitalocean.com/community/tutorials/pandas-dropna-drop-null-na-values-from-dataframe#dropping-all-rows-with-missing-values) - [Dropping All Columns with Missing Values](https://www.digitalocean.com/community/tutorials/pandas-dropna-drop-null-na-values-from-dataframe#dropping-all-columns-with-missing-values) - [Dropping Rows or Columns if \`all\` the Values are \`Null\` with \`how\`](https://www.digitalocean.com/community/tutorials/pandas-dropna-drop-null-na-values-from-dataframe#dropping-rows-or-columns-if-all-the-values-are-null-with-how) - [Dropping Rows or Columns if a Threshold is Crossed with \`thresh\`](https://www.digitalocean.com/community/tutorials/pandas-dropna-drop-null-na-values-from-dataframe#dropping-rows-or-columns-if-a-threshold-is-crossed-with-thresh) - [Dropping Rows or Columns for Specific \`subsets\`](https://www.digitalocean.com/community/tutorials/pandas-dropna-drop-null-na-values-from-dataframe#dropping-rows-or-columns-for-specific-subsets) - [Changing the source DataFrame after Dropping Rows or Columns with \`inplace\`](https://www.digitalocean.com/community/tutorials/pandas-dropna-drop-null-na-values-from-dataframe#changing-the-source-dataframe-after-dropping-rows-or-columns-with-inplace) - [Conclusion](https://www.digitalocean.com/community/tutorials/pandas-dropna-drop-null-na-values-from-dataframe#conclusion) - ## Deploy on DigitalOcean Click below to sign up for DigitalOcean's virtual machines, Databases, and AIML products. [Sign up](https://cloud.digitalocean.com/registrations/new?refcode=f6fcd01aaffb) ## Popular Topics 1. [AI/ML](https://www.digitalocean.com/community/tags/ai-ml) 2. [Ubuntu](https://www.digitalocean.com/community/tags/ubuntu) 3. [Linux Basics](https://www.digitalocean.com/community/tags/linux-basics) 4. [JavaScript](https://www.digitalocean.com/community/tags/javascript) 5. [Python](https://www.digitalocean.com/community/tags/python) 6. [MySQL](https://www.digitalocean.com/community/tags/mysql) 7. [Docker](https://www.digitalocean.com/community/tags/docker) 8. [Kubernetes](https://www.digitalocean.com/community/tags/kubernetes) 9. [All tutorials](https://www.digitalocean.com/community/tutorials) 10. [Talk to an expert](https://www.digitalocean.com/company/contact/sales?referrer=tutorials) ### Connect on Discord Join the conversation in our Discord to connect with fellow developers [Visit Discord](https://discord.gg/digitalocean) ## Featured tutorials 1. [SOLID Design Principles Explained: Building Better Software Architecture](https://www.digitalocean.com/community/tutorials/s-o-l-i-d-the-first-five-principles-of-object-oriented-design) 2. [How To Remove Docker Images, Containers, and Volumes](https://www.digitalocean.com/community/tutorials/how-to-remove-docker-images-containers-and-volumes) 3. [How to Create a MySQL User and Grant Privileges (Step-by-Step)](https://www.digitalocean.com/community/tutorials/how-to-create-a-new-user-and-grant-permissions-in-mysql) - [All tutorials](https://www.digitalocean.com/community/tutorials) - [All topic tags](https://www.digitalocean.com/community/tags) ![](https://www.digitalocean.com/api/static-content/v1/images?src=%2F_next%2Fstatic%2Fmedia%2Ftutorials-2-tulip.764b9f59.svg&width=1920) ## Become a contributor for community Get paid to write technical tutorials and select a tech-focused charity to receive a matching donation. [Sign Up](https://www.digitalocean.com/community/pages/write-for-digitalocean) ![](https://www.digitalocean.com/api/static-content/v1/images?src=%2F_next%2Fstatic%2Fmedia%2Fdocs-2-kiwi.239a03ef.svg&width=1920) ## DigitalOcean Documentation Full documentation for every DigitalOcean product. [Learn more](https://docs.digitalocean.com/) ![](https://www.digitalocean.com/api/static-content/v1/images?src=%2F_next%2Fstatic%2Fmedia%2Fblogs-1-lavender.495d1f00.svg&width=1920) ## Resources for startups and AI-native businesses The Wave has everything you need to know about building a business, from raising funding to marketing your product. [Learn more](https://www.digitalocean.com/resources) ## Get our newsletter Stay up to date by signing up for DigitalOcean’s Infrastructure as a Newsletter. New accounts only. By submitting your email you agree to our [Privacy Policy](https://www.digitalocean.com/legal/privacy-policy) ## The developer cloud Scale up as you grow — whether you're running one virtual machine or ten thousand. [View all products](https://www.digitalocean.com/products) ![](https://www.digitalocean.com/api/static-content/v1/images?src=%2F_next%2Fstatic%2Fmedia%2Fclouds-mobile.5d14bead.svg&width=3840) ## Start building today From GPU-powered inference and Kubernetes to managed databases and storage, get everything you need to build, scale, and deploy intelligent applications. [Sign up](https://cloud.digitalocean.com/registrations/new) ![](https://www.digitalocean.com/api/static-content/v1/images?src=%2F_next%2Fstatic%2Fmedia%2Fwaves-mobile.a054c63e.svg&width=3840) ## Company - [About](https://www.digitalocean.com/about) - [Leadership](https://www.digitalocean.com/leadership/executive-management) - [Blog](https://www.digitalocean.com/blog) - [Careers](https://www.digitalocean.com/careers) - [Customers](https://www.digitalocean.com/customers) - [Partners](https://www.digitalocean.com/partners) - [Referral Program](https://www.digitalocean.com/referral-program) - [Affiliate Program](https://www.digitalocean.com/affiliates) - [Press](https://www.digitalocean.com/press) - [Legal](https://www.digitalocean.com/legal) - [Privacy Policy](https://www.digitalocean.com/legal/privacy-policy) - [Security](https://www.digitalocean.com/security) - [Investor Relations](https://investors.digitalocean.com/) ## Products - [Gradient™ AI GPU Droplets](https://www.digitalocean.com/products/gradient/gpu-droplets) - [Gradient™ AI Bare Metal GPUs](https://www.digitalocean.com/products/gradient/bare-metal-gpus) - [Gradient™ AI 1-Click Models](https://www.digitalocean.com/products/gradient/1-click-models) - [Gradient™ AI Platform](https://www.digitalocean.com/products/gradient/platform) - [Droplets](https://www.digitalocean.com/products/droplets) - [Kubernetes](https://www.digitalocean.com/products/kubernetes) - [Functions](https://www.digitalocean.com/products/functions) - [App Platform](https://www.digitalocean.com/products/app-platform) - [Load Balancers](https://www.digitalocean.com/products/load-balancers) - [Managed Databases](https://www.digitalocean.com/products/managed-databases) - [Spaces](https://www.digitalocean.com/products/spaces) - [Block Storage](https://www.digitalocean.com/products/block-storage) - [Network File Storage](https://www.digitalocean.com/products/storage/network-file-storage) - [API](https://docs.digitalocean.com/reference/api) - [Uptime](https://www.digitalocean.com/products/uptime-monitoring) - [Cloud Security Posture Management (CSPM)](https://www.digitalocean.com/products/cloud-security-posture-management) - [Identity and Access Management (IAM)](https://www.digitalocean.com/products/identity-access-management) - [Cloudways](https://www.digitalocean.com/products/cloudways) - [View all Products](https://www.digitalocean.com/products) ## Resources - [Community Tutorials](https://www.digitalocean.com/community/tutorials) - [Community Q\&A](https://www.digitalocean.com/community/questions) - [CSS-Tricks](https://css-tricks.com/) - [Write for DOnations](https://www.digitalocean.com/community/pages/write-for-digitalocean) - [Currents Research](https://www.digitalocean.com/currents) - [DigitalOcean Startups](https://www.digitalocean.com/startups) - [Wavemakers Program](https://www.digitalocean.com/wavemakers) - [Compass Council](https://www.digitalocean.com/research) - [Open Source](https://www.digitalocean.com/open-source) - [Newsletter Signup](https://www.digitalocean.com/community#iaan) - [Marketplace](https://www.digitalocean.com/products/marketplace) - [Pricing](https://www.digitalocean.com/pricing) - [Pricing Calculator](https://www.digitalocean.com/pricing/calculator) - [Documentation](https://docs.digitalocean.com/) - [Release Notes](https://docs.digitalocean.com/release-notes) - [Code of Conduct](https://www.digitalocean.com/community/pages/code-of-conduct) - [Shop Swag](http://store.digitalocean.com/) ## Solutions - [AI GPU Hosting](https://www.digitalocean.com/solutions/ai-gpu-hosting) - [H100 Cloud GPU](https://www.digitalocean.com/solutions/h100-cloud-gpu) - [AI Training GPU](https://www.digitalocean.com/solutions/ai-training-gpu) - [GPU Inference](https://www.digitalocean.com/solutions/gpu-inference) - [VPS Hosting](https://www.digitalocean.com/solutions/vps-hosting) - [Website Hosting](https://www.digitalocean.com/solutions/website-hosting) - [VPN](https://www.digitalocean.com/solutions/vpn) - [Docker Hosting](https://www.digitalocean.com/solutions/docker-hosting) - [Node.js Hosting](https://www.digitalocean.com/solutions/nodejs-hosting) - [Web Mobile Apps](https://www.digitalocean.com/solutions/web-mobile-apps) - [WordPress Hosting](https://www.digitalocean.com/solutions/wordpress-hosting) - [Virtual Machines](https://www.digitalocean.com/solutions/virtual-machines) - [View all Solutions](https://www.digitalocean.com/solutions) ## Contact - [Support](https://www.digitalocean.com/support) - [Sales](https://www.digitalocean.com/company/contact/sales?referrer=footer) - [Report Abuse](https://www.digitalocean.com/company/contact/abuse) - [System Status](https://status.digitalocean.com/) - [Share your ideas](https://ideas.digitalocean.com/) ## Company - [About](https://www.digitalocean.com/about) - [Leadership](https://www.digitalocean.com/leadership/executive-management) - [Blog](https://www.digitalocean.com/blog) - [Careers](https://www.digitalocean.com/careers) - [Customers](https://www.digitalocean.com/customers) - [Partners](https://www.digitalocean.com/partners) - [Referral Program](https://www.digitalocean.com/referral-program) - [Affiliate Program](https://www.digitalocean.com/affiliates) - [Press](https://www.digitalocean.com/press) - [Legal](https://www.digitalocean.com/legal) - [Privacy Policy](https://www.digitalocean.com/legal/privacy-policy) - [Security](https://www.digitalocean.com/security) - [Investor Relations](https://investors.digitalocean.com/) ## Products - [Gradient™ AI GPU Droplets](https://www.digitalocean.com/products/gradient/gpu-droplets) - [Gradient™ AI Bare Metal GPUs](https://www.digitalocean.com/products/gradient/bare-metal-gpus) - [Gradient™ AI 1-Click Models](https://www.digitalocean.com/products/gradient/1-click-models) - [Gradient™ AI Platform](https://www.digitalocean.com/products/gradient/platform) - [Droplets](https://www.digitalocean.com/products/droplets) - [Kubernetes](https://www.digitalocean.com/products/kubernetes) - [Functions](https://www.digitalocean.com/products/functions) - [App Platform](https://www.digitalocean.com/products/app-platform) - [Load Balancers](https://www.digitalocean.com/products/load-balancers) - [Managed Databases](https://www.digitalocean.com/products/managed-databases) - [Spaces](https://www.digitalocean.com/products/spaces) - [Block Storage](https://www.digitalocean.com/products/block-storage) - [Network File Storage](https://www.digitalocean.com/products/storage/network-file-storage) - [API](https://docs.digitalocean.com/reference/api) - [Uptime](https://www.digitalocean.com/products/uptime-monitoring) - [Cloud Security Posture Management (CSPM)](https://www.digitalocean.com/products/cloud-security-posture-management) - [Identity and Access Management (IAM)](https://www.digitalocean.com/products/identity-access-management) - [Cloudways](https://www.digitalocean.com/products/cloudways) - [View all Products](https://www.digitalocean.com/products) ## Resources - [Community Tutorials](https://www.digitalocean.com/community/tutorials) - [Community Q\&A](https://www.digitalocean.com/community/questions) - [CSS-Tricks](https://css-tricks.com/) - [Write for DOnations](https://www.digitalocean.com/community/pages/write-for-digitalocean) - [Currents Research](https://www.digitalocean.com/currents) - [DigitalOcean Startups](https://www.digitalocean.com/startups) - [Wavemakers Program](https://www.digitalocean.com/wavemakers) - [Compass Council](https://www.digitalocean.com/research) - [Open Source](https://www.digitalocean.com/open-source) - [Newsletter Signup](https://www.digitalocean.com/community#iaan) - [Marketplace](https://www.digitalocean.com/products/marketplace) - [Pricing](https://www.digitalocean.com/pricing) - [Pricing Calculator](https://www.digitalocean.com/pricing/calculator) - [Documentation](https://docs.digitalocean.com/) - [Release Notes](https://docs.digitalocean.com/release-notes) - [Code of Conduct](https://www.digitalocean.com/community/pages/code-of-conduct) - [Shop Swag](http://store.digitalocean.com/) ## Solutions - [AI GPU Hosting](https://www.digitalocean.com/solutions/ai-gpu-hosting) - [H100 Cloud GPU](https://www.digitalocean.com/solutions/h100-cloud-gpu) - [AI Training GPU](https://www.digitalocean.com/solutions/ai-training-gpu) - [GPU Inference](https://www.digitalocean.com/solutions/gpu-inference) - [VPS Hosting](https://www.digitalocean.com/solutions/vps-hosting) - [Website Hosting](https://www.digitalocean.com/solutions/website-hosting) - [VPN](https://www.digitalocean.com/solutions/vpn) - [Docker Hosting](https://www.digitalocean.com/solutions/docker-hosting) - [Node.js Hosting](https://www.digitalocean.com/solutions/nodejs-hosting) - [Web Mobile Apps](https://www.digitalocean.com/solutions/web-mobile-apps) - [WordPress Hosting](https://www.digitalocean.com/solutions/wordpress-hosting) - [Virtual Machines](https://www.digitalocean.com/solutions/virtual-machines) - [View all Solutions](https://www.digitalocean.com/solutions) ## Contact - [Support](https://www.digitalocean.com/support) - [Sales](https://www.digitalocean.com/company/contact/sales?referrer=footer) - [Report Abuse](https://www.digitalocean.com/company/contact/abuse) - [System Status](https://status.digitalocean.com/) - [Share your ideas](https://ideas.digitalocean.com/) © 2026 DigitalOcean, LLC.[Sitemap](https://www.digitalocean.com/sitemap).[Cookie Preferences]() This site uses cookies and related technologies, as described in our [privacy policy](https://www.digitalocean.com/legal/privacy-policy/), for purposes that may include site operation, analytics, enhanced user experience, or advertising. You may choose to consent to our use of these technologies, or manage your own preferences. Please visit our [cookie policy](https://www.digitalocean.com/legal/cookie-policy) for more information. Agree & Proceed Decline All Manage Choices Loading... ## Community ## Product Docs ## Marketplace ## DigitalOcean Blog navigate go exit
Readable Markdown	### [Introduction](https://www.digitalocean.com/community/tutorials/pandas-dropna-drop-null-na-values-from-dataframe#introduction) In this tutorial, you’ll learn how to use panda’s DataFrame `dropna()` function. `NA` values are “Not Available”. This can apply to `Null`, `None`, `pandas.NaT`, or `numpy.nan`. Using `dropna()` will drop the rows and columns with these values. This can be beneficial to provide you with only valid data. By default, this function returns a new DataFrame and the source DataFrame remains unchanged. This tutorial was verified with Python 3.10.9, pandas 1.5.2, and NumPy 1.24.1. ## [Syntax](https://www.digitalocean.com/community/tutorials/pandas-dropna-drop-null-na-values-from-dataframe#syntax) `dropna()` takes the following parameters: ``` dropna(self, axis=0, how="any", thresh=None, subset=None, inplace=False) ``` - `axis`: `{0 (or 'index'), 1 (or 'columns')}, default 0` - If `0`, drop rows with missing values. - If `1`, drop columns with missing values. - `how`: `{'any', 'all'}, default 'any'` - If `'any'`, drop the row or column if any of the values is `NA`. - If `'all'`, drop the row or column if all of the values are `NA`. - `thresh`: (optional) an `int` value to specify the threshold for the drop operation. - `subset`: (optional) column label or sequence of labels to specify rows or columns. - `inplace`: (optional) a `bool` value. - If `True`, the source DataFrame is changed and `None` is returned. ## [Constructing Sample DataFrames](https://www.digitalocean.com/community/tutorials/pandas-dropna-drop-null-na-values-from-dataframe#constructing-sample-dataframes) Construct a sample DataFrame that contains valid and invalid values: dropnaExample.py ``` import pandas as pd import numpy as np d1 = { 'Name': ['Shark', 'Whale', 'Jellyfish', 'Starfish'], 'ID': [1, 2, 3, 4], 'Population': [100, 200, np.nan, pd.NaT], 'Regions': [1, None, pd.NaT, pd.NaT] } df1 = pd.DataFrame(d1) print(df1) ``` This code will print out the DataFrame: ``` OutputName ID Population Regions 0 Shark 1 100 1 1 Whale 2 200 None 2 Jellyfish 3 NaN NaT 3 Starfish 4 NaT NaT ``` Then add a second DataFrame with additional rows and columns with `NA` values: ``` d2 = { 'Name': ['Shark', 'Whale', 'Jellyfish', 'Starfish', pd.NaT], 'ID': [1, 2, 3, 4, pd.NaT], 'Population': [100, 200, np.nan, pd.NaT, pd.NaT], 'Regions': [1, None, pd.NaT, pd.NaT, pd.NaT], 'Endangered': [pd.NaT, pd.NaT, pd.NaT, pd.NaT, pd.NaT] } df2 = pd.DataFrame(d2) print(df2) ``` This will output a new DataFrame: ``` OutputName ID Population Regions Endangered 0 Shark 1 100 1 NaT 1 Whale 2 200 None NaT 2 Jellyfish 3 NaN NaT NaT 3 Starfish 4 NaT NaT NaT 4 NaT NaT NaT NaT NaT ``` You will use the preceding DataFrames in the examples that follow. ## [Dropping All Rows with Missing Values](https://www.digitalocean.com/community/tutorials/pandas-dropna-drop-null-na-values-from-dataframe#dropping-all-rows-with-missing-values) Use `dropna()` to remove rows with any `None`, `NaN`, or `NaT` values: dropnaExample.py ``` dfresult = df1.dropna() print(dfresult) ``` This will output: ``` OutputName ID Population Regions 0 Shark 1 100 1 ``` A new DataFrame with a single row that didn’t contain any `NA` values. ## [Dropping All Columns with Missing Values](https://www.digitalocean.com/community/tutorials/pandas-dropna-drop-null-na-values-from-dataframe#dropping-all-columns-with-missing-values) Use `dropna()` with `axis=1` to remove columns with any `None`, `NaN`, or `NaT` values: ``` dfresult = df1.dropna(axis=1) print(dfresult) ``` The columns with any `None`, `NaN`, or `NaT` values will be dropped: ``` OutputName ID 0 Shark 1 1 Whale 2 2 Jellyfish 3 3 Starfish 4 ``` A new DataFrame with a single column that contained non-`NA` values. ## [Dropping Rows or Columns if `all` the Values are `Null` with `how`](https://www.digitalocean.com/community/tutorials/pandas-dropna-drop-null-na-values-from-dataframe#dropping-rows-or-columns-if-all-the-values-are-null-with-how) Use the second DataFrame and `how`: dropnaExample.py ``` dfresult = df2.dropna(how='all') print(dfresult) ``` The rows with `all` values equal to `NA` will be dropped: ``` OutputName ID Population Regions Endangered 0 Shark 1 100 1 NaT 1 Whale 2 200 None NaT 2 Jellyfish 3 NaN NaT NaT 3 Starfish 4 NaT NaT NaT ``` The fifth row was dropped. Next, use `how` and specify the `axis`: dropnaExample.py ``` dfresult = df2.dropna(how='all', axis=1) print(dfresult) ``` The columns with `all` values equal to `NA` will be dropped: ``` OutputName ID Population Regions 0 Shark 1 100 1 1 Whale 2 200 None 2 Jellyfish 3 NaN NaT 3 Starfish 4 NaT NaT 4 NaT NaT NaT NaT ``` The fifth column was dropped. ## [Dropping Rows or Columns if a Threshold is Crossed with `thresh`](https://www.digitalocean.com/community/tutorials/pandas-dropna-drop-null-na-values-from-dataframe#dropping-rows-or-columns-if-a-threshold-is-crossed-with-thresh) Use the second DataFrame with `thresh` to drop rows that do not meet the threshold of at least `3` non-`NA` values: dropnaExample.py ``` dfresult = df2.dropna(thresh=3) print(dfresult) ``` The rows do not have at least `3` non-`NA` will be dropped: ``` OutputName ID Population Regions Endangered 0 Shark 1 100 1 NaT 1 Whale 2 200 None NaT ``` The third, fourth, and fifth rows were dropped. ## [Dropping Rows or Columns for Specific `subsets`](https://www.digitalocean.com/community/tutorials/pandas-dropna-drop-null-na-values-from-dataframe#dropping-rows-or-columns-for-specific-subsets) Use the second DataFrame with `subset` to drop rows with `NA` values in the `Population` column: dropnaExample.py ``` dfresult = df2.dropna(subset=['Population']) print(dfresult) ``` The rows that have `Population` with `NA` values will be dropped: ``` OutputName ID Population Regions Endangered 0 Shark 1 100 1 NaT 1 Whale 2 200 None NaT ``` The third, fourth, and fifth rows were dropped. You can also specify the `index` values in the `subset` when dropping columns from the DataFrame: dropnaExample.py ``` dfresult = df2.dropna(subset=[1, 2], axis=1) print(dfresult) ``` The columns that contain `NA` values in subset of rows `1` and `2`: ``` OutputName ID 0 Shark 1 1 Whale 2 2 Jellyfish 3 3 Starfish 4 4 NaT NaT ``` The third, fourth, and fifth columns were dropped. ## [Changing the source DataFrame after Dropping Rows or Columns with `inplace`](https://www.digitalocean.com/community/tutorials/pandas-dropna-drop-null-na-values-from-dataframe#changing-the-source-dataframe-after-dropping-rows-or-columns-with-inplace) By default, `dropna()` does not modify the source DataFrame. However, in some cases, you may wish to save memory when working with a large source DataFrame by using `inplace`. dropnaExample.py ``` df1.dropna(inplace=True) print(df1) ``` This code does not use a `dfresult` variable. This will output: ``` OutputName ID Population Regions 0 Shark 1 100 1 ``` The original DataFrame has been modified. ## [Conclusion](https://www.digitalocean.com/community/tutorials/pandas-dropna-drop-null-na-values-from-dataframe#conclusion) In this article, you used the `dropna()` function to remove rows and columns with `NA` values. Continue your learning with more Python and pandas tutorials - [Python pandas Module Tutorial](https://www.digitalocean.com/community/tutorials/python-pandas-module-tutorial), [pandas Drop Duplicate Rows](https://www.digitalocean.com/community/tutorials/pandas-drop-duplicate-rows-drop_duplicates-function). References - [pandas DataFrame `dropna()` API Doc](https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.DataFrame.dropna.html) Was this helpful? [![Creative Commons](https://www.digitalocean.com/api/static-content/v1/images?src=%2F_next%2Fstatic%2Fmedia%2Fcreativecommons.c0a877f1.png&width=384)](https://creativecommons.org/licenses/by-nc-sa/4.0/)This work is licensed under a Creative Commons Attribution-NonCommercial- ShareAlike 4.0 International License.
Shard	83 (laksa)
Root Hash	13428457316079428483
Unparsed URL	com,digitalocean!www,/community/tutorials/pandas-dropna-drop-null-na-values-from-dataframe s443