Data Analysis with Python

Python Crash Course

• Working with data types
• Slicers
• Control structures
• Understanding Python’s Data Structures
• Implementing Functions

Pandas – Series

• Understanding one-dimensional labeled arrays
• Create a Series from Python objects
• Using the read_csv() method
• Attributes
• Methods
• Arguments and Parameters
• Extracting Series values

Pandas – DataFrames

• Understanding two-dimensional data structures
• Selecting columns from a DataFrame
• Adding new columns to a DataFrame
• Working with Nulls
• Sorting a DataFrame
• Filter a DataFrame – conditions and methods
• Retrieving rows by Index position
• Delete rows or columns from a DataFrame
• Rename Index labels or Columns in a DataFrame
• Common String methods

Using MultiIndex

• Understanding multiIndexes in Pandas
• Creating a multiIndex
• Extracting rows from a multiIndex
• Common methods

Group By

• Basic operations
• Retrieving groups
• Common methods
• Group by multiple columns
• Iterating through groups

Joining and Concatenating Data

• Join operations between DataFrame objects
• combining together Pandas objects

Working with Dates

• Understanding Python’s datetime module
• Pandas Timestamp and DateTimeIndex objects
• Pandas DateOffset and TimeDelta objects
• Common methods

Python Pandas – Panels

• Understanding the axis of a Panel Object
• Common methods and attributes
• Extracting data

Pandas I/O API

• Object conversions
• Export DataFrame to csv
• Importing and exporting Excel files

Visualization

• Using the .plot() method
• Bar Graphs
• Pie Charts
• Histograms

• Previous experience with data analysis
• Basic understanding of SQL
• Basic understanding of Programming concepts