selecting across multiple columns with python pandas?

by

I encourage you to pose these questions on the mailing list, but in any case, it’s still a very much low level affair working with the underlying NumPy arrays. For example, to select rows where the value in any column exceed, say, 1.5 in this example:

In [11]: df
Out[11]: 
            A        B        C        D      
2000-01-03 -0.59885 -0.18141 -0.68828 -0.77572
2000-01-04  0.83935  0.15993  0.95911 -1.12959
2000-01-05  2.80215 -0.10858 -1.62114 -0.20170
2000-01-06  0.71670 -0.26707  1.36029  1.74254
2000-01-07 -0.45749  0.22750  0.46291 -0.58431
2000-01-10 -0.78702  0.44006 -0.36881 -0.13884
2000-01-11  0.79577 -0.09198  0.14119  0.02668
2000-01-12 -0.32297  0.62332  1.93595  0.78024
2000-01-13  1.74683 -1.57738 -0.02134  0.11596
2000-01-14 -0.55613  0.92145 -0.22832  1.56631
2000-01-17 -0.55233 -0.28859 -1.18190 -0.80723
2000-01-18  0.73274  0.24387  0.88146 -0.94490
2000-01-19  0.56644 -0.49321  1.17584 -0.17585
2000-01-20  1.56441  0.62331 -0.26904  0.11952
2000-01-21  0.61834  0.17463 -1.62439  0.99103
2000-01-24  0.86378 -0.68111 -0.15788 -0.16670
2000-01-25 -1.12230 -0.16128  1.20401  1.08945
2000-01-26 -0.63115  0.76077 -0.92795 -2.17118
2000-01-27  1.37620 -1.10618 -0.37411  0.73780
2000-01-28 -1.40276  1.98372  1.47096 -1.38043
2000-01-31  0.54769  0.44100 -0.52775  0.84497
2000-02-01  0.12443  0.32880 -0.71361  1.31778
2000-02-02 -0.28986 -0.63931  0.88333 -2.58943
2000-02-03  0.54408  1.17928 -0.26795 -0.51681
2000-02-04 -0.07068 -1.29168 -0.59877 -1.45639
2000-02-07 -0.65483 -0.29584 -0.02722  0.31270
2000-02-08 -0.18529 -0.18701 -0.59132 -1.15239
2000-02-09 -2.28496  0.36352  1.11596  0.02293
2000-02-10  0.51054  0.97249  1.74501  0.20525
2000-02-11  0.10100  0.27722  0.65843  1.73591

In [12]: df[(df.values > 1.5).any(1)]
Out[12]: 
            A       B       C        D     
2000-01-05  2.8021 -0.1086 -1.62114 -0.2017
2000-01-06  0.7167 -0.2671  1.36029  1.7425
2000-01-12 -0.3230  0.6233  1.93595  0.7802
2000-01-13  1.7468 -1.5774 -0.02134  0.1160
2000-01-14 -0.5561  0.9215 -0.22832  1.5663
2000-01-20  1.5644  0.6233 -0.26904  0.1195
2000-01-28 -1.4028  1.9837  1.47096 -1.3804
2000-02-10  0.5105  0.9725  1.74501  0.2052
2000-02-11  0.1010  0.2772  0.65843  1.7359

Multiple conditions have to be combined using & or | (and parentheses!):

In [13]: df[(df['A'] > 1) | (df['B'] < -1)]
Out[13]: 
            A        B       C        D     
2000-01-05  2.80215 -0.1086 -1.62114 -0.2017
2000-01-13  1.74683 -1.5774 -0.02134  0.1160
2000-01-20  1.56441  0.6233 -0.26904  0.1195
2000-01-27  1.37620 -1.1062 -0.37411  0.7378
2000-02-04 -0.07068 -1.2917 -0.59877 -1.4564

I’d be very interested to have some kind of query API to make these kinds of things easier

More Related Contents:

  1. Using numpy.genfromtxt to read a csv file with strings containing commas
  2. Precision lost while using read_csv in pandas
  3. pandas.read_csv from string or package data
  4. Load CSV to Pandas MultiIndex DataFrame
  5. Bin values based on ranges with pandas [duplicate]
  6. Converting between datetime, Timestamp and datetime64
  7. Writing a pandas DataFrame to CSV file
  8. Fast Haversine Approximation (Python/Pandas)
  9. How to make separator in pandas read_csv more flexible wrt whitespace, for irregular separators?
  10. Pandas Timedelta in Days
  11. Conditionally fill column values based on another columns value in pandas
  12. import text to pandas with multiple delimiters
  13. Vectorized look-up of values in Pandas dataframe
  14. Problem in combining bar plot and line plot (python)
  15. How to read a column of csv as dtype list using pandas?
  16. PIP Install Numpy throws an error “ascii codec can’t decode byte 0xe2”
  17. vectorize conditional assignment in pandas dataframe
  18. Pandas: How to create a datetime object from Week and Year?
  19. Read csv from Google Cloud storage to pandas dataframe
  20. Convert numpy type to python
  21. plotting a histogram on a Log scale with Matplotlib
  22. Conditional row read of csv in pandas
  23. Calculate summary statistics of columns in dataframe
  24. Extract csv file specific columns to list in Python
  25. double quoted elements in csv cant read with pandas
  26. Resample time series in pandas to a weekly interval
  27. Convert a column of timestamps into periods in pandas
  28. how to specify the datetime format in read_csv
  29. UnicodeDecodeError when reading CSV file in Pandas
  30. ValueError: x and y must be the same size

Leave a Comment