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
1answer
105 views

Smoothing an irregular TimeSeries and calculate it's Derivative

I've a data set consisting of two columns, the first column is a date and the second is a numeric cumulative amount. I tried to create a time series, resample it and smooth but I couldn't manage to ...
2
votes
0answers
36 views

Error using Standardize

I'm trying to standardize a set of data. ...
4
votes
1answer
112 views

Plot mean of data with error bar

Suppose I have the following data with co-ordinates: {{1,190},{1,200},{1,210},{1,180},{1.5,175},{1.5,200},{1.5,190},{2,100},{2,150}} How do I make a listplot of this data set, by taking the mean of ...
0
votes
1answer
45 views

Trouble when attempting to import a dat resource

I am trying to import the "Patient Medical Data for Novel Coronavirus COVID-19" dataset from the Wolfram Data Repository, but when I import, it shows me just 427036 results instead of the ...
8
votes
3answers
256 views

pivot_wider for Datasets

I'd like to transform this dataset: ...
4
votes
1answer
45 views

Custom object display in Dataset using MakeBoxes

The below code defines a couple "objects" in the Mathematica sense using a convention consisting of so-called Q-functions for creating types and data validation, ...
4
votes
2answers
76 views

Using subquery in Query of Dataset

I want to create a Query to a Dataset that will select a subset of three columns, modify the date column in this subset (to month), group by month and a second column (location), take the group means ...
0
votes
1answer
35 views

Unexpected display of Dataset object

I have a dataset on which I apply a GroupBy on the rows and columns. I expected the output to be a table with the first grouping on the vertical, and the second grouping on the horizontal. However, ...
0
votes
1answer
24 views

Cannot take DWT of parsed data

I have some data in foo.tsv, and I would like to take the DiscreteWaveletTransform of one column. My data looks like this: ...
6
votes
1answer
101 views

How can I make a dataset with one element display with a header row?

I'm building a virtual lab exercise in Mathematica. As part of it, I'm using Dynamic to show the students' lab dataset that they store in memory using a ...
1
vote
1answer
41 views

What is the best way to color alternative rows but by values in a particular column of a dataset?

Consider the following dataset as an example (the actual dataset is very large and has more columns so I am looking for an efficient method): ...
1
vote
0answers
30 views

Dataset changes layout depending on value types

I've been looking to using datasets for the sometimes nice layout and scrolling possibilities. However I've been trying to find a way to "force" the layout when using nested tables. I can't ...
3
votes
2answers
65 views

How to calculate totals in datasets with GroupBy applied to Values

I have the following Dataset: ExData = Import["Example.xlsx", {"Dataset", 1}, "HeaderLines" -> 1]; I would like to get the total ...
3
votes
1answer
92 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. ...
4
votes
3answers
352 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 ...
3
votes
0answers
36 views

BoxWhiskerChart features breaking with massive WeightedData datasets

I have huge WeightedData objects (500K) that I am trying to plot in BoxWhiskerChart. I can get the default chart, but if I try and use the "Outliers" option, it breaks and hits a recursion ...
2
votes
1answer
54 views

Join string and quantities

How can I join a string and a quantity and still preserved the quantity format? This what I have achieved: ...
0
votes
1answer
43 views

Add calculation name on dataset statistics

I am working on, with the Animal Weights data set and creating MyFunctionwhich calculates the Max,Min,Mean,Median and first ...
3
votes
3answers
69 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: ...
1
vote
1answer
55 views

Sort a nested Association by another Association

I have a nested association of numerous pixel values sorted by sample date (e.g. 20190422C) and futher by a strain percentage (e.g. 0, 30, 50). I want to sort it even further using and Association of ...
1
vote
0answers
63 views

12.1.1 “Part” functionality having issues with Dataset [closed]

I made some large datasets of SEM micrograph images and metadata in 12.0 and they have been working no problem for several weeks. but now when I run the notebook in 12.1.1, it seems that it fails to ...
1
vote
1answer
115 views

Getting strange output on commands that used to work

I have used the following code before and it worked then but now it seems to default to the word Function, and some of the other commands are giving results like <...
0
votes
0answers
58 views

is Epidemic Data For Novel Coronavirus COVID-19 not updated?

I am trying to get the epidemic data of Colombia and I encounter that since May 27 there is not information about. The data which I obtained is ...
4
votes
1answer
85 views

Openning JSON file, (NDJSON, new line delimited) — big file

I am trying since many hours to open a JSON file ("new line delimited") that has this as structure ...
1
vote
0answers
41 views

why does dataset not preserve its associations in Module[]? [closed]

Hello I am perplexed as to why a dataset, ds1 in this example, does not return the association with index and content in it. ...
2
votes
2answers
48 views

How to identify index intervals that contain a value?

I have a really simple question but, sorry, I can't seem to find an elegant solution to other than iterating through. I have a list of indices, and a relative list of values, I would like to extract ...
2
votes
1answer
41 views

on display of DataSet using list of associations. How to make header layout independent of order in list?

V 12.1 on windows. I use Associations allot as input for my dsolve solver I am writing. I do not use Dataset, other than to ...
3
votes
1answer
65 views

Dataset rearrangement

I have a datatset , and I want to sort the elements in the second column so that the elements in the other columns change accordingly. ...
6
votes
2answers
124 views

Add a column to the left side of a dataset

What I am trying to do is to add an id column at the left side of my data set. This is the data set I am working with. I Have three columns and I want to add a new column on the left side with the ...
0
votes
1answer
64 views

How to group duplicate data in a data set? [closed]

This is the data set I am working with. I Have two rows that repeat and I know how to delete them, but how can I group duplicate data in the data set so I can identify which rows or elements are ...
7
votes
1answer
148 views

In Wolfram Mathematica, who do I query the result of a Counts operation efficiently and conveniently?

Setup Say, I'm given a dataset, like the one below: titanic = ExampleData[{"Dataset", "Titanic"}]; titanic Answering with: And I want to count the occurrences ...
2
votes
0answers
35 views

How can I efficiently save multidimensional data that is retrievable by key?

I am doing some simulations in Mathematica, where I calculate a spectrum intensity(frequency) for a variation of parameters in my samples. So in the following image, for example, I vary the charge ...
4
votes
2answers
123 views

Problem with nested mapping for Dataset structures

Consider the following dataset: ...
1
vote
0answers
46 views

Working with DataSets [closed]

I am new to working with datasets, and I know this is relatively basic, but I can not figure out why I keep getting an empty set as my answer? ...
5
votes
2answers
169 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: ...
0
votes
0answers
22 views

Removing quotes from dataset association last element

I have a below dataset : ...
1
vote
1answer
86 views

How to apply a function to multiple columns per row

I routinely apply a function to a row and have even learned how to conditionally apply functions to rows in a Mathematica Dataset. However, it feels like I've been staring at the Dataset documentation ...
2
votes
0answers
53 views

Is there a documented meaning for the following Query syntax?

Consider this example: ...
2
votes
0answers
55 views

Efficiently get positions of Query results

I have some very large Datasets. Is there any efficient method of getting the positions of results found in a Query? That is, without using ...
4
votes
1answer
60 views

A simple way to extract information from this dataset with Query?

I have a dataset comparable to the following (you may wrap it in Dataset if you like). I am looking for a relatively simple way to query it and extract information. ...
8
votes
1answer
137 views

How to do conditional coloring in dataset using new 12.1 functionality?

For the first part of this question consider the following dataset as an example: ...
0
votes
1answer
48 views

How to replace missing items in a dataset?

I am reading Covid data from an external database like so: ...
0
votes
0answers
26 views

How do I share a Dataset using Wolfram Player?

I can Export a Dataset to a Notebook or CDF and share it with another person who only has access to Wolfram player. They can see ...
2
votes
2answers
87 views

Plotting using a Dataset, setting the color based on one column and plot markers based off another column

The set-up: I was able to generate some data and I merged it all together into one big matrix (exported and uploaded over here for use in this problem: EDIT: removed). When you download the data I ...
0
votes
4answers
63 views

Match & replace the elements in a dataset

somewhat similarly to Replace Elements in a Dataset by rules, I'd like to replace the components in all columns named "microseconds" in a hierarchical dataset, with their respective quantity. ...
2
votes
1answer
49 views

JoinAcross two datasets with KeyCollisionFunction

I would like to JoinAcross two datasets and use the KeyCollisionFunction. Basically, I would like to keep all rows from the left dataset (hence "Left"), add columns from the right dataset, but if some ...
0
votes
0answers
43 views

Group By with categorical variables

I was reading this answer reducing operations and I am curious if it is possible to extend the generalization already proposed to include categorical variables. So, having the same dataset as initial ...
12
votes
0answers
197 views

Internal error using part specification with Dataset

Bug introduced in 12.1.0. Fixed in 12.1.1 Update 2020-04-13 WRI has confirmed that this is a bug. CASE:4530401 Suggested workaround from WRI ...
1
vote
1answer
61 views

A more efficient way to interrogate data inside a Dataset: a generic relational map

I have a Dataset that stores the relationships between people IDs (in columns) and the events they attended (in rows). I want to produce a linear text report of those relationships. How can I do this ...
6
votes
1answer
117 views

Idiomatic way to turn GroupBy field back into a column when aggregating

I'm trying to find a way to convert a GroupBy field in a dataset into a column after aggregation, but I'm clearly failing to this idiomatically, although I found a ...

1
2 3 4 5
12