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
5
votes
2answers
101 views

How to subtract two lists based on a key

Let's say you have the following datasets {set1, set2}: ...
2
votes
1answer
34 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
55 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
42 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
38 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
34 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
107 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
270 views

How to make arbitrary transpositions of associations and datasets

Is there a general Transpose for Dataset/Association that will transpose arbitrary levels, ...
5
votes
2answers
213 views

Picking a different column in each row of a Dataset[]

I have a Dataset[] like this: ...
3
votes
2answers
61 views

Referring to other Block variables within a Block statement?

In ...
11
votes
3answers
241 views

How to get control of Dataset display?

According to the documentation But If I run ...
2
votes
3answers
89 views

Select specific rows of a dataset

I am struggling with extracting specific rows from a dataset. ...
3
votes
1answer
186 views

Narrowing a dataset down by string pattern

For dataset ...
3
votes
1answer
46 views

Question on combining 2 datasets with common key

Hi I'm trying to combine 2 datasets with a common key which I'm not able to resolve with JoinAcross. 1st dataset is ...
6
votes
1answer
205 views

Importing a Wikipedia Table as a Dataset?

I am trying to import this table from Wikipedia into Mathematica as a Dataset. The fields I'm interested are Name, ...
0
votes
0answers
41 views

Importing text file to plot animation in 1D

I have .txt file with data that I want import into mathematica and then create a 1D animation/simulation of 3 curves. The format of the ...
0
votes
1answer
55 views

Parameter space for a class of problems

I have some simple equations like p1=(9x+30y^2+28z)/Sqrt[x^2+y+z^3]; p2=(90x+30z)/Sqrt[x^2+z]; p3=(76x^2+57y+z)/z; p4=(5x+36y) Now I have the range of p1,p2,p3,...
10
votes
1answer
217 views

Dataset function and related gadgets not ideal for large datasets

There's a performance bottleneck when using these types of functions. If I had a large CSV file and were to import it as a regular 'unstructured' CSV, I save almost half the time importing the file, ...
5
votes
1answer
86 views

Apply a function over Dataset as if it's an Association

Take a list of Associations. Using the Dataset function, this can be converted to a structured dataset. ...
2
votes
0answers
39 views

Convert Key to Value in Dataset with nested Associations [duplicate]

Let's say I have a Dataset consisting of nested Associations (in this case, created through a ...
11
votes
1answer
99 views

Nondeterministic $Failed when mapping over a Dataset

Consider the following simplified example (on Mathematica 12): ds = Dataset@{<|"hell" -> "o"|>, <|"hell" -> "no"|>}; ...
0
votes
0answers
41 views

Finding Fourier transform of a quantity v/s theta (0 to 360 degrees)

I have a physical quantity (experimentally measured) lets say T whose variation I have measured with angle (theta in degrees). I want to find out the Fourier components of this quantity with respect ...
2
votes
1answer
43 views

Interpolating and subtracting two sets of data

I have a data set "data9k" with x varying from 0 to 365, and another data "data0" set with x varying from 0 to 365. But the x values for both data sets are not same but similar. I want to subtract the ...
0
votes
0answers
19 views

SemanticImport adds garbage characters to key name

I want to import a csv to a dataset. This exact dataset successfully imported on a PC, but on a Mac one of the columns has garbage characters added to the key (see below example). I don't believe ...
5
votes
1answer
73 views

Applying a function on several columns of a dataset fails on Missing

Consider a dataset with missing values: ...
1
vote
1answer
42 views

Extracting values from a dataset column based on key from a different column

Take a small dataset, for example a sample of the Titanic data: ...
0
votes
1answer
32 views

Isolating Dataset group categories with numerical values introduced as string entries

I start with the following table: ...
0
votes
1answer
35 views

Discarding Files of Different Lengths

I have a set of imported CSV files stored under the variable name data. The imported files are of different lengths and I would like to be able to discard the ones ...
1
vote
1answer
40 views

Building a nine - region cluster chart but, getting inaccurate plot-legend when empty subregions are present

This is a follow up question to the one submitted at the following: Stack exchange Link I quickly get to the subject: ...
0
votes
0answers
31 views

How to count n observations/ rows in a table?

What is the expression to count the rows/ observations? This is how I entered data: ...
0
votes
0answers
19 views

Increase number of rows displayed by Dataset [duplicate]

Is it possible to increase the number of rows (records) displayed by Dataset? By default, only the first few rows are displayed. Which, in many cases, is fine. Especially for large datasets. ...
3
votes
1answer
91 views

Join Datasets based on row index

I would like to join two Datasets based on their row index. Unlike ordinary columns, a row index does not have a name. Single Row Index ...
2
votes
1answer
72 views

Sort Dataset by Row index after GroupBy

I would like to sort my Dataset by its row index. Unlike an ordinary column, this index does not have a name. ...
2
votes
1answer
38 views

Picking rows from a list

Let's consider the following list data = {{1}, {}, {1,1,1}, {1,1}, {1}, {1,1}, {1}, {2,1,1}, {3,1}, {3,2,1}, {}} As we can see, some rows have 0, other 1, other ...
4
votes
4answers
179 views

Padding a column of lists

I have data in the the form of a table, whose one column is the following ...
9
votes
1answer
123 views

How can weighted averages be calculated for a Dataset summarized with GroupBy

I would like to compute market-value weighted stock prices grouped by sector from a Dataset but can't figure out how to apply ...
0
votes
1answer
101 views

Using Semantic Import to do an Excel-like VLookUp using Mathematica

I'm following an example provided in the following Stack Exchange Link but, using a different approach. My data is contained in an Excel workbook called "Input Workbook.xlsx" as shown here: I ...
12
votes
1answer
166 views

Using Select on Dataset with missing keys

I have a very large dataset with about a million entries with up to 75 keys each. Across the whole dataset about half of the keys are blank. In order to reduce filesize, I have used the following ...
2
votes
0answers
80 views

How to display rotated columns names in dataset?

Consider the following minimalist Dataset: ...
5
votes
3answers
297 views

Changing Row Keys into Normal Rows

I have a dataset with column and row keys: ...
1
vote
1answer
95 views

How to build a structured data table

I'm going straight to the task; I start with the following list of Florida counties: ...
3
votes
2answers
43 views

Dataset query for upper levels

I have the following data set: ...
3
votes
2answers
77 views

Row Keys in Datasets: JoinAcross row keys; Demoting or deleting row keys

I want to combine two datasets that share row keys but have different column keys. Visually, this looks like a JoinAcross on the row keys to me, but the column of row keys doesn't appear to be named. ...
7
votes
2answers
103 views

Creating a new Dataset column using a map from a second Dataset

Say I have two datasets: one is a detailed list of events, and one is a coarse list of events. I want to add a column to the detailed list from the coarse list (for the purposes of sorting). For ...
1
vote
0answers
50 views

Wikipedia Edits History: how to split edit history and comments

I am trying to import Wikipedia Edit History. The code that I am using is the following: ...
1
vote
1answer
63 views

Taking the largest 10 items of a dataset? [closed]

With a dataset like: How can one take the top 10 items (largest by FileSize in this case)?
8
votes
1answer
156 views

Datasets and Time Values: Filtering and Plotting

After struggling for a few weeks, I have accumulated a few examples of challenging date-related operatations with datasets. Some I have partial solutions; others I cannot yet do. The resources on ...
9
votes
3answers
230 views

Parsing Org-Mode Timelog Data

Suppose we have in ~/time-data/time-data.org the following data: ...
0
votes
1answer
33 views

Import multiples images from FITS format

I want to import multiple images from url that are within a .txt but I am getting error, is not a valid file, directory, or URL specification ...

1 2 3 4 5 11