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
6
votes
1answer
66 views

How to preserve Dataset's pagination inside Manipulate?

I'm having troubles preserving automatic pagination provided by Dataset when it is embedded in a Manipulate. Consider the ...
5
votes
3answers
304 views

Changing Row Keys into Normal Rows

I have a dataset with column and row keys: ...
5
votes
5answers
410 views

Vector operation on datasets

I have a dataset like: ...
5
votes
3answers
699 views

Select dataset columns after GroupBy

Very basic question. Probably showing my ignorance, but if I have a dataset like the example in the docs ...
5
votes
2answers
482 views

What are the Slot Names in a Dataset?

I have a dataset which are keyed on {"Item", "Hour of Day", "Value"}. In the examples, I noticed that it is possible to apply functions using such as ...
5
votes
2answers
230 views

Picking a different column in each row of a Dataset[]

I have a Dataset[] like this: ...
5
votes
2answers
427 views

Create a list of rules built from data set fields

I want to convert a dataset to a list of features and a list of target values, for use in Predict and also more generally. I know ...
5
votes
2answers
166 views

How can I add column titles into a Dataset?

What I am trying to do is to add columns titles into my data set that has unit information. First I create a list of countries: ...
5
votes
1answer
449 views

How to export a Dataset to JSON or CSV?

I am getting wolfram CDF format from this, ...
5
votes
2answers
237 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: ...
5
votes
2answers
188 views

Fill Dataset value with result of queries on other Datasets

I have a Dataset ...
5
votes
3answers
250 views

Convert Matrix into a long form Dataset

I would like to convert a matrix into a dataset. The structure of the matrix is: ...
5
votes
2answers
250 views

Indexed Thread on dataset and list

I currently have a dataset, and I would like to add a column based on another list. For example: ...
5
votes
2answers
290 views

How to lookup by a string key after GroupBy? Inconsistent data type handling

This is relates to a bug that was introduced in 10.0.0 and fixed in 10.0.1 It also relates to an issue that has yet to be corrected. After applying GroupBy to a ...
5
votes
1answer
382 views

LinearModelFit with Dataset

I have a rectangular dataset, initially created with SemanticImport of a CSV file and then manipulated. Rather surprisingly, ...
5
votes
1answer
256 views

Updated: Correct Formatting of Dataset (labeled columns and rows) for Predict v NetTrain?

Problem I can not seem to figure out the correct way of formatting Dataset to be used with predict. I am providing Mathematica's example, which works fine. I also am including an abitrary "dataset" ...
5
votes
1answer
105 views

Getting error message with Search on arXiv electronic preprint database

Just installed Mathematica v10.3 which has the new option to use arXiv, the electronic database. However I get an error message using ...
5
votes
1answer
342 views

Filtering Query Nested Data (Dataset and Association)

I am trying to filter a nested Dataset. I have some data that looks like this (curated for this example): ...
5
votes
1answer
122 views

Converting Org-Mode Table into Wolfram Dataset

Simula to this post, is there a way to convert an org-mode table (say in the form of a string) to a Wolfram Dataset? So that for example this: ...
5
votes
1answer
103 views

Apply a function over Dataset as if it's an Association

Take a list of Associations. Using the Dataset function, this can be converted to a structured dataset. ...
5
votes
1answer
85 views

Applying a function on several columns of a dataset fails on Missing

Consider a dataset with missing values: ...
5
votes
1answer
150 views

DateObject with DateFormat displays incorrectly in Dataset

Bug in 10.4.1 still in 11.0 DateObjects with DateFormat option appear to have the first date part truncated when displayed in a ...
5
votes
1answer
159 views

Casting Dataset internal type from Assoc to Struct

Using: planets = ExampleData[{"Dataset", "Planets"}]; The full form of this projection displays the internal type def: ...
5
votes
2answers
769 views

How can you replace a column of a Dataset with another column or list?

Consider the dataset below with a "x" and a "CH 1" column: How can I replace the "x" column with a new set of data? For example, how could I replace "x" with values starting from 0 and incrementing ...
5
votes
1answer
552 views

Selecting rows in a Dataset

I'm struggling to get certain rows from a Dataset. Here's the set: plateData = ResourceData["Large Global Plate Boundaries"] I'd like to do something like this, ...
5
votes
2answers
900 views

Change value in a Dataset

I could not find an answer on this fundamental question, even though I was reading the references on Dataset and Association and ...
5
votes
2answers
1k 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 ...
5
votes
2answers
159 views

Dataset breaks multi-character StringSplit

Given ds = Dataset[{"a b", "c-d"} ] multi-character StringSplit is broken with Dataset (...
5
votes
1answer
337 views

Applying different functions to Dataset columns after GroupBy

I have a list of associations dataset. ...
5
votes
1answer
136 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
139 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): ...
5
votes
1answer
146 views

How to analyze all the data in a directory

I am trying to import, analyze, and save all the .txt files in a specific directory. I can do this with a single .txt file using the following code: ...
5
votes
2answers
98 views

Replacing “Unmatched” with value from other row - under condition

I have ...
5
votes
1answer
275 views

Sum some columns in list of associations grouped by other columns

I often need to sum values in a list of Associations according to some columns in that Association. I have a way of doing it, ...
5
votes
2answers
408 views

Remove rows from dataset using query

MyDataSet[Select[#point[Fsr] == 1 &]] returns the row I want to delete, now I am trying what looks to me the most logic command to remove these rows, which is <...
5
votes
1answer
285 views

Query Dataset to check if row contains any from a set of values

For a given keyless dataset, I can query to return the rows whose columns contain a specific value. For example: ...
5
votes
1answer
361 views

ANOVA test on dataset

I have a dataset with 3 groups and two variables. I want to do ANOVA test on the three groups for each variable. Does anyone know how to do this? ...
5
votes
1answer
784 views

How can I modify specific key values within a dataset?

Given a dataset, is there a way to modify a value? Example ...
5
votes
1answer
386 views

Trouble with Datasets in Version 10.0.1

Almost every morning, when I start my work, I observe the same problem as already mentioned here: Using Datasets in Mathematica 10.0 and here: Dataset: cannot reproduce a basic example. A bug? I ...
5
votes
1answer
174 views

Dataset: best practices for unordered hierarchical data

Note: the editor warns that this is a "subjective" post, but I am looking for an objective answer (e.g. in relation to easy of use of the many built-in functions, speed, etc). Suppose you have a ...
5
votes
1answer
159 views

How to judge if two Dataset are equal

I don's sure this is a bug or not.Suppose I have a dataset ...
5
votes
0answers
40 views

Why this shadowing when dealing with a dataset? [duplicate]

I have a dataset which I use as "dsall" and a function keylist (just for my convenience, nothing spectacular): ...
5
votes
0answers
250 views

Convert .csv Dataset and store in Databin [closed]

Trying out the new Databin product in the Wolfram Cloud. I have a simple ,-delimited .csv file with a header row which I have imported using the follwing: ...
5
votes
0answers
260 views

Why is Transpose Dataset slow in one direction

Transpose is faster when it distributes Keys at the 2nd level of a Dataset than when it factors them out. ...
4
votes
4answers
189 views

Padding a column of lists

I have data in the the form of a table, whose one column is the following ...
4
votes
2answers
204 views

Blocking Dataset`$ElisionThreshold doesn't work

I would like to define a simple function to automatically show all rows in a Dataset. Based on Taliesin Beynon's answer, I tried the following trivial snippet: <...
4
votes
3answers
342 views

Apply a function to each row of a Dataset

Have a Dataset which is derived from the output from another program. Have written some functions to retrieve and format this data. Can make this work as intended ...
4
votes
2answers
361 views

convert from a dataset to list

I have a Dataset of only 1 column to start with, and I want to StringJoin every element there. Got the error message ...
4
votes
3answers
2k views

Delete rows from a dataset

I have a dataset built from a call to SemanticImport("/data.csv", Delimiters -> ",") with data.csv of the form: ...
4
votes
2answers
244 views

Entropy of the elements of a general data set

I have the following data set, and wish to track the evolution of the entropy of each element within the set. I have evaluated the entropy for some elements, but how does one evaluate the entropy of ...

1
3 4
5
6 7
12