Python is one of the most popular programming languages used to analyze Big Data. Our training in Python will equip you to work with Big Data, and get a better understanding of data analysis techniques. The focus is on learning to use Python tools for data science and data analysis efficiently and effectively, with an eye on the overview of advanced pandas topics. Take this course to go beyond performing basic analysis in excel.
Preview
By the end of this course from apps2fusion tutorial, you will be able to:
1.Understand basic and advanced NumPy features
2.Perform data analysis with tools in the Pandas library
3.Manipulate, process, transform, merge and reshape large volumes of data
4.Solve data analysis problems in web analytics, social sciences, finance, and economics
5.Measure data by points in time, specific instances, fixed periods, or intervals
Course Contents
Day 1
Introduction to the Course
What is this Course?
Installation Instructions
Setting up your Environment
IPython Notebooks and Raw Python Data Analysis
Tools of the Trade, The IPython Notebook
Maps
Filters
List Comprehensions
Lambda Functions
The Basics of NumPy
NumPy Array Basics
Boolean Selection
Helpful Methods and Shortcuts
Vectorization
Multi-Dimensional Arrays
Querying Slicing, Combining, and Splitting Arrays
Pandas Basics
General pandas Concepts
pandas Series
Overview of the pandas Series
Look Ups, Selections, and Indexing
Advanced Indexing Options
Handling NaN Values, Reindexing, Filling Methods and Series Addition
Series Multiplication, More Reindexing, and Mapping
Day 2
Pandas DataFrame
DataFrame Basics
Reading Files, Plotting, and Basic Methods
Adding & Reseting Columns, Mapping with Functions
More Plotting, Rolling Calculations, Basic DateTime Indexing
Analysis Concepts, Filling NaN Values, Cumulative Sums and Value Counts
Data Maintenance, Adding/ Removing Columns and Rows
Basic Grouping, Concepts of Aggregate Functions
Advanced pandas Topics
pandas.IO.Data, Panels and Hierarchical Indexing
Advanced Reading Csvs/HTML, Binning, Categorical Data
Groupings and Aggregate Functions
More Grouping Functions including Apply and Transform