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

How to get access to ResourceData[…]

I use: ...
4
votes
2answers
103 views
0
votes
1answer
28 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: ...
0
votes
0answers
34 views

How can I select rows that contain a specific character in one column and are empty in another?

I'm trying to select rows of a dataset which contain a specific character (d or D) in column #Product (string) and no or missing values in column #Price (formatted as currency). I tried the following: ...
4
votes
3answers
69 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
39 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: ...
9
votes
1answer
119 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
72 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
30 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
217 views

Dataset Association of Association vs Hierarchical data

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

CloudDeploy DataSet does not work

I'm getting the following error when the code bellow is CloudDeployed: ...
3
votes
2answers
134 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
99 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
31 views

Problem with one axis title in a plot

If I have the following code: ...
0
votes
2answers
52 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
126 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
132 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
76 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
117 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? ...
5
votes
2answers
216 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? data = Import[ "C:\Users\49176\...
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% ...
1
vote
1answer
64 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 ...
4
votes
3answers
147 views

Problem with NonLinearModelFit for Sine behaviour

I'm trying to fit this following set of data: ...
6
votes
3answers
155 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
42 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
373 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
vote
0answers
96 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 ...
0
votes
1answer
56 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 ...
1
vote
1answer
140 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
40 views

Error using Standardize

I'm trying to standardize a set of data. ...
7
votes
5answers
800 views

SQL-like computation on Dataset: Aggregate function

Assume that I have this dataset a = Dataset[{<|"A" -> "A1", "B" -> 2|>, <|"A" -> "A1", "B" -> 3|>}] How can I get the total of Key["B"] ...
4
votes
1answer
132 views

Plot mean of data with error bar

Suppose I have the following data with co-ordinates: {{1,190},{1,200},{1,210},{1,180},{1.5,175},{1.5,200},{1.5,190},{2,100},{2,150}} How do I make a listplot of this data set, by taking the mean of ...
19
votes
3answers
2k views

Change dataset key name

Using the example in the documentation, how would I make a new dataset with the key "b" changed to key "h". ...
8
votes
3answers
270 views

pivot_wider for Datasets

I'd like to transform this dataset: ...
4
votes
1answer
55 views

Custom object display in Dataset using MakeBoxes

The below code defines a couple "objects" in the Mathematica sense using a convention consisting of so-called Q-functions for creating types and data validation, ...
2
votes
1answer
51 views

JoinAcross two datasets with KeyCollisionFunction

I would like to JoinAcross two datasets and use the KeyCollisionFunction. Basically, I would like to keep all rows from the left dataset (hence "Left"), add columns from the right dataset, but if some ...
4
votes
2answers
87 views

Using subquery in Query of Dataset

I want to create a Query to a Dataset that will select a subset of three columns, modify the date column in this subset (to month), group by month and a second column (location), take the group means ...
0
votes
1answer
41 views

Unexpected display of Dataset object

I have a dataset on which I apply a GroupBy on the rows and columns. I expected the output to be a table with the first grouping on the vertical, and the second grouping on the horizontal. However, ...
0
votes
1answer
26 views

Cannot take DWT of parsed data

I have some data in foo.tsv, and I would like to take the DiscreteWaveletTransform of one column. My data looks like this: ...
6
votes
1answer
106 views

How can I make a dataset with one element display with a header row?

I'm building a virtual lab exercise in Mathematica. As part of it, I'm using Dynamic to show the students' lab dataset that they store in memory using a ...
1
vote
1answer
48 views

What is the best way to color alternative rows but by values in a particular column of a dataset?

Consider the following dataset as an example (the actual dataset is very large and has more columns so I am looking for an efficient method): ...
1
vote
0answers
30 views

Dataset changes layout depending on value types

I've been looking to using datasets for the sometimes nice layout and scrolling possibilities. However I've been trying to find a way to "force" the layout when using nested tables. I can't ...
3
votes
2answers
72 views

How to calculate totals in datasets with GroupBy applied to Values

I have the following Dataset: ExData = Import["Example.xlsx", {"Dataset", 1}, "HeaderLines" -> 1]; I would like to get the total ...

1
2 3 4 5
13