Pandas: Use a local variable within a query
Pandas: DataFrame Exercise-75 with Solution
Write a Pandas program to use a local variable within a query.
Sample Solution :
Python Code :
import pandas as pd
df = pd.DataFrame({'W':[68,75,86,80,66],'X':[78,85,96,80,86], 'Y':[84,94,89,83,86],'Z':[86,97,96,72,83]});
print("Original DataFrame")
print(df)
maxx = df["W"].max()
print("\nValues which are less than maximum value of 'W' column")
print(df.query("W < @maxx"))
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.
Python: Tips of the Day
Memory Footprint Of An Object:
import sys x = 'farhadmalik' print(sys.getsizeof(x))
60
- Weekly Trends
- Python Interview Questions and Answers: Comprehensive Guide
- Scala Exercises, Practice, Solution
- Kotlin Exercises practice with solution
- MongoDB Exercises, Practice, Solution
- SQL Exercises, Practice, Solution - JOINS
- Java Basic Programming Exercises
- SQL Subqueries
- Adventureworks Database Exercises
- C# Sharp Basic Exercises
- SQL COUNT() with distinct
- JavaScript String Exercises
- JavaScript HTML Form Validation
- Java Collection Exercises
- SQL COUNT() function
- SQL Inner Join
We are closing our Disqus commenting system for some maintenanace issues. You may write to us at reach[at]yahoo[dot]com or visit us at Facebook