Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

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.

3
votes
2answers
58 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 ...
2
votes
1answer
51 views

How to set up SortBy columns in Dataset dynamically?

Given a dataset like this: ...
1
vote
0answers
43 views

what is equivalent of dataset when using with APIFunction? [duplicate]

I am researching on building a backend for website using Wolfram. APIFunction is great to use, but I can't figure out how should I store data like using dataset in a local notebook when using ...
11
votes
3answers
247 views

Deleting noisy data from a plot (manually) and export the best remaining data

I have the following temperature time-series. As you can see it contains very very noisy points in some periods (Fig.A). I tried to approach the best data(the black one in the center) based on the ...
1
vote
2answers
103 views

Select items from dataset with GUI using checkbox and Togglebar : empty results with DynamicModule

I have a dataset or records, I want to select records with a GUI (manually ticking on the selected item). Then, I want to apply functions to those items (not in this question). I think Im almost ...
2
votes
0answers
37 views

Calculate the precision@k in Classify

I am interested to measure a precision@k. The Classify function provides a build in an option for that or an elegant approach to calculate this without the need to ...
5
votes
2answers
76 views
1
vote
3answers
83 views

Most efficient way to replace/ update the values multiple rows and columns of a Dataset

Suppose we wish to replace the cols "b" and "c" of rows 3 to 5 in the following dataset to b and c respectively: ...
1
vote
1answer
35 views

Dynamic DateListPlot with multiple categories backed by DataSet

I have a DataSet that contains records with: an "activityName" string representing the kind of activity a "duration" value representing minutes a DateObject representing a date and time named "...
3
votes
1answer
77 views

TakeList of a Dataset

Check this out I want to split the Dataset for graphical reasons, like creating a nice composition on a page, TakeList should ...
2
votes
1answer
45 views

Replacing values in a dataset

Could someone explain why ...
0
votes
1answer
103 views

Aggregate function problem

I use a function to do something similar to a SQL sum. I've asked about simplifying it in another post. I'm still using this function and it works well for aggregates like ...
2
votes
1answer
47 views

Filter rows in nested Association / Dataset using Select

The Dataset I am working with has the following nested structure. ...
1
vote
1answer
88 views

Problem importing from HDF5

I'm trying to import an item from a valid HDF5 file, but I get this error: I can read the metadata, but cannot import the actual tensor dataset: And yet it's not an issue with the file's data - as ...
4
votes
1answer
154 views

How to export a Dataset to JSON or CSV?

I am getting wolfram CDF format from this, ...
2
votes
1answer
73 views

How can you replace a column of a Dataset with another column or list?

Consider the dataset below with a "x" and a "CH 1" column: How can I replace the "x" column with a new set of data? For example, how could I replace "x" with values starting from 0 and incrementing ...
4
votes
1answer
52 views

Operator form for Histogram of multiple datasets?

I would like to plot a histogram for multiple datasets in a dataset query, but can't quite seem to make it work in operator notation: ...
1
vote
1answer
122 views

How to make an Association of Assocations [closed]

As a learning exercise I’m trying to convert some data we have from spreadsheets into an association of associations. However, I’ve only managed to format two different associations, a key of the ...
10
votes
5answers
285 views

Select only first n elements in operator form?

Is there any way to make Select take a second argument (to select only the first n elems) while in operator form? It's too ...
3
votes
0answers
132 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:- ...
3
votes
0answers
42 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:- ...
5
votes
5answers
373 views

Vector operation on datasets

I have a dataset like: ...
3
votes
3answers
117 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: ...
0
votes
0answers
39 views

Nested Dataset and the Query operator

Suppose I have the following Dataset, one of whose columns is a nested Dataset: ...
0
votes
1answer
43 views

How to combine 3D figure with LogLogPlot to produce 2D figure

I have (x,y,z) set of data and I want to combine 3D figure with LogLogPlot and to produce 2D figure ...
2
votes
1answer
56 views

Where is the folder storing the ResourceData files?

I wonder where would the file be stored in Windows when I use the function ResourceData. Since sometimes the data is quite large, I would like to have a look at the ...
6
votes
1answer
83 views

How to update values of particular keys efficiently

Say I have a list of Association, SeedRandom[45] test = Association[Table[i -> RandomInteger[30], {i, 6}]] <|1 -> 18, ...
3
votes
2answers
101 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
87 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. "...
5
votes
3answers
144 views

Convert Matrix into a long form Dataset

I would like to convert a matrix into a dataset. The structure of the matrix is: ...
1
vote
4answers
86 views

setting size of images which are result of TextRecognize

Im learning Mathematica and the Wolfram language for shot time by myself. Its a pain for me that many settings are somehow hidden. Now I spent hours to find solution for something I already did with ...
0
votes
2answers
135 views

Prepare a dataset in Excel then import to Mathematica

I need to prepare a dataset, which will be much easier using e.g. Excel. Then I want to import and use it in Mathematica. One row in the dataset would look like this in Mathematica: ...
2
votes
1answer
33 views

Problem with Select using a Part [duplicate]

I have the following dataset: ...
0
votes
1answer
53 views

Export data of a function of 3 variables

I have a function like this ...
1
vote
1answer
86 views

Dynamically update of Association

I try dynamically to add new keys and update the values of existing keys in given dataset (Association). I implement this by the following code: ...
1
vote
0answers
63 views

What is a good way to store TimeSeries objects?

This is a question about proper ways to save and retrieve TimeSeries. I am processing data from two separate sources and compile around 150 ...
1
vote
2answers
103 views

Select several values in nested associations

I have nested associations like this: ...
9
votes
1answer
92 views

JoinAcross datasets based on Equal and not on SameQ

JoinAcross will join keys if values are the same (SameQ==True) but not if there are equal. For example these two associations are not joined : ...
1
vote
2answers
212 views

Export DataSet as CSV or XLS

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

ListPlot from DataSet

Let's say that I have the following Dataset: ...
1
vote
2answers
63 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 ...
7
votes
1answer
153 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
26 views

combined time-series plot from time-series dataset [duplicate]

I want to make a DateListPlot showing multiple series from a Dataset (ds). Each row of the ...
0
votes
0answers
71 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
195 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
150 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
63 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
52 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
252 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
84 views

`Transpose` nested `Association`

Say I have a nested Association like this one: ...