Data Analysis and Visualisation Using Python

Teacher

Anita Patra

Category

Core Courses

Course Attendees

Still no participant

Course Reviews

Still no reviews

Course Name : Data Analysis and Visualisation Using Python

Code(Credit) : CUTM 1018(0-1-3)

Course Objectives

  • How to tell a story from data
  • How to marshal the data for storyline
  • The ability to develop visualisation to tell the story
  • The focus is on analysis of data using visualisation as a tool

Course Outcomes

 

COs

 

Course outcomes

 

Mapping COs with POs (High-3, Medium-2, Low- 1)

 

CO1

 

Able to gain knowledge on visualization with good story line and perform job of a data analyst

 

PO1 (3)

 

CO2

 

Able to analyze and visualize the dataset

 

PO2(3)

 

CO3

 

Ability to design dashboard

 

PO3 (3), PO5(1)

Course Syllabus

Module-I

STORY BOARD DEVELOPMENT

The objective and flow of the story to be understood through cases

 

Module-II

DATA READING USING PYTHON FUNCTIONS

Python libraries: Pandas, NumPy, Plotly, Matplotlib, Seaborn, Dash

Data collection from online data sources, Web scrap, data formats such as HTML, CSV, MS Excel, data compilation, arranging and reading data, data munging

 

Module-III

DATA VISUALSATION USING PYTHON LIBRARIES

Different graphs such as Scatterplot, Line chart, Histogram, Bar chart, Bubble chart, Heatmaps etc.

Dashboard Basics – Layout, Reporting, Infographics, Interactive components, live updating

 

Projects List

1. World Development Indicators

2. IPL matches

3.  IBM HR Analytics

4. Statewise Analysis Socio Economic Indicators

5. Analysis of Lawn Tennis Tournaments

6. World Cup

7. FIFA cup

8. Status of Micro Small Medium Enterprises in India

9. Crime Against Women

10. Tourism in India

11. Loan/Credit Analysis

12. Indian Budget Analysis

13. Handlooms in India

14. Crimes in India

15. E-commerce

16. NIRF Results

17. Results Analysis of CUTM students (last five year passed out students)

18. Malnutrition

19. Population

20. Performance of Indian Movies

21. Crop Production in India

22. Sales in Super Markets

Project-2

23. ERP dashboarding

24. Details of Social/ Empowerment schemes of Govt. etc.

25. COVID 19

References:

https://www.programmer-books.com/wp-content/uploads/2019/04/Python-for-Data-Analysis-2nd-Edition.pdf

https://towardsdatascience.com/data-visualization/home

Reading materials and videos available on internet on how to use ANACONDA, JUPYTER NOTEBOOK and Python Libraries

Session Plan

Session 1

Session 3

Practice 

Environmental setup - Anaconad and Jupyter notebook, Anaconda Navigator and Libraries Installation

https://www.youtube.com/watch?v=beh7GE4FdnM

PPT: Python Libraries

Session 5 & 6

Project - 1

For Project -1, the student group has to define the objective/s of the study, identify the data that will be needed and the source of such data

Make Presentations groupwise

Session 10 & 11

Project - 1

Data collection and sorting for the assigned project

Pandas Tutorial 1. What is Pandas python? Introduction and Installation- https://www.youtube.com/watch?v=CmorAWRsCAw

Pandas Tutorial2. Dataframe and Series Basics- Selecting row and column- https://www.youtube.com/watch?v=zmdjNSmRXF4

Pandas Tutorial 3: Different Ways Of Creating DataFrame - https://www.youtube.com/watch?v=3k0HbcUGErE

Python Pandas Tutorial 4: Read Write Excel CSV File- https://www.youtube.com/watch?v=-0NwrcZOKhQ

Importing data in python - Read excel file - https://www.youtube.com/watch?v=lco-r5CgvhY

Pandas Tutorial 8 | How to import HTML data in Python | Importing HTML data in Python - https://www.youtube.com/watch?v=ndwuUzgAiPY

Pandas Tutorial 13, Crosstabs - https://www.youtube.com/watch?v=I_kUj-MfYys

Session 12 & 13

Practice

Basics of Numpy

https://www.youtube.com/watch?v=xECXZ3tyONo

Complete Python NumPy Tutorial (Creating Arrays, Indexing, Math, Statistics, Reshaping) - https://www.youtube.com/watch?v=GB9ByFAIAH4

PPT     Basic of Numpy

Session 16 & 17

Practice

Basic of Matplotlib

Different Graphs: plots

https://www.youtube.com/watch?v=MbKrSmoMads&pbjreload=10

Matplotlib Tutorial 1 - Introduction and Installation- https://www.youtube.com/watch?v=qqwf4Vuj8oM

Matplotlib Tutorial 2 - format strings in plot function - https://www.youtube.com/watch?v=zl5qPnqps8M

Matplotlib Tutorial 3 - Axes labels, Legend, Grid- https://www.youtube.com/watch?v=oETDriX9n1w

Matplotlib Tutorial 4 - Bar Chart - https://www.youtube.com/watch?v=iedmZlFxjfA

Matplotlib Tutorial 5 - Histograms - https://www.youtube.com/watch?v=r75BPh1uk38

Matplotlib Tutorial 6 - Pie Chart - https://www.youtube.com/watch?v=GOuUGWGUT14

Matplotlib Tutorial 7 - Save Chart To a File Using savefig - https://www.youtube.com/watch?v=XLJHkCn48lM

Plotting real-time data using Python - https://www.youtube.com/watch?v=GIywmJbGH-8

Session 18, 19, 20 & 21

Project (work on Project -1)

Work on the projects assigned using Python Libraries

Pandas Tutorial 1. What is Pandas python? Introduction and Installation- https://www.youtube.com/watch?v=CmorAWRsCAw 

Pandas Tutorial 3: Different Ways Of Creating DataFrame - https://www.youtube.com/watch?v=3k0HbcUGErE

Python Pandas Tutorial 4: Read Write Excel CSV File

https://www.youtube.com/watch?v=-0NwrcZOKhQ

Importing data in python - Read excel file - https://www.youtube.com/watch?v=lco-r5CgvhY

Pandas Tutorial 8 | How to import HTML data in Python | Importing HTML data in Python - https://www.youtube.com/watch?v=ndwuUzgAiPY

Pandas Tutorial 13, Crosstabs - https://www.youtube.com/watch?v=I_kUj-MfYys

 

Session 22 & 24

Practice 

Plotly

https://plotly.com/python/basic-charts/

Graphing Library - https://plotly.com/python/

Plotly Python - Plotly multi line chart| Plotly Python data visualization- https://www.youtube.com/watch?v=pfhBbJ2MnMI

Plotly Data Visualization in Python | Part 13 | how to create bar and line combo chart - https://www.youtube.com/watch?v=AQG4RQolUC8

Plotly Web based visualisation - https://www.youtube.com/watch?v=B911tZFuaOM

Session 25, 26, 27 & 28

Project (Project-1)

Work on Project

Interim Presentation

Session 29 & 30

Session 31 & 32

Practice

Web Scrapping

https://www.youtube.com/watch?v=mKxFfjNyj3c

Web scraping in Python (Part 4)_ Exporting a CSV with pandas - https://www.youtube.com/watch?v=Zh2fkZ-uzBU

Web scraping in Python (Part 2)_ Parsing HTML with Beautiful Soup - https://www.youtube.com/watch?v=zXif_9RVadI

Webscraping - Mode, Median, Mean, Range, and Standard Deviation- https://www.youtube.com/watch?v=mk8tOD0t8M0

Web Scraping Dynamic Graphs to CSV Files using Python - https://www.youtube.com/watch?v=NYK_1bVoBfU

Session 33 & 34

Practice

Solve the 10 problem (started from session 7)

-students will submit the assignment (in groups)

(upload the assignment ...done by Prof. Ramana)

Session 35 & 36

Practice 

Dashboard Basics

https://www.youtube.com/watch?v=e4ti2fCpXMI

Create Presentation Slides from Jupyter - https://www.youtube.com/watch?v=utNl9f3gqYQ

Dash and Python 1_ Setup -https://www.youtube.com/watch?v=Ldp3RmUxtOQ

Dash and Python 2_ Dash Core Components - https://www.youtube.com/watch?v=NM8Ue4znLP8

Dash and Python 3_ Using CSS - https://www.youtube.com/watch?v=x9mUZZ19dl0

Session 37 & 38

Practice

Dash (plotly) and Python

https://www.youtube.com/watch?v=Ldp3RmUxtOQ

Dash in 5 Minutes  - https://www.youtube.com/watch?v=e4ti2fCpXMI

How to Create a Slideshow using Jupyter+Markdown+Reveal.js- https://www.youtube.com/watch?v=EOpcxy0RA1A

ipython dashboard - https://www.youtube.com/watch?v=LOWBEYDkn90

Plotting real-time data using Python - https://www.youtube.com/watch?v=GIywmJbGH-8

Session 38 & 39

Session 40 & 41

Session 42 & 43

Project

Work on Project - 1 to make dash boards

Session 44, 45 & 46

Project

Final presentation of Project -1

Session 47 & 48

Project -2

Start Project - 2 (ERP Dash Board)

Define the objective and prepare the flow chart

Session 49 & 50

Project

Make presentations on the objective and flow chart of Project-2

Session 50 & 51

Project

Work on Project - 2

Session 52 & 53

Project

Make interim presentation on Project - 2

Session 54 & 55

Project

Work on Project - 2

Session 56 & 58

Project

Final Presentation on Project -2

Session 59 & 60

Project

Make final changes on Project -1 & Project -2 to make it ready for External Evaluation

Case Studies

I am text block. Click edit button to change this text. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.

Case Studies

Our Main Teachers

  Professor in Management and an enthusiast learner with teaching and research experience of 20 years. Research interests and publications in the area of Rural entrepreneurship, Banking, Women entrepreneurship. Have been a part of many training and research projects.   “SUCCESS IS NO ACCIDENT. IT IS HARD WORK, PERSEVERANCE, LEARNING, STUDYING, SACRIFICE AND MOST OF […]

Aswini Kumar

Assistant Professor
VIEW PROFILE

M.Aswini kumar working as Assistant Professor, Dept of CSE, Centurion University of Technology and Management, Andhra Pradesh. Interested to work on Machine learning, Natural Language Processing. Programming Skill: C Programming Java Python Android Data Structure Object Oriented Programming using JAVA Python Web Development(HTML,CSS,PHP) Database Management Systems Compilers

Debaraj Rana

Assistant Professor, Department of ECE, SoET Bhubaneswar Campus
VIEW PROFILE

Mr. Debaraj Rana , working as Asst. Professor in the Dept of Electronics & Communication Engineering, School of Engineering and Technology, Bhubaneswar Campus. He has nine years of teaching experience in the field of Electronics and Communication. He has completed his B.Tech from Biju Pattnaik University of Technology and completed in the year 2007 and […]

A Avinash

Asst Professor
VIEW PROFILE

A.Avinash working as Assistant Professor, Dept of CSE, Centurion University of Technology and Management, Andhra Pradesh . Interested to work on Machine learning,Natural Language Processing,Problem Solving Methodologies , and ChatBot. Programming Skill: C Programming Data Structure Object Oriented Programming using C++ Formal Language Automata Theory Python Web Development(HTML,CSS,PHP) Database Management Systems Compilers  

Dr. Bibhunandini Das is working as Associate Professor in Economics in the school of management, Centurion University of Technology and Management, Odisha. Dr Bibhunandini Das has obtained her PhD from the Centre for Development Studies, Jawaharlal Nehru University, New Delhi in 2015. Prior to joining CUTM, she has worked with Indian Institute of Public Health, […]

Dr. Madhumita Das

Assistant Professor
VIEW PROFILE

“We are what we repTeacherseatedly do. Excellence, therefore, is not an act but a habit” I have received my  Ph.D. from the Department of HSS, Indian Institute of Technology (IIT) Kharagpur. Prior to my Ph.D., I also have degrees in M.Phil. in Economics (2007) and MA in Economics (2005), both from Ravenshaw University, Odisha. Throughout my […]