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.

Filter by
Sorted by
Tagged with
1 vote
2 answers
28 views

Select rows with a specific element from a given table

Lets say I have 4 rows in alist = {{1, 1, 3, 3, 1, 6}, {1, 1, 3, 4, 1, 1, x}, {1, 2, 3, 3, 1, 6}, {1, 2, 3, 4, 1, 1, x}}; If I want to select and print out ...
user avatar
  • 85
1 vote
1 answer
40 views

List of ordered pairs from a dataset

I have a dataset with Keys Biz Unit, Rate, Average. Rate and Average are numerical values and I want to pull them from the dataset as a list of ordered pairs without the keys. I've tried various ...
user avatar
  • 81
1 vote
1 answer
116 views

Creating and exporting .dat file as desired

Please help me create a .dat file with the data format is as in the link given below https://pastebin.com/CXq0N3aT And export the file. Part of the data format in ...
user avatar
  • 103
5 votes
2 answers
104 views

Data munging Mathematica Dataset object

I struggle to use Mathematica's Dataset object. I like the descending and ascending query operators construct and I try to manipulate my simple tabular data using this approach. However, I am not a ...
user avatar
1 vote
1 answer
39 views

Correlation Matrix Not Working on All Numerical Dataset

I am trying to perform a correlation matrix on an all numerical dataset, imported from a .csv with headers specified as row 1: ...
user avatar
1 vote
1 answer
49 views

Performance tuning joinAcross (my version)

I have written what I think is a more or less complete version of JoinAcross with code below. I've done this to try to avoid the misbehavior I've observed in the ...
user avatar
  • 572
0 votes
1 answer
52 views

Recursive Functions in Mathematica

I have a dataset with 4 columns and want to take a column and apply some kind of function that subtracts the previous term. So I want to multiply the column by 2 and subtract all of the previous ...
user avatar
  • 5
3 votes
0 answers
72 views

JoinAcross Memory Leak

I believe JoinAcross may have a memory leak but would appreciate some help looking at it. It appears to be small when used just once but when iterated a lot it eventually crashes my wolframscripts. I'...
user avatar
  • 572
0 votes
1 answer
71 views

Datasets in Mathematica [closed]

I have two columns of data as two separately defined lists. I want to create a dataset and assign a key to each column. I tried this: ...
user avatar
  • 5
0 votes
2 answers
80 views

How to create a Dataset from Nested JSON Data?

I'm importing data from Swarm into Mathematica, and I'm trying to create a dataset and having issues because the values are at different levels: ...
user avatar
1 vote
1 answer
93 views

Find best fit function for different data set with errors

I have the following 3 data sets for the same quantity with errors as shown in the figure in different colors. How to find the best fit function of 1) each data set separately 2) combined of the 3 ...
user avatar
0 votes
0 answers
52 views

Assign different type of balls into output containers with constraints

The problem is to asssign all differend kind inputs to outputs. For example colored balls. On the input we can receive max 5 different type of colored balls any with amount. The amounts for the inputs ...
user avatar
  • 1
0 votes
0 answers
40 views

TagSetDelay the Plus[ ] function for direcy use with Datasets

I am trying to define a particular behavior of the function Plus[] when the arguments are $n$ Dataset, with $n\geq 3$. (The goal is to mimic the behavior of Plus[] with Datasets instead of numbers) ...
user avatar
0 votes
1 answer
98 views

Fitting data in a matrix

Consider the 'm' matrix: Link to 'matrix.dat': https://drive.google.com/drive/folders/1COdMCCBKq85vMDj6Jrb2qqoUlE9eTk6w?usp=sharing ...
user avatar
  • 939
0 votes
1 answer
81 views

How can I use the Table and Append commands to make Dimen

I have two sets of data with different dimensions. I would like to use the Table function to create data to fill the dimensions and append it to the set, so both sets have the same dimensions. I would ...
user avatar
0 votes
0 answers
29 views

Having Difficulty getting heading and data alignments to behave in a custom themed DataSet?

I'm actually quite competent when applying Option Style-s to almost any output so it puzzles me that everything I tried only ...
user avatar
  • 1,787
6 votes
7 answers
405 views

How to remove a row of a matrix according to the last element

I have a set of data as $\{x,y,f(x,y),error\}$. I want to remove the row which has the largest value of error. I thought it would be possible to use DeleteCases, ...
user avatar
  • 1,035
2 votes
3 answers
102 views

Custom normalization of Histogram

Let us consider the following lists SeedRandom[1] list1 = RandomReal[{-10, 10}, 1000]; list2 = RandomReal[{-10, 10}, 200]; Histogram[{list1, list2}, 100] The ...
user avatar
  • 1,578
0 votes
1 answer
92 views

Code refinement - bottleneck

In the code, I indicated a fragment (picker =...) where the program is slow for large m=n=dim (for example)=2000. Does anyone have any idea what to replace it with ...
user avatar
  • 939
3 votes
1 answer
58 views

Question on splitting into individual cycle from a list of 30 cycles dataset

Hi I have a set of data and will like to find out I can split these 30 cycles into each individual cycle? Do I use the for loop function in this application. Thanks for the help in advance. ...
user avatar
  • 302
3 votes
1 answer
156 views

Rectangles in matrix

Consider the matrix 'm1' : m1 = RandomReal[{0, 1}, {100, 100}]; Let's draw a rectangle in this matrix ...
user avatar
  • 939
0 votes
1 answer
149 views

Random figures in the matrix

Consider the matrix 'm1' : m1 = RandomReal[{0, 1}, {100, 100}]; Let's pick one of the elements of this matrix. It will be the center (point of intersection of the ...
user avatar
  • 939
1 vote
0 answers
30 views

"Unknown internal error" in Dataset via Map—bug?

If someone else can reproduce this, I'll report it as a bug. It seems that trying to access a Dataset inside another Dataset via ...
user avatar
  • 7,749
2 votes
0 answers
48 views

Is it possible to query an entity store created from a dataset?

Mathematica Dataset is unfortunately no built on top of relational algebra principles. If it were all datasets would be relations and all operations on datasets would also return relations (non ...
user avatar
  • 856
0 votes
1 answer
74 views

Manipulating dataset [closed]

I have a dataset in form of {{typ1,typ2,typ3..typ15},.....{typ1,typ2,typ3,...typ15}}. The attached image shows the table form of data. I want to select any 3 column of the data and do some calculation ...
user avatar
  • 383
5 votes
2 answers
167 views

Select behaving differently with Dataset and List

I have just encountered what I would term an unexpected disagreement in behaviour between Dataset and List. Consider the ...
user avatar
  • 4,677
2 votes
0 answers
34 views

Why Dataset does not accept to add two more lines in an element?

Why Dataset does not accept to add two more lines in the "quantifying" element (and returns an Association instead of making the 2 more lines)? ...
user avatar
3 votes
1 answer
47 views

Delete/Drop nested columns within dataset

I have sorted some data into a dataset, but when exporting the dataset to be an external file I would only need certain columns within the dataset. I would like to drop the everything within the "...
user avatar
  • 73
2 votes
1 answer
85 views

How to make all the rows of a Dataset appear? [closed]

Impossible to solve the hereunder question: How to make the 4 rows of "governing" to appear instead of only the 2 first one and a gray line saying "4 total >"? ...
user avatar
1 vote
1 answer
51 views

selecting specific part of data set [closed]

I have data set in form {section, Arcangale ,X,Y, type}. Section is the number between 1 to 3 (1,2,3), Arcangale is number change from 0 to 1 something like this (0.0176575), x and y are coordinate (...
user avatar
  • 383
3 votes
1 answer
120 views

Generic XML to Dataset

I am having trouble to transform XML data into a Mathematica Dataset of Associations. I want a dataset that follows the structure of the XML file with all its sublevels. Here is the example xml: ...
user avatar
0 votes
1 answer
94 views

Mathematica linear model fit to all data [closed]

I tried to use LinearModelFit[data, x, x] to fit linear curve to all data but I get an error: The data looks like this: Here is the file with data:data
user avatar
4 votes
1 answer
103 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 ...
user avatar
  • 1,180
9 votes
4 answers
293 views

Display information as fractions in dataset

I have some data that I want to display as rationals. ...
user avatar
  • 1,539
0 votes
1 answer
80 views

How to create a dataset out of the entities?

I am working on learning how to create a dataset from a series of entities. I have the following function that finds all properties of a certain entity: ...
user avatar
0 votes
0 answers
32 views

How to keep track of multiple properties of entities?

I have the following lines of code: ...
user avatar
4 votes
1 answer
157 views

How to reformat a Dataset[]

I have a dataset jdataSDG1 and like to reformat it as jdataSDG2. ...
user avatar
  • 4,391
5 votes
1 answer
123 views

How to access a Dataset column via a variable

I want to pick values of varying columns from a dataset, eg. from the Dataset in the documentation ...
user avatar
  • 5,453
3 votes
1 answer
42 views

Multicriterial filtering operators in Datasets

How to generate a long Select query with Dataset-based syntactic sugar? For instance, let we generate the dataset ...
user avatar
5 votes
1 answer
107 views

Displaying more columns of a dataset

How can I request (programmatically or otherwise) the display of more Dataset columns? For example, this command displays only 10 of the 13 columns of the dataset: <...
user avatar
1 vote
2 answers
116 views

How to Export a `Dataset` into a single worksheet of Excel

I have a Dataset: ...
user avatar
  • 4,391
0 votes
1 answer
79 views

How to get the Inverse Fast Fourier Transform (ifft) of a dataset? [closed]

I'm looking at the inverse fast Fourier transform as calculated by Matlab. In the question "What's the correct way to shift zero frequency to the center of a Fourier Transform?" the way to ...
user avatar
  • 1,100
1 vote
1 answer
76 views

how to draw a line at mean value of cross-section and time-series data using Bar Chart

I have Dataset; ...
user avatar
  • 4,391
6 votes
1 answer
198 views

How to correctly show plots in Dataset?

I want to show plots in Dataset. Something like this ...
user avatar
  • 15.6k
2 votes
2 answers
123 views

How to calculate percentage change using Dataset[]

With the following code, I can calculate percentage changes in selected indicators over time. The code is not efficient nor practical to integrate it into Manipulate...
user avatar
  • 4,391
1 vote
1 answer
81 views

how to perform operations on a subset of a dataset

I have this data set: ...
user avatar
  • 4,391
2 votes
1 answer
82 views

Plot Dataset items

Assume, I have a Dataset like this ...
user avatar
  • 591
1 vote
0 answers
64 views

Converting imported dataset columns to DateObject

I'm really banging my head against a wall here with something that feels like it should be simple. I am importing a .csv with a header row as a Dataset. One of the columns is Time, formatted as ...
user avatar
0 votes
0 answers
44 views

Set w/Log steps to generate a Table

I'm trying to generate a Table with data with the form data=Table[{x1,x2,expr1},{x1,x10,x1f,x1step},{x2,x20,x2f,x2step}] In the context of my ...
user avatar
  • 575
0 votes
0 answers
37 views

Aproximated matching of elements in two or more tables (datasets)

This question is slightly related to this other Context: I'm trying to constrain parameters from a model of Orbital Resonance equilibrium. In short, I know a parameter "$\Delta_{eq}$" which ...
user avatar
  • 575

1
2 3 4 5
15