NaN.

quiz

Pro Content

Hands-on Project: Digit classification with K-Nearest Neighbors and Data Augmentationby Keshav Dhandhania

This is for Pro Members

We like how far you've come. Upgrade today and get access to all quizzes, assignments and projects.

Limited-time discount for early adopters: Pro Membership is only ₹261 when paid yearly.65% OFF

Start your free 7-day trial →

Copied

reply in this discussion

Soujanna Sarkar14w

This is for Pro Members

We like how far you've come. Upgrade today and get access to all quizzes, assignments and projects.

Limited-time discount for early adopters: Pro Membership is only ₹261 when paid yearly.65% OFF

Start your free 7-day trial →

Importing Pandas

We will start our code session with the standard NumPy and Pandas imports:

In []: import numpy as np
       import pandas as pd
       import matplotlib.pyplot as plt
In []: pd.__version__
Out[]: '0.20.1'

The Pandas Index Object

In []: ind = pd.Index([2, 3, 5, 7, 11])
       ind
Out[]: Int64Index([2, 3, 5, 7, 11], dtype='int64')
In []: ind[1]
Out[]: 3

The index object is part of every Series and DataFrame in Pandas. It is used to identify locations within the Series / DataFrame, as we'll see in the coming sections.

The Pandas Series Object

The Pandas Series is a one dimensional labeled array capable of holding any data type with an index. The structure is similar to a single column of a DataFrame which we will come across momentarily. Here is an example of creating it from a list (you could also create it similarly starting with a NumPy array).

In []: data = pd.Series([0.25, 0.5, 0.75, 1.0])       
       data
Out[]: 
0    0.25
1    0.50
2    0.75
3    1.00
dtype: float64

And like any NumPy array, data is accessed by the associated index via the familiar Python square-bracket notation:

In []: data[1]
Out[]: 0.5
In []: data[1:3]
Out[]: 
1    0.50
2    0.75
dtype: float64

Pandas Series has an explicitly defined index associated with the values given which allows for renaming.

In []: data = pd.Series([0.25, 0.5, 0.75, 1.0], index=['a', 'b', 'c', 'd'])
       data
Out[]: 
a    0.25
b    0.50
c    0.75
d    1.00
dtype: float64
In []: data['c']
Out[]: 0.75

Pandas can also construct a Series object directly from a Python dictionary:

In []: population_dict = {'California': 38332521,
         'Texas': 26448193,
         'New York': 19651127,
         'Florida': 19552860,
         'Illinois': 12882135}
       population = pd.Series(population_dict)
       population
 
Out[]: 
California    38332521
Florida       19552860
Illinois      12882135
New York      19651127
Texas         26448193
dtype: int64

Next we have Pandas DataFrame Object!

The Pandas DataFrame Object

The Pandas DataFrame is a two dimensional table, similar to excel spreadsheet or SQL table. It allows easy organization of data types such as lists, arrays and dictionaries and can also be constructed from them. Data in DataFrame is stored in memory as a collection of series.

Construction from Series:

In []: pd.DataFrame(population, columns=['population'])
Out[]: 
California    38332521
Florida       19552860
Illinois      12882135
New York      19651127
Texas         26448193
dtype: int64

From a list of dictionaries:

In []: pd.DataFrame([{'a': 1, 'b': 2}, {'b': 3, 'c': 4}])
Out[]: 
     a  b    c
0  1.0  2  NaN
1  NaN  3  4.0

Alternatively, one can as well import data onto a DataFrame from Excel or CSV document.

In []: data = pd.read_csv('UKretail.csv')

The data is available for download at the following link: UKretail.csv. Do make sure you place it in the same directory as your Python working directory.

For an SQL or Excel document, use read_sql() or read_excel() respectively. When reading in your data, one can specify certain arguments to ensure that correct and relevant data is loaded.

This is achieved by cropping data in an organized way. For instance:

eg = pd.read_csv('UKretail.csv', header=0,  skiprows=4, nrows=20, usecols=[1,2,3])

Further information on adding arguments can be found here: csv — pandas documentation

Exploratory Data Analysis (EDA)

Now that we know how to import data, it's time to go exploring, look for trends, patterns, and anomalies both quantitatively and visually. Pandas offers an extensive suite of functions that allows you to explore data to your heart's content.

Ways of observing descriptive statistics, at first glance, is by checking the shape, info and describe methods as shown below.

In []: data.shape
Out[]: (325145, 8)

This shows that there are 325,145 rows and 8 columns in the data-set.

In []: data.info()
<class 'pandas.core.frame.DataFrame'>
RangeIndex: 325145 entries, 0 to 325144
Data columns (total 8 columns):
InvoiceNo      325145 non-null object
StockCode      325145 non-null object
Description    324275 non-null object
Quantity       325145 non-null int64
InvoiceDate    325145 non-null object
UnitPrice      325145 non-null float64
CustomerID     244154 non-null float64
Country        325145 non-null object
dtypes: float64(2), int64(1), object(5)
memory usage: 19.8+ MB

Pandas stores data types as objects, floats64, null, boolean...

In []: type(data["CustomerID"])
Out[]: pandas.core.series.Series
In []: data.describe()
Out[]: 
            Quantity      UnitPrice     CustomerID
count  325145.000000  325145.000000  244154.000000
mean        9.273340       4.845239   15288.823120
std       154.394112     116.830451    1713.496816
min    -80995.000000  -11062.060000   12347.000000
25%         1.000000       1.250000            NaN
50%         3.000000       2.080000            NaN
75%        10.000000       4.130000            NaN
max     12540.000000   38970.000000   18287.000000

The describe function only applies to numeric datatype in the dataset and finds its stats (mean, standard deviation, minimum, maximum, and 25th, 50th and 75th percentiles).

Slicing and Indexing

Pandas identifies the first line of input data as index headers. So whether you select the first row or ask for column values, you will receive the same answer. This shows that there are multiple ways of coming to the same answers, but the more you learn Pandas, the more elegant and pythonic your code will be.

In []: data[1:1]
Out[]: 
Empty DataFrame
Columns: [InvoiceNo, StockCode, Description, Quantity, InvoiceDate, UnitPrice, CustomerID, Country]
Index: []
       
In []: data.columns.values
Out[]: 
array(['InvoiceNo', 'StockCode', 'Description', 'Quantity', 'InvoiceDate',
       'UnitPrice', 'CustomerID', 'Country'], dtype=object)

Selecting columns is no different from selecting Index. One can simply call on the column label. Here are examples showing top 5 rows. As a refresher, python indexing starts with a zero and is no exception here in Pandas.

In []: data["CustomerID"].head()
Out[]: 
0    17850.0
1    17850.0
2    17850.0
3    17850.0
4    17850.0
Name: CustomerID, dtype: float64

Instead of the column name, we can also refer to columns by the location. In this case, we'll have to use the iloc attribute, which stands for integer location.

In []: data.iloc[:,[3]].head()
Out[]: 
   Quantity
0         2
1         6
2         6
3         6
4         6

In order to select specific rows or range of rows by index values use these methods.

In []: data[:3]
Out[]: 
  InvoiceNo StockCode                          Description  Quantity  \
0    536365     22752         SET 7 BABUSHKA NESTING BOXES         2
1    536365     71053                  WHITE METAL LANTERN         6
2    536365    84029G  KNITTED UNION FLAG HOT WATER BOTTLE         6
 
           InvoiceDate  UnitPrice  CustomerID         Country
0  2010-12-01 08:26:02       7.65     17850.0  United Kingdom
1  2010-12-01 08:26:02       3.39     17850.0  United Kingdom
2  2010-12-01 08:26:02       3.39     17850.0  United Kingdom
 
In []: data.iloc[[3,5,9],:]
Out[]: 
  InvoiceNo StockCode                         Description  Quantity  \
3    536365    85123A  WHITE HANGING HEART T-LIGHT HOLDER         6
5    536367     21754            HOME BUILDING BLOCK WORD         3
9    536367     22745          POPPY'S PLAYHOUSE BEDROOM          6
 
           InvoiceDate  UnitPrice  CustomerID         Country
3  2010-12-01 08:26:02       2.55     17850.0  United Kingdom
5  2010-12-01 08:33:59       5.95     13047.0  United Kingdom
9  2010-12-01 08:33:59       2.10     13047.0  United Kingdom

Now that you understand how to select values by row-wise and column-wise manipulations, we can combine these methods to slice frames.

In []: data.iloc[0:6,2:3]
Out[]: 
                           Description
0         SET 7 BABUSHKA NESTING BOXES
1                  WHITE METAL LANTERN
2  KNITTED UNION FLAG HOT WATER BOTTLE
3   WHITE HANGING HEART T-LIGHT HOLDER
4               HAND WARMER UNION JACK
5             HOME BUILDING BLOCK WORD

In case you are looking for a way to quickly glance at the top 5 or bottom 5 rows, the handy methods are head() and tail(). These methods also accept arguments to specify the number of rows.

In []: data.head()
Out[]: 
  InvoiceNo StockCode                          Description  Quantity  \
0    536365     22752         SET 7 BABUSHKA NESTING BOXES         2
1    536365     71053                  WHITE METAL LANTERN         6
2    536365    84029G  KNITTED UNION FLAG HOT WATER BOTTLE         6
3    536365    85123A   WHITE HANGING HEART T-LIGHT HOLDER         6
4    536366     22633               HAND WARMER UNION JACK         6
 
           InvoiceDate  UnitPrice  CustomerID         Country
0  2010-12-01 08:26:02       7.65     17850.0  United Kingdom
1  2010-12-01 08:26:02       3.39     17850.0  United Kingdom
2  2010-12-01 08:26:02       3.39     17850.0  United Kingdom
3  2010-12-01 08:26:02       2.55     17850.0  United Kingdom
4  2010-12-01 08:28:02       1.85     17850.0  United Kingdom
       
In []: data.tail(2)
Out[]: 
       InvoiceNo StockCode                    Description  Quantity  \
325143    581587     23254  CHILDRENS CUTLERY DOLLY GIRL          4
325144    581587     23256    CHILDRENS CUTLERY SPACEBOY          4
 
                InvoiceDate  UnitPrice  CustomerID Country
325143  2011-12-09 12:49:59       4.15     12680.0  France
325144  2011-12-09 12:49:59       4.15     12680.0  France

With this arsenal of selecting and slicing tools, you are good to go forward with adding, deleting and renaming components of your DataFrame.

Data Analysis & Visualization

Let's start by creating a new label that calculates the revenue for every transaction(row-wise). Formula:

Revenue = Quantity \times Unit Price

In []: data['Revenue'] = data.Quantity*data.UnitPrice

Let's create a sub-frame with the "Quantity", "UnitPrice" and "Revenue" columns.

In []: rawdata = data[["Quantity","UnitPrice", "Revenue"]]
In []: rawdata[1:3]
Out[]: 
   Quantity  UnitPrice  Revenue
1         6       3.39    20.34
2         6       3.39    20.34

Now, we can check the performance of the revenue over time by plotting a trend-line.

In []: data.plot(x="InvoiceDate", y="Revenue", kind="line")
Out[]: <matplotlib.axes._subplots.AxesSubplot at 0xe3540f0>
 
In []: plt.show() # This might take a few seconds

Looks like there had been cancellations that caused the revenue to drop down to negative. We can clean our data-set to drop these cancels for a better understanding of our revenue trend-line.

In []: cancels = data[data["Revenue"]<0]
In []: cancels.shape
Out[]: (5588, 9)
In []: data.drop(data[data.Revenue < 0].index, inplace=True)
In []: data.shape
Out[]: (319555, 9)
In []: data.plot(x="InvoiceDate", y="Revenue", kind="line")
Out[]: <matplotlib.axes._subplots.AxesSubplot at 0x153c33c8>
 
In []: plt.show() # This might take a few seconds

And voila, here we have it!

Beyond trend-line observations, we can further analyse the revenue contribution by countries. For this we apply the groupby() method on the "Revenue" column and sum() the values obtained. The reset_index() method helps to create a dataframe from the grouped values under the original label.

In []: CountryGroups = data.groupby("Country")["Revenue"].sum().reset_index()

Here is a sorted list of revenue per country with values ranging from highest to lowest.

In []: CountryGroups.sort_values(by= "Revenue", ascending=False)
Out[]: 
                 Country      Revenue
36        United Kingdom  4737733.051
24           Netherlands   164971.390
10                  EIRE   161755.430
14               Germany   133836.480
13                France   125011.240
0              Australia    78247.600
33           Switzerland    34012.330
31                 Spain    32205.140
3                Belgium    23866.770
25                Norway    22584.440
32                Sweden    20185.700
20                 Japan    19302.710
27              Portugal    17934.750
6        Channel Islands    12521.190
12               Finland    12147.790
9                Denmark    11583.920
19                 Italy    10375.560
7                 Cyprus     7192.460
1                Austria     6098.010
16             Hong Kong     5236.020
30             Singapore     4932.610
18                Israel     4134.340
26                Poland     3880.030
37           Unspecified     2898.650
15                Greece     2627.570
17               Iceland     2461.230
5                 Canada     2093.390
35  United Arab Emirates     1277.500
34                   USA     1261.850
21               Lebanon     1120.530
23                 Malta     1099.930
22             Lithuania     1038.560
11    European Community      868.050
4                 Brazil      602.310
28                   RSA      573.180
8         Czech Republic      441.080
2                Bahrain      137.660
29          Saudi Arabia       90.720

We can also plot histograms for revenue on a particular customer or for quantity on a product.

In []: data[data["CustomerID"] == 17850.0]["Revenue"].plot(kind="hist")
Out[]: <matplotlib.axes._subplots.AxesSubplot at 0x12081898>
 
In []: plt.show() # This might take a few seconds

In []: data[data["StockCode"] == 71053]["Quantity"].hist()
Out[]: <matplotlib.axes._subplots.AxesSubplot at 0xe0ca4a8>
 
In []: plt.show() # This might take a few seconds

Often, the data we start with has missing values or invalid values. For these cases, Pandas allows us to identify and insert values.

In []: empty = data[data.CustomerID.isnull()]
In []: empty.head()
Out[]: 
    InvoiceNo StockCode                  Description  Quantity  \
373    536414     22139                          NaN        56
856    536544     11001  ASSTD DESIGN RACING CAR PEN         3
857    536544     16236         KITTY PENCIL ERASERS         1
858    536544     16238    PARTY TIME PENCIL ERASERS         1
859    536544     17003          BROCADE RING PURSE          3
 
             InvoiceDate  UnitPrice  CustomerID         Country  Revenue
373  2010-12-01 11:51:59       0.00         NaN  United Kingdom     0.00
856  2010-12-01 14:32:01       3.36         NaN  United Kingdom    10.08
857  2010-12-01 14:32:01       0.43         NaN  United Kingdom     0.43
858  2010-12-01 14:32:01       0.43         NaN  United Kingdom     0.43
859  2010-12-01 14:32:01       0.43         NaN  United Kingdom     1.29
       
In []: data.CustomerID.fillna(0, inplace=True)
In []: data[data.CustomerID.isnull()]
Out[]: 
Empty DataFrame
Columns: [InvoiceNo, StockCode, Description, Quantity, InvoiceDate, UnitPrice, CustomerID, Country, Revenue]
Index: []

Mark that the above functions for cleaning data is part of pre-processing before inputting into any machine learning model. Other utilities involve mapping values to numbers. Here is an example showing countries mapped to integers using a dictionary.

In []: mymap = {'United Kingdom':1, 'Netherlands':2, 'Germany':3, 'France':4, 'USA':5}       
       data = data.applymap(lambda s: mymap.get(s) if s in mymap else s)
       
In []: data.head()
Out[]: 
  InvoiceNo StockCode                          Description  Quantity  \
0    536365     22752         SET 7 BABUSHKA NESTING BOXES         2
1    536365     71053                  WHITE METAL LANTERN         6
2    536365    84029G  KNITTED UNION FLAG HOT WATER BOTTLE         6
3    536365    85123A   WHITE HANGING HEART T-LIGHT HOLDER         6
4    536366     22633               HAND WARMER UNION JACK         6
 
           InvoiceDate  UnitPrice  CustomerID Country  Revenue
0  2010-12-01 08:26:02       7.65     17850.0       1    15.30
1  2010-12-01 08:26:02       3.39     17850.0       1    20.34
2  2010-12-01 08:26:02       3.39     17850.0       1    20.34
3  2010-12-01 08:26:02       2.55     17850.0       1    15.30
4  2010-12-01 08:28:02       1.85     17850.0       1    11.10

And, there you have it! All ready for feeding the Country data array into Machine Learning model.

Ending Note

Till this point, we have surfed through a few Pandas functionalities in order to get a gist of Pandas' usefulness. This list is definitely not exhaustive so for those willing to dive deeper to explore its depth and breadth please refer to the online documentation for Pandas found here: pandas documentation

Here is a fun little bonus for completing this tutorial:

In []: import this
The Zen of Python, by Tim Peters
 
Beautiful is better than ugly.
Explicit is better than implicit.
Simple is better than complex.
Complex is better than complicated.
Flat is better than nested.
Sparse is better than dense.
Readability counts.
Special cases aren't special enough to break the rules.
Although practicality beats purity.
Errors should never pass silently.
Unless explicitly silenced.
In the face of ambiguity, refuse the temptation to guess.
There should be one-- and preferably only one --obvious way to do it.
Although that way may not be obvious at first unless you're Dutch.
Now is better than never.
Although never is often better than *right* now.
If the implementation is hard to explain, it's a bad idea.
If the implementation is easy to explain, it may be a good idea.
Namespaces are one honking great idea -- let's do more of those!