Link Pandas and OpenTURNS

# sphinx_gallery_thumbnail_path = '_static/pandas.png'

In this example we are going to explore interaction with Pandas data analysis tool.

from __future__ import print_function
import openturns as ot
import pandas as pd
ot.Log.Show(ot.Log.NONE)

Create a sample from a 3-d normal distribution

sample = ot.Normal(3).getSample(10)

Create a DataFrame from a Sample

df = pd.DataFrame.from_records(sample, columns=sample.getDescription())
df.describe()

	X0	X1	X2
count	10.000000	10.000000	10.000000
mean	0.330767	0.078262	0.028626
std	1.068377	0.927432	0.924196
min	-0.721533	-1.488986	-1.787964
25%	-0.488980	-0.304870	-0.620888
50%	0.155288	-0.027645	0.337171
75%	0.466659	0.858217	0.506955
max	2.514145	1.367826	1.188010

Create a Sample from a DataFrame

sample2 = ot.Sample(df.values)
sample2.setDescription(df.columns)
sample2

	X0	X1	X2
0	-0.427656	1.123174	1.18801
1	2.514145	-1.488986	0.5213786
2	-0.5094218	-0.326085	0.4636851
3	-0.09078383	0.9957932	-0.1394528
4	-0.5602056	0.4454897	0.322925
5	0.4457853	-1.038077	-0.8567123
6	0.4736169	-0.1254977	0.3514178
7	1.782359	0.07020736	-0.7813665
8	-0.7215334	-0.2412235	-1.787964
9	0.4013597	1.367826	1.004343