UNIT- 5: Handling CSV files using Python.
Pandas DataFrame & Data Analysis with CSV Files 🔹 What is Pandas? Pandas is a powerful Python library for data analysis and manipulation. It provides two main data structures: Series → 1D array with labeled index (like a column) DataFrame → 2D table with rows and columns (like an Excel spreadsheet) Pandas is used to: […]
Unit-4 Python Collections and Library
Python Collections and Library Python Collections and Library. Python Tuples: A Comprehensive Guide A tuple is an ordered, immutable collection in Python that stores multiple items. It is similar to a list but has fixed values, meaning we cannot modify, add, or remove items after creation. Tuples are used when: ✅ We want data to […]
UNIT-3: Python conditional and iterative statements
Python conditional and iterative statements if statement , if…elif statement , if….. elif…..else statment , nested if 1. if Statement. The if statement is the most basic decision-making statement. It checks whether a given condition is True. If the condition evaluates to True, the indented block of code under the if statement executes; otherwise, the […]
UNIT-2: Python Strings and Operators
UNIT-2: Python Strings and Operators Python Strings A string in Python is a sequence of characters enclosed in single (‘ ‘), double (” “), or triple quotes (”’ ”’ or “”” “””). Strings are immutable, meaning they cannot be changed after creation. Python provides various ways to manipulate and work with strings efficiently. Multiline String, […]
UNIT-1: Python Fundamentals
UNIT-1: Python Fundamentals Concepts of Interpreter-Based Programming Language An interpreter-based programming language is a type of programming language in which the code is executed line by line, rather than being compiled into machine code before execution. The key characteristics of such languages include: Line-by-Line Execution: The interpreter reads and executes code sequentially. No Separate Compilation […]
Day – 2 Import Data into Power BI
Day – 2 Import Data into Power BI Importing Data into Power BI Introduction Importing data into Power BI is the first and most crucial step in building reports and dashboards. Power BI supports various data sources, including Excel, SQL databases, cloud services, APIs, and online data sources. This step involves connecting to a data […]
Day-1 Introduction to PowerBI
Day-1 Introduction to PowerBI Introduction to Power BI. Power BI is a powerful Business Intelligence (BI) and data visualization tool developed by Microsoft. It helps users analyze data, create interactive dashboards, and generate insightful reports with ease What is Power BI? Power BI is a collection of software services, apps, and connectors that work together […]
Create following tables.
Q.4 Create following tables SOLUTION. CREATE TABLE Doctormaster ( doct_id NUMBER PRIMARY KEY, name VARCHAR2(50) NOT NULL, address VARCHAR2(100), specialization VARCHAR2(50) ); CREATE TABLE Patientmaster ( pat_id NUMBER PRIMARY KEY, pat_name VARCHAR2(50) NOT NULL, DOB DATE, address VARCHAR2(100), phoneno VARCHAR2(15), doct_id NUMBER, CONSTRAINT fk_doctor FOREIGN KEY (doct_id) REFERENCES Doctormaster(doct_id) ON DELETE SET NULL ); DECLARE […]
Consider the following table and Do as Directed
Consider the following table and Do as Directed SOLUTION . Â DECLARE v_prod_no Product.Prod_No%TYPE; v_price Product.Price_per_Unit%TYPE; v_quantity Product.Quantity_Sold%TYPE; v_total_sale Product.Total_Sale%TYPE; BEGIN — Accept product number from user v_prod_no := &prod_no; — Retrieve price per unit and quantity sold for the given product SELECT Price_per_Unit, Quantity_Sold INTO v_price, v_quantity FROM Product WHERE Prod_No = v_prod_no; — […]
Write PL/SQL block that will accept employee number from user and deduct an amount of Rs.200 from the inputted employee, if he has a salary less than 1000 after Salary is deducted, it display message‘s Salary is less than 1000’. The process is to be fired on table employee (emp_no, name, salary).
Write PL/SQL block that will accept employee number from user and deduct an amount of Rs.200 from the inputted employee, if he has a salary less than 1000 after Salary is deducted, it display message‘s Salary is less than 1000’. The process is to be fired on table employee (emp_no, name, salary). solution. DECLARE v_emp_no […]