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
0answers
48 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
43 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
49 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
63 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
71 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
57 views

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

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

Reduction of nested association based on criteria

I have a nested association of the following form: ...
3
votes
1answer
50 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
45 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
102 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
123 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
65 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
133 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
111 views

Flatten outermost parenthesis

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

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

If I have the following data: ...
1
vote
1answer
43 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
36 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
73 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
77 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
97 views

NonlinearModelFit works badly

Consider the following dataset: ...
0
votes
0answers
60 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
50 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
93 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
83 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
41 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
208 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
159 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 ...
0
votes
0answers
43 views

How can I get the rows with specific elements in dataset

As you can see from the picture, I want to get the rows in a14 that contains all of the a15 elements in them. By the way a15 is a part of the 1st column of a14. ...
-2
votes
2answers
63 views

Import data from a formatted text file into a dataset

As you can see from the picture, it's a txt. file, and when I use Import, lot's of different type of data stored in one column, I want to devide them into different columns. For example: the 1st ...
2
votes
2answers
112 views

How to format a table of numbers with varying decimal points

Given: ...
3
votes
1answer
52 views

Dealing with Datasets of rowcount 1

I have 2 datasets: dsE and dsF that I want to process in a consistent way: ...
3
votes
1answer
71 views

How to change the keys names in dataset

As you can see from the picture, I want to change the keys names of the list. There are 14314 keys names, but they are all mess, I want to change it with a list of continuous numbers like Range[14314]....
0
votes
0answers
46 views

What is the best way to remove dataset rows with missing values?

Consider a rectangular dataset produced by SemanticImport from a CSV file where the first row has the headers. Some values are Missing. I want to delete all the ...
0
votes
0answers
59 views

fitting the dataset with a model equation

I have a dataset. ...
5
votes
1answer
52 views

Grouping dataset by tags

Here is a slight modificaiton of Mathematica's example dataset from the documentation: ...
0
votes
0answers
27 views

Search in a Dataset

I'm new to mathematica and I'm struggling to search for a value in a dataset. I have a dataset consisting of pairs of two values. The import led to: name = Import["name.txt","CSV"] ...
5
votes
2answers
94 views

How can I export a Dataset with graphics as an Excel file?

I would like to export a Dataset to Excel. The Dataset contains graphics. But the following does not work: ...
0
votes
1answer
52 views

How to do computations with a specific column of a stream?

I'm trying to calculate the mean of a specific column of a huge dataset (given as .csv-file) using a stream in mathematica. I tried the following: ...
2
votes
2answers
159 views

How to get access to ResourceData[…]

I use: ...
4
votes
2answers
121 views

Select dataset rows that meet a mathematical criterion in a column

Here is a simple dataset: ...
4
votes
3answers
91 views

Joining two datasets if second is association of associations

JoinAcross of two datasets does not work, because the second dataset is an association {key_i -> association_i} instead of a ...
1
vote
1answer
45 views

Sorting a Dataset by an enumerated column with assigned values

A $\mathtt{Dataset}$ has a column $C$ with enumerated values $c_i$, to each of which a number $n_{c_i}$ is manually assigned. The $\mathtt{Dataset}$ needs to be sorted based on the numbers. MWE: ...

1
2 3 4 5
13