Course Description


In this Specialization learners will develop foundational Data Science skills to prepare them for a career or further learning that involves more advanced topics in Data Science. The specialization entails understanding what is Data Science and the various kinds of activities that a Data Scientist performs. It will familiarize learners with various open source tools, like Jupyter notebooks, MS Excel and Stata. It will teach you about methodology involved in tackling data science problems. Learners will complete hands-on labs and projects to apply their newly acquired skills and knowledge.

Course Outline


Too often, finance courses stop short of making a connection between textbook finance and the problems of real-world business. This course bridges this gap between theory and practice by providing a nuts-and-bolts guide to solving common financial models with spreadsheets. This course takes the students step by step through financial models and various data management issues, showing how they can be solved.

Week No. Description    
Week 1 Lecture 1: Introduction to Python
Week 1 Lecture 1.1: Getting Started with Pandas
Week 1 Lecture 1.2  Tidy Data

Lecture Notes and Files

Week No. Description
LECTURE 1: Getting Started with Python  Download
Lecture 1.1: Practice on Python lists Download
Lecture 1.2: Advanced Topic: Python Dictionary Read
Lecture 2 : Project: Create a Number to Text Function Access Page
Lecture 3: Pandas DataFrames Download
Lecture 4 : Excercise Download
Lecture 1.3 : Tidy Data Download
Lecture 23 : Macros – 3 Download
Lecture 24 : Solver Function Download
Lecture 25 : Solver Function Download
Lecture 26: Find cost of equity with Solver Download
Lecture 27: Panel Data Analysis Download

Assignments

Assignment 1: Python Basics

Marks = 5
Deadline = Feb 20, 2020
Submission Link = MBA Upload Here | MS Upload Here

 

Tasks to be completed in the assignment

Use Jupyter Notebook for completing the following tasks

1. Show the use of all mathametical operations including the PEMDAS rule

2. Show output of integers and floating numbers

3. Use comments

4. Write and print text

5. Show variable assignments

6. Assign some text to variables and then add more text to the same variable

7. Show practice on SLICING of string 

8. SLICE from a given index upto a given index

9. Create lists and slice elements from list

10. Show the use of FOR loop

11. Show the use of WHILE loop

12. SHOW IF, ELIF, ELSE statements

 

Results

Column 1d Column 2d Column 3d Column 4d Column 5d
Column 1 Value Column 2 Value Column 3 Value Column 4 Value Column 5 Value
Column 1 Value 2 Column 2 Value 2 Column 3 Value 2 Column 4 Value 2 Column 5 Value 2
Column 1 Value 3 Column 2 Value 3 Column 3 Value 3 Column 4 Value 3 Column 5 Value 3
Column 1 Value 4 Column 2 Value 4 Column 3 Value 4 Column 4 Value 4 Column 5 Value 4
Column 1 Value 5 Column 2 Value 5 Column 3 Value 5 Column 4 Value 5 Column 5 Value 5
Column 1 Value 6 Column 2 Value 6 Column 3 Value 6 Column 4 Value 6 Column 5 Value 6
Column 1 Value 7 Column 2 Value 7 Column 3 Value 7 Column 4 Value 7 Column 5 Value 7
Column 1 Value 8 Column 2 Value 8 Column 3 Value 8 Column 4 Value 8 Column 5 Value 8
Column 1 Value 9 Column 2 Value 9 Column 3 Value 9 Column 4 Value 9 Column 5 Value 9
Column 1 Value 10 Column 2 Value 10 Column 3 Value 10 Column 4 Value 10 Column 5 Value 10
Column 1 Value 11 Column 2 Value 11 Column 3 Value 11 Column 4 Value 11 Column 5 Value 11
Column 1 Value 12 Column 2 Value 12 Column 3 Value 12 Column 4 Value 12 Column 5 Value 12
Column 1 Value 13 Column 2 Value 13 Column 3 Value 13 Column 4 Value 13 Column 5 Value 13
Column 1 Value 14 Column 2 Value 14 Column 3 Value 14 Column 4 Value 14 Column 5 Value 14
Column 1 Value 15 Column 2 Value 15 Column 3 Value 15 Column 4 Value 15 Column 5 Value 15