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
0 votes
0 answers
35 views

Permutations of Dataset

I have data with missing values. I need all permutations which follow the two rules: Every year must be represented in each draw; and each draw must contain a minimum of two elements for each year. ...
  • 649
0 votes
0 answers
27 views

plots in DataSet is "collaplsed" rather than fully "expanded (showed)" [duplicate]

For example, this will make a Dataset of dataSheet, the "CurveFigure" somethimes is fully showed, while sometimes is "collaplsed", it's like ...
  • 43
1 vote
1 answer
56 views

Append to a list inside a Dataset

I am trying to use Dataset to contain and label lists of data points. Eventually, I'll throw the lowest level of the Dataset onto a series of ListPlots. However, I'm having a hard time adding points ...
  • 73
1 vote
1 answer
181 views

How can we fix an incorrect form of data?

incorrdata=Import["https://www.dropbox.com/s/lk7wiutjf4bx5yk/DataX.dat?dl=1"]; How can I fix this data, it should be in the form {$a,\bf{b}$} where b is ...
1 vote
1 answer
50 views

Fitting a sum of three lorentzian based on a dataset

as you can see below, I have developed a code that allows me to fit the present dataset via a Lorentzian. Now what I should do is to develop a sum of three Lorentzians based on this model so that this ...
3 votes
0 answers
72 views

Need to confirm bug in Dataset options before I submit report to wolfram

I need to know if I need to submit a bug report. I finally got my HeaderSize the way I want it but I had fudge it. It gives the correct widths but does this look ...
  • 1,977
1 vote
1 answer
46 views

Uneliding Graphics expressions inside Dataset

Here's an example of a Graphics that has some modest decoration. lp=ListLinePlot[Callout[{1, 3, 4, 6}, "trend"], PlotMarkers -> Automatic] I can wrap ...
1 vote
0 answers
39 views

Manipulate reevaluate every time

my code is working, however I have a problem, every time I navigate to the pages of the dataset, the Manipulate performs a re-evaluation bringing me back to the first page of the dataset. I would like ...
-1 votes
1 answer
68 views

Visualize data with a Shapefile

I am trying to visualize data of a dataset on a shapefile in Mathematica, but cannot find an understandable example. Let's assume I have a normal Shapefile with one Field "District No." ...
  • 129
3 votes
3 answers
97 views

TemperatureMap Background of Dataset Cells based on their Value

I have a dataset with normal numbers (either integers or real) and I would like to visualize the dataset in a table where, for every row a colormap shows the ranking of the numbers from Min (blue) to ...
  • 129
2 votes
2 answers
87 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 ...
  • 95
0 votes
0 answers
35 views

Identifying and tracking cluster elements in ClusterClassify for multiple time-steps of data

I have multiple time-steps of {x,y,z}coordinates data for some atoms. I would like to cluster the data for each frame and later identify how cluster compositions change and how each atom changes from ...
  • 569
1 vote
1 answer
70 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 ...
  • 91
1 vote
1 answer
133 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 ...
  • 123
5 votes
2 answers
117 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 ...
1 vote
1 answer
69 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: ...
1 vote
1 answer
54 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 ...
  • 582
0 votes
1 answer
54 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 ...
  • 5
3 votes
0 answers
73 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'...
  • 582
0 votes
1 answer
79 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: ...
  • 5
0 votes
2 answers
92 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: ...
1 vote
1 answer
116 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 ...
  • 125
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 ...
  • 1
0 votes
0 answers
42 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) ...
0 votes
1 answer
110 views

Fitting data in a matrix

Consider the 'm' matrix: Link to 'matrix.dat': https://drive.google.com/drive/folders/1COdMCCBKq85vMDj6Jrb2qqoUlE9eTk6w?usp=sharing ...
  • 969
0 votes
1 answer
93 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 ...
0 votes
0 answers
32 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 ...
  • 1,977
6 votes
7 answers
417 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, ...
  • 1,045
2 votes
3 answers
119 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 ...
  • 1,578
2 votes
1 answer
85 views

How to delete a nested key?

This is my data: ...
0 votes
1 answer
99 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 ...
  • 969
3 votes
1 answer
59 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. ...
  • 302
1 vote
0 answers
32 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 ...
  • 8,458
2 votes
0 answers
52 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 ...
  • 866
0 votes
1 answer
90 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 ...
  • 383
5 votes
2 answers
171 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 ...
  • 4,871
2 votes
0 answers
36 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)? ...
3 votes
1 answer
60 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 "...
  • 115
2 votes
1 answer
87 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 >"? ...
1 vote
1 answer
54 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 (...
  • 383
3 votes
1 answer
139 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: ...
0 votes
1 answer
105 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
4 votes
1 answer
110 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,180
9 votes
4 answers
317 views

Display information as fractions in dataset

I have some data that I want to display as rationals. ...
  • 1,549
0 votes
1 answer
85 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: ...
0 votes
0 answers
38 views

How to keep track of multiple properties of entities?

I have the following lines of code: ...
4 votes
1 answer
158 views

How to reformat a Dataset[]

I have a dataset jdataSDG1 and like to reformat it as jdataSDG2. ...
  • 4,411
5 votes
1 answer
134 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 ...
  • 5,495
3 votes
1 answer
44 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 ...
6 votes
1 answer
147 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: <...

1
2 3 4 5
15