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
1
vote
2answers
484 views

Export DataSet as CSV or XLS

One question: How can I export a DataSet to CSV and XLS ? ...
2
votes
1answer
235 views

ListPlot from DataSet

Let's say that I have the following Dataset: ...
1
vote
2answers
115 views

Extract values from a string list with string elements like “ Id=\”1\“ ”

I have a simple problem which I am not able to work around. I have this list ...
8
votes
1answer
193 views

Operating on datasets that have been grouped based upon multiple criteria

I have a dataset tds that can be represented by the following code: ...
0
votes
0answers
109 views

Import Stackoverflow data and convert it into dataset

I have an xml file with the tag data from Stackexchange: https://archive.org/download/stackexchange/stackoverflow.com-Tags.7z After I unzip it I would like to import it to Mathematica to some ...
3
votes
4answers
254 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 ...
18
votes
0answers
165 views

Inefficient memory storage for Dataset

Why Dataset doesn't serialize its contents, isn't it the whole point? I expect it to behave similar to python's pandas.DataFrame,...
0
votes
1answer
92 views

Truncation of Labels and Data when visualized as Dataset

In the process of editing and manipulating web-derived data I am using Mathematica to assist in editing of tabular data entries. In my case the, data are served as Excel xls files that can be readily ...
1
vote
1answer
77 views

separating a `ReadList` of a CSV file into columns using `Case`

I have a really large file and would like to determine the pattern required for separating the columns by the different headers. I attempted to use Cases but it's ...
12
votes
5answers
291 views

Best way to convert numerical columns of a dataset with missing values into a matrix

What is the best way (simplest, fastest) to convert the numerical columns of a dataset into a matrix? The numerical columns can have missing values. For example for this dataset: ...
2
votes
0answers
111 views

`Transpose` nested `Association`

Say I have a nested Association like this one: ...
1
vote
0answers
57 views

How to: `GeneralizedLinearModelFit` with `Dataset` with cofactors

Please do not think of this question as a more general extension of LinearModelFit with Dataset asked by @alan, and answered by @Weach. The original question (or at least the solution) pertained more ...
3
votes
3answers
215 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 ...
2
votes
3answers
143 views

Conditional selection of rows from a dataset

How can one select rows "a" and "b" from the following dataset where "b" values are larger ...
3
votes
1answer
63 views

Dataset column stubs in query result

Suppose I have a dataset with a header row. ds = Dataset[AssociationThread[{"x", "y", "z"}, #] & /@ RandomReal[{0, 1}, {10, 3}]]; I want to construct the ...
3
votes
3answers
140 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 ...
1
vote
1answer
96 views

Take data point from Circle

I would like to draw a circle within triangle. In this case, I make it from 3 points. then I followed program below: ...
9
votes
4answers
201 views

Dataset query for keys of upper levels

Say I have a Dataset like this: dat=Dataset[<|"a" -> 2, "b" -> "y", "c" -> {2, 3}|>] I want to get the keys of upper levels as elements in the ...
0
votes
1answer
175 views

How to create and implement a small database on Mathematica?

I have a function f[x_,y_,z_]:= a^x b^y c^z and I want to evaluate it for various values of x,y,z always coming in triples. This means I have a database with ...
6
votes
1answer
123 views

General question about data management

I am curating a small number of databases-actually I am not sure if they qualify as such; they are more like collections of-loosely-related data points; the problem is that they are growing over time; ...
7
votes
2answers
213 views

Map Values in 'nested' association

JSON often returns sort of 'nested' associations like so: ...
6
votes
1answer
250 views

How to filter this nested list of Association

For example, I have the following data ...
2
votes
1answer
93 views

Percentage of keys that match a criteria in a dataset [duplicate]

I have dataset designed around a whiskey tasting. I have 25 tasters who have submitted scores on about 20 whiskeys. Here is a sample of how I structured the data in Mathematica: ...
0
votes
1answer
72 views

Find out how closely the model fits the data

I have an interpolating function pfun[t] and a data set in the form of {{t,f}} what can I do to get a numeric estimate on ...
2
votes
2answers
137 views

PlotMarkers not differently colored when Joined->True, InterpolationOrder and Mesh->True in ListPlot?

I have some data I need to plot smoothly. I am using ListPlot and Joined; to make them smooth, I found I need to use InterpolationOrder->3; then, to have only markers on the data set, I am using Mesh->...
0
votes
0answers
46 views

Error when selecting row and column with Dataset[]

I read in my data using: dat=Dataset[Import["dat.csv"]] When I view the data it appears correct. However, when I execute a command like ...
4
votes
1answer
77 views

How to display a True/False table [closed]

Below is my written program ...
4
votes
2answers
365 views

Why this syntax for renaming columns in datasets?

Form the documentation of Dataset: ...
6
votes
4answers
188 views

GroupBy dataset values and length

I have a dataset, and I want to group by one of my columns, and then show the Length of another set of columns for each group. For example: ...
1
vote
1answer
100 views

How to use GroupBy in Dataset when the key is not string

If the key is string, this code is working ...
5
votes
1answer
139 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 ...
2
votes
2answers
99 views

Dataset: dynamically selecting all rows of with the nth element of a column

Suppose you have a dataset with the following layout: ...
3
votes
0answers
116 views

Adjusting opacity in map overlays

I am currently working with rainfall data from hurricane Harvey in order to better understand how to allocate resources in the event of another disaster. I want to accomplish a few things given this ...
4
votes
0answers
71 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 ...
2
votes
1answer
61 views

TakeLargestBy nested variable in Dataset

I would like to TakeLargestBy a nested variable in a Dataset. To be clearer, here is code to make an example dataset ...
0
votes
4answers
363 views

ListPlot of two columns of a Dataset with respect to one another

Say I have some data in two columns of a set called table which are labelled C1 and C2, I can do the following: ...
5
votes
1answer
411 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, ...
2
votes
0answers
81 views

THISCONTEXTDOESNOTEXIST123 [closed]

I was playing with my Qwant API connection today and I hit this: The headings on the dataset give me that beautiful error message. Anyone have any idea what could have caused it? This might be too ...
6
votes
4answers
465 views

Selecting data from multiple columns

Mathematica has almost the following example in the documentation: ...
1
vote
1answer
68 views

MaximalBy in case of missing column entries

I have a large dataset, resulting from a JoinAcross operation, which looks similar like this one (only more complicated) ...
2
votes
4answers
138 views

Import two variable data from excel

I'm quite new to Mathematica. I've been looking for the information but couldn't find it. I have several sets of data corresponding to the exposure of photographic paper. On the first row I have the ...
4
votes
1answer
87 views

Replacing “Unmatched” with value

I have two datasets ...
1
vote
2answers
136 views

Exporting dataset with NumberForm

I have a dataset which includes strings and numbers. I want to export it in CSV with all numbers being printed with 2 decimals. I tried several functions like mydataset=NumberForm[#, {Infinity, 2}...
9
votes
1answer
190 views

Dataset - append row with a value which depends on two other rows

I have go through the forum but did not see this question. Hope I don't miss it. I want to add a new colum "C" to a dataset with existing columns named "A" and "B". The value of "C" shall be the ...
1
vote
1answer
90 views

Neat way to make Dataset from RecurrenceTable

I just learned that I can create a Dataset by combining Dataset and Table functions. For example: ...
4
votes
1answer
138 views

Combine datasets with partially different columns row-wise

I have a problem, which I assume to be trivial, but can't solve it: I have two datasets, ...
7
votes
1answer
302 views

Export of (large) Dataset lasts very long

I have a Dataset (non numerical data) which has a ByteCount of about 14GB, When I export it to disc (SSD) the resulting ".m" or "...
0
votes
2answers
287 views

How can I turn the first column in a dataset into row names?

I've used SemanticImport to import to a "TSV" spreadsheet into a Dataset. Each row starts ...
2
votes
1answer
96 views

Problem understanding Datasets with keys that are not strings

I am having difficulty understanding the difference between Dataset with strings as keys versus using symbols as keys. Below is a very simple toy dataset (my ...
8
votes
1answer
131 views

Adding metadata to non-atomic expressions in Associations and Dataset

Information and Attributes require arguments to be symbols and strings , whether built in or user-defined. there's often the ...