Hi Priya, You should look into the DataView class, which lets you construct another object from an instance of a DataTable by specifying how to filter and sort the rows or select columns or construct new columns. See https://developers.google.com/chart/interactive/docs/reference#DataView
Also the group and join methods let you do some database-like operations on data tables. See https://developers.google.com/chart/interactive/docs/reference#data-manipulation-methods On Thu, Aug 20, 2015 at 8:20 PM, <[email protected]> wrote: > Hi, > I have some data in a CSV file, which I then read into a dataTable. I want > to run a group-by query on the contents of this CSV, which I then want to > draw charts on. > > How can I run queries on a data table? Every reference to queries I see > seems to imply that queries are only for reading from spreadsheets, and not > for running on any local data source. What's the best way to work around > this? > > Best, > priya. > > -- > You received this message because you are subscribed to the Google Groups > "Google Visualization API" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to > [email protected]. > Visit this group at > http://groups.google.com/group/google-visualization-api. > To view this discussion on the web visit > https://groups.google.com/d/msgid/google-visualization-api/331e7156-6ca1-406e-a79f-65690bda0938%40googlegroups.com > <https://groups.google.com/d/msgid/google-visualization-api/331e7156-6ca1-406e-a79f-65690bda0938%40googlegroups.com?utm_medium=email&utm_source=footer> > . > For more options, visit https://groups.google.com/d/optout. > -- Daniel LaLiberte <https://plus.google.com/100631381223468223275?prsrc=2> - 978-394-1058 [email protected] <[email protected]> 5CC, Cambridge MA [email protected] <[email protected]> 9 Juniper Ridge Road, Acton MA -- You received this message because you are subscribed to the Google Groups "Google Visualization API" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/google-visualization-api. To view this discussion on the web visit https://groups.google.com/d/msgid/google-visualization-api/CAOtcSJM5WqrzuBVo6z8sFvYs3DiQNO3UXdoSJOohXA5x95tKzw%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
