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
2
votes
0answers
33 views

Parsing Org-Mode Timelog Data

Suppose we have in ~/time-data/time-data.org the following data: ...
0
votes
1answer
20 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
80 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
37 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
64 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
1answer
51 views

How to get company dataset in original currency?

I have obtained the financial data of a company using Entity["Company", ...]["Dataset"]: ...
0
votes
1answer
38 views

Apply function with multiple arguments to column in dataset

I have a Dataset that requires some cleaning. Let's consider this data: ...
0
votes
1answer
66 views

Correct double distribution function for the following dataset

Consider a dataset data-angles-gamma-factors.txt having the form {{x1,y1},{x2,y2},...}. Each row represents an event with values x,y; all events have the equal ...
0
votes
0answers
39 views

Interpolation of multidimensional data: some domains are lost

I am trying to make a reasonable interpolation of a dataset having the form dataset = {{x1,x2,x3,f[x1,x2,x3]},...}. I to the interpolation in the following way: <...
0
votes
1answer
62 views

Interpolation function error: The quality of the underlying mesh is too low

Consider a dataset BplustoPiXlight.dat (alternative link). I import it and try to interpolate: ...
0
votes
0answers
14 views

How do I apply GeoRegionValuePlot to a grouped Dataset?

I have a database like the one under this question which I transform into a Dataset by applying ...
1
vote
2answers
62 views

Create Dataset from lists

Let's assume I created the following dataset: ...
1
vote
1answer
42 views

How to join N datasets with common headers?

I am new to Dataset. I'm trying to join many datasets, naively trying to use Join, but I think I'm not using it correctly, or ...
1
vote
1answer
36 views

Why UnitCovert doesn't work with Fit?

I need to find the Hubble constant (Ho) in light years, from some data, the exercise tells me that the constant of the hubble is the slope of the line. data: r1 is in MegaParsecs. ...
4
votes
1answer
60 views

Inconsistency in getting Keys, Values and Query for nested Rules

Querying nested Rule expressions of the form a -> v -> b // FullForm Rule[a,Rule[v,b]] for ...
4
votes
2answers
96 views

How to pull out the underlying query syntax being used by dataset?

Consider the following dataset. titanic = ExampleData[{"Dataset", "Titanic"}] If I use the lookup syntax of the dataset like following it creates an equivalent <...
3
votes
1answer
45 views

Calculations on columns (column by column) in Dataset

Dataset from doc: ...
6
votes
2answers
407 views

Convert a huge txt-file into a dataset

My friend has this huge txt-log of sea levels. He wants to organize it into a dataset. After importing it this file a used StringSplit to separate it into rows, then to singular elements ...
1
vote
1answer
43 views

Two ways of obtaining differential distribution using Mathematica do not match

Consider a set of data dataset = {{x1,y1},{x2,y2},...} It contains ~200000 rows. I would like to obtain the pdf for x. I can do this, for example, using two ways:...
1
vote
1answer
31 views

How to display properly Dataset with index column?

I'm trying to construct and display properly DataSet. Everything works fine, except the index column('Year'). I'm trying different variants: Example 1: ...
2
votes
2answers
70 views
3
votes
2answers
72 views

Using DeleteCases with a defined function with two arguments as a pattern

I am trying to manipulate some large datasets in Mathematica. I have plotted the data, and I would like to be able to easily remove points from the dataset, and it's fairly easy to identify the x-...
3
votes
1answer
60 views
6
votes
2answers
222 views

How to read .npy file in Mathematica?

I have a .npy file which is created by numpy of Python as below:- ...
0
votes
0answers
46 views

How to handle exceptions and failures in Mathematica?

In python I can write fallback values like: ...
2
votes
0answers
27 views

one Dataset from multiple csv files

In one folder I have many csv files, all sharing an identical header. I can use SemanticImport to produce a Dataset from each ...
1
vote
1answer
59 views

Matrics manipulations

this is a basic question in Mathematica, I hope to get help to resolve it, How I can extract elements from matrics for example I have ...
0
votes
1answer
54 views

Deriving a list of time differences from a column in a dataset and appending the list as a new column

I know it's a beginner question, but I've struggled with it for some time now and can't find a solution. I have a dataset consisting of timestamps, where I've managed to compute the time differences ...
1
vote
1answer
29 views

FromDMS conversion within a Mathematica Dataset

I have a simple dataset for which I am attempting to modify so that values for two columns, entitled “LATITUDE” and “LONGITUDE” can be converted from a Deg-Min-Sec format, expressed as a String (ie “9°...
1
vote
0answers
61 views

How to display more of the Dataset depth?

Consider the following Dataset. ...
1
vote
3answers
95 views

Group by using a key [duplicate]

I have a dataset which looks like this: I want to create another dataset such that I get the count of A1flag for each userId, i.e., 5311->2, 5313->2. I tried the following code ...
4
votes
0answers
33 views

How to preserve Dataset's pagination inside Manipulate?

I'm having troubles preserving automatic pagination provided by Dataset when it is embedded in a Manipulate. Consider the ...
2
votes
1answer
62 views

How can empty fields in a csv file be set to Missing when importing as a Dataset?

When importing a csv file with empty fields as a Dataset, the empty fields are set to zero-length strings (""). There is an option, ...
1
vote
0answers
39 views

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

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 ...
1
vote
2answers
47 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
111 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
62 views

The specific GeoMarker from DataSet [closed]

With reference to this related topic, I have a map (called EKB): EKB= The coordinates of the map corners: ...
1
vote
1answer
72 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
52 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
111 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
62 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
57 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
22 views
3
votes
2answers
88 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
114 views

ScientificForm in Dataset

Via SQL query I produce a list ...
1
vote
0answers
32 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
47 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
124 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
86 views

How to set up SortBy columns in Dataset dynamically?

Given a dataset like this: ...