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
49 views

Dataset: selectively map a function onto the nth column

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

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

If I have two lists such as: ...
3
votes
1answer
47 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
710 views

Mathematica values new list

I have a list: ...
-1
votes
2answers
90 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
74 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
33 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
149 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
40 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
60 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
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: ...
3
votes
1answer
65 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
1answer
47 views

Grouping dataset by tags

Here is a slight modificaiton of Mathematica's example dataset from the documentation: ...
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"] ...
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: ...
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: ...
2
votes
2answers
141 views

How to get access to ResourceData[…]

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

Select dataset rows that meet a mathematical criterion in a column

Here is a simple dataset: ...
4
votes
3answers
85 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
43 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
146 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
76 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
140 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
135 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 ...
1
vote
1answer
44 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} ...
2
votes
5answers
135 views

Get two lists from a common list

If I have the following list: ...
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
80 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 ...
7
votes
1answer
120 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? ...
7
votes
2answers
290 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? ...
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: ...
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 ...
6
votes
3answers
167 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 ...
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 ...
1
vote
0answers
101 views

Machine Learning / Deep learning using Mathematica? [closed]

I am looking forward to the recommendation to learn ML/DL in Mathematica I know that there are plenty of resources web sites and books, MOOC to learn Machine Learning and Deep Learning mostly in ...
1
vote
1answer
150 views

Smoothing an irregular TimeSeries and calculate it's Derivative

I've a data set consisting of two columns, the first column is a date and the second is a numeric cumulative amount. I tried to create a time series, resample it and smooth but I couldn't manage to ...
2
votes
0answers
42 views

Error using Standardize

I'm trying to standardize a set of data. ...

1
2 3 4 5
13