🕷️ Crawler Inspector

URL Lookup

Direct Parameter Lookup

Raw Queries and Responses

1. Shard Calculation

Query:

Response:

Calculated Shard: 106 (from laksa170)

2. Crawled Status Check

Query:

curl -X POST \
  'http://laksa106.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.includehelp.com/python/pandas-how-to-remove-nan-and-inf-values.aspx\')), getAhrefsUnparsedNoserviceFromURL(\'https://www.includehelp.com/python/pandas-how-to-remove-nan-and-inf-values.aspx\'))) FORMAT JSONEachRow'

Response:

{"found_url":"https:\/\/www.includehelp.com\/python\/pandas-how-to-remove-nan-and-inf-values.aspx","crawl_time":1774587186,"first_indexed_time":1676292954,"http_code":200,"src_unparsed":"com,includehelp!www,\/python\/pandas-how-to-remove-nan-and-inf-values.aspx s443","src_root_hash":"1184066710662109106","history_drop_reason":null,"meta_title":"Python - Pandas: How to remove nan and -inf values?","meta_descriptions":["In this tutorial, we are going to learn how to remove nan and -inf values in Python Pandas?"],"attrs_boilerpipe_text":"Home\n»\nPython\n»\nPython Programs\nLearn, how to remove nan and -inf values in Python Pandas?\nBy\nPranit Sharma\nLast updated : October 06, 2023\nPandas is a special tool that allows us to perform complex manipulations of data effectively and efficiently. Inside pandas, we mostly deal with a dataset in the form of DataFrame.\nDataFrames\nare 2-dimensional data structures in pandas. DataFrames consist of rows, columns, and data.\nProblem statement\nSuppose that we are given a dataframe that contains several rows and columns with\nnan\nand\n-inf\nvalues too. We need to remove these\nnans\nand\n-inf\nvalues for better data analysis.\nRemoving nan and -inf values\nFor this purpose, we will use\npandas.DataFrame.isin()\nand check for rows that have any with\npandas.DataFrame.any()\n. Finally, we will use the boolean array to slice the dataframe.\nLet us understand with the help of an example,\nPython program to remove nan and -inf values from pandas dataframe\n# Importing pandas package\nimport\npandas\nas\npd\n# Import numpy\nimport\nnumpy\nas\nnp\nfrom\nnumpy\nimport\ninf\n# Creating a dataframe\ndf\n=\npd\n.\nDataFrame(data\n=\n{\n'X'\n: [\n1\n,\n1\n,np\n.\nnan],\n'Y'\n: [\n8\n,\n-\ninf,\n7\n],\n'Z'\n: [\n5\n,\n-\ninf,\n4\n],\n'A'\n: [\n3\n,np\n.\nnan,\n7\n]})\n# Display the DataFrame\nprint\n(\n\"Original DataFrame:\n\\n\n\"\n,df,\n\"\n\\n\\n\n\"\n)\n# Removing nan and -inf\nres\n=\ndf[\n~\ndf\n.\nisin([np\n.\nnan,\n-\nnp\n.\ninf])\n.\nany(\n1\n)]\n# Display Result\nprint\n(\n\"Result:\n\\n\n\"\n,res)\nOutput\nThe output of the above program is:\nPython Pandas Programs »\nAdvertisement\nAdvertisement","attrs_markdown":null,"attrs_readable_markdown":"[Home](https:\/\/www.includehelp.com\/default.aspx) » [Python](https:\/\/www.includehelp.com\/python\/default.aspx) » [Python Programs](https:\/\/www.includehelp.com\/python\/programs.aspx)\n\nLearn, how to remove nan and -inf values in Python Pandas?  By [Pranit Sharma](https:\/\/www.includehelp.com\/Members\/Pranit-Sharma.aspx) Last updated : October 06, 2023\n\nPandas is a special tool that allows us to perform complex manipulations of data effectively and efficiently. Inside pandas, we mostly deal with a dataset in the form of DataFrame. [DataFrames](https:\/\/www.includehelp.com\/python\/pandas-dataframe-in-python.aspx) are 2-dimensional data structures in pandas. DataFrames consist of rows, columns, and data.\n\n## Problem statement\nSuppose that we are given a dataframe that contains several rows and columns with *nan* and *\\-inf* values too. We need to remove these *nans* and *\\-inf* values for better data analysis.\n\n## Removing nan and -inf values\nFor this purpose, we will use pandas.DataFrame.isin() and check for rows that have any with pandas.DataFrame.any(). Finally, we will use the boolean array to slice the dataframe.\n\nLet us understand with the help of an example,\n\n## Python program to remove nan and -inf values from pandas dataframe\n```\n\r\n# Importing pandas package\r\nimport pandas as pd\r\n\r\n# Import numpy\r\nimport numpy as np\r\n\r\nfrom numpy import inf\r\n\r\n# Creating a dataframe\r\ndf = pd.DataFrame(data={'X': [1,1,np.nan], 'Y': [8,-inf,7], 'Z': [5,-inf,4],'A': [3,np.nan,7]})\r\n\r\n# Display the DataFrame\r\nprint(\"Original DataFrame:\\n\",df,\"\\n\\n\")\r\n\r\n# Removing nan and -inf\r\nres = df[~df.isin([np.nan, -np.inf]).any(1)]\r\n\r\n# Display Result\r\nprint(\"Result:\\n\",res)\n```\n### Output\nThe output of the above program is:\n\n![Example: Pandas: How to remove nan and -inf values?](https:\/\/www.includehelp.com\/python\/images\/remove-nan-and-inf-values.jpg)\n\n[Python Pandas Programs »](https:\/\/www.includehelp.com\/python\/pandas-programs.aspx)\n\nAdvertisement\n\nAdvertisement","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

13 days 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.5 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.includehelp.com/python/pandas-how-to-remove-nan-and-inf-values.aspx
Last Crawled	2026-03-27 04:53:06 (13 days ago)
First Indexed	2023-02-13 12:55:54 (3 years ago)
HTTP Status Code	200
Meta Title	Python - Pandas: How to remove nan and -inf values?
Meta Description	In this tutorial, we are going to learn how to remove nan and -inf values in Python Pandas?
Meta Canonical	null
Boilerpipe Text	Home » Python » Python Programs Learn, how to remove nan and -inf values in Python Pandas? By Pranit Sharma Last updated : October 06, 2023 Pandas is a special tool that allows us to perform complex manipulations of data effectively and efficiently. Inside pandas, we mostly deal with a dataset in the form of DataFrame. DataFrames are 2-dimensional data structures in pandas. DataFrames consist of rows, columns, and data. Problem statement Suppose that we are given a dataframe that contains several rows and columns with nan and -inf values too. We need to remove these nans and -inf values for better data analysis. Removing nan and -inf values For this purpose, we will use pandas.DataFrame.isin() and check for rows that have any with pandas.DataFrame.any() . Finally, we will use the boolean array to slice the dataframe. Let us understand with the help of an example, Python program to remove nan and -inf values from pandas dataframe # Importing pandas package import pandas as pd # Import numpy import numpy as np from numpy import inf # Creating a dataframe df = pd . DataFrame(data = { 'X' : [ 1 , 1 ,np . nan], 'Y' : [ 8 , - inf, 7 ], 'Z' : [ 5 , - inf, 4 ], 'A' : [ 3 ,np . nan, 7 ]}) # Display the DataFrame print ( "Original DataFrame: \n " ,df, " \n\n " ) # Removing nan and -inf res = df[ ~ df . isin([np . nan, - np . inf]) . any( 1 )] # Display Result print ( "Result: \n " ,res) Output The output of the above program is: Python Pandas Programs » Advertisement Advertisement
Markdown	null
Readable Markdown	[Home](https://www.includehelp.com/default.aspx) » [Python](https://www.includehelp.com/python/default.aspx) » [Python Programs](https://www.includehelp.com/python/programs.aspx) Learn, how to remove nan and -inf values in Python Pandas? By [Pranit Sharma](https://www.includehelp.com/Members/Pranit-Sharma.aspx) Last updated : October 06, 2023 Pandas is a special tool that allows us to perform complex manipulations of data effectively and efficiently. Inside pandas, we mostly deal with a dataset in the form of DataFrame. [DataFrames](https://www.includehelp.com/python/pandas-dataframe-in-python.aspx) are 2-dimensional data structures in pandas. DataFrames consist of rows, columns, and data. ## Problem statement Suppose that we are given a dataframe that contains several rows and columns with nan and \-inf values too. We need to remove these nans and \-inf values for better data analysis. ## Removing nan and -inf values For this purpose, we will use pandas.DataFrame.isin() and check for rows that have any with pandas.DataFrame.any(). Finally, we will use the boolean array to slice the dataframe. Let us understand with the help of an example, ## Python program to remove nan and -inf values from pandas dataframe ``` # Importing pandas package import pandas as pd # Import numpy import numpy as np from numpy import inf # Creating a dataframe df = pd.DataFrame(data={'X': [1,1,np.nan], 'Y': [8,-inf,7], 'Z': [5,-inf,4],'A': [3,np.nan,7]}) # Display the DataFrame print("Original DataFrame:\n",df,"\n\n") # Removing nan and -inf res = df[~df.isin([np.nan, -np.inf]).any(1)] # Display Result print("Result:\n",res) ``` ### Output The output of the above program is: ![Example: Pandas: How to remove nan and -inf values?](https://www.includehelp.com/python/images/remove-nan-and-inf-values.jpg) [Python Pandas Programs »](https://www.includehelp.com/python/pandas-programs.aspx) Advertisement Advertisement
Shard	106 (laksa)
Root Hash	1184066710662109106
Unparsed URL	com,includehelp!www,/python/pandas-how-to-remove-nan-and-inf-values.aspx s443