# Open Machine Learning Course. Topic 2. **Visual Data Analysis with Python**

In the field of Machine Learning, *data visualization* is not just making fancy graphics for reports; it is used extensively in day-to-day work for all phases of a project.

To start with, visual exploration of data is the first thing one tends to do when dealing with a new task. We do preliminary checks and analysis using graphics and tables to summarize the data and leave out the less important details. It is much more convenient for us, humans, to grasp the main points this way than by reading many lines of raw data. It is amazing how much insight can be gained from seemingly simple charts created with available visualization tools.

Next, when we analyze the performance of a model or report results, we also often use charts and images. Sometimes, for interpreting a complex model, we need to project high-dimensional spaces onto more visually intelligible 2D or 3D figures.

All in all, visualization is a relatively fast way to learn something new about your data. Thus, it is vital to learn its most useful techniques and make them part of your everyday ML toolbox.

In this article, we are going to get hands-on experience with visual exploration of data using popular libraries such as `pandas`

, `matplotlib`

and `seaborn`

.

### Article outline

**Dataset****Univariate****visualization**: quantitative and categorical distributions**Multivariate visualization**: interactions between variables**Whole dataset**: peeking into high-dimensional spaces**Assignment #2****Useful resources**

**The following material is better viewed as a ****Jupyter notebook**** and can be reproduced locally with Jupyter if you clone the ****course repository****.**

### 1. Dataset

Before we get to the data, let’s initialize our environment:

import numpy as np

import pandas as pd

pd.options.display.max_columns = 12

# Disable warnings in Anacondaimport warningswarnings.simplefilter('ignore')

# We will display plots right inside Jupyter Notebook%matplotlib inline

import matplotlib.pyplot as plt

# We will use the Seaborn libraryimport seaborn as sns

sns.set()

# Graphics in SVG format are more sharp and legible%config InlineBackend.figure_format = 'svg'

# Increase the default plot sizefrom pylab import rcParams

rcParams['figure.figsize'] = 5, 4

In the first article, we looked at the data on customer churn for a telecom operator. We will load again that dataset into a `DataFrame`

:

df = pd.read_csv('../../data/telecom_churn.csv')

To get acquainted with our data, let’s look at the first 5 entries using `head()`

:

`df.`**head**()

Here is the description of our features:

The last data column, **Churn**, is our target variable. It is binary: *True* indicates that that the company eventually lost this customer, and *False* indicates that the customer was retained. Later, we will build models that predict this variable based on the remaining features. This is why we call it a *target*.

### 2. Univariate visualization

*Univariate* analysis looks at one variable at a time. When we analyze a feature independently, we are usually mostly interested in the *distribution of its values* and ignore the other variables in the dataset.

Below, we will consider different statistical types of variables and the corresponding tools for their individual visual analysis.

#### 2.1 Quantitative features

*Quantitative features* take on ordered numerical values. Those values can be *discrete*, like integers, or *continuous*, like real numbers, and usually express a count or a measurement.

**Histograms and density plots**

The easiest way to take a look at the distribution of a numerical variable is to plot its *histogram* using the `DataFrame`

's method `hist()`

.

features = ['Total day minutes', 'Total intl calls']

df[features].hist(figsize=(12, 4));

A histogram groups values into *bins* of equal value range. The shape of the histogram may contain clues about the underlying distribution type: Gaussian, exponential etc. You can also spot any skewness in its shape when the distribution is nearly regular but has some anomalies. Knowing the distribution of the feature values becomes important when you use Machine Learning methods that assume a particular type of it, most often Gaussian.

In the above plot, we see that the variable *Total day minutes* is normally distributed, while *Total intl calls* is prominently skewed right (its tail is longer on the right).

There is also another, often clearer, way to grasp the distribution: *density plots* or, more formally, *Kernel Density Plots*. They can be considered a smoothed version of the histogram. Their main advantage over the latter is that they do not depend on the size of the bins. Let’s create density plots for the same two variables:

df[features].plot(kind='density', subplots=True,

layout=(1, 2), sharex=False, figsize=(12, 4));

It is also possible to plot a distribution of observations with `seaborn`

's `distplot()`

. For example, let's look at the distribution of *Total day minutes*. By default, the plot displays both the histogram with the kernel density estimate (KDE) on top.

sns.distplot(df['Total intl calls']);

The height of the histogram bars here is normed and shows the density rather than the number of examples in each bin.

**Box plot**

Another useful type of visualization is a *box plot*. `seaborn`

does a great job here:

_, ax = plt.subplots(figsize=(3, 4))

sns.boxplot(data=df['Total intl calls'], ax=ax);

Let’s see how to interpret a box plot. Its components are a *box* (obviously, this is why it is called a *box plot*), the so-called *whiskers*, and a number of individual points (*outliers*).

The box by itself illustrates the interquartile spread of the distribution; its length is determined by the 25th (Q1) and 75th (Q3) percentiles. The vertical line inside the box marks the median (50%) of the distribution.

The whiskers are the lines extending from the box. They represent the entire scatter of data points, specifically the points that fall within the interval (Q1−1.5⋅IQR, Q3+1.5⋅IQR), where IQR=Q3−Q1 is the interquartile range.

Outliers that fall out of the range bounded by the whiskers are plotted individually as black points along the central axis.

We can see that a large number of international calls is quite rare in our data.

**Violin plot**

The last type of distribution plots that we will consider is a *violin plot*.

Look at the figures below. On the left, we see the already familiar box plot. To the right, there is a *violin plot* with the kernel density estimate on both sides.

_, axes = plt.subplots(1, 2, sharey=True, figsize=(6, 4))

sns.boxplot(data=df['Total intl calls'], ax=axes[0]); sns.violinplot(data=df['Total intl calls'], ax=axes[1]);

The difference between the box and violin plots is that the former illustrates certain statistics concerning *individual examples* in a dataset while the violin plot concentrates more on the smoothed *distribution as a whole*.

In our case, the violin plot does not contribute any additional information about the data as everything is clear from the box plot alone.

**describe()**

In addition to graphical tools, in order to get the exact numerical statistics of the distribution, we can use the method `describe()`

of a `DataFrame`

:

df[features].describe()

Its output is mostly self-explanatory. *25%*, *50%* and *75%* are the corresponding percentiles.

#### 2.2 Categorical and binary features

*Categorical features* take on a fixed number of values. Each of these values assigns an observation to a corresponding group, known as a *category*, which reflects some qualitative property of this example. *Binary* variables are an important special case of categorical variables when the number of possible values is exactly 2. If the values of a categorical variable are ordered, it is called *ordinal*.

**Frequency table**

Let’s check the class balance in our dataset by looking at the distribution of the target variable: the *churn rate*. First, we will get a frequency table, which shows how frequent each value of the categorical variable is. For this, we will use the `value_counts()`

method:

df['Churn'].value_counts()

False 2850

True 483

Name: Churn, dtype: int64

By default, the entries in the output are sorted from the most to the least frequently-occurring values.

In our case, the data is not *balanced*; that is, our two target classes, loyal and disloyal customers, are not represented equally in the dataset. Only a small part of the clients canceled their subscription to the telecom service. As we will see in the following articles, this fact may imply some restrictions on measuring the classification performance, and, in the future, we may want to additionaly penalize our model errors in predicting the minority “Churn” class.

**Bar plot**

The bar plot is a graphical representation of the frequency table. The easiest way to create it is to use the `seaborn`

's function `countplot()`

. There is another function in `seaborn`

that is somewhat confusingly called `barplot()`

and is mostly used for representation of some basic statistics of a numerical variable grouped by a categorical feature.

Let’s plot the distributions for two categorical variables:

_, axes = plt.subplots(nrows=1, ncols=2, figsize=(12, 4))

sns.countplot(x='Churn', data=df, ax=axes[0]);

sns.countplot(x='Customer service calls', data=df, ax=axes[1]);

While the histograms, discussed above, and bar plots may look similar, there are several differences between them:

*Histograms*are best suited for looking at the distribution of numerical variables while*bar plots*are used for categorical features.- The values on the X-axis in the
*histogram*are numerical; a*bar plot*can have any type of values on the X-axis: numbers, strings, booleans. - The
*histogram*’s X-axis is a*Cartesian coordinate axis*along which values cannot be changed; the ordering of the*bars*is not predefined. Still, it is useful to note that the bars are often sorted by height, that is, the frequency of the values. Also, when we consider*ordinal*variables (like*Customer service calls*in our data), the bars are usually ordered by variable value.

The left chart above vividly illustrates the imbalance in our target variable. The bar plot for *Customer service calls* on the right gives a hint that the majority of customers resolve their problems in maximum 2–3 calls. But, as we want to be able to predict the minority class, we may be more interested in how the fewer dissatisfied customers behave. It may well be that the tail of that bar plot contains most of our churn. These are just hypotheses for now, so let’s move on to some more interesting and powerful visual techniques.

### 3. Multivariate visualization

*Multivariate* plots allow us to see relationships between two and more different variables, all in one figure. Just as in the case of univariate plots, the specific type of visualization will depend on the types of the variables being analyzed.

#### 3.1 Quantitative–Quantitative

We are going to start with the interaction between quantitative variables.

**Correlation matrix**

Let’s look at the correlations among the numerical variables in our dataset. This information is important to know as there are Machine Learning algorithms (for example, linear and logistic regression) that do not handle highly correlated input variables well.

First, we will use the method `corr()`

on a `DataFrame`

that calculates the correlation between each pair of features. Then, we pass the resulting *correlation matrix* to `heatmap()`

from `seaborn`

, which renders a color-coded matrix for the provided values:

# Drop non-numerical variablesnumerical = list(set(df.columns) -

set(['State', 'International plan',

'Voice mail plan', 'Area code', 'Churn',

'Customer service calls']))

# Calculate and plotcorr_matrix = df[numerical].corr()

sns.heatmap(corr_matrix);

From the colored correlation matrix generated above, we can see that there are 4 variables such as *Total day charge* that have been calculated directly from the number of minutes spent on phone calls (*Total day minutes*). These are called *dependent* variables and can therefore be left out since they do not contribute any additional information. Let’s get rid of them:

numerical = list(set(numerical) -

set(['Total day charge', 'Total eve charge',

'Total night charge', 'Total intl charge']))

**Scatter plot**

The *scatter plot* displays values of two numerical variables as *Cartesian coordinates* in 2D space. Scatter plots in 3D are also possible.

Let’s try out the function `scatter()`

from the `matplotlib`

library:

plt.scatter(df['Total day minutes'], df['Total night minutes']);

We get an uninteresting picture of two normally distributed variables. Also, it seems that these features are uncorrelated because the ellpise-like shape is aligned with the axes.

There is a slightly fancier option to create a scatter plot with the `seaborn`

library:

sns.jointplot(x='Total day minutes', y='Total night minutes',

data=df, kind='scatter');

The function `jointplot()`

plots two histograms that may be useful in some cases. Using the same function, we can also get a smoothed version of our bivariate distribution:

sns.jointplot('Total day minutes', 'Total night minutes',

data=df, kind="kde", color="g");

This is basically a bivariate version of the *Kernel Density Plot* discussed earlier.

**Scatterplot matrix**

In some cases, we may want to plot a *scatterplot matrix* such as the one shown below. Its diagonal contains the distributions of the corresponding variables, and the scatter plots for each pair of variables fill the rest of the matrix.

# pairplot may become very slow with the SVG format%config InlineBackend.figure_format = 'png' sns.pairplot(df[numerical]);

Sometimes, such visualization may help draw conclusions about data; but, in this case, everything is pretty clear with no surprises.

#### 3.2 Quantitative–Categorical

In this section, we will make our simple quantitative plots a little more exciting. We will try to gain new insights for churn prediction from the interactions between the numerical and categorical features.

More specifically, let’s see how the input variables are related to the target variable Churn.

Previously, you learned about scatter plots. Additionally, their points can be color or size coded so that the values of a third categorical variable are also presented in the same figure. We can achieve this with the `scatter()`

function seen above, but, let's try a new function called `lmplot()`

and use the parameter `hue`

to indicate our categorical feature of interest:

sns.lmplot('Total day minutes', 'Total night minutes', data=df,

hue='Churn', fit_reg=False);

It seems that our small proportion of disloyal customers lean towards the top-right corner; that is, such customers tend to spend more time on the phone during both day and night. But this is not absolutely clear, and we won’t make any definitive conclusions from this chart.

Now, let’s create box plots to visualize the distribution statistics of the numerical variables in two disjoint groups: the loyal customers (`Churn=False`

) and those who left (`Churn=True`

).

# Sometimes you can analyze an ordinal variable as numerical onenumerical.append('Customer service calls')

fig, axes = plt.subplots(nrows=3, ncols=4, figsize=(10, 7))

for idx, feat in enumerate(numerical):

ax = axes[int(idx / 4), idx % 4]

sns.boxplot(x='Churn', y=feat, data=df, ax=ax)

ax.set_xlabel('')

ax.set_ylabel(feat)

fig.tight_layout();

From this chart, we can see that the greatest discrepancy in distribution between the two groups is for three variables: *Total day minutes*, *Customer service calls*, and *Number vmail messages*. Later in this course, we will learn how to determine feature importance in classification using *Random Forest* or *Gradient Boosting*; there, we will see that the first two features are indeed very important for churn prediction.

Let’s look at the distribution of day minutes spoken for the loyal and disloyal customers separately. We will create box and violin plots for *Total day minutes* grouped by the target variable.

_, axes = plt.subplots(1, 2, sharey=True, figsize=(10, 4))

sns.boxplot(x='Churn', y='Total day minutes',

data=df, ax=axes[0]);

sns.violinplot(x='Churn', y='Total day minutes',

data=df, ax=axes[1]);

In this case, the violin plot does not contribute any additional information about our data as everything is clear from the box plot alone: disloyal customers tend to talk on the phone more.

**An interesting observation**: on average, customers that discontinue their contracts are more active users of communication services. Perhaps they are unhappy with the tariffs, so a possible measure to prevent churn could be a reduction in call rates. The company will need to undertake additional economic analysis to find out whether such measures would be beneficial.

When we want to analyze a quantitative variable in two categorical dimensions at once, there is a suitable function for this in the `seaborn`

library called `factorplot()`

. For example, let's visualize the interaction between *Total day minutes* and two categorical variables in the same plot:

sns.factorplot(x='Churn', y='Total day minutes',

col='Customer service calls',

data=df[df['Customer service calls'] < 8],

kind="box", col_wrap=4, size=3, aspect=.8);

From this, we could conclude that, starting with 4 calls, *Total day minutes* may no longer be the main factor for customer churn. Perhaps, in addition to our previous guess about the tariffs, there are customers that are dissatisfied with the service due to other problems, which might lead to fewer number of day minutes spent on calls.

#### 3.3 Categorical–Categorical

As we saw earlier in this article, the variable *Customer service calls* has few unique values and, thus, can be considered either numerical or ordinal. We have already seen its distribution with a *count plot*. Now, we are interested in the relationship between this ordinal feature and the target variable *Churn*.

Let’s look at the distribution of the number of calls to the customer service, again using a *count plot*. This time, let’s also pass the parameter `hue=Churn`

that adds a categorical dimension to the plot:

sns.countplot(x='Customer service calls', hue='Churn', data=df);

**An observation**: the churn rate increases significantly after 4 or more calls to the customer service.

Now, let’s look at the relationship between *Churn* and the binary features, *International plan* and *Voice mail plan*.

_, axes = plt.subplots(1, 2, sharey=True, figsize=(10, 4))

sns.countplot(x='International plan', hue='Churn',

data=df, ax=axes[0]);

sns.countplot(x='Voice mail plan', hue='Churn',

data=df, ax=axes[1]);

**An observation**: when *International Plan* is enabled, the churn rate is much higher; the usage of the international plan by the customer is a strong feature. We do not observe the same effect with *Voice mail plan*.

**Contingency table**

In addition to using graphical means for categorical analysis, there is a traditional tool from statistics: a *contingency table*, also called a *cross tabulation*. It represents multivariate frequency distribution of categorical variables in tabular form. In particular, it allows us to see the distribution of one variable conditional on the other by looking along a column or row.

Let’s try to see how *Churn* is related to the categorical variable *State* by creating a cross tabulation:

pd.crosstab(df['State'], df['Churn']).T

In the case of *State*, the number of distinct values is rather high: 51. We see that there are only a few data points available for each individual state — only 3 to 17 customers in each state abandoned the operator. Let’s ignore that for a second and calculate the churn rate for each state, sorting it from high to low:

df.groupby(['State'])['Churn'].

agg([np.mean]).

sort_values(by='mean', ascending=False).T

At first glance, it seems that the churn rate in *New Jersey* and *California* are above 25% and less than 6% for Hawaii and Alaska. However, these conclusions are based on too few examples, and our observation could be a mere property of our particular dataset. We can confirm this with the Matthews and Cramer correlation hypotheses, but this would be beyond the scope of this article.

### 4. Whole dataset

#### 4.1 Naive approach

We have been looking at different *facets* of our dataset by guessing interesting features and selecting a small number of them at a time for visualization. We have only delt with two to three variables at once and were easily able to observe the structure and relationships in data. But, what if we want to display all the features and still be able to interpret the resulting visualization?

We could use `hist()`

or create a scatterplot matrix with `pairplot()`

for the whole dataset to look at all of our features simultaneously. But, when the number of features is high enough, this kind of visual analysis quickly becomes slow and inefficient. Besides, we would still be analyzing our variables in a pairwise fashion, not all at once.

#### 4.2 Dimensionality reduction

Most real-world datasets have many features, sometimes, many thousands of them. Each of them can be considered as a dimension in the space of data points. Consequently, more often than not, we deal with high-dimensional datasets, where entire visualization is quite hard.

To look at a dataset as a whole, we need to decrease the number of dimensions used in visualization without losing much information about data. This task is called *dimensionality reduction* and is an example of an *unsupervised learning* problem because we need to derive new, low-dimensional features from the data itself, without any supervised input.

One of the well-known dimensionality reduction methods is *Principal Component Analysis* (PCA), which we will study later in this course. Its limitation is that it is a *linear* algorithm that implies certain restrictions on the data.

There are also many non-linear methods, collectively called *Manifold Learning*. One of the best-known of them is *t-SNE*.

#### 4.3 t-SNE

Let’s create a t-SNE representation of the same churn data we have been using.

The name of the method looks complex and a bit intimidating: *t-distributed Stohastic Neighbor Embedding*. Its math is also impressive (we will not delve into it here, but, if you feel brave, here is the original article by Laurens van der Maaten and Geoffrey Hinton from JMLR). Its basic idea is simple: to find a projection for a high-dimensional feature space onto a plane (or a 3D hyperplane, but it is almost always 2D) such that those points that were far apart in the initial n-dimensional space will end up far apart on the plane. Those that were originally close would remain close to each other.

Essentially, *neighbor embedding* is a search for a new and less-dimensional data representation that preserves neighborship of examples.

Now, let’s do some practice. First, we need to import some additional classes:

from sklearn.manifold import TSNE

from sklearn.preprocessing import StandardScaler

We will leave out the *State* and *Churn* features and convert the values “Yes”/”No” of the binary features into numerical values using `pandas.Series.map()`

:

X = df.drop(['Churn', 'State'], axis=1)

X['International plan'] = X['International plan'].

map({'Yes': 1, 'No': 0})

X['Voice mail plan'] = X['Voice mail plan'].

map({'Yes': 1, 'No': 0})

We also need to normalize the data. For this, we will subtract the mean from each variable and divide it by its standard deviation. All of this can be done with `StandardScaler`

.

scaler = StandardScaler()

X_scaled = scaler.fit_transform(X)

Now, let’s build a t-SNE representation:

%%time tsne = TSNE(random_state=17)

tsne_repr = tsne.fit_transform(X_scaled)

CPU times: user 1min 32s, sys: 7.86 s, total: 1min 39s

Wall time: 1min 39s

and plot it:

plt.scatter(tsne_repr[:, 0], tsne_repr[:, 1]);

Let’s color this t-SNE representation according to the churn (green for loyal customers, and red for those who left).

plt.scatter(tsne_repr[:, 0], tsne_repr[:, 1],

c=df['Churn'].map({False: 'green', True: 'red'}));

We can see that customers who churned are concentrated in a few areas of the lower dimensional feature space.

To better understand the picture, we can also color it with the remaining binary features: *International Plan* and *Voicemail*. The green dots here indicate the objects that are positive for the corresponding binary feature.

_, axes = plt.subplots(1, 2, sharey=True, figsize=(12, 5))

for i, name in enumerate(['International plan', 'Voice mail plan']):

axes[i].scatter(tsne_repr[:, 0], tsne_repr[:, 1],

c=df[name].map({'Yes': 'green', 'No': 'red'}))

axes[i].set_title(name)

Now it is clear that, for example, many dissatisfied customers who canceled their subscription are crowded together in the most south-west cluster that represents the people with the international plan but no voice mail.

Finally, let’s note some disadvantages of t-SNE:

- High computational complexity. The implementation in
`scikit-learn`

is unlikely to be feasible in a real task. If you have a large number of samples, you should try Multicore-TSNE instead. - The plot can change a great deal depending on the random seed, which complicates interpretation. Here is a good tutorial on t-SNE. In general, you shouldn’t make any far-reaching conclusions based on such graphs because it can equate to plain guessing. Of course, some findings in t-SNE pictures can inspire an idea and be confirmed through more thorough research down the line, but that does not happen very often.

Occasionally, using t-SNE, you can get a really good intuition for the data. The following is a good paper that shows an example of this for handwritten digits: Visualizing MNIST.

Sometimes t-SNE really helps to understand something, and sometimes you can just draw a Christmas tree toy :-)

### 5. Assignment #2

Full versions of assignments are announced each week in a new run of the course (October 1, 2018). Meanwhile, you can practice with a demo version: Kaggle Kernel, nbviewer.

### 6. Useful resources

- Here is the official documentation for the libraries we used:
`matplotlib`

,`seaborn`

and`pandas.`

- The gallery of sample charts created with
`seaborn`

is a very good resource. - Also, see the documentation on Manifold Learning in
`scikit-learn`

- Efficient t-SNE implementation Multicore-TSNE.
- “How to Use t-SNE Effectively”, Distill.pub.

*Authors: **Egor Polusmak**, and **Yury Kashnitskiy**. Translated and edited by **Yuanyuan Pao**, **Christina Butsko**, **Anastasia Manokhina**, **Inga Kaydanova**, and **Artem Trunov**.*