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
1answer
193 views

Problem with Module, Function, Association and Dataset

I have struck a combination of the above-mentioned functions that causes evaluation to fail. I wonder whether someone can help me create a more minimal example in order to understand the issue better. ...
6
votes
1answer
136 views

Explaining error when using Part inside Module in Dataset

I have a vague recollection of seen an explanation for this, but I can not find it, so it may be a false memory. Will delete if duplicated. Let ds be a simple <...
5
votes
1answer
133 views

PDF for MixtureDistribution fails in Dataset Query in 11.1

I have the results of a process involving FindDistribution as a Dataset of probability distributions. Attempting to plot the <...
5
votes
2answers
227 views

How to select data of one column from a Dataset ( in this particular case )?

I use Mathematica 11.0.1 on Windows10, consider the following MWE: ...
3
votes
2answers
185 views

How do I plot data from excel file with legends picking the column heading?

I have my data on an excel file (with five columns and 15 rows) and would like to import the file into mathematica and then: (a). Plot column 1 against column 3 (b). Plot column 1 against column 2, 3, ...
7
votes
0answers
66 views

Dataset Crashes Information and Definition functions

Bug in 11.0.1 fixed in 11.1.0 Has anyone else noticed this odd function crash with Datasets. Try the following in a clean kernel. ...
2
votes
6answers
3k views

Converting CSV data to a Dataset

I have data in a csv file. The first row has labels, and the first column, too. Datos = Import["C:\\Users\\jodom\\Desktop\\Data.csv"] Tha data in the csv file is ...
4
votes
3answers
192 views

Chart a PairedHistogram from two columns of a Dataset

I'm currently experimenting using the Titanic example data set: titanic = ExampleData[{"Dataset", "Titanic"}] I'm able to extract a specific column and then ...
1
vote
0answers
136 views

Going from Dataset back to underlying Associations [closed]

In attempting to scrape data from a Wikipedia table for conversion into a Dataset, I discovered that the simple program posted in another thread works rather well. ...
3
votes
2answers
127 views

Composition with Transpose failure with Dataset

Is the failure of the 2nd Transpose here a known bug? Dataset[{{0, 10}, {2, 11}, {3, 12}}][ Transpose /* Map[MinMax] /* Transpose] // Normal ...
-1
votes
1answer
130 views

Compare dataset with list and append the corresponding values

I'm not really experienced with Mathematica and I cannot find a solution to my question. Hopefully, you can help me. So I've got a Dataset ...
12
votes
5answers
2k views

Append a list as a column in a dataset

I have a Dataset and a List, called dataset and intervals, and I would like to append the list as a new column of the dataset. I ...
18
votes
3answers
1k views

Assign names to Dataset columns

I am constructing a dataset like so: data = Dataset[AssociationThread[Keys[characterCounts], charFrequencies]] which gives me a dataset that looks like this: ...
11
votes
1answer
134 views

Dataset interferes with SeedRandom

Bug introduced in 11.0.1 or earlier and fixed in 11.1 This seems like a pretty awful bug: SeedRandom[1]; RandomInteger[10, 10] Out: {1,4,0,7,0,0,8,6,0,4} While:...
6
votes
2answers
167 views

Dataset and Select with a SmoothKernelDistribution

This question is hopefully a case of stupidity on my side, but I just don't understand why this happens. I had code that worked perfectly fine for several weeks and gives an error now on Linux and Mac....
1
vote
1answer
123 views

StringExpression: Cleaning up curated datasets from camel-case for CSV export

Context: If a Property of a Wolfram Curated Dataset could contain multiple elements, it is stored as a List; further, although ...
1
vote
0answers
36 views

Inconsistent display of DateObjects in Dataset [closed]

This question is similar issue to here. <|"a" -> DateObject[{2014, 1, 14}], "b" -> {DateObject[{2015, 3, 23}], DateObject[{2015, 3, 30}]}|> // Dataset The formatting is the same if the ...
1
vote
0answers
97 views

How to avoid quotes around strings in variables with a custom format in the display inside Datasets in V11? [duplicate]

I'm wondering how to deal with some unwanted behaviour of the new display format of Dataset in Mathematica 11 (I'm using version 11.0.1): I'm using a custom "type",...
5
votes
2answers
804 views

Plot 2 columns from a Dataset on the same plot as lists

I have imported as a csv file and converted to a Dataset. I would now like to plot columns of data (by the column title) as ListPlot. I can do this one column at a time, but cannot combine multiple ...
4
votes
1answer
59 views

How do I import a Dataset that contains lists?

The very first example in the Dataset documentation is the following: ...
20
votes
2answers
359 views

Query: adding additional operator changes meaning of preceding operators

Consider the following query: Range[5] // Query[Select[EvenQ] /* Append[1], f] (* {f[2], f[4], 1} *) It selects the even numbers, applies ...
7
votes
0answers
80 views

How to navigate a large Dataset with keyboard short-cuts?

Update : Starting in 11.1 the navigation buttons are fixed to the left-hand side instead of being centered and don't jump around anymore. Starting with version 11.0 ...
1
vote
1answer
241 views

Extracting sheet/pages from Excel XLXS file to Mathematica [duplicate]

I'm attempting to extract a sheet in an Excel file which consists of multiple sheets. How do I instruct Mathematica to extract a specific page? Any help is appreciated. Thanks in advance.
3
votes
0answers
58 views

Aligning input form of a sequence of Queries

Is there a way to modify the parser, or define options, to align the indentation of a sequence of Queries on a Dataset? Given: ds = <|"a" -> 1, "b" -> <|"c" -> 2|>, "d" -> <|"e" -> 3, "f" ...
9
votes
3answers
258 views

Applying functions to some columns in a Dataset and keeping only those

Take the following example Dataset: data = Table[Association["a" -> i, "b" -> i^2, "c" -> i^3], {i, 4}] // Dataset ...
2
votes
0answers
147 views

Accessing dataset columns with underscore in keys [closed]

I have a dataset which has a column called "PS_I". I cannot change this because I imported the column from an existing csv. I would like to add another column. Such as: ...
1
vote
1answer
271 views

Dataset's visual appearance is inconsistent

planets = ExampleData[{"Dataset", "Planets"}]; When I run result1 = planets[All, "Moons" /* Keys] I don't like the column ...
5
votes
1answer
354 views

LinearModelFit with Dataset

I have a rectangular dataset, initially created with SemanticImport of a CSV file and then manipulated. Rather surprisingly, ...
3
votes
2answers
94 views

Unexpected behavior of Dataset

This code form documention of Dataset in ref/Dataset->Applicastions->Indexed Tables(Associations of Associations): ...
11
votes
1answer
131 views

Display bug in Dataset's UnitConvert handling

Bug introduced in 11.0.1 or earlier and fixed in 11.1.0 Is this yet another annoying regression in v11 Dataset type handling? The display form seems to be a ...
8
votes
2answers
557 views

Creating a Stock Dataset

I've been looking into how to create a stock database in Mathematica using Dataset. This may or may not be a sensible idea, depending on the quantity of data required, although the possibility of ...
7
votes
1answer
119 views

KeyTake, KeyDrop fail with Transpose in Dataset

I think similar to unexpected-behavior-of-keytake there are other issues with v11.0 KeyTake and (more useful) KeyDrop that show ...
7
votes
2answers
135 views

Associations of List is not printing properly in mathematica 11

<|"i1" -> {a11, a12, a13}, "i2" -> {a21, a22, a23}, "i3" -> {a31, a32, a33}|>//Dataset The above code produces the following where rows are still ...
0
votes
1answer
1k views

Help: Shifted columns values of a dataset [closed]

How do i add a new column to a Dataset that is the shifted version of another column with nulls placed in missing places. (just like the function shift in pandas in ...
1
vote
1answer
94 views

Counting the occurences of entries in a dataset columnwise

Consider a dataset with some rows and considerably less columns (eg something like 10x3). Assume that the contents of the dataset...
2
votes
1answer
164 views

Query and Dataset Syntax Peculiarities

Question Can someone please explain to me the syntax of Query and why its behavior is so befuddling to me at the moment? I am going to go through a few simple ...
9
votes
1answer
399 views

How do I 'Join' two Structured Datasets?

Consider the following Datasets dsCompetitions with fields {"id","name","eventTypeId"} dsEventTypes with fields {"id", "name"} I want to join the datasets as ...
2
votes
0answers
94 views

List, Association, and Dataset, according to what principles to choose which one to use?

List, Association and Dataset are three 'objects' that can be used to store data in MMA. So ...
2
votes
1answer
232 views

Bioinformatics: RNA-seq and Gene Set Analysis Pipelines

Context The decreasing price of high-throughput genome sequencing has skyrocketed its use. While Mathematica is a remarkable language, it does lag behind in some regards for various reasons; ...
3
votes
1answer
102 views

ID Swapping: Efficient use of a reference table to convert ID values

Context The rise of various bio-companies for high-throughput sequencing technology and open-source bioinformatic software suites for analysis thereof, has resulted in a equivalent rise of reference ...
4
votes
0answers
105 views

Dataset row position changed by GroupBy in 11.0.1

Bug introduced in 11.0.0 and persisting through 11.0.1 or later In 10.4.1 and previous versions then using GroupBy in a Dataset ...
12
votes
5answers
482 views

Dataset Processing: efficient ways to clean and merge sets for Life Sciences

Dataset Processing (for Life Sciences) Note: a related, but distinct task is posted here ID Swapping: Efficient use of a reference table to convert ID values. A common task, at least for me, ...
3
votes
1answer
208 views

Normalizing the value of columns in Dataset [duplicate]

Here's some data in a Dataset. It's about insurers. ...
0
votes
1answer
77 views

Find integration boundaries by comparing two data sets

EDIT: the mathematica problem: My spectra are two 1-D lists of numbers (which I will copy at the end of this message), and so as to be able to integrate the narrow-slit-data, I created an ...
5
votes
2answers
123 views

Filtering a subset of a nested dataset

I have a nested dataset (a result of a JSON import done by Mathematica, curated for this example): ...
6
votes
1answer
87 views

Dataset: Failure when using functions that generate messages

Consider the dataset: data = Dataset[{<|"A" -> 1|>, <| "A" -> 2|>}] Define the function: ...
2
votes
1answer
116 views

Modify an element of a Dataset

I have a Dataset of states and I need to modify a variable: ...
11
votes
2answers
196 views

Large Dataset query fails if column contains Missing

In version 11.0 (Win 8.1 Pro) a query on a large Dataset for a column that contains Missing fails most unceremoniously. With <...
6
votes
1answer
98 views

Failure when exporting dataset with real-valued cells

Consider the following dataset: dat = Dataset[<| "A" -> 1, "B" -> 2|>]; ExportString[dat, "CSV"] It exports perfectly, with the expected result: <...
10
votes
1answer
188 views

Problems with Dataset's querying on a fresh Kernel

Bug introduced in V10.4.1 or earlier and fixed in V11.3 A support case with the identification [CASE:3710757] [...] I checked and reproduced the issue at my end and have reported the issue to ...