Data Analytics with Python / R crash course, Online BBA, Semester 5:
This subject covers using Python or R to load, clean, merge and reshape data with pandas or dplyr, explore it through summary statistics and charts, and query…
- 10 video lessons
- 3h 30m
- Study notes
- 50 quiz questions
- Assignment
10 lessons in Data Analytics with Python / R
Each lesson pairs one topic with a hand-picked video, trimmed to the part that teaches it.
About this subject
This subject covers using Python or R to load, clean, merge and reshape data with pandas or dplyr, explore it through summary statistics and charts, and query it with SQL. After it you will be able to prepare a messy business dataset for analysis, produce EDA charts in Matplotlib or ggplot, and write SQL queries using JOIN, GROUP BY and subqueries.
- 1
Setting Up Python and R Environments
Module 1, Programming Refresher: Python / R environments
Different Ways Of Creating Python Environment In Data Science Projects- Conda,Virtualenv,Python· Krish Naik· 7 min
Study notes 5 quiz questionsWatch lesson - 2
Data Structures and Functions in Python and R
Module 1, Programming Refresher: Data structures, Functions
Python Tutorial for Beginners | Learn Python in 1.5 Hours· Apna College· 23 min
Study notes 5 quiz questionsWatch lesson - 3
Pandas and dplyr Basics
Module 2, Data Wrangling: Pandas / dplyr
Python for Data Analytics - Full Course for Beginners· Luke Barousse· 36 min
Study notes 5 quiz questionsWatch lesson - 4
Data Cleaning and Handling Missing Values
Module 2, Data Wrangling: Cleaning and missing values
Data Cleaning with Python (Full Course) | Step-by-Step Guide for Data Analyst & Data Science· Tech Classes· 31 min
Study notes 5 quiz questionsWatch lesson - 5
Merging and Reshaping Data in Pandas and dplyr
Module 2, Data Wrangling: Merging and reshaping
Lecture 23 - dplyr join - Combining two dataframes - join - full, inner, left, right, semi and anti· Dr. Vipin's Classroom· 19 min
Study notes 5 quiz questionsWatch lesson - 6
Summary Statistics for EDA
Module 3, Exploratory Data Analysis: Summary statistics
Descriptive Statistics: FULL Tutorial - Mean, Median, Mode, Variance & SD (With Examples)· Grad Coach· 11 min
Study notes 5 quiz questionsWatch lesson - 7
Data Visualisation with Matplotlib and ggplot
Module 3, Exploratory Data Analysis: Visualisation with Matplotlib / ggplot
Matplotlib Python Tutorial for Beginners | Data Visualization in Python· Rishabh Mishra· 37 min
Study notes 5 quiz questionsWatch lesson - 8
SQL SELECT and WHERE Basics
Module 4, SQL for Analytics: SELECT, WHERE
SQL SELECT Queries (Visually Explained) for Beginners | All Essential Clauses | #SQL Course 4· Data with Baraa· 16 min
Study notes 5 quiz questionsWatch lesson - 9
SQL JOIN Types Explained
Module 4, SQL for Analytics: JOIN
Complete SQL JOINS For Beginners | SQL JOIN Queries with Examples | SQL Tutorial in Hindi 11· Rishabh Mishra· 20 min
Study notes 5 quiz questionsWatch lesson - 10
SQL GROUP BY and Subqueries
Module 4, SQL for Analytics: GROUP BY, Subqueries
Group By and Having Clause in SQL | SQL Tutorial in Hindi 9· Rishabh Mishra· 10 min
Study notes 5 quiz questionsWatch lesson
Assignment
Mini Analytics Project: Cleaning, Exploring and Querying a Small Sales Dataset
Less scrolling. More passing.
- Free
Hand-picked video lessons
10 short lessons, each with the best YouTube explanation we could find, trimmed to the part that matters.
- Free login
Study notes
10 lessons come with a summary, key points, key terms and takeaways for quick revision.
- Free login
Quizzes
50 questions across the course, with the right answer and why, the moment you pick.
- Free login
Assignments
1 subject assignments with clear tasks, so you practise what each subject actually asks of you.
- Free login
Notebook
Write notes beside the video, stamped with the exact time, and jump back to that moment later.
- Free login
Progress that follows you
Completed lessons, quiz scores and where you stopped, saved to your account on every device.
- Live chat pass
Live chat
A members-only live chat beside every lesson: doubts, tips, stickers and GIFs with your batch. One ₹19 pass opens every live chat.
The Online BBA live chat. Study together, live.
A live chat right beside the video, shared by everyone studying Online BBA. Ask a Data Analytics with Python / R doubt mid-lesson, share a shortcut, celebrate a finished semester.
- Live chat beside every lesson
- One live chat for all of Online BBA
- Members-only stickers & GIFs
- One ₹19 pass opens every live chat
Online BBA live chat
Anyone else finding Data Analytics with Python / R tricky? 😅
Lesson 2 cleared it up for me. Watch it before the quiz
Doing it now, thanks!
Starting Consumer Behaviour tonight if anyone wants to go together
More from Online BBA Semester 5
All subjects- Sem 5
Consumer Behaviour
Psychological and social influences on consumer decisions.
- 10 lessons
- 2h 53m
- Notes
- Quiz
- Sem 5
Business Analytics
Data management, data mining and Excel modelling for decisions.
- 12 lessons
- 2h 52m
- Notes
- Quiz
- Sem 5
Production and Operations Management
Designing, planning and controlling production and operations.
- 12 lessons
- 3h 52m
- Notes
- Quiz
- Sem 5General Mgmt
Economic Planning
Development theory and economic planning in India.
- 6 lessons
- 6h 14m
- Notes
- Quiz
- Sem 5General Mgmt · Digital Marketing
E-Commerce
Infrastructure, models, security and payments in e-commerce.
- 11 lessons
- 2h 24m
- Notes
- Quiz
- Sem 5
Entrepreneurship
From opportunity to launching, growing and exiting a venture.
- 11 lessons
- 2h 15m
- Notes
- Quiz
Data Analytics with Python / R: common questions
This subject covers using Python or R to load, clean, merge and reshape data with pandas or dplyr, explore it through summary statistics and charts, and query it with SQL. After it you will be able to prepare a messy business dataset for analysis, produce EDA charts in Matplotlib or ggplot, and write SQL queries using JOIN, GROUP BY and subqueries. It's the Data Analytics with Python / R subject of Online BBA, Semester 5, in 10 lessons: Setting Up Python and R Environments; Data Structures and Functions in Python and R; Pandas and dplyr Basics; Data Cleaning and Handling Missing Values; Merging and Reshaping Data in Pandas and dplyr; Summary Statistics for EDA; Data Visualisation with Matplotlib and ggplot; SQL SELECT and WHERE Basics; SQL JOIN Types Explained; SQL GROUP BY and Subqueries.
Yes. Every video lesson is free to watch without an account. A free login unlocks study notes, quizzes, the assignment, a notebook and progress that syncs across devices.
About 3h 30m of video across 10 lessons, plus time for notes and quizzes. Go at your own pace; your place is saved.
Yes: “Mini Analytics Project: Cleaning, Exploring and Querying a Small Sales Dataset”. It comes after the last lesson, with a brief, clear tasks and how the work is judged.
A members-only live chat beside the video, shared by everyone studying Online BBA, where learners ask doubts, share tips and react with stickers and GIFs. One ₹19 pass, paid once from your InsideEdge wallet, opens the live chat for every degree.
No. It's a crash course to help you understand and revise the subject quickly. Use it alongside your official study material and assignments.