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
4
votes
1answer
336 views

How to Operate on a Dynamic Dataset?

I cannot operate on the Dataset I am dynamically filtering. Minimal example follows. ...
4
votes
1answer
138 views

Upvalues for Missing do not work with Dataset

Consider the following Dataset: d = Dataset[<| 1 -> Missing[], 2 -> 1.0, 3 -> 4.0 |>] And the following Upvalue for Missing: ...
4
votes
1answer
191 views

Extraction of rows with even numbers of a dataset

...
4
votes
1answer
262 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: ...
4
votes
2answers
350 views

GroupBy and MaximalBy to create a new Dataset

I'm looking for a neater way to achieve this, which to me looks awkward and suggests that I am missing something... Given a Dataset... ...
4
votes
3answers
314 views

How to generate and label multiple histograms as Query operator(s)?

The Dataset documentation doesn't indicate how to label a Histogram with the key. ...
4
votes
1answer
196 views

Why is there a lot of noise in the Wolfram Blockchain?

I tried to look into the transaction history of the Wolfram Blockchain. I tried this:- ...
4
votes
1answer
81 views

How to find the block number of a transaction in a Wolfram Blockchain?

For example, in block 1004 of the Wolfram Blockchain, I can get the 4th transaction's ID by using the following code:- ...
4
votes
1answer
78 views

How to display a True/False table [closed]

Below is my written program ...
4
votes
1answer
355 views

How to get name of “named row” in Dataset for function applied to each row

After some calculations and a GroupBy I have a Dataset that is structured like this. ...
4
votes
1answer
646 views

Using Datasets in Mathematica 10.0

Bug introduced in 10.0 and fixed in 10.1 I am trying to use the Dataset functionality which was introduced in Mathematica 10.0 : ...
4
votes
1answer
333 views

How to get data from DB into dataset with keys

I'm a Mathematica newbie and I have the following problem: I connect to a Oracle DB and read out a set of variables, further on I want to histogram some of the variables. A Dataset seems to be the ...
4
votes
0answers
42 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 ...
4
votes
0answers
63 views

Is this the most idiomatic way to convert matrix into dataset?

Is this the most idiomatic way to convert matrix into dataset? (for Mathematica 10 or higher) I was kind of hoping this would work: ...
4
votes
0answers
76 views

Scrolling Dataset with down arrow hangs its display

Update : same in v 11.3.0 (OSX) (so bad, it just froze completly the Front End and I had to kill by hand ... and I lost some work !!! Be careful) It's rather an annoying problem i've got many times ...
4
votes
1answer
139 views

Unstable Dataset Formatting [duplicate]

I have a list of associations data set. If I do a simple Mean[] with GroupBy on two columns, I get a nice tidy table display. <...
4
votes
0answers
106 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 ...
4
votes
0answers
104 views

Highlighting values in a dataset [closed]

I have a question regarding highlighting severals values in (column of) a dataset. Here a simple example: ...
4
votes
0answers
95 views

Parallelize Dateset query

I would like to evaluate a Dataset query in parallel, my latest approach being: ...
3
votes
2answers
188 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: <...
3
votes
4answers
288 views

Build a Frequency Table from a Dataset

How can the Mathematica 11.3 module below be improved (it builds a frequency table)? The data source is a Dataset object (dbase) and the row/column variables are respectively rowDIN and colDIN. Here ...
3
votes
2answers
61 views

Referring to other Block variables within a Block statement?

In ...
3
votes
2answers
90 views

Creating dataset from list of ragged associations with defaults for missing keys

Given the ragged dataset in form of association of associations: ...
3
votes
3answers
229 views

How to ListPlot two datasets on the same graph?

Consider the following dataset: keys = {"a", "b", "c", "d"}; vals = Partition[Range[20], 5] ds = Dataset[AssociationThread[keys, #] & /@ Transpose@vals] In ...
3
votes
2answers
185 views

How to reduce each column of a dataset?

Given a simple dataset like this one: ...I want to apply some reduction function (like Total or MinMax) to each column ...
3
votes
1answer
182 views

Narrowing a dataset down by string pattern

For dataset ...
3
votes
1answer
118 views

Query from Association of Associations Dataset

I have a rather large dataset comprised of Association of Associations. For better or worse, I've converted this into a Dataset. Here is a simplified version of ...
3
votes
3answers
203 views

RDataFrame to Dataset

Is there an easy way to convert an RDataFrame object to a Mathematica Dataset? For example I have an R function which returns ...
3
votes
2answers
43 views

Dataset query for upper levels

I have the following data set: ...
3
votes
2answers
88 views

Using DeleteCases with a defined function with two arguments as a pattern

I am trying to manipulate some large datasets in Mathematica. I have plotted the data, and I would like to be able to easily remove points from the dataset, and it's fairly easy to identify the x-...
3
votes
2answers
111 views

Need help charting school shootings by year and number of victims

For my school project I've decided to take some data from Wolfram. I have the dataset from Data Repository, and I want to create three BarCharts. The first one shows the highest number of fatalities. ...
3
votes
1answer
230 views

Replace Elements in a Dataset by rules

I've got a dataset with 100+ various columns. I want to change e.g. the values 0 and 1 in the first column with "male" and "female". In the second column i'd like to change the 0 and 1 with e.g. "...
3
votes
3answers
142 views

aggregate records across dates

Each record in a dataset includes a country name, a year, and observations (e.g., GDP) for that country in that year. I would like to generate a new dataset with one record per country (so I would ...
3
votes
1answer
220 views

Normalizing the value of columns in Dataset [duplicate]

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

How to make a 3D surface plot from DataSet

I am trying to plot some Aerodynamic data. I import my data like this: data = SemanticImport["roll-damp-due-to-roll-rate-semantic.csv"] The CSV file can be found here: data I want to make a 3D ...
3
votes
1answer
1k views

Dataset: sort rows in descending order of first column

I am new in the Mathematica community and I have a probably easy question for you regarding how to sort a dataset as the following so that I have sorted the values in the fist row descending from 44 ...
3
votes
2answers
225 views

Importing an Excel file as a structured dataset

I need to import an Excel file as a dataset with row and column headers, and the following option using "Dataset" does not work. However, I can import the Excel file using "Data" option as a list ...
3
votes
2answers
191 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, ...
3
votes
1answer
1k views

How would I obtain a list of column names in a Dataset?

I really love the addition of Dataset to Mathematica. I would like to write a basic utility function that exports a Dataset to Excel. Is there a way to get a list of column names from a Dataset?
3
votes
2answers
227 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? ...
3
votes
1answer
46 views

Question on combining 2 datasets with common key

Hi I'm trying to combine 2 datasets with a common key which I'm not able to resolve with JoinAcross. 1st dataset is ...
3
votes
1answer
85 views

Join Datasets based on row index

I would like to join two Datasets based on their row index. Unlike ordinary columns, a row index does not have a name. Single Row Index ...
3
votes
2answers
75 views

Row Keys in Datasets: JoinAcross row keys; Demoting or deleting row keys

I want to combine two datasets that share row keys but have different column keys. Visually, this looks like a JoinAcross on the row keys to me, but the column of row keys doesn't appear to be named. ...
3
votes
1answer
79 views
3
votes
2answers
144 views

Is there a straightforward way of naming CSV/TSV columns when importing as a dataset?

I have data in TSV (tab-separated) files. The thing is, columns do not have headers. Importing data is as easy as ds = Import["foo.tsv", {"Dataset"}]; ...
3
votes
3answers
137 views

Simpler way to thread dataset values to each other

I have a relatively simple dataset that provides a list of values for a list of countries: ...
3
votes
1answer
77 views

Dataset type system fail with composite keys and Infinity

In 11.1, a Dataset consisting of an Association with composite keys with an Infinity causes failure in keying-in: ...
3
votes
2answers
96 views

Unexpected behavior of Dataset

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

How to use a list to label a BarChart

I'm trying to add labels to the BarChart I have generated from a Dataset however, I seem to be stuck on a couple of points. ...
3
votes
2answers
194 views

Building a classifier with complex strings as variable

I'm attempting to build a classifier using complex strings as one of the variables. Modified Titanic data as an example: ...