Welcome to Unit 2: Data Collection and Data Manipulation
Welcome to Unit 2 of Foundation of Data Science Using Python, where we explore the essential techniques used to collect, manipulate, clean, and prepare data for Data Science applications.
This unit introduces students to powerful Python libraries such as NumPy and Pandas, which are widely used for numerical computing, data manipulation, analysis, and preprocessing. The concepts are explained in a simple, practical, and beginner-friendly manner, helping students understand how raw data can be transformed into a useful format for further analysis.
You will begin by learning how to install and use NumPy and Pandas, followed by important NumPy concepts such as array operations, reshaping, broadcasting, and indexing. You will also learn how to work with CSV files, filter data, and perform essential data cleaning operations using Pandas.
The unit further introduces the integration of SQL databases with Pandas, including techniques such as read_sql(), which allows students to retrieve and analyze database information directly within Python.
An important part of this unit focuses on Web Data Collection, where you will learn how Python can be used to collect information from websites using popular libraries such as BeautifulSoup, Requests, and Scrapy. A practical mini project on Web Scraping Real-World Data will help students connect theoretical concepts with real-world Data Science applications.
📚 In this Unit, You will Learn:
🔹 Data Collection and Data Manipulation
🔹 Installing and Using NumPy
🔹 Installing and Using Pandas
🔹 NumPy Array Operations
🔹 Array Reshaping
🔹 Array Broadcasting
🔹 Array Indexing
🔹 Reading and Writing CSV Files
🔹 Data Filtering using Pandas
🔹 Data Cleaning and Preprocessing
🔹 Integration of SQL with Pandas
🔹 Reading Database Data using
read_sql()🔹 Introduction to Web Data Collection
🔹 Web Data Collection using Requests
🔹 Web Scraping using BeautifulSoup
🔹 Introduction to Scrapy
🔹 Collecting Real-World Data from Websites
🔹 Mini Project: Web Scraping Real-World Data
Throughout this unit, students will learn how to work with data from different sources such as CSV files, databases, and websites, and understand the techniques required to clean, filter, manipulate, and prepare that data for further analysis.
By the end of this unit, students will be able to use NumPy and Pandas for data manipulation, work with CSV and SQL data, perform basic data cleaning, and collect real-world information from websites using Python web scraping tools.
This unit provides an important practical foundation for advanced topics such as Data Visualization, Exploratory Data Analysis, Machine Learning, and Artificial Intelligence.
🎓 This Study Material is Useful for:
🎓 BCA Students
🎓 MCA Students
🎓 B.Sc. (IT) Students
🎓 Computer Science & IT Beginners
🎓 Python Beginners
🎓 Data Science & Data Analysis Beginners
🎓 Web Scraping Beginners
🎓 Competitive Exam Preparation
⭐ About Ruparel Education
Ruparel Education Pvt. Ltd., Junagadh has been providing quality education and professional computer training for more than 27 years. Our mission is to help students build strong technical skills through practical learning, industry-oriented courses, and expert guidance.
Prepared & Compiled By
Mr. Uday Shah
Head of Information Technology (HOD–IT)
Ruparel Education Pvt. Ltd., Junagadh
Assistant Professor
Faculty of Computer Applications
Noble University
🌐 Blog: https://uday-shah.blogspot.com
© 2026 All Rights Reserved.
