Python Data Course, Prepare, Clean, Transform Data. In-Classroom/Online.

Python for Data Analysis

Course summary

You would learn to manipulate large and varied datasets by getting hands-on, practical experience working on real-life data problems.

You would gain working knowledge of the most commonly used Python modules for data scientists.

Get data from data sources, merge and copmbine it to one or more data sets.

Clean your data, re-structure, transform, manipulate data to make sure it is suitable for your use case.

• Location: Online Instructor-led, Or at your office, Or at our classroom. 
• To arrange training at your site, contact us.
• For training in our classroom, book a training ticket and a classroom ticket, or contact us to discuss your group size.
• Duration:  1 Day

Course Outline: 

Session 1: 

Brief Revision of Python Basics. 

Session 2: Data Structures

Lists, Tuples, Sets, Dictionaries, List and Dict Comprehensions

Session 3: Data and Files

Reading and writing CSV files into a Python program: The CSV module,Txt Files. Bytes and Unicode with files. Json Files. Exception Handling. 

Session 3: Database

Linking with SQL Database, Insert Tables,  Insert, Update and delete records. Select queries, traverse and display query results.

Session 3: API's

Inter-acting with Api's

Session 4: Numpy

The Python NumPy Module: Working with arrays, array manipulation, string, math, arithmetic and statistical functions.

Session 5: Pandas

The Python Pandas: Dataframes, Series, Indexing, Sorting, Filter, Slicing, Iteration, Functions, Date/ Time Functionality.  Time series.

Session 6: Data Cleaning and preparation

Random Sampling. Finding and filtering data, Replacing values, Finding and filtering Missing data, Remove Duplicates, String objects, Regex.  Transforming data using function and mapping,  Renaming Axis Indexes, Discretization and Binning. 

Session 7: Data Wrangling

Hierarchical Indexing, Reorder, Sorting, Stastitics, Dataframe Joins, Merging, Concatenation, Overlap. Reshaping and pivoting.

Session 7: Scipy

Introduction and overview of SciPy functions.

Session 6: Plotting and Visualization

Introducing to plotting data with MatPlotLib