Stack Exchange Network

Stack Exchange network consists of 175 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.

1
vote
0answers
27 views

How do I Select when the key of an association is a multi-word string

I have imported some survey responses into a Dataset. I now want to select those rows where the response to "participant type" == "Virtual". I discovered that this ...
0
votes
0answers
37 views

How do dereference part of a dataset? [on hold]

I have a certain function that is returning data in curly brackets instead of a direct value. How I extract the value so that I can use it?
1
vote
2answers
36 views

Changing values in a column of a Dataset using a Do loop

I'm trying to use "Do" to change the entries in a column of a dataset using two adjacent columns. When I simply assign i and execute the lin for each value of i, it works but when I enclose it in Do, ...
2
votes
1answer
92 views

Deleting missing values from a dataset

I wanted to create a dataset of all UFO sightings in April of 2018. The AssociationThread doesn't want to work, because some of the entries are missing value, what ...
0
votes
1answer
50 views

The specific GeoMarker from DataSet

With reference to this related topic, I have a map (called EKB): EKB= The coordinates of the map corners: ...
1
vote
1answer
71 views

How do I formulate a query on the data returned by ResourceData? [closed]

I struggle to answer the following question: Use ResourceData["New Orleans Slave Sales 1856-1861"] to answer the following question: How many rows in which the ...
4
votes
2answers
42 views

Simple dataset query

Why does taking a Part fail in a Dataset query function when there is an operation in the index argument? ...
1
vote
2answers
75 views

Importing Excel File as Dataset

This might be a basic question but I couldn't get it to work. I have a dataset in Excel that I import to mathematica using ...
3
votes
1answer
55 views

What's the best way to import such dataset?

https://www.ocr.org.uk/Images/400305-large-data-set-lds_1-h630-2018-h640-2018-2019-pre-release-data-mei.xlsx What's the best way to import such dataset? I have tried to use ...
4
votes
0answers
53 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: ...
0
votes
0answers
21 views
3
votes
2answers
58 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"}]; ...
2
votes
3answers
103 views

ScientificForm in Dataset

Via SQL query I produce a list ...
1
vote
0answers
29 views

Issues with Manipulate (or variable assignment)

I am working to take a large manipulator I have built and generalize it, but I keep running into some variable assignment issue. I made a short example of my issues below: Set up: ...
1
vote
1answer
37 views

Building a data frame from a list of lists of lists

OK, let's say we have a following list of lists of lists: ...
3
votes
2answers
84 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
81 views

How to set up SortBy columns in Dataset dynamically?

Given a dataset like this: ...
1
vote
0answers
45 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 ...
13
votes
3answers
299 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
110 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
39 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
78 views
1
vote
3answers
93 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
38 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
85 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
58 views

Replacing values in a dataset

Could someone explain why ...
0
votes
1answer
111 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
54 views

Filter rows in nested Association / Dataset using Select

The Dataset I am working with has the following nested structure. ...
1
vote
1answer
112 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
185 views

How to export a Dataset to JSON or CSV?

I am getting wolfram CDF format from this, ...
4
votes
2answers
136 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
54 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
123 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
294 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 ...
4
votes
0answers
144 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
45 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
377 views

Vector operation on datasets

I have a dataset like: ...
3
votes
3answers
123 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
51 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 ...
6
votes
1answer
88 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
107 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
106 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
149 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
101 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
149 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
34 views

Problem with Select using a Part [duplicate]

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

Export data of a function of 3 variables

I have a function like this ...
1
vote
1answer
94 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
66 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 ...