Pandas: Check for inequality of two given DataFrames
Pandas: DataFrame Exercise-80 with Solution
Write a Pandas program to check for inequality of two given DataFrames.
Sample Solution :
Python Code :
import pandas as pd
df1 = pd.DataFrame({'W':[68,75,86,80,None],'X':[78,85,None,80,86], 'Y':[84,94,89,83,86],'Z':[86,97,96,72,83]});
df2 = pd.DataFrame({'W':[78,75,86,80,None],'X':[78,85,96,80,76], 'Y':[84,84,89,83,86],'Z':[86,97,96,72,83]});
print("Original DataFrames:")
print(df1)
print(df2)
print("\nCheck for inequality of the said dataframes:")
print(df1.ne(df2))
Sample Output:
Original DataFrames: W X Y Z 0 68.0 78.0 84 86 1 75.0 85.0 94 97 2 86.0 NaN 89 96 3 80.0 80.0 83 72 4 NaN 86.0 86 83 W X Y Z 0 78.0 78 84 86 1 75.0 85 84 97 2 86.0 96 89 96 3 80.0 80 83 72 4 NaN 76 86 83 Check for inequality of the said dataframes: W X Y Z 0 True False False False 1 False False True False 2 False True False False 3 False False False False 4 True True False False
Python-Pandas Code Editor:
Have another way to solve this solution? Contribute your code (and comments) through Disqus.
Previous: Write a Pandas program to create a DataFrame from the clipboard (data from an Excel spreadsheet or a Google Sheet).
Next: Write a Pandas program to get lowest n records within each group of a given DataFrame.
What is the difficulty level of this exercise?
Test your Programming skills with w3resource's quiz.
It will be nice if you may share this link in any developer community or anywhere else, from where other developers may find this content. Thanks.
https://www.w3resource.com/python-exercises/pandas/python-pandas-data-frame-exercise-80.php
- Weekly Trends and Language Statistics
- Weekly Trends and Language Statistics