Questions tagged [query]
The query tag has no summary.
71 questions
1
vote
1
answer
337
views
2
votes
2
answers
174
views
Write an expression that queries all of MMA to find the top M Symbols with the most Options or M Symbols having N Options?
I apologize, but I'm way over my pay-grade on this one, so I don't have any code to share that needs correcting. That is because I really don't know how to start this. I feel like this has a very easy ...
- 2,507
4
votes
1
answer
221
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
0
votes
0
answers
81
views
How to search exact product title with ServiceExecute
I am trying to find the exact product title having phrase "HEPA filter bags" on "amazon.com" but it doesn't return the correct result.
...
- 125
4
votes
1
answer
113
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
0
votes
0
answers
62
views
How to specify authenticity of SSL for querying APIs?
While ago I was using this command with no issue, now I have an SSL error:
...
- 467
4
votes
2
answers
232
views
Select dataset rows that meet a mathematical criterion in a column
Here is a simple dataset:
...
- 141
9
votes
1
answer
340
views
Generating Google BigQuery API Access Token in Wolfram Language
I'm working on a Wolfram Language Package to connect into Google Bigquery (that I'll make public available). In order to finish It, I need to solve a last step, that is how to get an authentication ...
- 26.5k
4
votes
2
answers
255
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
5
votes
1
answer
207
views
2
votes
0
answers
79
views
3
votes
0
answers
198
views
Efficiently get positions of Query results
I have some very large Datasets. Is there any efficient method of getting the positions of results found in a Query? That is, without using ...
- 3,880
4
votes
1
answer
160
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
0
votes
0
answers
50
views
Can the following operation be performed in a single query without using explicit Maps or nesting Queries?
Is there a way to include the function StringPosition["e"] inside the Query in the following:
...
- 10.4k
1
vote
1
answer
139
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