Questions tagged [data]

Questions on systematic data handling and analysis, including data correction, manipulation, or selection of user-data or built-in data available with Mathematica.

Filter by
Sorted by
Tagged with
3 votes
1 answer
77 views

Extremely slow import of mx files with Molecule objects [closed]

Version: 13.0.1 on Linux Hello, I recently found a collection of 39,361 SMILES strings that I converted to Molecule format with Mathematica. I then exported the resulting list of Molecule objects into ...
user avatar
  • 483
3 votes
1 answer
31 views

Retain Values in new column when Appending a column to an existing dataset

I am working on a basketball data set. I am trying to append a "Class" column which looks at the "Pos" column and assigns a 1 if a forward (C, PF, SF) or a 2 if a guard (PG, SG). I ...
user avatar
0 votes
1 answer
30 views

How to import a file with 3 columns of numerical data and visualize it with ListPointPlot3D? [closed]

The file is plain ascii. e.g. 100 rows, each row like "1.23 2.34 3.45". I'm a complete novice with Mathematica, I assume this will be trivial.
user avatar
1 vote
1 answer
38 views

Correlation Matrix Not Working on All Numerical Dataset

I am trying to perform a correlation matrix on an all numerical dataset, imported from a .csv with headers specified as row 1: ...
user avatar
1 vote
1 answer
52 views

Can WordFrequencyData run faster?

I want the WordFrequencyData of the whole WordList[] However it takes too long to get the result. ...
user avatar
0 votes
1 answer
61 views

How to output data according to specific requirements and improve the calculation accuracy of NDsolveValue

How to output data after solving an equation? That is, the output x, and the y value corresponding to x. ...
user avatar
  • 13
4 votes
4 answers
414 views

Find fit function

I want to find a fit function for the following data. Can someone suggest the best-fit function for the following data? The upper part of the data set is difficult. ...
user avatar
5 votes
2 answers
312 views

Find intersection of curves

I have a curve (not a function) as a list of points and I would like to find the intersection of the curve with another curve (another set of points). To be more concrete about the problem I am ...
user avatar
  • 327
4 votes
2 answers
532 views

Tabulating and visualizing the expression 0.905*(0.1^n)/n!

I need help tabulating and visualizing the expression, 0.905*0.1^n)/n!, where n goes from 0 to 100. I want to store all the values, and use those values to plot a ...
user avatar
1 vote
0 answers
43 views

Molecule fingerprint MorganConnectivity

I am looking for a way to calculate the MorganConnectivity finger print for molecule object in Mathematica. v12.1 seemed to have an undocumented function MoleculeFingerprint ...
user avatar
  • 483
0 votes
1 answer
89 views

how can I arrange points to get the Circumference? [duplicate]

this is a simple example, points can circumvent complex shapes too. ...
user avatar
4 votes
1 answer
78 views

How can I get the intersect points of lines connecting different points?

How can I get the numeric points {x,y} where the lines below intersect, please? ...
user avatar
4 votes
3 answers
261 views

How can I rotate a 2D shape with respect to another?

...
user avatar
5 votes
4 answers
253 views

Fit data with NormalDistribution

Good day to all! I have some data that I would like to fit with a normal distribution: ...
user avatar
5 votes
2 answers
141 views

how to avoid duplication with 2D Sum [closed]

I would like to do 2D $\sum_{i,j}$ where $i\neq j$ and only $(i,j)$ must included and avoiding $(j,i)$ due to symmetry. Here as an example: ...
user avatar
1 vote
2 answers
91 views

ListLogLinearPlot

I have a table of data containing four columns 0. 4.246579091762123e-6 0.03265347837226368 2.194410478609251 1. -0.12938661984768404 0.16521412970349758 1.856296278715755 2. -0.6524263619026305 1....
user avatar
  • 279
1 vote
0 answers
28 views

Invalid character when importing XML

I am having trouble importing XML data taken from Open Street Map. This seems to be due to a problematic Asian character. Though the full file is quite large, here is an simplified example of the XML ...
user avatar
  • 393
2 votes
6 answers
235 views

Finding fit function for a given data

In the following, there is some data given. How to find the best fit function of one variable with multiple parameters that best describe this data? It's better to check the agreement on the ...
user avatar
1 vote
2 answers
142 views

How to simplify combined data

Let's consider the following sample data ...
user avatar
  • 8,308
2 votes
3 answers
102 views

Custom normalization of Histogram

Let us consider the following lists SeedRandom[1] list1 = RandomReal[{-10, 10}, 1000]; list2 = RandomReal[{-10, 10}, 200]; Histogram[{list1, list2}, 100] The ...
user avatar
  • 1,578
1 vote
1 answer
56 views

Listplot legend in one column

I am trying to plot multiple curves with ListPlot. Since I have 12 curves to plot, the legend appears in two columns. I looked into this solution but it does not work with Listplot. Can anyone help? ...
user avatar
  • 37
0 votes
2 answers
69 views

How to export 2730 Table with different name?

I have 2370 table which I need to export in cvs format with different name and I don't want to do it manually. Let say I have this 3 tables: ...
user avatar
  • 383
1 vote
1 answer
114 views

How to calculate Jensen-Shannon divergence?

How to write the function (or any other methods) to calculate Jensen-Shannon divergence (JSD) for two (p and q) discrete probability distributions? I need to calculate JSD for too many different (over ...
user avatar
  • 383
0 votes
2 answers
58 views

Problem with multidimensional interpolation: "Data point {0,0} contains abscissa 0, which is not a real number"

I'm trying to do a multidimensional interpolation. For simplicity, say I have the following array: {{{a,b},c},{{d,e},f},{{g,h},i}} This means that I have a two-...
user avatar
  • 618
6 votes
3 answers
240 views

How to merge join two matrixes?

First, I have a 3x3x2 matrix A, which looks like: then i have a 3x3x1 matrix B, which is: How to merge the B into A and make a 3x3x3 matrix by appending each of the element of B into corresponding ...
user avatar
  • 113
-2 votes
1 answer
147 views

How to split data in a matrix

Consider the matrix 'm1' : m1 = RandomReal[{0, 1}, {50, 50}]; MatrixForm@m1 The partition of this matrix into non-overlapping rectangles (arranged horizontally) ...
user avatar
  • 939
0 votes
1 answer
74 views

Manipulating dataset [closed]

I have a dataset in form of {{typ1,typ2,typ3..typ15},.....{typ1,typ2,typ3,...typ15}}. The attached image shows the table form of data. I want to select any 3 column of the data and do some calculation ...
user avatar
  • 383
2 votes
2 answers
108 views

Counting the number of elements in bin

I have a 2D dataset (x,y) for which the X coordinate range is -4000-7000 and the y range is 1000-9000. The data needs to be created. I would like to divide the x-y plane into several bins and count ...
user avatar
  • 383
3 votes
3 answers
228 views

Plot associated curves with a color when data ordinates from a complex number

I have a list of data {{x1,c11}, {x1,c12}, {x2,c21},{x2,c22}, {x3,c31},{x3,c32}, {x4,c4}, {x5,c51},{x5,c52}, ...}, in which x is ...
user avatar
  • 889
1 vote
1 answer
51 views

selecting specific part of data set [closed]

I have data set in form {section, Arcangale ,X,Y, type}. Section is the number between 1 to 3 (1,2,3), Arcangale is number change from 0 to 1 something like this (0.0176575), x and y are coordinate (...
user avatar
  • 383
1 vote
2 answers
77 views

Plot two smooth curves from a set of data with interlaced points

I have a set of data which was obtained from numerical calculation. The plot of the original data is as follows (the data is 26Kb only). ...
user avatar
  • 889
4 votes
1 answer
127 views

How can I sort the eigenvalues of a matrix when passing to Plot3D?

these eigenvalues should be separated when sorted in the correct way but it is not the case when passing to Plot3D ...
user avatar
4 votes
1 answer
151 views

How can I speed up processing with DeleteCases?

I would like to get points that are only inside a region. Here are the region and unfiltered points: ...
user avatar
2 votes
1 answer
102 views

How can I smooth sharp edges in ListDensityPlot

I have this data and there are some zigzag behaviors around the sharp edges ...
user avatar
3 votes
1 answer
100 views

Problem with Interpolation in Density Plot

I have this DATA points: ...
user avatar
5 votes
2 answers
122 views

How can I sort a data in specific form for Interpolation?

I have data of closed shape form ListPlot[data, AspectRatio -> 1] I would like to Interpolate this data to get the missing points so I am using ...
user avatar
-2 votes
1 answer
70 views

How to make a graph of derivatives for a set of points [closed]

Hello and merry christmas! I've been trying to get a simple graph of derivatives (graph slope) out of a set of data. I read here this is the way to do it, but couldn't manage to make that work.
user avatar
5 votes
1 answer
122 views

How to select data using conditions from associations?

Consider the following dataset: ...
user avatar
  • 3,542
1 vote
1 answer
33 views

Interpolation of a set of points that include a non-numeric real constants

I have a set of data like: matrix=Table[{x,y,x+y*c1},{x,0,1,0.1},{y,0,1,0.1}] where 'c1' is a real constant. I'm trying to create an interpolation function called '...
user avatar
-1 votes
2 answers
55 views

How to extract entities from TravelDirectionsData?

I am wondering how to extract entities such as states and cities from TravelDistanceData. For example, given the following example from the documentation, how could I extract the states the route goes ...
user avatar
3 votes
1 answer
128 views

Is it possible to improve a code related with iterative closest point (ICP) algorithm?

I am trying to write a code related with ICP algorithm. The purpose of the code is matching a target data with a reference data by translational operation in XYZ axes (3-degree-of-freedom (DOF) ...
user avatar
  • 147
5 votes
3 answers
192 views

How to manipulate the colours when joining points in ListPlot

Suppose I plot out two sets of data on the same graph as follows: ListPlot[{{{1, 1}, {2, 2}, {4, 4}}, {{3, 3}, {5, 5}, {6, 6}}}] The colours of the points change ...
user avatar
  • 755
3 votes
1 answer
92 views

How to export/import the following data in a proper way?

Consider numeric data that has the form {{{a,{b,c,d},e,f,g,h,k,{l,m,n},o}, ...},...}, where the first ... mean other similar rows, while the second ... mean ...
user avatar
  • 3,542
1 vote
0 answers
28 views

How to draw a line marking where each chapter occurs in a text? [duplicate]

I am performing a text analysis on C.S. Lewis's book The Lion, the Witch, and the Wardrobe. I have created the following analysis of textual occurences of Aslan or Lion, Peter, Lucy, Edmund, Susan, ...
user avatar
0 votes
1 answer
79 views

How to get the Inverse Fast Fourier Transform (ifft) of a dataset? [closed]

I'm looking at the inverse fast Fourier transform as calculated by Matlab. In the question "What's the correct way to shift zero frequency to the center of a Fourier Transform?" the way to ...
user avatar
  • 1,100
0 votes
1 answer
66 views

How to graph a discontinuous array of data

I have an array of data, I am trying to plot it but I need to draw a line each 10 data and displayed as a discontinuous function. I tried using ListLinePlot but ...
user avatar
  • 1
1 vote
1 answer
45 views

How to optimize time to obtain large data set? [duplicate]

I would like to generate a set of data of matrix of size 1000 x 1000 x 1000 in a region defined by 0 outside the sphere of radius r=100 centered in the coordinate (500, 500, 500), and number 1 inside ...
user avatar
  • 1,100
1 vote
2 answers
44 views

`KernelMixtureDistribution` error message about precision

I want to use KernelMixtureDistribution to deal with a large amount of data points. For example, the following codes shows how I use it: ...
user avatar
  • 463
13 votes
3 answers
492 views

Animated bar chart race, a popular data visualization

Recently I see more and more data-viz called "Animated bar chart race". Some random examples, and note, how smoothly and organically everything changes in these videos.: https://flourish....
user avatar
1 vote
2 answers
62 views

Replacing data in a new table using the index

This problem might be similar to others but I could not find the solution with the extra step I need. I have two tables with the same value on the x axis, and different in the y. I want to pick values ...
user avatar
  • 81

1
2 3 4 5
17