Drop the specific value by using Operators
We can use the column_name function along with the operator to drop the specific value.
Syntax: dataframe[dataframe.column_name operator value]
where
- dataframe is the input dataframe
- column_name is the value of that column to be dropped
- operator is the relational operator
- value is the specific value to be dropped from the particular column
Drop column by using different operators
Python3
# import pandas moduleimport pandas as pd# create dataframe with 4 columnsdata = pd.DataFrame({ "name": ['sravan', 'jyothika', 'harsha', 'ramya', 'sravan', 'jyothika', 'harsha', 'ramya', 'sravan', 'jyothika', 'harsha', 'ramya'], "subjects": ['java', 'java', 'java', 'python', 'python', 'python', 'html/php', 'html/php', 'html/php', 'php/js', 'php/js', 'php/js'], "marks": [98, 79, 89, 97, 82, 98, 90, 87, 78, 89, 93, 94]})# displayprint(data)print("---------------")# drop rows where value is 98# by using not equal operatorprint(data[data.marks != 98])print("---------------") |
Output:
How to Drop Rows that Contain a Specific Value in Pandas?
In this article, we will discuss how to drop rows that contain a specific value in Pandas. Dropping rows means removing values from the dataframe we can drop the specific value by using conditional or relational operators.
Contact Us