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
0answers
26 views

Sortable Grid-like control for large data sets?

I've been using a roll-your-own function for a while that's a wrapper around Grid which adds a couple things I always use, like headers, dynamic sorting, filtering, and clipping (only showing the ...
4
votes
2answers
75 views

Dataset division by dataset subtotals

I have the following dataset: ...
7
votes
1answer
143 views

Tooltip issue using Dataset

When I try to create a tooltip for a Dataset item, I get ... instead of the item value. See the toy code example below: ...
0
votes
0answers
39 views

NMinimize with elimination returns strange results

I have a parameter vectors pars, par1, and a matrix data1 together with a vector result <...
4
votes
0answers
56 views

Matrices stored inside a dataset do not behave well

I am storing matrices in datasets as in ...
4
votes
1answer
70 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? ...
3
votes
1answer
52 views

Advanced List selection by strings when preprocessing data

Below is a sample of the data I'm preprocessing. It's longer in both dimensions than what's shown. I already have a list of the string entries I want and now need grab the rows of numeric data ...
3
votes
2answers
59 views

Importing complex numpy arrays

Related question: Formatting Imported Complex Arrays from Python (csv. files) I am trying to import a large numpy array to Mathematica but the strategy in the question above is far too slow. For a 100-...
1
vote
2answers
64 views

Converting HTML Tables derived from URL's on the Web to Datasets 211112 Revisited

In a previous question [211112] that deals with importing data from a Wikipedia table directly into a Dataset. For the following data: ...
0
votes
0answers
59 views

Transforming a time-series Dataset

I am trying to perform some analysis on a Dataset instance but my 28K queries involve a Select[#MAC==mac&] over the whole ...
3
votes
1answer
52 views

Unable to Select Value from Dataset

I'm doing a project using one of the datasets in the Wolfram Data Repository, and I ran into a weird wall that I have not been able to fix. I imported the dataset like this: ...
0
votes
1answer
42 views

Construct a matrix from a given data set and perform subsequent operations

I have data set, say, {${x_i, y_i}$} where $i$ varies from $1$ to $n$. Now, how can I construct the matrices $M_i=\{\{1,x_i,x_i\},\{\ x_i,1,y_i\},\{x_i, y_i, 1 \}\}$ and perform the following ...
1
vote
2answers
74 views

Removing Commas From Numbers in Datasets Expressed as Strings and Converting To Numbers

The following code generates a dataset from a table within a webpage: ...
0
votes
1answer
47 views

Discontinous line when plotting [closed]

If I have the following data: ...
5
votes
3answers
178 views

Find the data set for boundary/edge of ListPlot

I have a data set, say, {$x_i, y_i$}. After plotting which looks like the following How can I get the data set for the boundary from this. Here is the link for my data
1
vote
1answer
110 views

Fitting data to a model

I am using the following code with the following data (which I called fn): data (fn) here: https://pastebin.com/WwANBjNx ...
1
vote
0answers
50 views

Plot Dataset, convert to time series

How do I plot an imported dataset? In pandas one can use pd.DataFrame.plot(), which includes multiple column plotting too. How ...
0
votes
1answer
53 views

Selecting data around peak position

I'm trying to write code that imports experimental data, finds peaks in it and cuts data around specific peak for further analysis (Fourier transform & model fitting of spectra). Currently, I'm ...
2
votes
1answer
64 views

Comparing amino acids in Mathematica nutrition data

Essential amino acids for lentils and barley can compensate each other: what the one does not have, the other has. How can I find that in the nutrition database? I can find such in old tables but can ...
0
votes
1answer
52 views

how to create a new bar chart using the data from the existing barcharts

I have the following code to generate two separate bar charts. I like to create a new bar chart by extracting the data from the following barcharts. ...
2
votes
1answer
76 views

Dataset Theme Issue [closed]

In watching Stephen Wolfram introduce Vers. 12.3, I installed the upgrade from 12.2 and executed the following statement as he did in his presentation: ...
0
votes
2answers
60 views

How to delete rows in Dataset that contain specific values (efficiently)

consider this Dataset: ...
4
votes
2answers
60 views

Reduction of nested association based on criteria

I have a nested association of the following form: ...
3
votes
1answer
53 views

Update column value from hierarchical/nested Dataset

Let's say I have the following nested dataset: ...
2
votes
0answers
34 views

Changing the color and thickness of smooth histograms of two sets curves on the same graph

I have a code (shown below) where I generate two different sets of data and plot the two sets as a smooth histogram on the same graph. The code works pretty well. What I'm having an issue with is ...
1
vote
0answers
46 views

Is there an analog of ArrayQ for datasets?

ArrayQ provides a nice way to check for missing data (specifically, it checks if the array is ragged). But if you import your data as a dataset, and apply ArrayQ, it will return False for both ragged ...
4
votes
1answer
109 views

Better way to create a Dataset?

I'd like to create a Dataset from an array, where each column's heading becomes the key for all elements in that column. I can accomplish this using nested Table commands, but was wondering if there ...
10
votes
2answers
126 views

Dataset from association of lists doesn't work

Mathematica 12 on wolfram cloud isn't rendering the table for an association of lists. According to the documentation you should be able to make columns in the table by: However I tried this ...
5
votes
1answer
109 views

How to force Dataset[] to output tables with named columns instead of named rows

In the mathematica documentation it says that the syntax required to make "a table with named columns" is the following: So consider some data arranged in this syntax: ...
1
vote
1answer
70 views

how I should use `MovingMap` on a `Dataset`?

I am aware of How would I use Map on a Dataset column? still I cannot see how I should use MovingMap on a Dataset. Even the ...
1
vote
1answer
70 views

How to fit the following data?

Consider a dataset in the form {mN,tauN,x,value[mN,tauN,x]} (it may be downloaded here): ...
5
votes
3answers
136 views

dataset highlight rows based on cell values

With the new Dataset/Background option feature introduced in 12.1, I would like to highlight the rows when either of the two columns has one of the target values in ...
0
votes
4answers
113 views

Flatten outermost parenthesis

If I have the following data: ...
0
votes
1answer
79 views

Correlation test for $x$ and $y$ values of a list

If I have the following data: ...
1
vote
1answer
45 views

Using Select on aggregate properties in a hierarchical dataset (association of associations)

I have a hierarchical dataset, called finalData, like this, with 31 entries per 'outer' association. What I want to do is select the outer associations (let's call them 'chunks') based on calculated ...
1
vote
1answer
37 views

Difference on average of y-axis between data sets

How can I calculate in Mathematica the difference on average between the y-axis of two data sets such?: ...
4
votes
0answers
75 views

What can Dataset do which Association and List cannot?

Looking at the documentation page for Dataset, I don't seem to find any example which cannot be easily reproduced by a few lines of code involving Association or List. Dataset gives you some ...
0
votes
0answers
57 views

How to get COVID-19 moving-average data of the most recent 7 days for a list of countries

MMA Service Center informed me that they have fixed the problem with ResourceData[] and now I have access to COVID-19 data using: ...
2
votes
0answers
96 views

How to fill in missing data in Dataset in place

I have a dummy dataset that contains a few missing values and some filler strings. The missing values have been entered as a blank space while the filler string has been entered as "NA". I ...
0
votes
2answers
101 views

NonlinearModelFit works badly

Consider the following dataset: ...
0
votes
0answers
63 views

Dataset: selectively map a function onto the nth column

I have this data, which I used the following to Import. ...
0
votes
1answer
20 views

y values of a list into the x values of another list [closed]

If I have two lists such as: ...
3
votes
1answer
51 views

Retract Dataset value without using its Key

First of all, I cannot think of a better title for this question. I have a csv file, snippet, which is encoded in Japanese. I used the following code to import and it could correctly show the column ...
4
votes
10answers
1k views

Mathematica values new list

I have a list: ...
-1
votes
2answers
94 views

Fitting data to equation with one fitting parameter

If I have the following data (x value is composition and y value is temperature): ...
1
vote
1answer
86 views

Strategies to mimic Dataset features in a TimeSeries?

QUESTION: Seeking TimeSeries advice for simulating Dataset subsets using named columns (e.g., timeseries[[All, {"SBP", "DSP", "HR"}]]. DETAIL: While writing biometric ...
0
votes
1answer
47 views

Convert dataset to {row_head, col_head, value} list

I have a dataset imported using this method with both row and column head are some numeric values shown below. Now I would like to convert the following dataset to a list of {row_head, col_head, ...
4
votes
1answer
75 views

Create a new list from given data

Let us consider the following type of data list ...
5
votes
1answer
221 views

How to Extract (Magnetic) XYZ Data Points from Color (Airborne Magnetic Survey) Image and Legend

I've been trying to work my way through this by working through search results like: Data extraction from a picture of a graph Numeric data from a color map Extract bathymetry data from a map I can't ...
6
votes
3answers
162 views

Combine SortBy with ReverseSortBy

Suppose I have a dataset, which I want to sort according to two criteria. However, I want the first criteria to be sorted ascending, and the second descending. This would require to somehow combine ...

1
2 3 4 5
14