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
0answers
52 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
106 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
54 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
67 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
38 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
46 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
35 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
52 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
98 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
53 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
126 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
34 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
116 views

Problem with nested mapping for Dataset structures

Consider the following dataset: ...
1
vote
0answers
44 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
155 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
17 views

Removing quotes from dataset association last element

I have a below dataset : ...
1
vote
1answer
68 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
49 views

Is there a documented meaning for the following Query syntax?

Consider this example: ...
2
votes
0answers
51 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
50 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
129 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
40 views

How to replace missing items in a dataset?

I am reading Covid data from an external database like so: ...
0
votes
0answers
22 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
71 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
58 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
30 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
38 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
176 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
56 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
114 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 ...
0
votes
2answers
67 views

Log Return of data with 0s [closed]

I am struggling with trying to normalise a dataset I have to use for other functions I have created. I have data that range from 0 to 80 000 and I want to transform this data either by making the ...
4
votes
1answer
45 views

Ascending and descending in the context of the order of operations on Datasets

I did not understand the concepts ascending and descending in the context of the order of operations on Datasets. It is listed in the documentation, on Dataset's page and yet I did not understand. ...
1
vote
1answer
44 views

Count based hypothesis test for inhomogeneous Poisson process

I am intended to fit the following data using InhomogeneousPoissonProcess[] in v12.0. The original form of data tabulated given as below Such a table contains ...
0
votes
0answers
26 views

Heat map from multiple trajectories

I have x (position) v/s t (time) data for 50 trajectories and I want to create a heat map from this data with Mathematica. The data looks like: {{0,0,...,0},{t1,x11,...,x1k},...,{tn,xn1,...,xnk}}. Let'...
7
votes
0answers
217 views

Wolfram Desktop 12.1 fonts are inconsistent within various interfaces of the frontend?

I just installed the Wolfram Desktop 12.1 clean install on windows by first completely uninstalling all previous versions so previous settings don't impact the new installation. The new front end for ...
4
votes
0answers
99 views

Display of datasets

This question is again related to the improper font sizes used in the Windows versions of Mathematica, including version 12.1: Is there a way to change the font size used in the display of Datasets? ...
0
votes
2answers
52 views

How to subtract the received anomalies from the dataset

We have a dataset data = ResourceData["Sample Data: Boston Homes"] Find anomalous examples in the dataset. ...
3
votes
1answer
55 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.
55
votes
2answers
2k views

User interface Mathematica 12.1 terribly slow

I installed Mathematica 12.1 a few days ago and now I experience a serious speed slow down. When working with datasets for example Mathematica is close to be unusable. Even in the help systems it ...
14
votes
2answers
398 views

How to merge dataset rows conditionally?

I have dataset of the following form. I have processed the dates to be DateObjects and now would like to merge the hours per the date because sometimes multiple ...
3
votes
2answers
69 views
6
votes
2answers
126 views

How to subtract two lists based on a key

Let's say you have the following datasets {set1, set2}: ...
2
votes
1answer
39 views

How do I make exponential graph show only one trend-line with two lists of data?

Below is my code containing two lists of data, I need the graph to show one exponential trendline from an exponential equation, but it currently shows one trendline per item in the list. I am sure ...
2
votes
1answer
69 views

Is there a way to `Merge` with different functions across Keys?

Many times when working with Dataset I have to GroupBy. If for example, I group by and aggregate on columns of the same type ...
1
vote
0answers
45 views

Append columns to a Dataset without unpacking via Normal [duplicate]

I would consider myself transitioning from beginner to intermediate skill in Mathematica, and am finally exploring Associations and Datasets. I am using version 12. I have a Dataset (list of ...
3
votes
0answers
43 views

How to implement with Rlink and RFunction the mblm non parametric regression library in R

See (https://cran.r-project.org/web/packages/mblm/index.html) I would imagine this could be done analoge to a blog from 2013 by Jon Mcloone (https://blog.wolfram.com/2013/05/22/why-would-a-...
0
votes
0answers
39 views

How to use Headers after imported them?

I read this post here, and played a bit with the Import function, so I now have my data imported from xlsx file, which say is a <...
5
votes
1answer
118 views

Converting Org-Mode Table into Wolfram Dataset

Simula to this post, is there a way to convert an org-mode table (say in the form of a string) to a Wolfram Dataset? So that for example this: ...
13
votes
3answers
291 views

How to make arbitrary transpositions of associations and datasets

Is there a general Transpose for Dataset/Association that will transpose arbitrary levels, ...

1
2 3 4 5
12