What is Pandas?
- A library built on top of the Python programming language
- A robust toolkit for Analyzing, filtering, manipulating, aggregating, merging, pivoting, and cleaning data
- “Excel for Python” or ” Excel on steroids”
Prerequisites
Required
- Basic Knowledge of spreadsheet software
- Basic understanding of data types(text / strings, integres, floats, Booleans)
Recommended
- Strong knowledge of spreadsheet software (pivots, vlookups, functions)
- Basic understanding of Python ( variables, functions, lists)
Getting Started
- Python and pandas must be installed
- Easiest option is installing the Anaconda distribution, which bundles Python, Pandas
- Use the Terminal /Command Line to update Libraries and install additional ones
to install:
Create Conda
To create an environment:
(base)$ conda create --name pandas_plyground
When conda asks you to proceed, type y
:
proceed ([y]/n)?
To verify:
(base)$ conda info --envs
Activate the new environment:
(base)$ conda activate pandas_plyground
Install pandas, jupyter, bottleneck, numexpr, matplotlib
(pandas_plyground)$ conda install pandas jupyter bottleneck numexpr matplotlib
proceed ([y]/n)? y
(pandas_plyground)$ conda update pandas
(pandas_plyground)$ conda update --all
If you need to delete the environment
(pandas_plyground)$ conda deactivate
(base)$ conda remove --name pandas_plyground --all
proceed ([y]/n)? y
create new file in Jupyter
- Right click on New> Python3
- You can see your new file
- If you need new notebook name click on Untitled
- Here you can enter the notebook name
Mouse navigation
All navigation and actions in the Notebook are available using the mouse through the menubar and toolbar, which are both above the main Notebook area:
Shortcuts in both modes:
Shift + Enter
run the current cell, select belowCtrl + Enter
run selected cellsAlt + Enter
run the current cell, insert belowCtrl + S
save and checkpointD, D (press the key twice)
delete selected cells
- You can change the cell type to Markdown by using the
Cell
menu, the toolbar.
Headers
- You can add headings by starting a line with one (or multiple)
#
followed by a space, as in the following example:
# H1
## H2
### H3
#### H4
##### H5
###### H6
Edit mode
- Edit mode is indicated by a green cell border and a prompt showing in the editor area:
- When a cell is in edit mode, you can type into the cell, like a normal text editor.
- Enter edit mode by pressing
Enter
or using the mouse to click on a cell’s editor area.
Command mode
- Command mode is indicated by a grey cell border with a blue left margin:
- Enter command mode by pressing
Esc
or using the mouse to click outside a cell’s editor area.
Example of Code Cell Execution
Example of import Libraries
Example of Data Types and Variables
Example of Lists
Example of Dictionaries
Example of Operators
Example of Functions
About Fellow Consulting
Fellow Consulting AG, based in Poing near Munich, has been advising clients on digitizing their business processes for more than 10 years.
We know how our customers can implement their digital vision. Together with our partners infor_ Amazon AWS, Microsoft Azure, SugarCRM, and Ephesoft, we bring the mission of digitalization to life.
We act as an operational and strategic specialist for our clients as well as a sparring partner for the everyday challenges of digital transformation.