Python API to delete selected rows in omnisci table

Follow

leelakrishna gairuboina

• June 19, 2022 13:16

Hi,

I am connecting to omnisci table using python. Is there any API to remove certain rows based on condition on any column?

Thanks, Leelakrishna.

0

• 

  Candido Dessanti

  • June 19, 2022 16:11

  Hi @leelakrishna_gairubo,

  Thanks for joining our community.

  If you are using the heavyai python sqllibrary you have to specify the condition into the sql used to query the table or if you want delete rows from table you should use a sql delete statement.

  If you need something similar to pandas you can try to use IBIS library, but I'm not sure if you can delete row from a table, but it should build the sql statements for aggregates, filtering and stuff like that.

  https://docs.heavy.ai/data-science/introduction-to-ibis

  Let me know if this replies to you question, because I'm not sure if I interpreted you question

  Regards, Candido

  0

  Comment actions Permalink
• 

  leelakrishna gairuboina

  • June 20, 2022 16:31

  Hi @candido.dessanti ,

  I am glad to be part of the community. Thank you for the response and it is helpful.

  Regards, Leelakrishna.

  0

  Comment actions Permalink

Please sign in to leave a comment.