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
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-...
1
vote
0answers
41 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 ...
13
votes
3answers
265 views

How to make arbitrary transpositions of associations and datasets

Is there a general Transpose for Dataset/Association that will transpose arbitrary levels, ...
0
votes
0answers
31 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
98 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: ...
11
votes
3answers
234 views

How to get control of Dataset display?

According to the documentation But If I run ...
33
votes
5answers
2k views

Mathematica 10 Dataset doesn't format more than 4 columns?

Try this code in Mathematica 10: Dataset@Table[Association[ToString[#] -> # & /@ Range[4]], {2}] I got a nicely formatted table: But when I do the same ...
15
votes
2answers
331 views
1
vote
2answers
150 views

How to work with dataset without column names?

I have a dataset of 2 columns as follows a 1 b 2 c 3 That dataset doesn't have names for both columns, how should I use select to work on it, i.e., get data with the second column number ...
5
votes
2answers
209 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 ...
2
votes
0answers
78 views

How to display rotated columns names in dataset?

Consider the following minimalist Dataset: ...
2
votes
3answers
79 views

Select specific rows of a dataset

I am struggling with extracting specific rows from a dataset. ...
9
votes
3answers
228 views

Parsing Org-Mode Timelog Data

Suppose we have in ~/time-data/time-data.org the following data: ...
3
votes
1answer
183 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
199 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
40 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
54 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
216 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, ...
1
vote
2answers
639 views

Export DataSet as CSV or XLS

One question: How can I export a DataSet to CSV and XLS ? ...
5
votes
1answer
84 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
40 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
41 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 ...
4
votes
1answer
81 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:- ...
4
votes
1answer
196 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:- ...
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
70 views

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

Consider a dataset with missing values: ...
1
vote
1answer
40 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: ...
16
votes
3answers
928 views

Simple way to concatenate Dataset columns

Consider these two datasets: d1 = Transpose@Dataset[<|"a" -> Range[5]|>]; d2 = Transpose@Dataset[<|"b" -> Range[5, 1, -1]|>]; {d1, d2} What's ...
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
39 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
29 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
1answer
98 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 ...
2
votes
0answers
96 views

Converting Datasets into EntityStores: best practice?

The advent of the family of *edEntityClass functions in V12 looks very promising. Dataset and its related queries are ideal for ...
3
votes
2answers
188 views

Blocking Dataset`$ElisionThreshold doesn't work

I would like to define a simple function to automatically show all rows in a Dataset. Based on Taliesin Beynon's answer, I tried the following trivial snippet: <...
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
85 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
68 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. ...
3
votes
1answer
252 views
4
votes
4answers
178 views

Padding a column of lists

I have data in the the form of a table, whose one column is the following ...
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 ...
9
votes
1answer
122 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 ...
1
vote
2answers
114 views

Apply function with multiple arguments to column in dataset

I have a Dataset that requires some cleaning. Let's consider this data: ...
12
votes
1answer
163 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 ...
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: ...
5
votes
3answers
295 views

Changing Row Keys into Normal Rows

I have a dataset with column and row keys: ...