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
40 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
28 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
30 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
95 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
259 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
205 views

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

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

Referring to other Block variables within a Block statement?

In ...
11
votes
3answers
231 views

How to get control of Dataset display?

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

Select specific rows of a dataset

I am struggling with extracting specific rows from a dataset. ...
3
votes
1answer
182 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
197 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
52 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
214 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
83 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
40 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
70 views

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

Consider a dataset with missing values: ...
1
vote
1answer
39 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
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
28 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
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
67 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
176 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
121 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
95 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
159 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
78 views

How to display rotated columns names in dataset?

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

Changing Row Keys into Normal Rows

I have a dataset with column and row keys: ...
1
vote
1answer
94 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
74 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
100 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
48 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
152 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
227 views

Parsing Org-Mode Timelog Data

Suppose we have in ~/time-data/time-data.org the following data: ...
0
votes
1answer
32 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 ...
2
votes
1answer
97 views

Scraping 2020 Polling Data w/Mathematica?

Is there a way to use Mathematica to scrub the latest ("RCP average") polling data for each of the 2020 Democratic Primary candidates?
1
vote
1answer
43 views

Applying Function to Ambiguous Dates in a Dataset

I have a large Dataset with a few columns that contain ambiguous date strings in a variety of formats. I am wanting to reformat these so they are all the same. ...
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 ...
2
votes
2answers
76 views

How to get company dataset in original currency?

I have obtained the financial data of a company using Entity["Company", ...]["Dataset"]: ...