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

How to display a True/False table [closed]

Below is my written program ...
4
votes
1answer
465 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
653 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
3answers
82 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 ...
4
votes
1answer
342 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
74 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
196 views

`Transpose` nested `Association`

Say I have a nested Association like this one: ...
4
votes
0answers
101 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
159 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
116 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
117 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
104 views

Parallelize Dateset query

I would like to evaluate a Dataset query in parallel, my latest approach being: ...
3
votes
3answers
500 views

Select specific rows of a dataset

I am struggling with extracting specific rows from a dataset. ...
3
votes
4answers
431 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
100 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
6answers
5k 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 ...
3
votes
2answers
139 views

Merge two datasets of different sizes

I have two data tables formatted as DataSets. The first one has five keys: date, origin, ...
3
votes
3answers
277 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
210 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
61 views

How to change the keys names in dataset

As you can see from the picture, I want to change the keys names of the list. There are 14314 keys names, but they are all mess, I want to change it with a list of continuous numbers like Range[14314]....
3
votes
1answer
210 views

Narrowing a dataset down by string pattern

For dataset ...
3
votes
1answer
134 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
222 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
3answers
79 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 ...
3
votes
1answer
100 views

Associate a title to columns in a data set

I am using a dataset to construct a matrix, how can I add the title Mass in kilograms above the Earth and Moon like in the table. Here is the code I am working on. ...
3
votes
2answers
49 views

Dataset query for upper levels

I have the following data set: ...
3
votes
2answers
127 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
114 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
3answers
151 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
79 views

Syntax for transforming column in a dataset [closed]

Suppose I have a dataset a, featuring a column labeled n, whose values are all string representations of integer values. I want ...
3
votes
1answer
263 views

Normalizing the value of columns in Dataset [duplicate]

Here's some data in a Dataset. It's about insurers. ...
3
votes
1answer
868 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
3answers
73 views

Type of data in columns of a data set

How can I get the head of the elemtns in the columns and at the same time count how many of them are they? Here is the data set I am working with: ...
3
votes
1answer
99 views

How to Subtract column from another in dataset

I want to subtract the "assigned_ts" values from the "closed_ts" column and paste the results in seconds into the column with the "difference_ts" header.
3
votes
2answers
72 views
3
votes
1answer
126 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
1answer
361 views

How can empty fields in a csv file be set to Missing when importing as a Dataset?

When importing a csv file with empty fields as a Dataset, the empty fields are set to zero-length strings (""). There is an option, ...
3
votes
2answers
472 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
226 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
2answers
704 views

Classifying images in mass with URLs and CSV file

I'm looking to train a image classifier with a large number of examples and categories (30,000 & 100). I would then import a file of image URLs that need to be classified, and export the results. ...
3
votes
2answers
240 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
2answers
88 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
101 views

Connect grid with dataset to change grid background

...
3
votes
2answers
269 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
143 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
81 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
103 views

Unexpected behavior of Dataset

This code form documention of Dataset in ref/Dataset->Applicastions->Indexed Tables(Associations of Associations): ...
3
votes
1answer
352 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. ...

1
5 6
7
8 9
13