query operator

[priyankat99]

i see querying by logical operators has been deprecated:
https://danfo.jsdata.org/api-reference/dataframe/danfo.dataframe.query#query-a-dataframe-using-logical-operators

is there a reason it was deprecated? i need to filter my DF to remove certain values like so:

 const filtered = this.datapoints.query({
        column: "ModelName",
        is: "==",
        to: "model"  
      }).query({
        column: "Timestamp",
        is: ">=",
        to: start  
      }).query({
        column: "Timestamp",
        is: "<=",
        to: end 
      }) 

was this logic deprecated because it is inefficient? im not sure how to achieve this with the updated logic in query.
any help or clarification would be appreciated!

[Xloka]

@priyankat99 you can't chain it but you can do this

const query = [
  {
    column: "ModelName",
    is: "==",
    to: "model"  
  },
  {
    column: "Timestamp",
    is: ">=",
    to: start  
  },
  {
    column: "Timestamp",
    is: "<=",
    to: end 
  }
];

const finalQuery = query.reduce((acc, condition, index) => {
  if (condition.is === '>=') {
    return index === 0 ? this.datapoints[condition.column].gte(condition.to) : acc.and(this.datapoints[condition.column].gte(condition.to));
  } else if (condition.is === '<=') {
    return index === 0 ? this.datapoints[condition.column].lte(condition.to) : acc.and(this.datapoints[condition.column].lte(condition.to));
  } else if (condition.is === '==') {
    return index === 0 ? this.datapoints[condition.column].eq(condition.to) : acc.and(this.datapoints[condition.column].eq(condition.to));
  }
}, null);

const filtered = this.datapoints.query(finalQuery);

[risenW]

i see querying by logical operators has been deprecated: https://danfo.jsdata.org/api-reference/dataframe/danfo.dataframe.query#query-a-dataframe-using-logical-operators

is there a reason it was deprecated? i need to filter my DF to remove certain values like so:

 const filtered = this.datapoints.query({
        column: "ModelName",
        is: "==",
        to: "model"  
      }).query({
        column: "Timestamp",
        is: ">=",
        to: start  
      }).query({
        column: "Timestamp",
        is: "<=",
        to: end 
      }) 

was this logic deprecated because it is inefficient? im not sure how to achieve this with the updated logic in query. any help or clarification would be appreciated!

This is quite old, but I'll still answer it as it can help others.

The old query method with logical operators (is: "==", etc.) was deprecated in favor of a more powerful and chainable boolean operations approach. This new approach:

• Is more performant since it uses tensor operations under the hood
• Provides better type safety and error handling
• Allows for more complex boolean operations through chaining

Here's how you can rewrite your filtering logic using the modern approach:

const filtered = this.datapoints.query(
    this.datapoints["ModelName"].eq("model")
        .and(this.datapoints["Timestamp"].ge(start))
        .and(this.datapoints["Timestamp"].le(end))
)