Glossary

Data frame: A pandas data structure. In simple words it is an Excel table or Excel file.

Openpyxl: A software reading and writing your Excel documents.

Python3: Latest version of Python.

PIP: A tool to manage and download Python software package.

Pandas: A software reading your Excel documents.

Xlrd: A software accessing and modifying your Excel documents. Your Excel documents must have “.xls” or “.xlsx”

Numeric Type: Numbers, such as 10, 12.1, -2.

String: A sequence of characters. A String can be all digits such as “123”, but it is not a “number”.

Terminal: A tool performing computer tasks within a single tab(by coding).

Working Directory: The directory where you wish to perform tasks.