Questions tagged [query]
The query tag has no summary.
71 questions
1 vote
1 answer
334 views
4 votes
1 answer
220 views
Apply TimeSeries onto one or more Dataset Columns
I recently responded to a question on Wolfram Community. My solution works, but I believe it could be improved. I'm trying to apply a TimeSeries to one or more ...
- 1,534
4 votes
1 answer
112 views
How can default valued be added in a Query?
I'm not understanding the the default values are not used to produced a length of 0 in the following example. What is the right way to add default values during a query? ...
- 14.1k
4 votes
2 answers
230 views
Select dataset rows that meet a mathematical criterion in a column
Here is a simple dataset: ...
- 141
4 votes
2 answers
254 views
Using subquery in Query of Dataset
I want to create a Query to a Dataset that will select a subset of three columns, modify the date column in this subset (to month), group by month and a second column (location), take the group means ...
- 460
2 votes
0 answers
79 views
4 votes
1 answer
159 views
A simple way to extract information from this dataset with Query?
I have a dataset comparable to the following (you may wrap it in Dataset if you like). I am looking for a relatively simple way to query it and extract information. ...
- 239k
1 vote
1 answer
137 views
A more efficient way to interrogate data inside a Dataset: a generic relational map
I have a Dataset that stores the relationships between people IDs (in columns) and the events they attended (in rows). I want to produce a linear text report of those relationships. How can I do this ...
- 163