DBMS and Reporting Skill, MDS Program 1, MDS Program 2
Python Base and Advanced Programming
0( 0 REVIEWS )
0 STUDENTS
Instructors
Python Base and Advanced Programming
0 STUDENTS ENROLLED
Python is a high-level programming language and it is mainly used in the field of mathematics and complex program designing, web development, software development and system scripting. However we will learn Python program uses for data analytics here
Course Curriculum
Session - 1 | |||
Python Overview and Installation steps | 00:00:00 | ||
Introduction to Python Editors & IDE’s (Canopy, Pycharm, Jupyter, Rodeo, Ipython etc…) | 00:00:00 | ||
Work around Jupiter Notebook and its customized settings | 00:00:00 | ||
Importing Packages (NumPy, SciPy, scikit-learn, Pandas, Matplotlib, etc) | 00:00:00 | ||
Installing & loading Packages & Name Spaces | 00:00:00 | ||
Data Types & Data objects/structures | 00:00:00 | ||
<ul> <li>Srtings</li> <li>Tuples</li> <li>List</li> <li>Dictionaries</li> </ul> | |||
Variable Types and Values | 00:00:00 | ||
Reading and writing data (Importing and Exporting) | 00:00:00 | ||
<ul> <li>Importing Data from various sources (Csv, txt, excel, access etc)</li> <li>Database Input (Connecting to database)</li> <li>Viewing Data objects - subsetting, methods</li> <li>Exporting Data to various formats</li> <li>Important python modules: Pandas, beautifulsoup</li> </ul> | |||
Session - 2 | |||
Data Manipulation Steps | 00:00:00 | ||
<ul> <li>Sorting/ Filtering</li> <li>Duplicate data handling</li> <li>Smapling/Subsetring</li> <li>Dericed Variable</li> <li>Data type conversion</li> <li>Renaming</li> <li>Formatting</li> </ul> | |||
Session - 3 | |||
Vertical Join- Appending | 00:00:00 | ||
Horizontal Join- Merging | 00:00:00 | ||
<ul> <li style="list-style-type: none;"> <ul> <li>Inner Join</li> <li>Outer Join <ul> <li style="list-style-type: none;"> <ul> <li>Full outer join <ul> <li>Un-matched join</li> </ul> </li> <li>Left outer join <ul> <li>Left null join</li> </ul> </li> <li>Right outer join <ul> <li>Right null join</li> </ul> </li> </ul> </li> </ul> </li> <li>Keys and Relationships</li> </ul> </li> </ul> | |||
Session - 4 | |||
Control flow & conditional statements | 00:00:00 | ||
<ul> <li>If-Else</li> <li>Loops (For and While)</li> </ul> | |||
Python Functions | 00:00:00 | ||
<ul> <li>Built-in <ul> <li>Text, Numeric, Date, Utility</li> </ul> </li> <li>User defined function</li> </ul> | |||
Session - 5 | |||
Data Analysis and Visualization steps | 00:00:00 | ||
<ul> <li style="list-style-type: none;"> <ul> <li>Creating graphs <ul> <li>Bar Chart</li> <li>Pie Chart</li> <li>Line Chart</li> <li>Histogram</li> <li>Boxplot</li> <li>Scatter</li> <li>Density</li> </ul> </li> <li>Introduction to model building steps</li> <li>Data exploration and validation</li> <li>Descriptive statistics, Frequency Tables and summarization</li> <li>Univariate Analysis (Distribution of data & Graphical analysis)</li> <li>Bivariate Analysis (Cross Tabs, Distributions & Relationships, Graphical analysis)</li> </ul> </li> </ul> |