search

google-research / tapas

End-to-end neural table-text understanding models.
Apache License 2.0
1.15k stars 217 forks source link

calculating sum #120

Open mohandas1 opened 3 years ago

mohandas1 commented 3 years ago

Can anyone please tell how to get the sum of a column in the table. I have used both WTQ and WIKISQL but not getting the sum. This is the op i am getting when i run the query: "what is the sum of Runs?" SUM > 18426, 14234, 13704, 13430, 12650, 11867, 11739, 11579, 11363, 10889

eisenjulian commented 3 years ago

Hi @mohandas1 can you explain in more detail what's the issue, ideally with a colab to reproduce the error. A model that computes aggregation functions, such as the one trained on WTQ will return a set of selected cells plus an aggregation function. The actual computation can be done on top of that, for example the wtq evaluation script does that to compute the denotation accuracy.

mohandas1 commented 3 years ago

@eisenjulian can u please tell me how do i get total sum value in one figure after the model returned the cells ? 18426 + 14234 + 13704+ 13430+ 12650+ 11867+ 11739+ 11579+ 11363+ 10889 = 129881 I want to get this value - 129881

SyrineKrichene commented 3 years ago

Hi @mohandas1 https://github.com/mohandas1, can you give us the exact command line or script and the input interaction example that you are using? Thanks.

On Fri, May 28, 2021 at 12:45 PM mohandas1 @.***> wrote:

@eisenjulian https://github.com/eisenjulian can u please tell me how do i get total sum value in one figure after the model returned the cells ? 18426 + 14234 + 13704+ 13430+ 12650+ 11867+ 11739+ 11579+ 11363+ 10889 = 129881 I want to get this value - 129881

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub https://github.com/google-research/tapas/issues/120#issuecomment-850329640, or unsubscribe https://github.com/notifications/unsubscribe-auth/APARZOL4XURHNYL5CLL7JRTTP5X5BANCNFSM45CLH4XA .