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”
- Basic Knowledge of spreadsheet software
- Basic understanding of data types(text / strings, integres, floats, Booleans)
- Strong knowledge of spreadsheet software (pivots, vlookups, functions)
- Basic understanding of Python ( variables, functions, lists)
- 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 create an environment:
(base)$ conda create --name pandas_plyground
When conda asks you to proceed, type
(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
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 + Enterrun the current cell, select below
Ctrl + Enterrun selected cells
Alt + Enterrun the current cell, insert below
Ctrl + Ssave and checkpoint
D, D (press the key twice)delete selected cells
- You can change the cell type to Markdown by using the
Cellmenu, the toolbar.
- You can add headings by starting a line with one (or multiple)
#followed by a space, as in the following example:
- 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
Enteror using the mouse to click on a cell’s editor area.
- Command mode is indicated by a grey cell border with a blue left margin:
- Enter command mode by pressing
Escor 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.