The tag has no wiki summary.

learn more… | top users | synonyms

7
votes
1answer
72 views

Transform Dataset so it can be used as training set for Classify

Trying to learn the new Dataset features, I am playing with the iris dataset: ...
14
votes
3answers
256 views

Applying different functions to different columns of a Dataset

Suppose I have different functions: Total, Mean and Max and the following ...
15
votes
3answers
318 views

Dataset seems unable to handle ListDensityPlot and ListContourPlot

If I create a Dataset: ...
7
votes
2answers
90 views

Show More Rows of Dataset

Dataset rather conveniently truncates the display of a dataset that has many rows. However, occasionally, I would like to show more of a dataset without having to ...
6
votes
4answers
242 views

Finding totals in a Dataset

I have this Dataset: ...
10
votes
2answers
136 views

Temporal database reconstruction in mathematica

<EDIT> after some internet research I found the database domain that deals with this kind of thing: Temporal Databases. I think my question therefore becomes how to reconstruct a temporal ...
1
vote
0answers
64 views

Why does my dataset lose its typesetting when I add columns?

I've tried multiple methods of adding and removing columns to a dataset, but it seems no matter which way I choose I can't get the data to typeset as a table. Here's my initial dataset: 1) ...
0
votes
0answers
51 views

How to open *.sif files with Mathematica

While I am processing my data collect from an Andor EM-CCD, I find it diffcult to import the file into mathematica. I think mathematica can open this kind of files since that Matlab can open it. So if ...
4
votes
1answer
70 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: ...
4
votes
3answers
307 views

How to create a table?

I have looked here at the forum and on the mathematica documentation center though still couldn't get it to work. I have two lists ...
2
votes
2answers
108 views

How to SemanticImport Multiple Excel Sheets

I have an Excel workbook with multiple sheets that I'd like to import into a dataset each. With Import I can target individual sheets by their name into a nested ...
8
votes
0answers
509 views

Dataset in Mathematica 10.0.1

Wolfram pages "Mathematica Quick Revision History" in Mathematica 10.0.1 release says: "New operators and compositions of operators enabled for associations functions such as Dataset and Query" ...
9
votes
5answers
174 views

Applying a function to a Dataset column conditional on another slot's value

How to apply a function to a column conditional on another slot's value? The Dataset documentation show only how to apply a function to named slots independently. The ...
1
vote
1answer
56 views

Select data from a Dataset [closed]

I have a dataset that looks like ...
6
votes
1answer
130 views

Incorrect result with SemanticImport

I might use this incorrectly. I want to use a .csv file that as list looks {{"Group", "data 1", "data 2"}, {"a", 1, 5}, {"a", 2, 3}, {"a", 4, 5}, {"b", 8, 9}} ...
6
votes
2answers
114 views

DeleteMissing level spec confusion

Given: titanic = ExampleData[{"Dataset", "Titanic"}] Why does this correctly delete Missing[] elements: ...
1
vote
1answer
57 views

ReadList or any other command to read in blocks of very large numbers

I have a data file, data.txt, having following data: ...
8
votes
2answers
111 views

Missing: KeyGroupBy?

Especially in tree-structured data, keys and values, being two sides of the same coin, frequently interchange roles. The ability to aggregate by value but not by key upsets the balance. How to ...
6
votes
1answer
70 views

Only String Keys supported in Dataset's Association Query?

Given data: titanic = ExampleData[{"Dataset", "Titanic"}] This Association Query works: ...
2
votes
2answers
83 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, ...
4
votes
1answer
155 views

Import iTunes xml data and convert it into a dataset or table

I have an xml file with song data from iTunes (https://dl.dropboxusercontent.com/u/1012958/iTunes%20Library.xml) and I'd like to import it to Mathematica to do some statistics. I get an XMLObject like ...
5
votes
2answers
127 views

Advanced SQL-type select statements (filtering) on Datasets

I'm trying to improve on mathematica's handling of datasets. I'm currently writing this function that should do the following. Suppose I have a dataset with columns, e.g. ...
9
votes
2answers
115 views

Problem constructing Association tables with some operators

First, set up the example Dataset from the documentation: titanic = ExampleData[{"Dataset", "Titanic"}]; Why does this fail: ...
7
votes
1answer
122 views

Group dataset on two keys (GroupBy)

I would like to group the elements of row c of the following dataset according to the values in the columns a and b. That is Go from here To here And then I would like to print this on a grid, ...
6
votes
2answers
111 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". ...
5
votes
2answers
130 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 ...
8
votes
1answer
96 views

Possible Bug in ProbitModelFit when used in a Dataset

Since upgrading to Mathematica 10 on Mac OSX I have come across a number of instances of this error, which occurs using Probit and Logit model fit. A bit of googling show this is something to do ...
3
votes
2answers
104 views

Simplifying a time-series segmentation Query

This query segments a time-series and filters out dropout frames. Can it be simplified - ie, made more readable? ...
9
votes
2answers
121 views

Does Dataset round? [duplicate]

I'm importing the following Excel file: My code and its results are: ...
14
votes
1answer
205 views

Export dataset to JSON

I'm experiencing a weird issue. Consider a dataset defined like this: dataset = Dataset[{<|"a" -> 1, "b" -> 2|>, <|"a" -> 3, "b" -> 4|>}]; ...
7
votes
0answers
129 views

Median of Dataset in Mathematica 10

I'm having trouble calculating the median of a Dataset[] in Mathematica 10. The situation is as follows. Consider a dataset that was defined as follows: ...
5
votes
1answer
243 views

How to split a Dataset into training and testing for machine learning?

Suppose I have iris data In the Dataset Format. How to split the iris data Into training and testing for Machine learning? For example,Transform the data for Classify.
10
votes
3answers
250 views

GroupBy several keys while keeping the Dataset as a Table (List of Associations)

Assume you import data from a Table source of the following format. ...
10
votes
4answers
232 views

Dataset: get number of levels and elements

The summary box for Dataset objects shows the number of levels and elements at the bottom. How can we get these values programmatically? For example, "4 levels, ...
4
votes
2answers
90 views

Create composite key - operating across rows in a dataset

I would like to be able to create a new dataset by extracting 2 columns to make a composite key, and also extracting other columns. For example, suppose my dataset looked like: I would like to ...
7
votes
4answers
253 views

Join two datasets on keys

I want to be able to join two datasets by keys, pretty much like I'd do in SQL. I thought the JoinAcross function might do it, but it doesn't operate the way I thought. The example in the ...
6
votes
3answers
221 views

Display ALL keys in dataset

I created a dateset (estimates) with 25 keys (my columns), and about a hundred rows. I'd like to be able to list the keys from the dataset. I did this: ...
7
votes
2answers
162 views

Export a simple DataSet with key-value associations to CSV in Mathematica 10

I'm trying to Export a simple dataset with key-value pairs to a CSV Export["n.csv", MyDataset, "CSV"] This results in a single-line serialization: ...
10
votes
1answer
119 views

Using MapIndexed[List] on a dataset fails — why?

The following works: MapIndexed[List]@{1, 2, 3} (* {{1, {1}}, {2, {2}}, {3, {3}}} *) This works too: ...
7
votes
0answers
111 views

How to merge Datasets representing matrices with named rows/columns?

I am working with square (non-symmetric) matrices with named rows and columns. The data I receive is sometimes messy and rows/columns may come in various permutations. I usually need to ...
8
votes
1answer
239 views

Why is Dataset upset by division by zero?

Consider this example: ds = Dataset@Transpose[<|"a" -> {1, 2, 3, 4, 3, 2, 1}, "b" -> {6, 5, 4, 3, 2, 1, 0}|>, AllowedHeads -> All] Now say I ...
8
votes
2answers
206 views

Unexpected behavior when using SortBy as a dataset filter

I am still experimenting with datasets. Recently I tried to query the Titanic example to get info on the oldest passengers. Here is what I tried ...
5
votes
2answers
106 views

How can I save a Manipulate's control settings to a dataset?

This is probably an extremely simple question. I have a manipulate that sets variables used to define an offset, amplitude, frequency and phase of a trigonometric function. ...
0
votes
0answers
65 views

How to modify a Dataset? [duplicate]

How does one go about modifying parts of a Dataset? Could the answer please solve the following as an example. Start with the ...
8
votes
1answer
92 views

Operator syntax for Merge-like Query

Is it possible to take advantage of Dataset's Query operator syntax to Merge parallel queries thereby avoiding Function's that are otherwise required? Using the planets data: ...
7
votes
1answer
141 views

Possible bug involving Dataset/Query and RightComposition

Bug introduced in 10.0.0 and fixed in 10.0.1 Short Version Why are the results of the following expressions different? ...
0
votes
0answers
40 views

Cannot convert list of associations to dataset for length longer then 4 [duplicate]

Situation: I initialize two ranges: range1 = CharacterRange["a", "d"] range2 = CharacterRange["a", "i"] Create associations: ...
8
votes
0answers
137 views

Benefit of using Dataset to collect SQLSelect output

Considering a DatabaseExample included with Mathematica: ...
25
votes
4answers
567 views

What is the natural way of using Dataset to get a FittedModel?

The new Dataset in Mathematica 10 is a great addition to the language, potentially reducing the convenience gap with R. Given this, I would like to understand what the equivalent simple or natural ...
7
votes
2answers
123 views

How to insert zero counts uniformly with Dataset Counts query

Missing[] is generated when an association does not contain the specified key. ...