CERTIFICATES

This module presents the basic installation setup of the python, overview of python and anaconda environment, setting up jupyter notebook and explaining the dashboard of the jupyter and importing the librariesrequired to work with data.

Basic Data Types, Operators, Variables, Declare Variables, Built-in Functions, Custom Functions, String Methods, Lists , Creating Lists, Index Positions and Slicing and Dictionaries

This module covers to create a Series Object v2, Intro to Methods, Intro to Attributes, Attributes and Methods on a Series, Parameters and Arguments, Parameters and Arguments, Import Series with the pd.read_csv Function, Import Series with the read_csv Function, Use the head and tail Methods to Return Rows from Beginning and End of Dataset, The head and tail Methods, Passing Series to Python Built-In, Functions. Use the apply Method to Invoke a Function on Every Series Values snd map Method.

This module presents Intro to DataFrames, Methods and Attributes between Series and DataFrames, Differences between Shared Methods, Select Two or More Columns from a DataFrame, Add New Column to DataFrame, Create New Column from Existing Column, A Review of the value_counts Method, Drop DataFrame Rows with Null Values with the dropna Method, Delete DataFrame Rows with Missing Values,  astype MethodSort a DataFrame with the sort_values Method, Sort DataFrame Index with the sort_index Method, Rank Series Values with the rank Method.

This Module presents module's Dataset, Memory Optimization, Filter a DataFrame Based on a Condition, Filter DataFrame with More than One Condition (AND - &), Filter DataFrame with More than One Condition (OR - |), Check for Inclusion with the isin Method, Check for Null and Present DataFrame Values with the isnull and notnull Methods, Check for Duplicate DataFrame Rows with the duplicated Method, Delete Duplicate DataFrame Rows with the drop_duplicates Method and identify and Count Unique Values with the unique and nunique Methods.
 

This module presents to import Datasets, Use the set_index and reset_index methods to define a new DataFrame index, Retrieve Rows by Index Label with loc Accessor, Retrieve Rows by Index Position with iloc Accessor, Passing second arguments to the loc and iloc Accessors, Set New Value for a Specific Cell or Cells In a Row, Set Multiple Values in a DataFrame, Delete Rows or Columns from a DataFrame, Create Random Sample with the sample Method, Filter. Apply a Function to every DataFrame Row with the apply Method and Create a Copy of a DataFrame with the copy Method.

This module covers Intro to the Working with Text Data Section, Common String Methods, Use the str.replace method to replace all occurrences of character with another, Filter a DataFrame's Rows with String Methods, More DataFrame String Methods - strip, lstrip, and rstrip, Invoke String Methods on DataFrame Index and Columns, Split Strings by Characters with the str.split Method, More Practice with the str.split method on a Series and Exploring the expand and n Parameters of the str.split Method

This module presents Intro to the MultiIndex Module, Create a MultiIndex on a DataFrame with the set_index Method, Create a MultiIndex on a DataFrame, Extract Index Level Values with the get_level_values Method, Change Index Level Name with the set_names Method, sort_index Method on a MultiIndex DataFrame, Extract Rows from a MultiIndex DataFrame, The transpose Method on a MultiIndex DataFrame, swaplevel Method, unstack Method, pivot Method, Use the pivot_table method to create an aggregate summary of a DataFrame and pd.melt Method

This module covers intro to the GroupBy Module, First Operations with groupby Object, Retrieve a group from a GroupBy object with the get_group Method, Methods on the Groupby Object and DataFrame Columns, Grouping by Multiple Columns and Iterating through Groups.

This module presenst the idea about the Merging, Joining, and Concatenating Section, pd.concat Method, Inner Joins, Outer Joins, left_on and right_on Parameters, Merging by Indexes with the left_index and right_index Parameters, join() Method and pd.merge() Method

This module is useful to gain knowledge about Working with Dates and Times Module, Review of Python's datetime Module, pandas Timestamp Object, pandas DateTimeIndex Object, pd.to_datetime() Method, Create Range of Dates with the pd.date_range() Method, .dt Accessor, Install pandas-datareader Library, Fixing API Errors in Next Lesson, Import Financial Data Set with pandas_datareader Library, Selecting Rows from a DataFrame with a DateTimeIndex, Timestamp Object Attributes and Methods, pd.DateOffset Object, Timeseries Offsets, Timedelta Object and Timedeltas in a Dataset

This module presents the intro to the Input and Output Section, Quick Object Conversions, Export CSV File with the to_csv Method, Install xlrd and openpyxl Libraries to Read and Write Excel Files, Import Excel File into pandas with the read_excel Method and Export Excel File with the to_excel Method
 

This module idea about the Visualization Section, Use the plot Method to Render a Line Chart, Modifying Plot Aesthetics with matplotlib Templates, Creating Bar Graphs to Show Counts, Creating Pie Charts to Represent Proportions.

This module presenst the introduction to the Options and Settings Module, Changing pandas Options with Attributes and Dot Syntax, Changing pandas Options with Methods and precision Option.