Pandas: Use a local variable within a query
Write a Pandas program to use a local variable within a query.
Sample Solution :
Python Code :
Sample Output:
Original DataFrame W X Y Z 0 68 78 84 86 1 75 85 94 97 2 86 96 89 96 3 80 80 83 72 4 66 86 86 83 Values which are less than maximum value of 'W' column W X Y Z 0 68 78 84 86 1 75 85 94 97 3 80 80 83 72 4 66 86 86 83
Python-Pandas Code Editor:
Have another way to solve this solution? Contribute your code (and comments) through Disqus.
Previous: Write a Pandas program to fill missing values in time series data.
Next: Write a Pandas program to clean object column with mixed data of a given DataFrame using regular expression.
What is the difficulty level of this exercise?
Test your Programming skills with w3resource's quiz.
- Weekly Trends and Language Statistics
- Weekly Trends and Language Statistics