Questions tagged [dataset]
Questions on the Dataset data type and related functionality introduced in version 10. Do not use for questions on data in more generic list format or data-manipulation questions generally.
770
questions
0
votes
0
answers
6
views
Performing Efficient Select on Data with Different Time Resolution
I have two data sources with different time resolution. For data source A (temperature) I have about 1 s time resolution. For data source B (spectra) I have 0.01 s time resolution. I would like to ...
- 490
4
votes
3
answers
81
views
How to add a column to a dataset made up of an association of associations?
A dataset can be created in at least two ways: first, from a list of associations, second, from an association of associations (I know that it is also possible to create it as a list of list and an ...
0
votes
0
answers
60
views
Download html file
I want to download the data found on the following page and I am unable to do so.
https://resultados.admision.uni.edu.pe/ep1.html
I have already tried all the options I find in Mathematica but I can't ...
0
votes
0
answers
43
views
2
votes
0
answers
67
views
Elegant operations on associations and datasets
As a useful extension of this question:
Elegant operations on matrix rows and columns
I would like to ask:
What are for you elegant, short, useful or frequently used functions to use with ...
- 48.2k
0
votes
0
answers
50
views
How to use JLink to connect and read data from Tableau Hyper using Hyper API?
First of all, here is the link to download the API for Java for Windows.
I initially wanted to use NETLink since I have some experience with it but they have ...
- 9,113
1
vote
2
answers
51
views
Extracting integers from a Dataset containing variables
I want to extract two vectors DataA = {1,0,0,0} and DataB = {0,2,5,0} from a dataset. I tried a few ways including using the dataset and ...
- 159
4
votes
2
answers
144
views
DateSelect : columnwise selection applied to a matrix
Let consider :
A time interval (January given by Time)
A random set of values (Minimal example values given by Val)
as
...
- 508
0
votes
2
answers
49
views
Interpolation function for data with repeating independent variable
I want to find an interpolation function for data in which the x-variable is repeated (example below). The repetition in data is natural and cannot not be eliminated.
Can I somehow use ...
- 361
3
votes
1
answer
79
views
Updating a data table
1. Example data
I have a data table organized as an Association of Associations:
...
- 48.2k
1
vote
0
answers
95
views
How to get a dataset from GitHub?
I want to use the dataset on https://quickdraw.withgoogle.com/data
And the dataset is published on GitHub at the following address.
https://github.com/googlecreativelab/quickdraw-dataset
I want to ...
- 1,470
2
votes
2
answers
94
views
3
votes
4
answers
208
views
Add missing column keys
Example data:
data = {{"1", 50}, {"1", 60}, {"1", 40}, {"2", 15}, {"3", 18}, {"3", 18}};
The first ...
- 48.2k
8
votes
1
answer
244
views
3
votes
2
answers
133
views
Updating multiple columns based on a nested value in an association, create a nested function?
I have a dataset that looks like this and I sorted them by ts since that corresponds to the values of when the data was taken. After reading the primer on associations and keys, and this question, I ...
- 113
4
votes
2
answers
200
views
2
votes
0
answers
186
views
How to approximate an exponential series?
Consider the following expression
$$
y_j= \sum_{k=0}^{L} \frac{e^{-\sum_{i=-k}^k(k-|i|)x_{j+i}}-e^{-\sum_{i=-k}^k(k+1-|i|)x_{j+i}}}{\sum_{i=-k}^k x_{j+i}}\tag{1}
$$
for $1\leq j \leq L$. Given smooth ...
- 4,179
4
votes
1
answer
94
views
How do I fill in these missing keys with empty strings to get a complete Dataset?
This is my original data:
...
- 26.3k
2
votes
3
answers
305
views
4
votes
1
answer
87
views
On displaying association, including all items in a nice way?
Currently I use Dataset to display an association in a nice to see way on the screen. However, only top level items are shown this way. And have to click on each ...
- 137k
0
votes
2
answers
82
views
Problem during the analysis and plotting of a large data
I am dealing with a large dataset and I need to plot the dataset as a contour plot. The code is as follows:
...
- 441
1
vote
1
answer
153
views
5
votes
3
answers
277
views
How can I select only rows where a column is equal to any value from some list? [closed]
Consider some data
data=Table[{RandomInteger[{0,10}],RandomReal[{0,1}]},10];
and some list
list={0,5,7,3};
How can I leave ...
- 4,642
2
votes
2
answers
153
views
How to import, read and convert a .bib to .csv format?
I have a document in .bib format, namelad by savedrecs1.bib, obtained from Web of Science.
The document have a set of reference, of the type:
...
- 1,335
0
votes
0
answers
18
views
How to import output from a dynamic Manipulate in NB1 to NB2?
I have the following Code which works fine:
...
- 5,470
1
vote
1
answer
83
views
How to combine two different tables in the following way?
Consider the following two grids:
grid1 = RandomReal[{0, 1}, {3, 2}];
grid2 = Flatten[Thread[{#[[1]], #[[2]], Range[3]}] & /@ grid1, 1];
Therefore, ...
- 4,642
3
votes
2
answers
244
views
How to. automate nutrition calculation
Given a vector of quantities:
fbs = {6.18*10^6, 2.663*10^6, 1.4735*10^7};
I like to create the following code:
...
- 5,470
0
votes
0
answers
32
views
Question about the behavior of a data point as a function of time
I have a set of data points. The first coordinate is time and the second coordinate is energy. I am trying to figure out how the energy is decaying over time. Particularly, I have to find if it is ...
- 109
2
votes
1
answer
141
views
How to pick elements from a set and use them in a sum (or product)
I would like to obtain the sum (or some other reduction) from a set which is the result of a previous operation:
...
- 197
4
votes
2
answers
167
views
How to wrap text of large headings in dataset?
I am trying to achieve the following effect produced in Excel in Wolfram Dataset:
The following attempt doesn't work:
...
- 9,113
3
votes
2
answers
173
views
Partition of lists with specified elements
I have an array like this and want to split it into sublists. It should contain the first element "Res" without curly braces and the one sublist starts from 2 to the 9th column the 3rd ...
- 73
3
votes
2
answers
130
views
How to create a GroupBy function that is better aligned with relational algebra?
I want a GroupBy function that behaves more in alignment with relational algebra principles.
I can get what I want if I do it in 2 steps:
Preparation:
...
- 918
1
vote
0
answers
36
views
How to keep data/tables stored in Mathematica notebooks for use when reopening the notebook? [duplicate]
When we create a table in Mathematica, can we keep it stored in the Noteboook for use when we reopen the notebook? I know I can export to a CSV or other filetypes and import whenever I need and I know ...
- 5,121
1
vote
0
answers
45
views
How to extract a column in a dataset without row names?
Suppose I have an association such as:
...
- 5,121
4
votes
1
answer
60
views
How can we get/calculate all the available FinancialIndicators outside TradingChart and InteractiveTradingChart?
How can we get/calculate all the available FinancialIndicators outside TradingChart and ...
- 1,536
1
vote
1
answer
74
views
How to speedup calling the interpolation function? [duplicate]
Consider the following data:
...
- 4,642
1
vote
1
answer
95
views
How to put separators in large data set?
I have a large data set. Here is a part of it:
{1., 18.6, 460.4346}
{2., 28.4, 460.4346}
{3., 38.2, 460.4346}
{4., 48., 460.4346}
How to put a comma separator ...
- 361
6
votes
1
answer
181
views
How to create a cross tabulation table using a Dataset?
After searching a lot from this forum and @Anton Anton's codes on Cross Tabulation, i still cannot find the way to create a dataset table with two-row headers. The ...
- 5,470
10
votes
7
answers
649
views
1
vote
1
answer
50
views
How to convert or filter a comma-numbered elements in a data to number as elements in filtered data?
My subset data (10 Rows, 3 Columns) of the big data looks like this:
...
3
votes
2
answers
230
views
Finding a subset in the set of the digits of Pi
Well, I want to find the first position where the digits of Pi are {a,b,c,...,z}. So to find the first n digits of Pi and put them in listform I used:
...
- 1,941
1
vote
0
answers
51
views
Truncation of long strings in DataSet items
Given a dataset containing items with long texts (strings), Mathematica would automatically truncate those texts after 3 lines
...
- 3,487
2
votes
1
answer
107
views
How can one stipulate the width (visible columns) of a displayed dataset?
In perusing MSA, I note that one can control the number of rows that are visible in a dataset by using the command:
Dataset`$DatasetTargetRowCount = n;
where n ...
- 1,774
0
votes
1
answer
78
views
Sorting a dataset on multiple column
Following an answer provided by kglr in a previous post:
...
- 1,774
0
votes
2
answers
56
views
Streamlining Dataset Select meta-programming
Imagine you are deep in studying the Powerball Winning Numbers starting from 2010:
...
- 5,116
1
vote
2
answers
52
views
How to create a Flexible RadialAxisPlot with Manipulate using Dataset
I have the following code:
...
- 5,470
2
votes
1
answer
159
views
How to paint world map with some data?
I have a dataset which associate each country to respective number, from a list with few countries, as shown below:
...
- 1,335
1
vote
1
answer
54
views
Construction of many logical sentences
Consider the set:
c1 = {h1, h2, h3, h4, h5, h6, s1, s2, s3, s4, s5, s6};
How to build a list of all possible logical sentences based on the set 'c1' and logical ...
- 1,019
6
votes
5
answers
490
views
2d data set as contour
There is a set of data in the form of a table that I import into Mathematica:
https://dropmefiles.com/7BXAE
...
- 2,374
0
votes
1
answer
74
views
How to obtain smooth distribution for the given datasets?
Consider a variable x defined in the range
$$
\tag 1 x \in (1,10^{7})
$$
Let us assume that we have three datasets belonging to three different intervals of x:
...
- 4,642