Work in progress
Book version 0.2

4 Development Tools

Terence Parr and Jeremy Howard

Copyright © 2018 Terence Parr. All rights reserved.
Please don't replicate on web or redistribute in any way.
This book generated from markup+markdown+python+latex source with Bookish.

You can make comments or annotate this page by going to the annotated version of this page. You'll see existing annotated bits highlighted in yellow. They are PUBLICLY VISIBLE. Or, you can send comments, suggestions, or fixes directly to Terence.

Contents

Before we dig more into machine learning, let's get familiar with our primary development tools. The code samples in this book explicitly or implicitly use the following important libraries that form the backbone of machine learning with Python for structured data:

In the last chapter, we got a taste of using sklearn to train models, and so this chapter we'll focus on the basics of pandas, NumPy, and matplotlib. The development environment we recommend is Jupyter Lab, but you're free to use whatever you're comfortable with. You can skip this chapter if you're itching to get started building models, but it's a good idea to at least scan this chapter to learn what's possible with the libraries before moving on.

4.1 Your machine learning development environment

Over the last 30 years, there's been remarkable progress in the development of IDEs that make programmers very efficient, such as Intellij, Eclipse, VisualStudio, etc... Their focus, however, is on creating and navigating large programs, the opposite of our small machine learning scripts. More importantly, those IDEs have little to no support for interactive programming, but that's exactly what we need to be effective in machine learning. While Terence and Jeremy are strong advocates of IDEs in general, IDEs are less useful in the special circumstances of machine learning.

1All of the code snippets you see in this book, even the ones to generate figures, can be found in the notebooks generated from this book.

Instead, we recommend Jupyter Notebooks, which are web-based documents with embedded code, akin to literate programming, that intersperses the generated output with the code.1 Notebooks are well-suited to both development and presentation. To access notebooks, we're going to use the recently-introduced Jupyter Lab because of its improved user interface. (It should be out of beta by the time you're reading this book.) Let's fire up a notebook to appreciate the difference between it and a traditional IDE.

First, let's make sure that we have the latest version of Jupyter Lab by running this from the Mac/Unix command line or Windows “anaconda prompt” (search for “anaconda prompt” from the Start menu):

conda install -c conda-forge jupyterlab

The conda program is a packaging system like the usual Python pip tool, but has the advantage that it can also install non-Python files (like C/Fortran code often used by scientific packages for performance reasons.)

Before launching jupyter, it's a good idea to create and jump into a directory where you can keep all of your work for this book. For example, you might do something like this sequence of commands (or the equivalent with your operating system GUI):

cd /Users/YOURID mkdir mlbook cd mlbook

On Windows, your user directory is C:\Users\YOURID.

Let's also make a data directory underneath /Users/YOURID/mlbook so that our notebooks can access data files easily:

mkdir data

So that we have some data to play with, download and unzip the data/rent-ideal.csv.zip file into the /Users/YOURID/mlbook/data directory.

Launch the local Jupyter web server that provides the interface by running jupyter lab from the command line:

$ jupyter lab [I 11:27:00.606 LabApp] [jupyter_nbextensions_configurator] enabled 0.2.8 [I 11:27:00.613 LabApp] JupyterLab beta preview extension loaded from /Users/parrt/anaconda3/lib/python3.6/site-packages/jupyterlab [I 11:27:00.613 LabApp] JupyterLab application directory is /Users/parrt/anaconda3/share/jupyter/lab [W 11:27:00.616 LabApp] JupyterLab server extension not enabled, manually loading... ...

Figure 4.1. Initial Jupyter Lab screen

Figure 4.2. Jupyter Lab after creating Python 3 notebook

Running that command should also open a browser window that looks like Figure 4.1. That notebook communicates with the Jupyter Lab server via good old http, the web protocol. Clicking on the “Python 3” icon under the “Notebook” category, will create and open a new notebook window that looks like Figure 4.2. Cut-and-paste the following code into the empty notebook cell, replacing the data file name as appropriate for your directory structure (our set up has file rent-ideal.csv in the mlbook/data subdirectory).

with open("data/rent-ideal.csv") as f: for line in f.readlines()[0:5]: print(line.strip())

Figure 4.3. Jupyter Lab with one code cell and output

After pasting, hit shift-enter in the cell (hold the shift key and then hit enter), which will execute and display results like Figure 4.3. Of course, this would also work from the usual interactive Python shell:

$ python Python 3.6.6 |Anaconda custom (64-bit)| (default, Jun 28 2018, 11:07:29) [GCC 4.2.1 Compatible Clang 4.0.1 (tags/RELEASE_401/final)] on darwin Type "help", "copyright", "credits" or "license" for more information. >>> with open("data/rent-ideal.csv") as f: ... for line in f.readlines()[0:5]: ... print(line.strip()) ... bedrooms,bathrooms,latitude,longitude,price 3,1.5,40.7145,-73.9425,3000 2,1.0,40.7947,-73.9667,5465 1,1.0,40.7388,-74.0018,2850 1,1.0,40.7539,-73.9677,3275 >>>

We could also save that code snippet into a file called dump.py and run it, either from within a Python development environment like PyCharm or from the command line:

$ python dump.py bedrooms,bathrooms,latitude,longitude,price 3,1.5,40.7145,-73.9425,3000 2,1.0,40.7947,-73.9667,5465 1,1.0,40.7388,-74.0018,2850 1,1.0,40.7539,-73.9677,3275

Figure 4.4. Jupyter Lab cell with pandas CSV load

Figure 4.5. Notebook with graph output

Notebooks have some big advantages over the interactive Python shell. Because the Python shell is using an old-school terminal, it has very limited display options whereas notebooks can nicely display tables and even embed graphs inline. For example, Figure 4.4 shows what pandas dataframes look like in Jupyter Lab. Figure 4.5 illustrates how to generate a histogram of rent prices that appears inline right after the code. Click the “+” button on the tab of the notebook to get a new cell (if necessary), paste in the following code, then hit shift-enter.

import pandas as pd import matplotlib.pyplot as plt df = pd.read_csv("data/rent-ideal.csv") fig, ax = plt.subplots() ax.hist(df.price, bins=45) plt.show()

(We'll learn more about loading dataframes and creating graphs below.)

The Python shell also has the disadvantage that all of the code we type disappears when the shell exits. Notebooks also execute code through Python shells (running within Jupyter Lab's web server), but the notebooks themselves are stored as .ipynb files on the disk. Killing the Python process associated with a notebook does not affect or delete the notebook file. Not only that, when you restart the notebook, all of the output captured during the last run is cached in the notebook file and immediately shown upon Jupyter Lab start up.

Programming with traditional Python .py files means we don't lose our work when Python exits, but we lose interactive programming. Because of its iterative nature, creating and testing machine learning models rely heavily on interactive programming in order to perform lots of little experiments. If loading the data alone takes, say, 5 minutes, we can't restart the entire program for every experiment. We need the ability to iterate quickly. Using a Python debugger from within an IDE does let us examine the results of each step of a program, but the programming part is not interactive; we have to restart the entire program after making changes.

So notebooks combine the important interactive nature of the Python shell with the persistence of files. Because notebooks keep graphics and other output within the document containing the code, it's very easy to see what a program is doing. That's particularly useful for presenting results or continuing someone else's work. You're free to use whatever development environment you find comfortable, of course, but we strongly recommend Jupyter notebooks. If you follow this recommendation, it's a good idea to go through some of the Jupyter tutorials and videos out there to get familiar with your tools.

4.2 Dataframe Dojo

Before we can use the machine learning models in sklearn, we have to load and prepare data, for which we'll use pandas. We recommend that you get a copy of Wes McKinney's book, “Python for Data Analysis,” but this section covers a key subset of pandas functionality to get you started. (You can also check out the notebooks from McKinney's book.) The goal here is to get you started with the basics so that you can get the gist of the examples in this book and can learn more on your own via stackoverflow and other resources.

4.2.1 Loading and examining data

The first step in the machine learning pipeline is to load data of interest. In many cases, the data is in a comma-separated value (CSV) file and pandas has a fast and flexible CSV reader:

import pandas as pd # import the library and give a short alias: pd df = pd.read_csv("data/rent-ideal.csv") df.head()
 bedroomsbathroomslatitudelongitudeprice
031.500040.7145-73.94253000
121.000040.7947-73.96675465
211.000040.7388-74.00182850
311.000040.7539-73.96773275
441.000040.8241-73.94933350

The head() method shows the first five records in the data frame, but we can pass an argument to specify the number of records. Data sets with many columns are usually too wide to view on screen without scrolling, which we can overcome by transposing (flipping) the data frame using the T property:

df.head(2).T
 01
bedrooms3.00002.0000
bathrooms1.50001.0000
latitude40.714540.7947
longitude-73.9425-73.9667
price3000.00005465.0000

In this way, the columns become rows and wide data frames become tall instead. To get meta-information about the data frame, use method info():

df.info()

<class 'pandas.core.frame.DataFrame'> RangeIndex: 48266 entries, 0 to 48265 Data columns (total 5 columns): bedrooms 48266 non-null int64 bathrooms 48266 non-null float64 latitude 48266 non-null float64 longitude 48266 non-null float64 price 48266 non-null int64 dtypes: float64(3), int64(2) memory usage: 1.8 MB

It's often useful to get a list of the column names, which we can do easily with a dataframe property:

print(df.columns)

Index(['bedrooms', 'bathrooms', 'latitude', 'longitude', 'price'], dtype='object')

And, to learn something about the data itself, use describe():

df.describe()
 bedroomsbathroomslatitudelongitudeprice
count48266.000048266.000048266.000048266.000048266.0000
mean1.50901.178440.7507-73.97253439.4866
std1.09240.42620.03940.02911401.1814
min0.00000.000040.5712-74.12151025.0000
25%1.00001.000040.7281-73.99172495.0000
50%1.00001.000040.7516-73.97793100.0000
75%2.00001.000040.7739-73.95474000.0000
max8.000010.000040.8989-73.75099999.0000

There are also methods to give you a subset of that information, such as the average of each column:

print(df.mean())

bedrooms 1.508950 bathrooms 1.178438 latitude 40.750740 longitude -73.972496 price 3439.486595 dtype: float64

To get the number of apartments with a specific number of bedrooms, use the value_counts() method:

print(df.bedrooms.value_counts())

1 15709 2 14435 0 9428 3 6776 4 1710 5 169 6 36 8 2 7 1 Name: bedrooms, dtype: int64

We can also easily sort a dataframe by a specific column:

df.sort_values('price', ascending=False).head()
 bedroomsbathroomslatitudelongitudeprice
1794763.000040.7287-73.98569999
2791233.000040.7934-73.97439999
4750663.000040.7287-73.98569999
3647532.000040.7320-73.98859995
460422.500040.7285-73.99029995

4.2.2 Extracting subsets

Preparing data for use in a model often means extracting subsets, such as a subset of the columns or a subset of the rows. Getting a single column of data is particularly convenient in pandas because each of the columns looks like a dataframe object property. For example, here's how to extract the price column from data frame df as a Series object:

print(type(df.price)) print(df.price.head(5))

<class 'pandas.core.series.Series'> 0 3000 1 5465 2 2850 3 3275 4 3350 Name: price, dtype: int64

df.price is equivalent to the slightly more verbose df['price'], except that df.price does not work on the left-hand side of an assignment when trying to create a new column (see Section 4.2.5 Injecting new dataframe columns).

Once we have a series, there are lots of useful functions we can call, such as the following.

prices = df.price print(prices.min(), prices.mean(), prices.max())

1025 3439.486595118717 9999

If we need more than one column, we can get a dataframe with a subset of the columns (not a list of Series objects):

bedprice = df[['bathrooms','price']] print(type(bedprice)) bedprice.head()

<class 'pandas.core.frame.DataFrame'>

 bathroomsprice
01.50003000
11.00005465
21.00002850
31.00003275
41.00003350

Data sets typically consist of multiple columns of features and a single column representing the target variable. To separate these for use in training our model, we can explicitly select all future columns or use drop():

X = df.drop('price', axis=1) # get all but price column y = df['price'] X.head(3)
 bedroomsbathroomslatitudelongitude
031.500040.7145-73.9425
121.000040.7947-73.9667
211.000040.7388-74.0018

The axis=1 bit is a little inconvenient but it specifies we'd like to drop a column and not a row (axis=0). The drop() method does not alter the dataframe; instead it returns a view of the dataframe without the indicated column.

Getting a specific row or a subset of the rows by row number involves using the iloc dataframe property. For example, here's how to get the first row of the dataframe as a Series object:

print(type(df.iloc[0])) print(df.iloc[0])

<class 'pandas.core.series.Series'> bedrooms 3.0000 bathrooms 1.5000 latitude 40.7145 longitude -73.9425 price 3000.0000 Name: 0, dtype: float64

and here's how to get the first two rows as a dataframe:

df.iloc[0:2]
 bedroomsbathroomslatitudelongitudeprice
031.500040.7145-73.94253000
121.000040.7947-73.96675465

Those iloc accessors implicitly get all columns, but we can be more explicit with the : slice operator as the second dimension:

print(df.iloc[0,:])

bedrooms 3.0000 bathrooms 1.5000 latitude 40.7145 longitude -73.9425 price 3000.0000 Name: 0, dtype: float64

Or, we can use a list of integer indexes to get specific columns:

print(df.iloc[0,[0,4]])

bedrooms 3.0 price 3000.0 Name: 0, dtype: float64

Generally, though, it's easier to access columns by name by using iloc to get the row of interest and then using dataframe column indexing by name:

print(df.iloc[0][['bedrooms','price']])

bedrooms 3.0 price 3000.0 Name: 0, dtype: float64

4.2.3 Dataframe Indexes

Data frames have indexes that make them behave like dictionaries, where a key maps to one or more rows of a dataframe. By default, the index is the row number, as shown here as the leftmost column:

df.head(3)
 bedroomsbathroomslatitudelongitudeprice
031.500040.7145-73.94253000
121.000040.7947-73.96675465
211.000040.7388-74.00182850

The loc property performs an index lookup so df.loc[0] gets the row with key 0 (the first row):

print(df.loc[0])

bedrooms 3.0000 bathrooms 1.5000 latitude 40.7145 longitude -73.9425 price 3000.0000 Name: 0, dtype: float64

Because the index is the row number by default, iloc and loc give the same result. But we can set index to a column in our dataframe:

dfi = df.set_index('bedrooms') # set_index() returns new view of df dfi.head()
 bathroomslatitudelongitudeprice
bedrooms
31.500040.7145-73.94253000
21.000040.7947-73.96675465
11.000040.7388-74.00182850
11.000040.7539-73.96773275
41.000040.8241-73.94933350

Using the index, we can get all 3-bedroom apartments:

dfi.loc[3].head()
 bathroomslatitudelongitudeprice
bedrooms
31.500040.7145-73.94253000
31.000040.7454-73.98454395
31.000040.7231-74.00443733
31.000040.7660-73.99144500
32.000040.7196-74.01096320

Now that the index differs from the default row number index, dfi.loc[3] and dfi.iloc[3] no longer get the same data; dfi.iloc[3] gets 4th row (indexed from 0).

Setting the dataframe index to the bedrooms column means that bedrooms is no longer available as a column, which is inconvenient but a quirk to be aware of: dfi['bedrooms'] gets error KeyError: 'bedrooms'. By resetting the index, bedrooms will reappear as a column and the default row number index will reappear:

dfi = dfi.reset_index() # overcome quirk in Pandas dfi.head(3)
 bedroomsbathroomslatitudelongitudeprice
031.500040.7145-73.94253000
121.000040.7947-73.96675465
211.000040.7388-74.00182850

Indexing pops up when trying to organize or reduce the data in a data frame. For example, grouping the rows by the values in a particular column makes that column the index. Here's how to group the data by the number of bathrooms and compute the average value of the other columns:

bybaths = df.groupby(['bathrooms']).mean() bybaths
 bedroomslatitudelongitudeprice
bathrooms
0.00000.830040.7561-73.97013144.8700
1.00001.252240.7508-73.97213028.1110
1.50002.277340.7489-73.96594226.3364
2.00002.687440.7495-73.97565278.5957
2.50002.863240.7562-73.96516869.0474
3.00003.296640.7597-73.96766897.9746
3.50003.857140.7487-73.95487635.3571
4.00004.622240.7563-73.95637422.8889
4.50001.000040.8572-73.93502050.0000
10.00002.000040.7633-73.98493600.0000

If we want a dataframe that includes bathrooms as a column, we have to reset the indexCan't access bybaths[['bathrooms','price']], must reset first:

bybaths = bybaths.reset_index() # overcome quirk in Pandas bybaths
 bathroomsbedroomslatitudelongitudeprice
00.00000.830040.7561-73.97013144.8700
11.00001.252240.7508-73.97213028.1110
21.50002.277340.7489-73.96594226.3364
32.00002.687440.7495-73.97565278.5957
42.50002.863240.7562-73.96516869.0474
53.00003.296640.7597-73.96766897.9746
63.50003.857140.7487-73.95487635.3571
74.00004.622240.7563-73.95637422.8889
84.50001.000040.8572-73.93502050.0000
910.00002.000040.7633-73.98493600.0000

and then we can access the columns of interest:

bybaths[['bathrooms','price']]
 bathroomsprice
00.00003144.8700
11.00003028.1110
21.50004226.3364
32.00005278.5957
42.50006869.0474
53.00006897.9746
63.50007635.3571
74.00007422.8889
84.50002050.0000
910.00003600.0000

(Notice that the average price for an apartment with no bathroom is $3145. Wow. Evaluating len(df[df.bathrooms==0]) tells us there are 300 apartments with no bathrooms!)

Accessing dataframe rows via the index is essentially performing a query for all rows whose index key matches a specific value, but we can perform much more sophisticated queries.

4.2.4 Dataframe queries

Pandas dataframes are kind of like combined spreadsheets and database tables and this section illustrates some of the basic queries we'll use for cleaning up data sets.

Machine learning models don't usually accept missing values and so we need to deal with any missing values in our data set. The isnull() method is a built-in query that returns true for each missing element in a series:

print(df.price.isnull().head(3))

0 False 1 False 2 False Name: price, dtype: bool

or even an entire dataframe:

df.isnull().head(3)
 bedroomsbathroomslatitudelongitudeprice
0FalseFalseFalseFalseFalse
1FalseFalseFalseFalseFalse
2FalseFalseFalseFalseFalse

Of course, what we really care about is whether any values are missing and any() returns true if there is at least one true value in the series or dataframe:

print(df.isnull().any())

bedrooms False bathrooms False latitude False longitude False price False dtype: bool

Like a database WHERE clause, pandas supports rich conditional expressions to filter for data of interest. Queries return a series of true and false, according to the results of a conditional expression:

print((df.price>3000).head())

0 False 1 True 2 False 3 True 4 True Name: price, dtype: bool

That boolean series can then be used as an index into the dataframe and the dataframe will return the rows associated with true values. For example, here's how to get all rows whose price is over $3000:

df[df.price>3000].head(3)
 bedroomsbathroomslatitudelongitudeprice
121.000040.7947-73.96675465
311.000040.7539-73.96773275
441.000040.8241-73.94933350

To find a price within a range, we need two comparison operators:

df[(df.price>1000) & (df.price<3000)].head(3)
 bedroomsbathroomslatitudelongitudeprice
211.000040.7388-74.00182850
811.000040.8234-73.94571725
1001.000040.7769-73.94671950

Note that the parentheses are required around the comparison subexpressions to override the high precedence of the & operator. (Without the parentheses, Python would try to evaluate 1000 & df.price.)

Compound queries can reference multiple columns. For example here's how to get all apartments with at least two bedrooms that are less than $3000:

df[(df.bedrooms>=2) & (df.price<3000)].head(3)
 bedroomsbathroomslatitudelongitudeprice
2121.000040.7427-73.97942999
3421.000040.8440-73.94042300
5422.000040.7059-73.83392100

4.2.5 Injecting new dataframe columns

After selecting features (columns) and cleaning up a data set using queries, data science practitioners often create new columns of data in an effort to improve model performance. Creating a new column with pandas is easy, just assign a value to the new column name. Here's how to make a copy of the original df and then create a column of all zeroes in the new dataframe:

df_aug = df.copy() df_aug['junk'] = 0 df_aug.head(3)
 bedroomsbathroomslatitudelongitudepricejunk
031.500040.7145-73.942530000
121.000040.7947-73.966754650
211.000040.7388-74.001828500

That example just shows the basic mechanism; we'd rarely find it useful to set a column of zeros. On the other hand, we might want a column of random numbers to see how it affected model performance. Here's how to overwrite the junk column using a NumPy array of random numbers:

import numpy as np df_aug['junk'] = np.random.random(size=len(df_aug)) df_aug.head(3)
 bedroomsbathroomslatitudelongitudepricejunk
031.500040.7145-73.942530000.6472
121.000040.7947-73.966754650.3905
211.000040.7388-74.001828500.4034

A word of warning when injecting new columns into a dataframe subset. Injecting a new column into, say, df is no problem as long as df is the entire data frame, and not a subset (sometimes called a view). For example, in the following code, bedsprices is a subset of the original df; pandas returns of view of the data rather than inefficiently creating a copy.

bedsprices = df[['bedrooms','price']] # a view or a copy of df? bedsprices['beds_to_price_ratio'] = bedsprices.bedrooms / bedsprices.price

Trying to inject a new column yields a warning from pandas:

A value is trying to be set on a copy of a slice from a DataFrame. Try using .loc[row_indexer,col_indexer] = value instead

Essentially, pandas does not know whether we intend to alter the original df or to make bedsprices into a copy and alter it but not df. The safest route is to explicitly make a copy:

bedsprices = df[['bedrooms','price']].copy() # make a copy of 2 cols of df bedsprices['price_to_beds_ratio'] = bedsprices.price / bedsprices.bedrooms bedsprices.head(3)
 bedroomspriceprice_to_beds_ratio
0330001000.0000
1254652732.5000
2128502850.0000

See Returning a view versus a copy from the pandas documentation for more details.

4.2.6 String and date operations

Dataframes have string and date-related functions that are useful when deriving new columns or cleaning up existing columns. To demonstrate these, we'll need a data set with more columns, so download and unzip rent.csv.zip into your mlbook/data directory. Then use read_csv to load the rent.csv file and display five columns:

df_raw = pd.read_csv("data/rent.csv", parse_dates=['created']) df_rent = df_raw[['created','features','bedrooms','bathrooms','price']] df_rent.head()
 createdfeaturesbedroomsbathroomsprice
02016-06-24 07:54:24[]31.50003000
12016-06-12 12:19:27['Doorman', 'Elevator', '...21.00005465
22016-04-17 03:26:41['Laundry In Building', '...11.00002850
32016-04-18 02:22:02['Hardwood Floors', 'No F...11.00003275
42016-04-28 01:32:41['Pre-War']41.00003350

The parse_dates parameter make sure that the created column is parsed as a date not a string. Column features is a string column (pandas labels them as type object) whose values are comma-separated lists of features enclosed in square brackets, just as Python would display a list of strings. Here's the type information for all columns in rent.csv:

df_rent.info()

<class 'pandas.core.frame.DataFrame'> RangeIndex: 49352 entries, 0 to 49351 Data columns (total 5 columns): created 49352 non-null datetime64[ns] features 49352 non-null object bedrooms 49352 non-null int64 bathrooms 49352 non-null float64 price 49352 non-null int64 dtypes: datetime64[ns](1), float64(1), int64(2), object(1) memory usage: 1.9+ MB

The string-related methods are available via series.str.method(); the str object just groups the methods. For example, it's a good idea to normalize features of string type so that doorman and Doorman are treated as the same word:

df_aug = df_rent.copy() # alter a copy of dataframe df_aug['features'] = df_aug['features'].str.lower() # normalize to lower case df_aug.head()
 createdfeaturesbedroomsbathroomsprice
02016-06-24 07:54:24[]31.50003000
12016-06-12 12:19:27['doorman', 'elevator', '...21.00005465
22016-04-17 03:26:41['laundry in building', '...11.00002850
32016-04-18 02:22:02['hardwood floors', 'no f...11.00003275
42016-04-28 01:32:41['pre-war']41.00003350

As part of the normalization process, it's a good idea to replace any missing values with a blank and any empty features column values, [], with a blank:

df_aug['features'] = df_aug['features'].fillna('') # fill missing w/blanks df_aug['features'] = df_aug['features'].replace('[]','') # fill empty w/blanks df_aug.head()
 createdfeaturesbedroomsbathroomsprice
02016-06-24 07:54:2431.50003000
12016-06-12 12:19:27['doorman', 'elevator', '...21.00005465
22016-04-17 03:26:41['laundry in building', '...11.00002850
32016-04-18 02:22:02['hardwood floors', 'no f...11.00003275
42016-04-28 01:32:41['pre-war']41.00003350

Pandas uses “not a number”, NumPy's np.nan, as a placeholder for unavailable values, even for nonnumeric string and date columns. Because np.nan is a floating-point number, a missing integer flips the entire column to have type float. See Working with missing data for more details.

Looking at the string values in the features column, there is a good deal of information that would potentially improve the model's performance. Models would not generally be able to automatically extract useful features and so we have to give them a hand. The following code creates two new columns that indicates whether or not the apartment has a doorman or laundry ("laundry|washer" is a regular expression that matches if either laundry or washer is present).

df_aug['doorman'] = df_aug['features'].str.contains("doorman") df_aug['laundry'] = df_aug['features'].str.contains("laundry|washer") df_aug.head()
 createdfeaturesbedroomsbathroomspricedoormanlaundry
02016-06-24 07:54:2431.50003000FalseFalse
12016-06-12 12:19:27['doorman', 'elevator', '...21.00005465TrueFalse
22016-04-17 03:26:41['laundry in building', '...11.00002850FalseTrue
32016-04-18 02:22:02['hardwood floors', 'no f...11.00003275FalseFalse
42016-04-28 01:32:41['pre-war']41.00003350FalseFalse

Ultimately, models can only use numeric or boolean data columns, so these conversions are very common. Once we've extracted all useful information from the raw string column, we would typically delete that features column.

Instead of creating new columns, sometimes we convert string columns to numeric columns. For example, the interest_level column in the rent.csv data set is one of three strings (low, medium, and high):

df_aug = df_raw[['created','interest_level']].copy() print(f"type of interest_level is {df_aug.interest_level.dtype}") df_aug.head()

type of interest_level is object

 createdinterest_level
02016-06-24 07:54:24medium
12016-06-12 12:19:27low
22016-04-17 03:26:41high
32016-04-18 02:22:02low
42016-04-28 01:32:41low

An easy way to convert that to a numeric column is to map each string to a unique value:

m = {'low':1,'medium':2,'high':3} df_aug['interest_level'] = df_aug['interest_level'].map(m) print(f"type of interest_level is {df_aug.interest_level.dtype}") df_aug.head()

type of interest_level is int64

 createdinterest_level
02016-06-24 07:54:242
12016-06-12 12:19:271
22016-04-17 03:26:413
32016-04-18 02:22:021
42016-04-28 01:32:411

For large data sets, sometimes it's useful to reduce numeric values to the smallest entity that will hold all values. In this case, the interest_level values all fit easily within one byte (8 bits), which means we can save a bunch of space if we convert the column to int8 from int64:

df_aug['interest_level'] = df_aug['interest_level'].astype('int8') print(f"type of interest_level is {df_aug.interest_level.dtype}")

type of interest_level is int8

Like string columns, models cannot directly use date columns, but we can break up the date into a number of components and derive new information about that date. For example, imagine training a model that predicts sales at a grocery market. The day of the week, or even the day of the month, could be predictive of sales. People tend to shop more on Saturday and Sunday than during the week and perhaps more shopping occurs on monthly paydays. Maybe there are more sales during certain months like December (during Christmas time). Pandas provides convenience methods, grouped in property dt, for extracting various date attributes and we can use these to derive new model features:

df_aug['dayofweek'] = df_aug['created'].dt.dayofweek # add dow column df_aug['day'] = df_aug['created'].dt.day df_aug['month'] = df_aug['created'].dt.month df_aug[['created','dayofweek','day','month']].head()
 createddayofweekdaymonth
02016-06-24 07:54:244246
12016-06-12 12:19:276126
22016-04-17 03:26:416174
32016-04-18 02:22:020184
42016-04-28 01:32:413284

Once we've extracted all useful numeric data, we'd drop column created before training our model on the data set.

4.2.7 Merging dataframes

Imagine we have a df_sales data frame with lots of features about sales transactions, but let's simplified to just two columns for discussion purposes. The problem we have is that price information is in a different dataframe, possibly because we extracted the data from a different source. The two dataframes look like the following.

df_sales
 SalesIDYearMade
012228371000
112228392006
212228412000
312228431000
412228452002
df_prices:
 SalesIDSalePrice
0122283631000
1122283744300
2122283954000
3122284310000
4122284535000
512228478000
6122284933000

Our goal is to create a new column in df_sales that has the appropriate SalePrice for each record. To do that, we need a key that is common to both tables, which is the SalesID in this case. For example, the record in df_sales with SalesID of 1222843 should get a new SalesPrice entry of 10000. In database terms, we need a left join, which keeps all records from the left dataframe and ignores records for unmatched SalesIDs from the right dataframe:

Any record in the left dataframe without a counterpart in right dataframe gets np.NaN (not a number) to represent a missing entry.

In Python the merge operation looks like:

df_merged = df_sales.merge(df_prices, on='SalesID', how='left') # merge in prices df_merged
 SalesIDYearMadeSalePrice
01222837100044300.0000
11222839200654000.0000
212228412000
31222843100010000.0000
41222845200235000.0000

The left join makes a bit more sense sometimes when we see the right join. A right join keeps all records in the right dataframe, filling in record values for unmatched keys with np.NaN:

df_merged = df_sales.merge(df_prices, on='SalesID', how='right') df_merged.sort_values('SalesID')
 SalesIDYearMadeSalePrice
4122283631000
012228371000.000044300
112228392006.000054000
212228431000.000010000
312228452002.000035000
512228478000
6122284933000

4.2.8 Saving and loading data in the feather format

Data files are often in CSV, because it is a universal format and can be read by any programming language. But, loading CSV files into dataframes is not very efficient, which is a problem for large data sets during the highly iterative development process of machine learning models. The author of pandas, Wes McKinney, and Hadley Wickham (a well-known statistician and R programmer) recently developed a new format called feather that loads large data files much faster than CSV files. Given a dataframe, here's how to save it as a feather file and read it back in:

df.to_feather("data/data.feather") # save df as feather file df = pd.read_feather("data/data.feather") # read it back

We performed a quick experiment, mirroring the one done by McKinney and Wickham in their original blog post from 2016. Given a data frame with 10 columns each with 10,000,000 floating-point numbers, pandas takes about two minutes to write it out as CSV to a fast SSD drive. In contrast, it only takes 1.5 seconds to write out the equivalent feather file. Also, the CSV file is 1.8G versus only 800M for the feather file. Reading the CSV file takes 22s versus 6s for the feather file. Here is the test rig, adapted from McKinney and Wickham:

import pandas as pd import numpy as np arr = np.random.randn(10000000) arr[::10] = np.nan # kill every 10th number df = pd.DataFrame({'column_{0}'.format(i): arr for i in range(10)}) %time df.to_csv('/tmp/foo.csv') %time df.to_feather('/tmp/foo.feather') %time df = pd.read_csv('/tmp/foo.csv') %time df = pd.read_feather('/tmp/foo.feather')

Now that we know how load, save, and manipulate dataframes, let's explore the basics of visualizing dataFrame data.

4.3 Generating plots with matplotlib

Matplotlib is a free and widely-used Python plotting library. There are lots of other options, but matplotlib is so well supported, it's hard to consider using anything else. For example, there are currently 34,515 matplotlib questions on stackoverflow. That said, we find it a bit quirky and the learning curve is pretty steep. Getting basic plots working is no problem, but highly-customized plots require lots of digging in the documentation and with web searches. The goal of this section is to show how create the three most common plots: scatter, line, and histogram.

Each matplotlib plot is represented by a Figure object, which is just the drawing surface. The graphs or charts we draw in a figure are called Axes (a questionable name due to similarity with “axis”) but it's best to think of axes as subplots. Each figure has one or more subplots. Here is the basic template for creating a plot:

import matplotlib.pyplot as plt fig, ax = plt.subplots() # make one subplot (ax) on the figure plt.show()

Let's use that template to create a scatterplot using the average apartment price for each number of bedrooms. First, we group the rent data in df by the number of bedrooms and ask for the average (mean). To plot bedrooms versus price, we use the scatter method of the ax subplot object:

» Generated by code to left
bybeds = df.groupby(['bedrooms']).mean() bybeds = bybeds.reset_index() # make bedrooms column again fig, ax = plt.subplots() ax.scatter(bybeds.bedrooms, bybeds.price, color='#4575b4') ax.set_xlabel("Bedrooms") ax.set_ylabel("Price") plt.show()

With some self explanatory methods, such as set_xlabel(), we can also set the X and Y axis labels. Drawing a line in between the points, instead of just a scatterplot, is done using method plot():

» Generated by code to left
fig, ax = plt.subplots() ax.plot(bybeds.bedrooms, bybeds.price, color='#4575b4') ax.set_xlabel("Bedrooms") ax.set_ylabel("Price") plt.show()

If we have a function to plot over some range, instead of data, we can still use plot(). The function provides the Y values, but we need to provide the X values. For example, let's say we'd like to plot the log (base 10) function over the range 0.01 to 100. To make it smooth, we should evaluate the log function at, say, 1000 points; NumPy's linspace() works well to create the X values. Here's the code to make the plot and label the axes:

» Generated by code to left
x = np.linspace(0.01, 100, 1000) y = np.log10(x) # apply log10 to each x value fig, ax = plt.subplots() ax.plot(x, y, color='#4575b4') plt.ylabel('y = log_base_10(x)') plt.xlabel('x') plt.show()

Creating a histogram from a dataFrame column is straightforward using the hist() method:

» Generated by code to left
fig, ax = plt.subplots() ax.hist(df.price, color='#4575b4', bins=50) ax.set_xlabel("Price") ax.set_ylabel("Count of apts") plt.show()

Such plots approximate the distribution of a variable and histograms are a very useful way to visualize columns with lots of data points. Here, we see that the average price is roughly $3000 and that there is a long “right tail” (with a few very expensive apartments).

The last trick we'll consider here is getting more than one plot into the same figure. Let's take two of the previous graphs and put them side-by-side into a single figure. The code to generate the individual graphs is the same, except for the Axes object we use for plotting. Using the subplots() method, we can specify how many rows and columns of subplots we want, as well as the width and height (in inches) of the figure:

fig, axes = plt.subplots(1,2,figsize=(6,2)) # 1 row, 2 columns axes[0].plot(bybeds.bedrooms, bybeds.price, color='#4575b4') axes[0].set_ylabel("Price") axes[0].set_xlabel("Bedrooms") axes[1].hist(df.price, color='#4575b4', bins=50) axes[1].set_ylabel("Count of apts") axes[1].set_xlabel("Price") plt.tight_layout() plt.show()

For some reason, matplotlib does not automatically adjust the space between subplots and so we generally have to call plt.tight_layout(), which tries to adjust the padding. Without that call, the plots overlap.

There's one more library that you will encounter frequently in data science code, and that is Numpy. We've already used it for such things as creating random numbers and representing “not a number” (np.nan).

4.4 Representing and processing data with NumPy

Pandas dataframes are meant to represent tabular data with heterogeneous types, such as strings, dates, and numbers. NumPy, on the other hand, is meant for performing mathematics on n-dimensional arrays of numbers. (See NumPy quickstart.) The boundaries between pandas, matplotlib, NumPy, and sklearn are blurred because they have excellent interoperability. We can create dataframes from NumPy arrays and we can get arrays from pandas dataframes. Matplotlib and sklearn functions accept both pandas and NumPy objects, automatically doing any necessary conversions between datatypes.

The fundamental data type in NumPy is the np.ndarray, which is an n-dimensional array data structure. A 1D ndarray is just a vector that looks just like a list of numbers. A 2D ndarray is a matrix that looks like a list of lists of numbers. Naturally, a 3D ndarray is a rectangular volume of numbers (list of matrices), and so on. The underlying implementation is highly optimized C code and NumPy operations are much faster than doing the equivalent loops in Python code. The downside is that we have yet more library functions and objects to learn about and remember.

Let's start by creating a one dimensional vector of numbers. While the underlying data structure is of type ndarray, the constructor is array():

import numpy as np # import with commonly-used alias np a = np.array([1,2,3,4,5]) # create 1D vector with 5 numbers print(f"type is {type(a)}") print(f"dtype is {a.dtype}") print(f"ndim is {a.ndim}") print(a)

type is <class 'numpy.ndarray'> dtype is int64 ndim is 1 [1 2 3 4 5]

By default, the array has 64-bit integers, but we can use smaller integers if we want:

a = a.astype(np.int8) print(a.dtype) print(a)

int8 [1 2 3 4 5]

To initialize a vector of zeros, we call zeros with a tuple or list representing the shape of the array we want. In this case, let's say we want five integer zeros:

z = np.zeros(shape=[5], dtype=np.int8) print(z)

[0 0 0 0 0]

2We could also use Python tuple syntax, (5,), but that syntax for a tuple with a single element is a bit awkward. (5) evaluates to just 5 in Python, so the Python language designers defined (5,) to mean a single-element tuple. If you ask for a.shape on some 1D array a, you'll get (5,) not [5].

Shape information is always a list or a tuple of length n for an n-dimensional array. Each element in the shape specification is the number of elements in that dimension. In this case, we want a one-dimensional array with five elements so we use shape [5].2

Similarly, here's how to initialize an array with ones:

ones = np.ones([5]) print(ones)

[1. 1. 1. 1. 1.]

The equivalent to Python's range function is arange():

print(np.arange(1,11))

[ 1 2 3 4 5 6 7 8 9 10]

When creating a sequence of evenly spaced floating-point numbers, use linspace (as we did above to create values between 0.1 and 100 to plot the log function). Here's how to create 6 values from 1 to 2, inclusively:

print(np.linspace(1,2,6))

[1. 1.2 1.4 1.6 1.8 2. ]

Using raw Python, we can add two lists of numbers together to get a third very easily, but for long lists speed could be an issue. Delegating vector addition, multiplication, and other arithmetic operators to NumPy gives a massive performance boost. Besides, data scientists need to get use to doing arithmetic with vectors (and matrices) instead of atomic numbers. Here are a few common vector operations performed on 1D arrays:

print(f"{a} + {a} = {a+a}") print(f"{a} - {ones} = {a-ones}") print(f"{a} * {z} = {a*z}") # element-wise multiplication print(f"np.dot({a}, {a}) = {np.dot(a,a)}") # dot product

[1 2 3 4 5] + [1 2 3 4 5] = [ 2 4 6 8 10] [1 2 3 4 5] - [1. 1. 1. 1. 1.] = [0. 1. 2. 3. 4.] [1 2 3 4 5] * [0 0 0 0 0] = [0 0 0 0 0] np.dot([1 2 3 4 5], [1 2 3 4 5]) = 55

How operator overloading works

Python supports operator overloading, which allows libraries to define how the standard arithmetic operators (and others) behave when applied to custom objects. The basic idea is that Python implements the plus operator, as in a+b, by translating it to a.__add__(b). If a is an instance of a class definition you control, you can override the __add__() method to implement what addition means for your class. Here's a simple one dimensional vector class definition that illustrates how to overload + to mean vector addition:

class MyVec: def __init__(self, values): self.data = values def __add__(self, other): newdata = [x+y for x,y in zip(self.data,other.data)] return MyVec(newdata) def __str__(self): return '['+', '.join([str(v) for v in self.data])+']' a = MyVec([1,2,3]) b = MyVec([3,4,5]) print(a + b) print(a.__add__(b)) # how a+b is implemented

[4, 6, 8] [4, 6, 8]

Aside from the arithmetic operators, there are lots of common mathematical functions we can apply directly to arrays without resorting to Python loops:

prices = np.random.random_integers(low=1, high=10, size=5) print(np.log(prices)) print(np.mean(prices)) print(np.max(prices)) print(np.sum(prices))

[2.30258509 1.60943791 0. 2.07944154 1.79175947] 6.0 10 30

The expression np.log(prices) is equivalent to the following loop and array constructor, but the loop is much slower:

np.array([np.log(p) for p in prices])

We ran a simple test to compare the speed of np.log(prices) on 50M random numbers versus np.log on a single number via the Python loop. NumPy takes half a second but the Python loop takes over a minute. That's why it's important to learn how to use these libraries, because using straightforward loops is usually too slow for big data sets.

Now, let's move on to matrices, two dimensional arrays. Using the same array() constructor, we can pass in a list of lists of numbers. Here is the code to create two 4 row x 5 column matrices, t and u, and print out information about matrix t:

t = np.array([[1,1,1,1,1], [0,0,1,0,0], [0,0,1,0,0], [0,0,1,0,0]]) u = np.array([[1,0,0,0,1], [1,0,0,0,1], [1,0,0,0,1], [1,1,1,1,1]]) print(f"type is {type(t)}") print(f"dtype is {t.dtype}") print(f"ndim is {t.ndim}") print(f"shape is {t.shape}") print(t)

type is <class 'numpy.ndarray'> dtype is int64 ndim is 2 shape is (4, 5) [[1 1 1 1 1] [0 0 1 0 0] [0 0 1 0 0] [0 0 1 0 0]]

As another example of matplotlib, let's treat those matrice as two-dimensional images and display them using method imshow() (image show):

» Generated by code to left
fig, axes = plt.subplots(1,2,figsize=(2,1)) # 1 row, 2 columns axes[0].axis('off') axes[1].axis('off') axes[0].imshow(t, cmap='binary') axes[1].imshow(u, cmap='binary') plt.show()

There are also built-in functions to create matrices of zeros:

print(np.zeros((3,4)))

[[0. 0. 0. 0.] [0. 0. 0. 0.] [0. 0. 0. 0.]]

and random numbers, among others:

a = np.random.random((2,3)) # 2 rows, 3 columns print(a)

[[0.67746108 0.70357622 0.26555164] [0.7010816 0.18301225 0.66328037]]

Indexing 1D NumPy arrays works like Python array indexing with integer indexes and slicing, but NumPy arrays also support queries and list of indices, as we'll seen shortly. Here are some examples of 1D indexing:

a = np.arange(1,6) print(a) print(a[0],a[4]) # 1st and 5th item print(a[1:3]) # 2nd and 3rd items print(a[[2,4]]) # 3rd and 5th item

[1 2 3 4 5] 1 5 [2 3] [3 5]

For matrices, NumPy indexing is very similar to pandas iloc indexing. Here are some examples:

print(t[0,:]) # 1st row print(t[:,2]) # middle column print(t[2,3]) # element at 2,3 print(t[0:2,:]) # 1st two rows print(t[:,[0,2]]) # 1st and 3rd columns

[1 1 1 1 1] [1 1 1 1] 0 [[1 1 1 1 1] [0 0 1 0 0]] [[1 1] [0 1] [0 1] [0 1]]

As with pandas, we can perform queries to filter NumPy arrays. The comparison operators return a list of boolean values, one for each element of the array:

a = np.random.random(5) # get 5 random numbers in 0..1 print(a) print(a>0.3)

[0.91242242 0.15364257 0.21901684 0.96691852 0.87590327] [ True False False True True]

We can then use that array of booleans to index into that array, or even another array of the same length:

b = np.arange(1,6) print(b[a>0.3])

[1 4 5]

As with one dimensional arrays, vectors, the NumPy defines the arithmetic operators for matrices. For example, here's how to add and print out two matrices:

print(t+u)

[[2 1 1 1 2] [1 0 1 0 1] [1 0 1 0 1] [1 1 2 1 1]]

If we make an array of matrices, we get a 3D array:

u = np.array([[1,0,0,0,1], [1,0,0,0,1], [1,0,0,0,1], [1,1,1,1,1]]) X = np.array([t,u]) print(f"type is {type(X)}") print(f"dtype is {X.dtype}") print(f"ndim is {X.ndim}") print(X)

type is <class 'numpy.ndarray'> dtype is int64 ndim is 3 [[[1 1 1 1 1] [0 0 1 0 0] [0 0 1 0 0] [0 0 1 0 0]] [[1 0 0 0 1] [1 0 0 0 1] [1 0 0 0 1] [1 1 1 1 1]]]

Sometimes, we'd like to go the opposite direction and unravel (ravel is a synonym) flatten a multidimensional array. Imagine we'd like to process every element of the matrix. We could use nested loops that iterated over the rows and columns, but it's easier to use a single loop over a flattened, 1D version of the matrix. For example, here is how to sum up the elements of matrix u:

# loop equivalent of np.sum(u.flat) n = 0 for v in u.flat: n += v print(n)

11

The flat property is an iterator that is more space efficient than iterating over u.ravel(), which is an actual 1D array of the matrix elements. If you don't need a physical list, just iterate using the flat iterator.

u_flat = u.ravel() # flattens into new 1D array print(np.sum(u.flat)) # flat is an iterator print(u_flat)

11 [1 0 0 0 1 1 0 0 0 1 1 0 0 0 1 1 1 1 1 1]

To iterate through the rows of a matrix instead of the individual elements, use the matrix itself as an iterator:

for i,row in enumerate(t): print(f"{i}: {row}")

0: [1 1 1 1 1] 1: [0 0 1 0 0] 2: [0 0 1 0 0] 3: [0 0 1 0 0]

NumPy has a general method for reshaping n-dimensional arrays. The arguments of the method indicate the number of dimensions and how many elements there are in each dimension.

a = np.arange(1,13) print( "4x3\n", a.reshape(4,3) ) print( "3x4\n", a.reshape(3,4) ) print( "2x6\n", a.reshape(2,6) )

4x3 [[ 1 2 3] [ 4 5 6] [ 7 8 9] [10 11 12]] 3x4 [[ 1 2 3 4] [ 5 6 7 8] [ 9 10 11 12]] 2x6 [[ 1 2 3 4 5 6] [ 7 8 9 10 11 12]]

One of the dimension arguments can be -1, which is kind of a wildcard. Given the total number of values in the array and n-1 dimensions, NumPy can't figure out the dimension. It's very convenient when we know how many rows or how many columns we want because we don't have to compute the other dimension size. Here's how to create a matrix with 4 rows and a matrix with 2 columns using the same data:

print( "4x?\n", a.reshape(4,3) ) print( "?x2\n", a.reshape(-1,2) )

4x? [[ 1 2 3] [ 4 5 6] [ 7 8 9] [10 11 12]] ?x2 [[ 1 2] [ 3 4] [ 5 6] [ 7 8] [ 9 10] [11 12]]

The reshape method comes in handy when we'd like to run a single test vector through a machine learning model. Let's train a random forest regressor model on the rent-idea.csv data using price as the target variable:

import pandas as pd from sklearn.ensemble import RandomForestRegressor df = pd.read_csv("data/rent-ideal.csv") X, y = df.drop('price', axis=1), df['price'] rf = RandomForestRegressor(n_estimators=100, n_jobs=-1) rf.fit(X, y)

And, here's a test vector describing an apartment for which we'd like a predicted price. The sklearn predict() method is expecting a matrix of test vectors, rather than a single test vector.

test_vector = np.array([2,1,40.7947,-73.9957])

If we try sending the test vector in, rf.predict(test_vector), we get error:

ValueError: Expected 2D array, got 1D array instead: array=[ 2. 1. 40.7947 -73.9957]. Reshape your data either using array.reshape(-1, 1) if your data has a single feature or array.reshape(1, -1) if it contains a single sample.

There's a big difference between a 1D vector and 2D matrix with one row (or column). Since sklearn is expecting a matrix, we need to send in a matrix with a single row and we can conveniently convert the test vector into a matrix with one row using reshape(1,-1):

test_vector = test_vector.reshape(1,-1) pred = rf.predict(test_vector) print(f"{test_vector} -> {pred}")

[[ 2. 1. 40.7947 -73.9957]] -> [4951.15242063]

Notice that we also get a vector of predictions (with one element) back because predict() is designed to map multiple test vectors to multiple predictions.

Let's finish up our discussion of NumPy by looking at how to extract NumPy arrays from pandas dataframes. Given a dataframe or column, use the values dataframe property to obtain the data in a NumPy array. Here are some examples using the rent data in df:

print(df.price.values)

[3000 5465 2850 ... 2595 3350 2200]

print(df.iloc[0].values)

[ 3.00000e+00 1.50000e+00 4.07145e+01 -7.39425e+01 3.00000e+03]

print(df[['bedrooms','bathrooms']].values)

[[3. 1.5] [2. 1. ] [1. 1. ] ... [1. 1. ] [0. 1. ] [2. 1. ]]

That wraps up our whirlwind tour of the key libraries, pandas, matplotlib, and NumPy. Let's apply them to some machine learning problems. In the next chapter, we're going to re-examine the apartment data set used in Chapter 3 A First Taste of Applied Machine Learning to train a regressor model, but this time using the original data set. The original data has a number of issues that prevent us from immediately using it to train a model and get good results. We have to explore the data and do some preprocessing before training a model.