Data Analysis with Pandas and Python

Inquire now

Course Overview:

Pandas is a Python package that provides data structures for working with structured (tabular, multidimensional, potentially heterogeneous) and time series data. On this course you will gain a fundamental understanding of Python Programming Language. Become a proficient Python programmer by learning along with skilled mentors. Learn how to search and navigate the tech documentation and efficiently handle errors and exceptions.

Get comfortable developing Python programs on your own through a series of coding exercises Become familiar with industry standards and learn the best practices for writing code Master your programming skills by working on real life projects; great for a resume building Create two of your projects for your portfolio of code.

Course Objectives:

  • Installing
  • Sorting
  • Filtering
  • Grouping
  • Aggregating
  • De-duplicating
  • Pivoting
  • Munging
  • Deleting
  • Merging
  • Visualizing

Pre-requisites:

  • Basic / intermediate experience with Microsoft Excel or another spreadsheet software (common
  • functions, vlookups, Pivot Tables etc)
  • Basic experience with the Python programming language
  • Strong knowledge of data types (strings, integers, floating points, booleans) etc

Target Audience:

  • Data analysts and business analysts
  • Excel users looking to learn a more powerful software for data analysis

Course Duration:

  • 14 hours – 2 days

Course Content:

Introduction to Python Programming

  • What is Python?
  • Why Python for Analysts?
  • Basic Python operations
  • Variable Types in Python
  • Control Structures in Python
  • Pillars of programming: Python built-in Data types
  • Concept of mutability and behavior of different Data structures.
  • Control flow statements: If, Elif and Else
  • Definite and Indefinite loops: For and While loops
  • Writing user-defined functions in Python
  • Read and write Text files with python
  • Learn how to manipulate data with Python
  • Functions and Procedures
  • Python lists, tuples and dictionaries.

Python as Object Oriented programming language

  • Python classes, objects
  • Python attributes and methods
  • Inheritance

Functional Programming

Introduction to Jupyter

  • Data analysis using python (numpy, pandas, series)
  • Data visualisation using python libraries (ex; matplotlib, seaborn)
  • Closing and Remarks

 

 

Course Customization Options

To request a customized training for this course, please contact us to arrange.

Inquire now

Best selling courses

This site uses cookies to offer you a better browsing experience. By browsing this website, you agree to our use of cookies.