Pandas DataFrame筛选与索引：如何提取W列大于0的数据？

Hey there! Glad you already grasp that a DataFrame is just a collection of Series sharing the same index—solid foundation! Let me walk you through a few straightforward ways to pull all the values greater than 0 from column W:

Method 1: Basic Boolean Indexing (Intuitive) #

This is the most straightforward approach, leveraging boolean masking on the Series:

# Get all values in W where value > 0
positive_w = df['W'][df['W'] > 0]

Here, df['W'] > 0 creates a boolean Series where each entry is True if the corresponding value in W is greater than 0. We use this boolean Series to filter the original W column, keeping only the entries where the mask is True.

Method 2: Using .loc (More Explicit & Maintainable) #

If you prefer clearer, more explicit indexing (especially useful if you might expand to select multiple columns later), use .loc:

positive_w = df.loc[df['W'] > 0, 'W']

The .loc indexer follows the pattern [row_condition, column_name], making it obvious exactly which rows and columns you're targeting.

Method 3: .query() Method (Natural Language Style) #

For a syntax that reads almost like plain English, use the .query() method—great for more complex filtering logic:

# Option 1: Query first, then select W
positive_w = df.query('W > 0')['W']

# Option 2: Shorthand using attribute access
positive_w = df.query('W > 0').W

Bonus: Convert to NumPy Array (If Needed) #

If you need the result as a NumPy array instead of a Pandas Series, just append .to_numpy():

positive_w_array = df['W'][df['W'] > 0].to_numpy()

All these methods will give you exactly the subset of column W where values are greater than 0—pick the one that fits your coding style best!

内容的提问来源于stack exchange，提问作者bgarcial