Data Science & Machine Learning

𝗙𝗿𝗲𝘀𝗵𝗲𝗿𝘀 𝗖𝗮𝗻 𝗚𝗲𝘁 𝗮 𝟯𝟬 𝗟𝗣𝗔 𝗝𝗼𝗯 𝗢𝗳𝗳𝗲𝗿 𝘄𝗶𝘁𝗵 𝗔𝗜 & 𝗗𝗦 𝗖𝗲𝗿𝘁𝗶𝗳𝗶𝗰𝗮𝘁𝗶𝗼𝗻😍 IIT Roorkee offering AI & Data Science Certification Program 💫Learn from IIT ROORKEE Professors ✅ Students & Fresher can apply 🎓 IIT Certification Program 💼 5000+ Companies Placement Support Deadline: 22nd March 2026 📌 𝗥𝗲𝗴𝗶𝘀𝘁𝗲𝗿 𝗡𝗼𝘄 👇 :- https://pdlink.in/4kucM7E Big Opportunity, Do join asap!

✅ NumPy Basics 🐍📊 NumPy (Numerical Python) is the most important library for numerical computing in Python. It is widely used in: ✔ Data Science ✔ Machine Learning ✔ AI ✔ Scientific computing 🔹 1. What is NumPy? NumPy provides a powerful data structure called NumPy Array. It is faster and more efficient than Python lists for mathematical operations. Example:

import numpy as np

🔹 2. Creating a NumPy Array From a List

import numpy as np
arr = np.array([1, 2, 3, 4])
print(arr)

Output:

[1 2 3 4]

🔹 3. Check Array Type

print(type(arr))

Output:

<class 'numpy.ndarray'>

🔹 4. NumPy Array Operations Addition:

import numpy as np
arr = np.array([1, 2, 3])
print(arr + 2)

Output:

[3 4 5]

Multiplication:

print(arr * 2)

Output:

[2 4 6]

🔹 5. NumPy Built-in Functions

arr = np.array([10, 20, 30, 40])
print(arr.sum())
print(arr.mean())
print(arr.max())
print(arr.min())

Output:

100
25.0
40
10

🔹 6. NumPy Array Shape

arr = np.array([[1, 2, 3], [4, 5, 6]])
print(arr.shape)

Output:

(2, 3)

Meaning: 2 rows and 3 columns. 🔹 7. Why NumPy is Important? NumPy is the foundation of data science libraries: ✔ Pandas ✔ Scikit-Learn ✔ TensorFlow ✔ PyTorch All these libraries use NumPy internally. 🎯 Today's Goal ✔ Install NumPy ✔ Create arrays ✔ Perform math operations ✔ Understand array shape Double Tap ♥️ For More

𝗙𝗥𝗘𝗘 𝗢𝗻𝗹𝗶𝗻𝗲 𝗠𝗮𝘀𝘁𝗲𝗿𝗰𝗹𝗮𝘀𝘀 𝗢𝗻 𝗕𝘆 𝗜𝗻𝗱𝘂𝘀𝘁𝗿𝘆 𝗘𝘅𝗽𝗲𝗿𝘁𝘀 😍 Choose the Right Career Path in 2026 Learn → Level Up → Get Hired 🎯 Join this FREE Career Guidance Session & find: ✔ The right tech career for YOU ✔ Skills companies are hiring for ✔ Step-by-step roadmap to get a job 👇 𝗦𝗮𝘃𝗲 𝘆𝗼𝘂𝗿 𝘀𝗽𝗼𝘁 𝗻𝗼𝘄 (𝗟𝗶𝗺𝗶𝘁𝗲𝗱 𝘀𝗲𝗮𝘁𝘀) https://pdlink.in/4sNAyhW Date & Time :- 18th March 2026 , 7:00 PM

SQL, or Structured Query Language, is a domain-specific language used to manage and manipulate relational databases. Here's a brief A-Z overview by @sqlanalyst A - Aggregate Functions: Functions like COUNT, SUM, AVG, MIN, and MAX used to perform operations on data in a database. B - BETWEEN: A SQL operator used to filter results within a specific range. C - CREATE TABLE: SQL statement for creating a new table in a database. D - DELETE: SQL statement used to delete records from a table. E - EXISTS: SQL operator used in a subquery to test if a specified condition exists. F - FOREIGN KEY: A field in a database table that is a primary key in another table, establishing a link between the two tables. G - GROUP BY: SQL clause used to group rows that have the same values in specified columns. H - HAVING: SQL clause used in combination with GROUP BY to filter the results. I - INNER JOIN: SQL clause used to combine rows from two or more tables based on a related column between them. J - JOIN: Combines rows from two or more tables based on a related column. K - KEY: A field or set of fields in a database table that uniquely identifies each record. L - LIKE: SQL operator used in a WHERE clause to search for a specified pattern in a column. M - MODIFY: SQL command used to modify an existing database table. N - NULL: Represents missing or undefined data in a database. O - ORDER BY: SQL clause used to sort the result set in ascending or descending order. P - PRIMARY KEY: A field in a table that uniquely identifies each record in that table. Q - QUERY: A request for data from a database using SQL. R - ROLLBACK: SQL command used to undo transactions that have not been saved to the database. S - SELECT: SQL statement used to query the database and retrieve data. T - TRUNCATE: SQL command used to delete all records from a table without logging individual row deletions. U - UPDATE: SQL statement used to modify the existing records in a table. V - VIEW: A virtual table based on the result of a SELECT query. W - WHERE: SQL clause used to filter the results of a query based on a specified condition. X - (E)XISTS: Used in conjunction with SELECT to test the existence of rows returned by a subquery. Z - ZERO: Represents the absence of a value in numeric fields or the initial state of boolean fields.

Sure! Here's the text with the requested changes: ✅ Python Exception Handling (try–except) 🐍⚠️ Exception handling helps programs handle errors gracefully instead of crashing. 👉 Very important in real-world applications and data processing. 🔹 1. What is an Exception? An exception is an error that occurs during program execution. Example:

print(10 / 0)

Output: ZeroDivisionError This will crash the program. 🔹 2. Using try–except We use try–except to handle errors. Syntax:

try:
    # code that may cause error
except:
    # code to handle error

Example:

try:
    x = 10 / 0
except:
    print("Error occurred")

Output: Error occurred 🔹 3. Handling Specific Exceptions

try:
    num = int("abc")
except ValueError:
    print("Invalid number")

✔ Handles only ValueError. 🔹 4. Using else else runs if no error occurs.

try:
    x = 10 / 2
except:
    print("Error")
else:
    print("No error")

Output: No error 🔹 5. Using finally finally always executes.

try:
    file = open("data.txt")
except:
    print("File not found")
finally:
    print("Execution completed")

🔹 6. Common Python Exceptions • ZeroDivisionError: Division by zero • ValueError: Invalid value • TypeError: Wrong data type • FileNotFoundError: File does not exist 🎯 Today's Goal ✔ Understand exceptions ✔ Use try–except ✔ Handle specific errors ✔ Use else and finally 👉 Exception handling is widely used in data pipelines and production code. Double Tap ♥️ For More

🚀 𝗪𝗮𝗻𝘁 𝘁𝗼 𝗕𝗲𝗰𝗼𝗺𝗲 𝗮 𝗙𝘂𝗹𝗹 𝗦𝘁𝗮𝗰𝗸 𝗗𝗲𝘃𝗲𝗹𝗼𝗽𝗲𝗿 𝗶𝗻 𝟮𝟬𝟮𝟲? Tech companies are hiring developers with React, JavaScript, Node.js & MongoDB skills.  This Full Stack Development Program helps you learn everything from scratch with real projects. 💡 Perfect for: * Beginners * Students * Career switchers 𝗥𝗲𝗴𝗶𝘀𝘁𝗲𝗿 𝗡𝗼𝘄 👇:-     https://pdlink.in/4hO7rWY   ⚡ Don’t miss this chance to enter the high-paying tech industry!

Top Programming Languages for Beginners 👆

🤖 𝗔𝗜 + 𝗗𝗮𝘁𝗮 = 𝗧𝗵𝗲 𝗙𝘂𝘁𝘂𝗿𝗲 𝗼𝗳 𝗝𝗼𝗯𝘀 Start your journey in Data Analytics & Data Science with AI Certification and gain skills companies are actively hiring for. 📊 Data Analysis 🐍 Python Programming 🤖 Machine Learning 📈 AI-Driven Insights 🔥 Perfect for College Students ,Freshers & Professionals 1️⃣𝗣𝘆𝘁𝗵𝗼𝗻 :- https://pdlink.in/3OD9jI1 2️⃣𝗗𝗮𝘁𝗮 𝗦𝗰𝗶𝗲𝗻𝗰𝗲 :- https://pdlink.in/4kucM7E 3️⃣𝗗𝗮𝘁𝗮 𝗔𝗻𝗮𝗹𝘆𝘁𝗶𝗰𝘀 :- https://pdlink.in/4ay4wPG 4️⃣𝗕𝘂𝘀𝗶𝗻𝗲𝘀𝘀 𝗔𝗻𝗮𝗹𝘆𝘁𝗶𝗰𝘀 :- https://pdlink.in/3ZtIZm9 5️⃣𝗔𝗜 & 𝗠𝗮𝗰𝗵𝗶𝗻𝗲 𝗟𝗲𝗮𝗿𝗻𝗶𝗻𝗴 :- https://pdlink.in/4rMivIA Don't Miss This Opportunity . Get Placement Assistance With 5000+ Companies

💻 𝗙𝗥𝗘𝗘 𝗘𝘅𝗰𝗲𝗹 𝗠𝗮𝘀𝘁𝗲𝗿𝗰𝗹𝗮𝘀𝘀 – 𝗕𝗲𝘆𝗼𝗻𝗱 𝗖𝗼𝗹𝗹𝗲𝗴𝗲 𝗕𝗮𝘀𝗶𝗰𝘀 Still using Excel only for simple tables? Learn how professionals use Excel for data analysis, insights & reporting. ✔ Real business use cases ✔ Must-know Excel formulas ✔ Data cleaning & analysis ✔ Career guidance 📅 13 March | ⏰ 6 PM 𝗥𝗲𝗴𝗶𝘀𝘁𝗲𝗿 𝗙𝗼𝗿 𝗙𝗥𝗘𝗘👇 :-  https://pdlink.in/4bEDmIw 🚀 Upgrade your Excel skills today!

Data Science Roadmap ✅ Python File Handling 🐍📂 File handling allows Python programs to read and write data from files. 👉 Very important in data science because most datasets come as: ✔ CSV files ✔ Text files ✔ Logs ✔ JSON files 🔹 1. Opening a File Python uses the open() function. Syntax: open("filename", "mode") Example: file = open("data.txt", "r") 👉 "r" → Read mode 🔹 2. File Modes - "r" → Read file - "w" → Write file (overwrites existing content) - "a" → Append file (adds to existing content) - "r+" → Read and write 🔹 3. Reading a File - Read Entire File: file.read() - Read One Line: file.readline() - Read All Lines: file.readlines() 🔹 4. Writing to a File

file = open("data.txt", "w")
file.write("Hello Data Science")
file.close()

⚠ "w" will overwrite existing content. 🔹 5. Append to File

file = open("data.txt", "a")
file.write("\nNew line added")
file.close()

✔ Adds content without deleting old data. 🔹 6. Best Practice (Very Important ⭐) Use with statement.

with open("data.txt", "r") as file:
    content = file.read()
    print(content)

✔ Automatically closes the file. 🔹 7. Why File Handling is Important? Used for: ✔ Reading datasets ✔ Saving results ✔ Logging machine learning models ✔ Data preprocessing 🎯 Today’s Goal ✔ Understand file modes ✔ Read files ✔ Write files ✔ Use with open() 👉 File handling is used heavily when working with CSV datasets in data science. Double Tap ♥️ For More

📢 𝗖𝗲𝗿𝘁𝗶𝗳𝗶𝗰𝗮𝘁𝗶𝗼𝗻 𝗔𝗹𝗲𝗿𝘁 – 𝗗𝗮𝘁𝗮 𝗔𝗻𝗮𝗹𝘆𝘁𝗶𝗰𝘀 𝗪𝗶𝘁𝗵 𝗔𝗜 Upgrade your career with AI-powered data analytics skills. 📊 Learn Data Analytics from Scratch 🤖 AI Tools & Automation 📈 Data Visualization & Insights 🎓 Certification Program 🔥 Highly demanded skill in today’s job market. 𝗔𝗽𝗽𝗹𝘆 𝗡𝗼𝘄👇 :-  https://pdlink.in/4syEItX 🚀 Perfect for Students ,Freshers & Working Professionals