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
4
votes
8answers
298 views

Mathematica values new list

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

Fitting data to equation with one fitting parameter

If I have the following data (x value is composition and y value is temperature): ...
0
votes
0answers
42 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
32 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
72 views

Create a new list from given data

Let us consider the following type of data list ...
4
votes
1answer
187 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
144 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
39 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
58 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 ...
1
vote
1answer
73 views

Sort a nested Association by another Association

I have a nested association of numerous pixel values sorted by sample date (e.g. 20190422C) and futher by a strain percentage (e.g. 0, 30, 50). I want to sort it even further using and Association of ...
2
votes
2answers
107 views

How to format a table of numbers with varying decimal points

Given: ...
3
votes
1answer
48 views

Dealing with Datasets of rowcount 1

I have 2 datasets: dsE and dsF that I want to process in a consistent way: ...
7
votes
2answers
282 views

Delete column from a dataset in mathematica

Hi, can anyone help me with this? I want to delete the column "FIPS" and "Admin2", and keep the dataset as the original. How would I do this? ...
3
votes
1answer
61 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
36 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
57 views

fitting the dataset with a model equation

I have a dataset. ...
5
votes
2answers
84 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: ...
5
votes
1answer
46 views

Grouping dataset by tags

Here is a slight modificaiton of Mathematica's example dataset from the documentation: ...
0
votes
1answer
62 views

Trouble when attempting to import a dat resource

I am trying to import the "Patient Medical Data for Novel Coronavirus COVID-19" dataset from the Wolfram Data Repository, but when I import, it shows me just 427036 results instead of the ...
0
votes
0answers
24 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"] ...
2
votes
1answer
101 views
4
votes
2answers
112 views
0
votes
1answer
47 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: ...
4
votes
3answers
82 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
42 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: ...
10
votes
1answer
141 views

How to modify default options of Dataset

I try to make a dark stylesheet based on the ReverseColor theme. However, dataset headers are barely readable. This question is related to others such as Question ...
6
votes
1answer
75 views

Labeling points in plot made from a dataset

I am trying to use Mathematica to do some data analysis. I am trying to label points in a plot of a dataset. I know that Callout should work, but can't for the life ...
0
votes
1answer
33 views

Import multiple sheets from one excel file to one datasheet

This is probably quite a simple question for you guys but I've just started M and I've been mulling this problem for a few days and I think I am well and truly stuck. So any help would be greatly ...
10
votes
1answer
223 views

Dataset Association of Association vs Hierarchical data

I have the following dataset: ...
1
vote
1answer
35 views

CloudDeploy DataSet does not work

I'm getting the following error when the code bellow is CloudDeployed: ...
3
votes
2answers
139 views

Merge two datasets of different sizes

I have two data tables formatted as DataSets. The first one has five keys: date, origin, ...
2
votes
0answers
105 views

Replacing an part in a dataset

I have a nested dataset, which has been created to be the correct size from using Table, and I wish to replace parts of the dataset with the data. My dataset would look like (with placeholder values ...
2
votes
1answer
27 views

Splitting a Dataset into Multiples based on a row separator

Suppose I have a dataset like the following with some rows containing nothing but dashes. Question: Is there a way to split this dataset into multiple datasets (with the same headers) at the "...
1
vote
1answer
32 views

Problem with one axis title in a plot

If I have the following code: ...
0
votes
2answers
53 views

Finding the number of unique solutions in a .txt file

Well, my question is the following: I have a .txt file that consists of the following data: ...
5
votes
3answers
131 views

Delete elements of a list with the same x value

Suppose we have the following list data = {{0,1},{-1,2},{5,-2},{4,4},{3,0},{-1,1},{6,0.5},{7,2},{8,-5},{9,2}} How can we remove all elements of this list which ...
16
votes
3answers
368 views

Dataset shows an “All” Key when it contains a List of Associations

From a process I have a Dataset similar to this minimal example. ...
2
votes
5answers
135 views

Get two lists from a common list

If I have the following list: ...
1
vote
1answer
43 views

Get a list with alternate values of two lists [closed]

If I have two lists such as: list1={60,65,70,75,80,85,87} ...
1
vote
1answer
51 views

Building a nine - region cluster chart but, getting inaccurate plot-legend when empty subregions are present

This is a follow up question to the one submitted at the following: Stack exchange Link I quickly get to the subject: ...
1
vote
1answer
40 views

How to filter a list with no strings elements

I have looked here, in several posts, but I can't solve it here my list ...
3
votes
3answers
79 views

Plot Dataset with Two Lines

I would like to plot a dataset with ListLinePlot (or similar opcodes). As you can see, the frequencies are associated with both a minimum and maximum value. I would like to plot min and max values ...
2
votes
2answers
145 views

How to make functions from datasets

I have a csv that encodes the results of plugging certain parameters (say, A and B) into certain functions (say, ...
7
votes
1answer
118 views

Is there a way to get tooltip for parts of a string?

Is there a way to get the tooltip to appear for parts of a string? ...
0
votes
2answers
49 views

Relative error with bands plot

I have 2 sets of data imported from excel file, Let say A = 20 21 22 ... 30A B= 0 1 2 3 ... 10 I want to plot A with a relative error of 10% ...
4
votes
3answers
149 views

Problem with NonLinearModelFit for Sine behaviour

I'm trying to fit this following set of data: ...
6
votes
3answers
166 views

How to convert a Dataset into an indexed dataset / association-of-associations given a column header?

Given a dataset as such If "letter" is the header that is chosen, how do I convert it into an indexed dataset / association-of-associations? i.e. How do ...
0
votes
1answer
35 views

Issues Applying Selections to Hierarchical Datasets

I have a large dataset in the format below. I'm able to graph them as polygons easily enough, but am having trouble doing fine selections of the coordinates in ...
1
vote
1answer
44 views

How to Join a list of Datasets

I have a an arbitrary number of ".wl" files to import, say 4~7 at any given time, that come in as Datasets. This old thread does what I want for two ...
2
votes
3answers
398 views

Importing Excel File as Dataset

This might be a basic question but I couldn't get it to work. I have a dataset in Excel that I import to mathematica using ...

1
2 3 4 5
13