Skip to main content

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
1 answer
41 views

Removing message "Data not saved. Save now" from Dataset object

How can I remove the message "Data not saved. Save now" from a Dataset object? I know I can click on it, but when I reevaluate the cell, the raft appears again. The main problem is that the ...
elbOlita's user avatar
  • 1,681
4 votes
1 answer
93 views

Export a dataset to Excel into a named sheet

I have a dataset: ...
Eisbär's user avatar
  • 1,476
1 vote
1 answer
75 views

How to compute a weighted mean as a measure of central tendency?

Imagine I have data points in triplicates, as follows $$ L=\begin{pmatrix} p_{11} & p_{12} & p_{13}\\ p_{21} & p_{22} & p_{23}\\ & \vdots &\\ p_{n1} & p_{n2} & p_{n3} \...
sam wolfe's user avatar
  • 4,863
1 vote
1 answer
77 views

How to extract elements from a Table?

I have a time series table of three players ...
RPlotter's user avatar
5 votes
2 answers
163 views

How to combine two different datasets to create a unified dataset

I have two different datasets : dsDat1 and dsDat2: ...
Tugrul Temel's user avatar
  • 6,223
0 votes
0 answers
48 views

Splitting HDF5 file

Below I am attaching the h5 file that I want to analyze. There are two branches "S_F_VAL_0", "S_F_VAL_1" Each branch has 10 branches, which then have a dataset that is a 3D array ...
PhysicsStudy's user avatar
2 votes
4 answers
116 views

Rescaling the data points

Lets say I have the following data points, ...
a019's user avatar
  • 867
3 votes
2 answers
281 views

Reading what is inside DataStructure[]

In my code I end up with such data structures and I cannot see what is inside. Is there a command to open this type of data structure? I tried \\Normal but it does ...
Tugrul Temel's user avatar
  • 6,223
3 votes
0 answers
70 views

How to display a circular data set?

Is there a straighftorward way of building the following plot where 5 data sets are displayed circularly, and some specific regions are highlighted (indexed i to vi)?
sam wolfe's user avatar
  • 4,863
3 votes
2 answers
84 views

Multiple append over a Dataset

I have the following association : ...
Jocelyn Minini's user avatar
4 votes
2 answers
85 views

How can I access the default value for ItemDisplayFunction?

Let's say I have some data I've imported and processed: ...
lericr's user avatar
  • 29.2k
1 vote
1 answer
149 views

How can a directed network model be linked to Dataset[ ] for further computation?

REVISED Question: My only request is to know how to monitor the evolution of {agentStates, steps} in simulateSlow[...] function. ...
Tugrul Temel's user avatar
  • 6,223
0 votes
0 answers
59 views

Problem when copying and pasting codes

When I copy codes I usually have problems, because when I paste them to the Mathematica notebook, they don't run as they should. It has happened to me already several times, and specifically now when ...
Emerson Villafuerte's user avatar
0 votes
0 answers
24 views

Performing Efficient Select on Data with Different Time Resolution

I have two data sources with different time resolution. For data source A (temperature) I have about 1 s time resolution. For data source B (spectra) I have 0.01 s time resolution. I would like to ...
BesselFunct's user avatar
6 votes
3 answers
130 views

How to add a column to a dataset made up of an association of associations?

A dataset can be created in at least two ways: first, from a list of associations, second, from an association of associations (I know that it is also possible to create it as a list of list and an ...
Emerson Villafuerte's user avatar
0 votes
0 answers
67 views

Download html file

I want to download the data found on the following page and I am unable to do so. https://resultados.admision.uni.edu.pe/ep1.html I have already tried all the options I find in Mathematica but I can't ...
Emerson Villafuerte's user avatar
1 vote
0 answers
57 views

Selecting from a list of associations

From a list of Associations ...
eldo's user avatar
  • 74.7k
3 votes
0 answers
81 views

Elegant operations on associations and datasets

As a useful extension of this question: Elegant operations on matrix rows and columns I would like to ask: What are for you elegant, short, useful or frequently used functions to use with ...
eldo's user avatar
  • 74.7k
0 votes
0 answers
55 views

How to use JLink to connect and read data from Tableau Hyper using Hyper API?

First of all, here is the link to download the API for Java for Windows. I initially wanted to use NETLink since I have some experience with it but they have ...
user13892's user avatar
  • 9,443
1 vote
2 answers
53 views

Extracting integers from a Dataset containing variables

I want to extract two vectors DataA = {1,0,0,0} and DataB = {0,2,5,0} from a dataset. I tried a few ways including using the dataset and ...
krygh's user avatar
  • 157
5 votes
2 answers
150 views

DateSelect : columnwise selection applied to a matrix

Let consider : A time interval (January given by Time) A random set of values (Minimal example values given by Val) as ...
Jocelyn Minini's user avatar
0 votes
2 answers
59 views

Interpolation function for data with repeating independent variable

I want to find an interpolation function for data in which the x-variable is repeated (example below). The repetition in data is natural and cannot not be eliminated. Can I somehow use ...
SciJewel's user avatar
  • 452
4 votes
1 answer
86 views

Updating a data table

1. Example data I have a data table organized as an Association of Associations: ...
eldo's user avatar
  • 74.7k
1 vote
0 answers
224 views

How to get a dataset from GitHub?

I want to use the dataset on https://quickdraw.withgoogle.com/data And the dataset is published on GitHub at the following address. https://github.com/googlecreativelab/quickdraw-dataset I want to ...
Milk's user avatar
  • 1,718
2 votes
2 answers
109 views

Move rows and columns of an association matrix

Example data: ...
eldo's user avatar
  • 74.7k
3 votes
4 answers
217 views

Add missing column keys

Example data: data = {{"1", 50}, {"1", 60}, {"1", 40}, {"2", 15}, {"3", 18}, {"3", 18}}; The first ...
eldo's user avatar
  • 74.7k
8 votes
1 answer
248 views

Shading of Dataset area

I want to shade a certain rectangular subarea of a Dataset: ...
eldo's user avatar
  • 74.7k
3 votes
2 answers
138 views

Updating multiple columns based on a nested value in an association, create a nested function?

I have a dataset that looks like this and I sorted them by ts since that corresponds to the values of when the data was taken. After reading the primer on associations and keys, and this question, I ...
atomic-muclei's user avatar
4 votes
2 answers
210 views

How to build a ranking matrix

I have the following Association: ...
eldo's user avatar
  • 74.7k
2 votes
0 answers
192 views

How to approximate an exponential series?

Consider the following expression $$ y_j= \sum_{k=0}^{L} \frac{e^{-\sum_{i=-k}^k(k-|i|)x_{j+i}}-e^{-\sum_{i=-k}^k(k+1-|i|)x_{j+i}}}{\sum_{i=-k}^k x_{j+i}}\tag{1} $$ for $1\leq j \leq L$. Given smooth ...
sam wolfe's user avatar
  • 4,863
5 votes
1 answer
106 views

How do I fill in these missing keys with empty strings to get a complete Dataset?

This is my original data: ...
yode's user avatar
  • 26.8k
2 votes
3 answers
308 views

How to plot properly the following data?

Consider the following test data: ...
John Taylor's user avatar
  • 5,827
4 votes
1 answer
126 views

On displaying association, including all items in a nice way?

Currently I use Dataset to display an association in a nice to see way on the screen. However, only top level items are shown this way. And have to click on each ...
Nasser's user avatar
  • 145k
0 votes
2 answers
84 views

Problem during the analysis and plotting of a large data

I am dealing with a large dataset and I need to plot the dataset as a contour plot. The code is as follows: ...
P Pyne's user avatar
  • 453
1 vote
1 answer
155 views

How to merge the lines in the following way?

Consider the following curves: ...
John Taylor's user avatar
  • 5,827
5 votes
3 answers
290 views

How can I select only rows where a column is equal to any value from some list? [closed]

Consider some data data=Table[{RandomInteger[{0,10}],RandomReal[{0,1}]},10]; and some list list={0,5,7,3}; How can I leave ...
John Taylor's user avatar
  • 5,827
2 votes
2 answers
284 views

How to import, read and convert a .bib to .csv format?

I have a document in .bib format, namelad by savedrecs1.bib, obtained from Web of Science. The document have a set of reference, of the type: ...
SAC's user avatar
  • 1,335
1 vote
1 answer
87 views

How to combine two different tables in the following way?

Consider the following two grids: grid1 = RandomReal[{0, 1}, {3, 2}]; grid2 = Flatten[Thread[{#[[1]], #[[2]], Range[3]}] & /@ grid1, 1]; Therefore, ...
John Taylor's user avatar
  • 5,827
3 votes
2 answers
246 views

How to. automate nutrition calculation

Given a vector of quantities: fbs = {6.18*10^6, 2.663*10^6, 1.4735*10^7}; I like to create the following code: ...
Tugrul Temel's user avatar
  • 6,223
0 votes
0 answers
32 views

Question about the behavior of a data point as a function of time

I have a set of data points. The first coordinate is time and the second coordinate is energy. I am trying to figure out how the energy is decaying over time. Particularly, I have to find if it is ...
HadamardN2's user avatar
2 votes
1 answer
155 views

How to pick elements from a set and use them in a sum (or product)

I would like to obtain the sum (or some other reduction) from a set which is the result of a previous operation: ...
Vectorizer's user avatar
4 votes
2 answers
191 views

How to wrap text of large headings in dataset?

I am trying to achieve the following effect produced in Excel in Wolfram Dataset: The following attempt doesn't work: ...
user13892's user avatar
  • 9,443
3 votes
3 answers
220 views

Partition of lists with specified elements

I have an array like this and want to split it into sublists. It should contain the first element "Res" without curly braces and the one sublist starts from 2 to the 9th column the 3rd ...
Miss's user avatar
  • 73
3 votes
2 answers
140 views

How to create a GroupBy function that is better aligned with relational algebra?

I want a GroupBy function that behaves more in alignment with relational algebra principles. I can get what I want if I do it in 2 steps: Preparation: ...
Luxspes's user avatar
  • 930
1 vote
0 answers
36 views

How to keep data/tables stored in Mathematica notebooks for use when reopening the notebook? [duplicate]

When we create a table in Mathematica, can we keep it stored in the Noteboook for use when we reopen the notebook? I know I can export to a CSV or other filetypes and import whenever I need and I know ...
Red Banana's user avatar
  • 5,391
2 votes
0 answers
50 views

How to extract a column in a dataset without row names?

Suppose I have an association such as: ...
Red Banana's user avatar
  • 5,391
4 votes
1 answer
70 views

How can we get/calculate all the available FinancialIndicators outside TradingChart and InteractiveTradingChart?

How can we get/calculate all the available FinancialIndicators outside TradingChart and ...
GarouDan's user avatar
  • 1,536
1 vote
1 answer
98 views

How to speedup calling the interpolation function? [duplicate]

Consider the following data: ...
John Taylor's user avatar
  • 5,827
1 vote
1 answer
97 views

How to put separators in large data set?

I have a large data set. Here is a part of it: {1., 18.6, 460.4346} {2., 28.4, 460.4346} {3., 38.2, 460.4346} {4., 48., 460.4346} How to put a comma separator ...
SciJewel's user avatar
  • 452
6 votes
1 answer
195 views

How to create a cross tabulation table using a Dataset?

After searching a lot from this forum and @Anton Anton's codes on Cross Tabulation, i still cannot find the way to create a dataset table with two-row headers. The ...
Tugrul Temel's user avatar
  • 6,223

1
2 3 4 5
16