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.
783
questions
1
vote
1
answer
34
views
Removing message "Data not saved. Save now" from Dataset object
How can I remove the message "Data not saved. Save now" from a Dataset object? I know I can click on it, but when I reevaluate the cell, the raft appears again.
The main problem is that the ...
4
votes
1
answer
91
views
Export a dataset to Excel into a named sheet
I have a dataset:
...
1
vote
1
answer
73
views
How to compute a weighted mean as a measure of central tendency?
Imagine I have data points in triplicates, as follows
$$
L=\begin{pmatrix}
p_{11} & p_{12} & p_{13}\\
p_{21} & p_{22} & p_{23}\\
& \vdots &\\
p_{n1} & p_{n2} & p_{n3}
\...
1
vote
1
answer
71
views
How to extract elements from a Table?
I have a time series table of three players
...
5
votes
2
answers
158
views
How to combine two different datasets to create a unified dataset
I have two different datasets : dsDat1 and dsDat2:
...
0
votes
0
answers
43
views
Splitting HDF5 file
Below I am attaching the h5 file that I want to analyze.
There are two branches "S_F_VAL_0", "S_F_VAL_1"
Each branch has 10 branches, which then have a dataset that is a 3D array ...
2
votes
4
answers
115
views
Rescaling the data points
Lets say I have the following data points,
...
3
votes
2
answers
280
views
Reading what is inside DataStructure[]
In my code I end up with such data structures and I cannot see what is inside. Is there a command to open this type of data structure? I tried \\Normal but it does ...
3
votes
0
answers
69
views
How to display a circular data set?
Is there a straighftorward way of building the following plot
where 5 data sets are displayed circularly, and some specific regions are highlighted (indexed i to vi)?
3
votes
2
answers
82
views
Multiple append over a Dataset
I have the following association :
...
4
votes
2
answers
82
views
How can I access the default value for ItemDisplayFunction?
Let's say I have some data I've imported and processed:
...
1
vote
1
answer
148
views
How can a directed network model be linked to Dataset[ ] for further computation?
REVISED Question:
My only request is to know how to monitor the evolution of {agentStates, steps} in simulateSlow[...] function. ...
0
votes
0
answers
57
views
Problem when copying and pasting codes
When I copy codes I usually have problems, because when I paste them to the Mathematica notebook, they don't run as they should. It has happened to me already several times, and specifically now when ...
0
votes
0
answers
23
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 ...
6
votes
3
answers
124
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
67
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 ...
1
vote
0
answers
55
views
Selecting from a list of associations
From a list of Associations
...
3
votes
0
answers
77
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 ...
0
votes
0
answers
53
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 ...
1
vote
2
answers
52
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 ...
5
votes
2
answers
149
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
...
0
votes
2
answers
59
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 ...
4
votes
1
answer
86
views
Updating a data table
1. Example data
I have a data table organized as an Association of Associations:
...
1
vote
0
answers
196
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 ...
2
votes
2
answers
105
views
Move rows and columns of an association matrix
Example data:
...
3
votes
4
answers
214
views
Add missing column keys
Example data:
data = {{"1", 50}, {"1", 60}, {"1", 40}, {"2", 15}, {"3", 18}, {"3", 18}};
The first ...
8
votes
1
answer
246
views
Shading of Dataset area
I want to shade a certain rectangular subarea of a Dataset:
...
3
votes
2
answers
137
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 ...
4
votes
2
answers
205
views
How to build a ranking matrix
I have the following Association:
...
2
votes
0
answers
190
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 ...
5
votes
1
answer
105
views
How do I fill in these missing keys with empty strings to get a complete Dataset?
This is my original data:
...
2
votes
3
answers
308
views
How to plot properly the following data?
Consider the following test data:
...
4
votes
1
answer
121
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 ...
0
votes
2
answers
84
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:
...
1
vote
1
answer
155
views
How to merge the lines in the following way?
Consider the following curves:
...
5
votes
3
answers
289
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 ...
2
votes
2
answers
251
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:
...
0
votes
0
answers
20
views
How to import output from a dynamic Manipulate in NB1 to NB2?
I have the following Code which works fine:
...
1
vote
1
answer
87
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, ...
3
votes
2
answers
246
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:
...
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 ...
2
votes
1
answer
154
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:
...
4
votes
2
answers
186
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:
...
3
votes
2
answers
196
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 ...
3
votes
2
answers
136
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:
...
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 ...
2
votes
0
answers
50
views
How to extract a column in a dataset without row names?
Suppose I have an association such as:
...
4
votes
1
answer
68
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
vote
1
answer
97
views
How to speedup calling the interpolation function? [duplicate]
Consider the following data:
...
1
vote
1
answer
96
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 ...