Pro Machine Learning Algorithms: A Hands-On Approach to Implementing Algorithms in Python and R

Appendix: Basics of Excel, R, and Python

This chapter introduces the three tools mentioned often in this book: Microsoft Excel and the two programming languages R and Python.

Basics of Excel

In Microsoft Excel , each cell is represented by numbers in rows and letters in columns.

For example, the following highlighted cell is the cell D4:

Cells can be referenced by specifying the = symbol followed by the cell we are trying to refer to. For example, if we want the cell D4 to reflect the value in cell A1, we would type it in as follows:

Pressing ...