Selection in pandas using query

This page summarizes the projects mentioned and recommended in the original post on dev.to

InfluxDB - Power Real-Time Data Analytics at Scale
Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.
www.influxdata.com
featured
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com
featured
  • numexpr

    Fast numerical array expression evaluator for Python, NumPy, Pandas, PyTables and more

  • What is not entirely obvious here is that under the hood you can install a nice library called numexpr (docs, src) that exists to make calculations with large NumPy (and pandas) objects potentially much faster. When you use query or eval, this expression is passed into numexpr and optimized using its bag of tricks. Expected performance improvement can be between .95x and up to 20x, with average performance around 3-4x for typical use cases. You can read details in the docs, but essentially numexpr takes vectorized operations and makes them work in chunks that optimize for cache and CPU branch prediction. If your arrays are really large, your cache will not be hit as often. If you break your large arrays into very small pieces, your CPU won’t be as efficient.

  • InfluxDB

    Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.

    InfluxDB logo
NOTE: The number of mentions on this list indicates mentions on common posts plus user suggested alternatives. Hence, a higher number means a more popular project.

Suggest a related project

Related posts

  • Stack Overflow Upset over Users Deleting Answers After OpenAI Partnership

    1 project | news.ycombinator.com | 8 May 2024
  • The Birth of Parquet

    1 project | news.ycombinator.com | 8 May 2024
  • Hacking our way to better team meetings

    2 projects | news.ycombinator.com | 8 May 2024
  • AlphaFold 3 predicts the structure and interactions of all of life's molecules

    5 projects | news.ycombinator.com | 8 May 2024
  • TimesFM (Time Series Foundation Model) for time-series forecasting

    4 projects | news.ycombinator.com | 8 May 2024