Scribd
Upload
6 views

Pandas, matplotlib are python libra

Answers to IP practical

Uploaded by

ankita66833
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
6 views

Pandas, matplotlib are python libra

Answers to IP practical

Uploaded by

ankita66833
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
You are on page 1/ 2

Pandas, matplotlib are python libraries that are used for data analysis,

visualization, and manipulation.

Functions of pyplot?
Ans. Pyplot is used to create plots, graphs, and charts in the Matplotlib library.

Functions used to make bar, line, histogram in python


ans. hist() numpy.histogram(), line(), plt.bar()

Deleting row, column in python


ans. drop() ( axis='column')(for column) or ( axis='index')(for rows)

Adding row, column in python


insert command, loc() or assign()

Accessing first and last row from a series or dataframe


head() or tail()

for rename -- df.rename

modification commands -- UPDATE, CREATE, DROP AND DELETE

DDL(Data definition language) -- It includes commands such as ALTER TABLE, CREATE


TABLE, DROP TABLE, CREATE DATABASE It is used to define and manage database scheme

DML(Data manipulation language) -- It inclue commands such as DELETE, INSERT,


REPLACE, SELECT, AND UPDATE

What are single row functions?


ans. Functions that work on a single row of data and return a single output value
for each row.

What are multi row functions?


ans. Functions that return multiple rows of data from a group of rows.

the WHERE clause filters individual rows in a table, while the HAVING cluse filters
groups of rows.

CREATW TABLE query


CREATE TABLE persons (
person int,
LastName varchar(225),
FirstName varchar(225),
Address varchar(225),
city varchar(225));

ALter Table ---


ALTER TABLE customers
ADD Email varchar(225);

ALTER TABLE customers


DROP COLUMN Email;

Drop Table --- DROP TABLE Shippers;

UPDATE table ---


UPDATE table name
SET column1= value1, column2 = value2, ....
WHERE condition;

DELETE

DELETE FROM table_name WHERE condition;

INSERT INTO table_name (column1, column2)


VALUES (value1, value2);

SELECT --
SELECT CustomerName, city FROM customers;

You might also like