Skip to content
Posts
- ‘Storage of data is cost effective and time saving in cloud computing.’
- 1. Give the terms for each of the following:
Collection of logically related records. - 1. Name the function that iterate over a Dataframe horizontally? 2. Name the function that iterate over a Dataframe vertically?
- 1. Name the library of which the PyPlot is an Interface.
2. Write the statement to import PyPlot in your script. - 10. What additional argument do you need to specify in to_sql() so that old data of MySQL table is retained ?
11. If query is string storing an SQL statement. Write statements so that the data is fetched based on query from SQL database Mydata. - 11. What is a web site ? How is it related to a web page and a home page ?
- 12. For the given database STUDENT-PROJECT, answer the following:
(a) Name primary key of each table.
(b) Find foreign key(s) in table PROJECT-ASSIGNED. - 12. Name the function to give the title to a plot?
13. Name the function to set the figure size of a plot.
14. Name the function to set the limit for the axes. - 12. What do you understand by a
(i) Web Browser
(ii) Web Server - 13. What are Data types ? How are they important?
14. How many Integer types are supported by Python? Name them. - 13. What is URL ? What are its components ? Examplify.
- 13. Write the term suitable for the following description
- 14. How is an absolute URL different from a relative URL ?
- 15. Name the function to show the legend on a plot.
16. Name the function to add ticks on axes. - 15. What do you understand by HTTP ? How is it related to World Wide Web ?
- 16. What are the two parts of an email address ? Which character is used to separate these two parts ?
- 16. What is Cyber Crime? Give examples.
- 18.What is missing data? 19. Why is missing data filled in Dataframe with some value? 20. Name the function you can use for filling missing data? 21. Name some function to handle missing data.
- 19. What is cyber bullying?
- 2. Choose appropriate answer with respect to the following code snippet.
CREATE TABLE student ( name CHAR(30), student_id INT, gender CHAR(1), PRIMARY KEY (student_id)); - 2. What all libraries do you require in order to bring data from a CSV file into a dataframe ?
3. You want to read data from a CSV file in a dataframe but you want to provide your own column names to dataframe. What additional argument would you specify in read_csv() ? - 2. What will be the output of the following code?
2. SELECT CONCAT (CONCAT(‘Inform’, ‘atics’), ‘Practices’);
3. SELECT LCASE (’INFORMATICS PRACTICES CLASS 11TH‘);
4. SELECT UCASE (’Computer Studies‘);
5. SELECT CONCAT (LOWER (‘Class’), UPPER (‘xii’)); - 20. Below are seven segment of code, each with part colored. Indicate the data type of each colored part by choosing the correct type of data from the following type.
(a) int (b) float (c) bool (d) str (e) function (f) list of int (g) list of str - 21. What is VoIP ? How is it useful ?
- 22. List some advantages/disadvantages of VoIP ?
- 22. Name the function to create histogram from DataFrame. 23. Name some functions used to join or combine dataframes. 24. Name two functions that can produce result similar to SQL joins.
- 24. What are some health concerns related to the excessive use of technology ?
- 3. Enlist some services provided by a web server ?
4. Name some web server software prominently in use ? - 4. By default, read_csv() uses the values of first row as column headers in dataframes. Which argument will you give to ensure that the top/first row’s data is used as data and not as column headers ?
5. Which argument would you give to read.csv() if you only want to read top 10 rows of data ? - 4. Can nongraphic characters be used and processed in Python? How? Give examples to support your answer.
- 5. Out of the following, find those identifiers, which can not be used for naming variables or functions in a Python program:
Price*Qty, class, For, do, 4thCol, totally, Row31, _Amount, - 6. If Str = “INFORMATION PRACTICES…” and Str1 = “… FOR CLASS XI”write commands to print the output as ‘information practices’ for class xi’
- 7. Why do you need connection to an SQL database in order to get data from a table ?
8. What is ‘pymysql’ library of Python ? - 7. Write command to display system date.
8. Write command to display the name of current month.
9. Write SQL statement to display
today, the date is - 8. How can you protect your digital properties ?
- 9. Expand the terms-
OSI, FLOSS, FSF, GNU, GPL, W3C , OSS - A program having multiple functions is considered better designed than a program without any functions. Why?
- A school has a rule that each student must participate in a sports activity. So each one should give only one performance for sport activity. Suppose there are five students in a class, each having a unique roll number. The class representative has prepared a list of sports preferences as shown below. Answer the following:
- A shop called Wonderful Garments that sells school uniforms maintain a database SCHOOL_UNIFORM as shown below. It consisted of two relations — UNIFORM and PRICE.
- An immutable data type is one that can not change after being created. Give three reasons to use immutable data.
- An organization ABC maintains a database EMP-DEPENDENT to record the following details about its employees and their dependents.
- An organization wants to create a database EMPDEPENDENT to maintain following details about its employees and their dependent.
EMPLOYEE (AadharNumber, Name, Address, Department, EmployeeID)
DEPENDENT (EmployeeID, DependentName, Relationship) - Are sum() and add() functions are same?
- Artificial Intelligence Short Notes
- Big Data and its Characteristics
- Boolean Logic Class 11 | Class 11 Computer Science Notes
- BPSC Computer Sample Paper Set-A
- BPSC Computer Science MCQ | Complete Syllabus | Free PDF
- BPSC FAQ
- BPSC Notes Computer Science
- BPSC Syllabus | PGT Computer Science | Free pdf
- Can a function return multiple values? Why?
- Can you suggest a real life application for input/output restricted queues?
- Can you term a PAN as LAN Why/why not
- CBSE Sample Paper 2021-22 Term-1 Informatics Practices Class 12
- Class 10 Self Management Skills MCQ
- Class 11 IP Chapter 4 List and Dictionaries MCQ | Information Practices
- Class 12 Half yearly Question Paper | Informatices Practices | Class 12 Mid Term Exam
- Class 12 IP Answer Key | CBSE Board Exam
- Class 12 IP Answer Key 2023
- Class 12 IP Database Query Using SQL Notes | IP Class 12 SQL Notes
- Class 12 IP NCERT Solutions Chapter 2 | Data Handling Using Pandas Solutions
- Class 12 IP Practical File | Practicals and Solutions with PDF
- Class 12 IP Practical File 2022-23 | Download PDF
- Class 12 IP SQL Practical Questions | MySQL Worksheet for Class 12
- Class 12 IP Viva Questions | Important Python MySQL Viva Questions
- Class 12 Mid Term Question Paper | Informatices Practices
- Class-10 Communication Skills MCQ
- Class-11 Information Practices MCQ
- Class-11 MCQ Chapter-3 Python Overview IP
- Cloud Computing Short Notes
- Communication Skill Class 12 MCQ
- Communication Skill MCQ Class 10
- Communication Skills IT Class-10 MCQ
- Compare and contrast star and bus topologies
- Compare Mesh topology with Tree topology
- Compare Tree and Star topology
- Compared a file system, how does a database management system avoid redundancy in data through a database?
- Computer Network | Sumita Arora Solution Chapter 9 | IP Class 12
- Computer Network MCQ | CBSE Computer Science Questions
- Computer Networks Class 12 Computer Science | Computer Network Notes
- Computer Organization Class 11 Notes | IT 802 Unit-1
- Computer Security Aspects MCQ
- Computer System And Organization Class 11 Notes | Computer Science
- Consider the following MOVIE database and answer the SQL queries based on it.
- Consider the following table FITNESS with details about fitness products being sold in the store.
- Consider the following table named “GYM” with details about fitness items being sold in the store.
- Consider the two fields B_date, which stores the birth date and j_date, which stores the joining date of an employee. Write commands to find out and display the approximate age of an employee as on today.
- Create a database called STUDENT_PROJECT having the following tables. Choose appropriate data type and apply necessary constraints.
- Create a dictionary named with three entries, for key ‘a’, ‘b’ and ‘c’.
What happened if you try to index a nonexistent key (D[‘d’]) ?
What does python do if you try to assign to a nonexistent key d.
e.g. D[‘d’]=‘spam’ - CUET Computer Science Notes | CUET CS IP Notes
- CUET Computer Science Question Paper 2022 PDF Download
- CUET Computer Science Syllabus 2024 | Download Free pdf
- CUET FAQ | Common University Entrance Test related Questions
- CUET MCQ IP Societal Impact
- CUET PYQ Download
- Data Communication MCQ Computer Science
- Data handling class 12 mcq | Informatics Practices MCQ
- Data Visualization MCQ Class 12 IP | Plotting with Pyplot
- Database Concepts Class 12 | Computer Science Notes
- Database Query SQL Function MCQ | MySQL functions MCQ
- DBMS Concept MCQ
- Define a function.
- Define these terms:
(i) Phishing (ii) Scam (iii) hacking (iv) Spoofing - Describe the concept of blocks and body. What is indentation and how is it related to block and body?
- Dictionary in Python Class 11 Notes | Tuples and Dictionaries
- Dictionary is a mutable type, which means you can modify its contents ? What all is modifiable in a dictionary ? Can you modify the keys of a dictionary?
- Difference Linear queue and Circular queue
- Difference Queue and Deque
- Differential between fruitful function and non-fruitful function
- Differentiate between Degree and Cardinality of a relation
- Differentiate between a web page and a home page ?
- Differentiate between ALTER and UPDATE
- Differentiate between cloud computing and grid computing with suitable examples.
- Differentiate between Database state and database schema
- Differentiate between DDL and DML
- Differentiate between DELETE and DROP
- Differentiate between DROP TABLE, DROP DATABASE and DROP Cluase of ALTER TABLE
- Differentiate between Primary key and Foreign key
- Differentiate the different styles of functions in Python using appropriate examples.
- Digital documentation Class 10 Notes | Information Technology 402 Class 10
- Digital Documentation Class 9 Notes | Unit-3
- Discuss and compare various types of network
- Discuss the factor that governs the selection of a topology for a network.
- Discuss the role of following device in the context of networking Bridge
- Discuss the role of following device in the context of networking Gateway
- Discuss the utility and significance of List, briefly.
- Discuss the utility and significance of tuple.
- Electronic Spreadsheet Class 10 | IT 802 Class 10 Notes
- Encoding Scheme and Number System Class 11 Notes
- enqueue and dequeue operations
- Exception Handling Python MCQ
- Explain the difference between import and from import statement, with example.
- Explain the structure of an email message. Also differentiate between cc and bcc fields.
- Explain the use of pass statement. Illustrate it with an example.
- Explain various mostly used topologies.
- Explain with a code example the usage of default argument and keyword argument.
- facilities provided by the SERVER in a Network environment
- File Handling Python MCQ
- File Handling Python Notes
- Find the output of the following program segments:
- Five friends plan to try a startup. However, they have a limited budget and limited computer infrastructure. How can they avail the benefits of cloud services to launch their startup?
- Free Software and Open Source Software (Compare and Contrast)
- Freeware and Free Software (Compare and Contrast)
- Freeware and Shareware (Compare and Contrast)
- Function in Python Class 12 Computer Science
- Fundamentals of Java Class 11 | Java Class 11 IT-802 Notes
- Fundamentals of Java Class 12 Notes | Java Class 12
- Give some examples of queue applications
- Give some examples of stack applications
- Give the output of the following when num1 = 4, num2 = 3, num3 = 2
- Given a dataframe df as shown below:
- Given following Series objects: (a) What will be the result of S1 + S2 ?
- Given following Series objects: (b) What will be the result of S1 – S2 ?
- Hospital Management System in Python | Mini School College Project
- How are floating constants represented in python? Give examples to support your answer.
- How are following import statement different?
(i) import X (ii) from X import * (iii) from X import a,b,c - How are keyword different from Identifier?
- How are SQL commands classified?
- How are string-literals represented and implemented in Python ?
- How block chain technology can be used to promote accountability, transparency and efficiency in distribution of scholarships?
- How can you avoid plagiarism while referring to someone’s else’s creation?
- How does excessive use of technology impact the mental health of a user?
- How IoT and WoT are related?
- How is a LAN different from PAN
- How is a LAN different from WAN
- How is a website different from that of a web portal ?
- How is file open() function different from close() function?
- How is FOREIGN KEY commands different from PRIMARY KEY command?
- How is FOREIGN KEY related to PRIMARY KEY command?
- How is LAN different from MAN
- How is repeater different from an amplifier
- How is Series object different from and similar to ndarrays ? Support your answer with example.
- How public cloud is different from private cloud
- How would you add a new column namely ‘val’ to a Dataframe df that has 10 rows in it and has columns as ‘Item’, ‘Qty’, ‘Price’ ? You can choose to put any values of your choice.
- How would you delete column from a dataframe.
- How would you delete rows from dataframe ?
- If a is (1,2,3)
- Import/Export CSV Files in Pandas MCQ | CSV File MCQ
- In the python shell do the following.
- In which order Python looks for the function/module names used by you?
- Insert all those records of table Account into table Pending where amt_outstanding is more than 10000.
- Introduction to Problem Solving Class 11 Notes | CBSE Computer Science
- Inventory Management System in Python | Stock Management System
- IP Class 11 List and Dictionaries MCQ Chapter-4
- IP Class 11 MCQ Chapter 4 List and Dictionaries
- IP CLASS 12 TERM-1 ANSWER KEY 2021
- IP Class 12 Dataframe MCQ
- IP Class-11 MCQ Chapter-1 | Chapter-1 Computer System MCQ
- IP Project File Class 12 | Python Project File Class 12
- IP Sample Practice Paper 2023 | CBSE Board Class 12
- Is data structure related to data type? Explain
- Is the result of sub() and rsub() the same? Why/why not?
- Is there one function that calculate much of descriptive statistics values ? Name it.
- IT 402 Class 10 Self Management Skills MCQ
- IT 802 Class 12 Database Concept Notes
- IT-402 Class-10 Communication Skill MCQ
- KVS PGT Computer Science MCQ | KVS Recruitment 2022-23
- KVS PGT Computer Science Mock Test | KVS Mock Test | Online Test Series
- KVS PGT Computer Science Notes | KVS Recruitment 2022-23
- KVS PGT Computer Science Syllabus | KVS Recruitment 2022-23
- Library Management System in Python | Download PDF
- List in Python Class 11 Notes | Python List Manipulation
- List some of the cloud-based services that you are using at present.
- Machine Learning Short Notes
- Math the following clauses with their respective functions.
- Matplotlib Plotting with pyplot MCQ | Data Visualization MCQ
- MCQ Communication Skill Class-10
- MCQ for Class-11 Python | Chapter-3 Python Overview
- MySQL Functions MCQ
- Name some common data structures of Python’s Pandas library.
- Name some functions that perform descriptive statistics on a Dataframe.
- Name the function that give you the index of maximum and minimum values on a dataframe.
- Name the function that gives you maximum and minimum values in a Dataframe.
- Name the function that lets you calculate different types of quantiles.
- Name the function to label the axis.
- Networking and Internet Class 11 Notes | IT 802 Unit-2
- Operating Web Based Application Class 12 MCQ | IT 802 Unit-2
- Operating Web Class 12 Notes | Web Application Class 12 IT 802
- OSS and FLOSS (Compare and Contrast)
- Practical File IP Class 12 Term 2
- Previous Year Question Paper IP Class 12
- Pricacy Policy
- Project Synopsis Inventory Management System | CS IP 12 BCA
- Proprietary Software and Free Software (Compare and Contrast)
- Python assignment statements Examples
- Python Data Handling MCQ | Python Pandas MCQ
- Python DataFrame MCQ | Class 12 IP MCQ
- Python Fundamentals Class 11 Notes | Getting Started with Python
- Python MySQL Projects with Source Code
- Python Pandas Dataframe Notes | Class 12 IP Dataframe
- Python Pandas Series Notes | Pandas Series IP 12
- Python Plotting With Pyplot MCQ | Python Data Visualization
- Python Revision Tour Class 12 Notes | CBSE Computer Science
- python stack mcq | postfix expression mcq
- Question-1 | Ch-6 Societal Impact | NCERT Solution IP-12
- Question-10 | Ch-6 Societal Impact | NCERT Solution IP-12
- Question-11 | Ch-6 Societal Impact | NCERT Solution IP-12
- Question-12 | Ch-6 Societal Impact | NCERT Solution IP-12
- Question-13 | Ch-6 Societal Impact | NCERT Solution IP-12
- Question-14 | Ch-6 Societal Impact | NCERT Solution IP-12
- Question-15 | Ch-6 Societal Impact | NCERT Solution IP-12
- Question-16 | Ch-6 Societal Impact | NCERT Solution IP-12
- Question-17 | Ch-6 Societal Impact | NCERT Solution IP-12
- Question-18 | Ch-6 Societal Impact | NCERT Solution IP-12
- Question-19 | Ch-6 Societal Impact | NCERT Solution IP-12
- Question-2 | Ch-6 Societal Impact | NCERT Solution IP-12
- Question-20 | Ch-6 Societal Impact | NCERT Solution IP-12
- Question-21 | Ch-6 Societal Impact | NCERT Solution IP-12
- Question-3 | Ch-6 Societal Impact | NCERT Solution IP-12
- Question-4 | Ch-6 Societal Impact | NCERT Solution IP-12
- Question-5 | Ch-6 Societal Impact | NCERT Solution IP-12
- Question-7 | Ch-6 Societal Impact | NCERT Solution IP-12
- Question-8 | Ch-6 Societal Impact | NCERT Solution IP-12
- Question-9 | Ch-6 Societal Impact | NCERT Solution IP-12
- RDBMS Class 10 Notes | Relational Database Management System
- RDBMS Class 11 Notes | Unit 4 IT-802
- RDBMS Database Concept MCQ
- role of following device in the context of networking Router
- Sample Paper Computer Science Class 12 with Solutions
- School uniform is available at M/s Sheetal Private Limited. They have maintained SCHOOL_UNIFORM Database with two relations viz. UNIFORM and COST. The following figure shows database schema and its state.
- Societal Impact Class 12 IP MCQ
- Societal Impact MCQ | Data Protection MCQ
- Societal Impact MCQ Class 12 | Cyber Safety MCQ
- Societal Impact Notes, IP Class 12 Notes, MCQ n Exercise
- Society Law and Ethics Class 11 Notes | Computer Science
- SQL Class 12 Notes | CBSE Computer Science
- SQL MCQ class 12
- Start with a list [8,9,10]. Do the followings:
- Strings in Python Class 11 | String Manipulation Notes
- Suppose your school management has decided to conduct cricket matches between students of class XI and Class XII. Students of each class are asked to join any one of the four teams — Team Titan, Team Rockers, Team Magnet and Team Hurricane. During summer vacations, various matches will be conducted between these teams. Help your sports teacher to do the following:
- Term-2 IP Class 12 CBSE 2021-22 Suggested Practical List with solution
- The school canteen wants to maintain records of items available in the school canteen and generate bills when students purchase any item from the canteen. The school wants to create a canteen database to keep track of items in the canteen and the items purchased by students. Design a database by answering the following questions:
- Though tuples are immutable type, yet they cannot always be used as keys in a dictionary. what is the condition to use tuples as a key in a dictionary?
- To consider only numeric values for calculation, what argument do you pass to statistics function of Pandas?
- Tuples in Python Class 11 Notes | Tuple and Dictionaries
- Using the sports database containing two relations (TEAM, MATCH_DETAILS), answer the following relational algebra queries.
- Web Applications and Security Class 10 Notes | Unit-4 IT Class 10
- What all components can a Python program contain ?
- What all information does a function header give you about the function ?
- What all libraries do you require in order to interact with MySQL database (and dataframe) from within python.
- What are aggregate functions? What is their use? Give some examples.
- What are arguments ? What are parameters ? How are these terms different yet related ? Give example.
- What are cookies ? What is their utility ?
- What are different cloud deployment models
- What are docstrings? What is their significance? Give example to support your answer?
- What are entry controlled loop ? Which loop is entry controlled loop in Python.
- What are hubs What are it types
- What are immutable and mutable types ? List immutable and mutable types of Python.
- What are input/output restricted queues?
- What are literals in Python? How many types of literals are allowed in Python?
- What are netiquettes? Why are these important?
- What are open source software ?
- What are operators ? What is their function ? Give examples of some unary and binary operators.
- What are plugins ? How do you install these on a web browser ?
- What are push and pop operations
- What are some types of Software license?
- What are table constraints? What are column constraints? How are these two different?
- What are the advantages of CSV file Format ?
- What are the advantages of saving data in:
(i) Binary form
(ii) Text form - What are the components of a web page ?
- What are the components of a website ?
- What are the concerns related to IoT
- What are the difference between implicit type conversion and explicit type conversion ?
- What are the hubs and its various types
- What are the limitations of file system that can be overcome by a relational DBMS?
- What are the two ways to remove something from a list? how are they different?
- What are the two ways to to add something in a list? How are they different?
- What are tokens in Python? How many types of tokens are allowed in Python? Exemplify your answer.
- What are variables ? How are they important for a program?
- What do you understand by linear and non-linear data structures?
- What do you understand by local and global scope of variables ? How can you access a global variable inside the function, if function has a variable with same name?
- What do you understand by mutability? What does “in place” task mean?
- What do you understand by standard library of Python?
- What do you understand by the Internet of Things? List some of its potential applications.
- What does info() and describe() do?
- What happens if mode() returns multiple values for a column but other columns have a single mode?
- What is a line chart?
- What is a network What are its goals and applications
- What is a pie chart?
- What is a scatter chart?
- What is an expression and a statement?
- What is Bar chart?
- What is boxplot?
- What is cloud What is cloud computing
- What is copyright?
- What is data structure? Name some common data structure
- What is difference between a list and a tuple?
- What is digital footprint?
- what is digital property?
What are the threats to digital properties ? - What is dot notation of referring to objects inside a module?
- What is Foreign key? How do you define a Foreign key in your table?
- What is frequency polygon?
- What is Gateway What does it do
- What is GPL software license ? How is it different from LGPL software license ?
- What is hacking? Who is hacker ?
- What is histogram?
- What is intellectual property ? What do you understand by intellectual property rights ?
- What is Internet addiction? What are some symptoms of the Internet addiction ?
- What is Internet of Things
- What is network its goals and applications
- What is on-demand service? How it is provided in cloud computing?
- What is package? How is a package different form module?
- What is pivoting? Name the two functions that you can use for pivoting.
- What is plagiarism ?
- What is public domain software ? Name some common public domain software licenses.
- What is PYTHONPATH variable? What is its significance?
- What is quantile and quartile?
- What is queue
- What is scope? What is the scope resolving rule of Python?
- What is server ? What is a web server ?
- What is stack
- What is the basic difference between pivot() and pivot_table()?
- What is the difference between “w” and “a” modes?
- What is the difference between else and elif construct of if statement?
- What is the difference between HAVING and GROUP BY clause?
- What is the difference between iat and at.
- What is the difference between iloc and loc with respect to Dataframe ?
- What is the difference between Local Variable and Global Variable
- What is the importance of router
- What is the importance of site-packages folder of Python installation?
- What is the internal structure of Python strings?
- What is the library? Write procedure to create own library in Python.
- What is the purpose of DROP TABLE command in MySQL? How is it different from DELETE command?
- What is the role of modem in electronic communications?
- What is the role of switch in a network
- What is the role of switch in a network
- What is the significance of file-object?
- What is the significance of Pandas library?
- What is the significance of the Modules?
- What is the usage of help() and dir() functions.
- What is the use of file _init_.py in a package even when it is empty?
- What is the use of GROUP BY clause?
- What is the use of ORDER BY clause?
- What is the use of UPDATE statement in SQL? How is it different from ALTER statement?
- What is utility of:
(i) default argument
(ii) keyword argument - What is WWW? How does it function ?
- What role is played by modes in file operations? Describe the various file mode constants and their meanings.
- What type of object can be used as keys in dictionaries?
- When do you thing text file should be preferred over binary files?
- When is global statement is used? Why is its use is not recommended?
- When would you opt for a router in a network
- When would you prefer Bridges over hubs
- When would you prefer Switch over other network devices
- Which data structure will you use for simulating a blanket donation camp?
- Which data type will be used to represent the following data values and why?
- Which function would you use to rename the index/column names in a Dataframe?
- Which of the following identifier names are invalid and why?
- Why foreign keys are allowed to have NULL values? Explain with an example.
- Why it is so important to carefully think of digital footprint?
- Why should the form import
- Work Integrated Learning IT DMA Notes | Class 12 IT 802
- Write a program that asks the user to enter one’s name and age. Print out a message addressed to the user that tells the user the year in which he/she will turn 100 years old.
- Write a program to find the average of 3 numbers.
- Write a program to repeat the string “GOOD MORNING” n times. Here n is an integer entered by the user.
- Write a Python program to calculate the amount payable if money has been lent on simple interest. Principal or money lent = P, Rate = R% per annum and Time = T years.
- Write a python script that traverses through an input string and prints its characteristics in different lines – two character per string
- Write advantages and disadvantages of mesh topology
- Write advantages and disadvantages of Tree topology
- Write appropriate function to perform the following on a Dataframe. (i) Calculate the sum (ii) Count the values (iii) Calculate the average (iv) Calculatethe median (v) Calculate the most repeated value (vi) Calculate the standard deviation (vii) Calculate the variance (viii) Calculate the maximum value
- Write code statement for Dataframe df for the following: (a) Delete an existing column from it. (b) Delete row from 3 to 6 from it. (c) Check the Dataframe has any missing values. (d) Fill all missing values with 999 in it.
- Write command to store data of dataframe mdf into a CSV file Mydata.csv, with separator characeter as ‘@’.
- Write commands to print following details of a Series object seal.
- Write equivalent expression for the given functions: (i) A.add(B) (ii) B.add(A) (iii) A.sub(B) (iv) B.sub(A) (v) A.rsub(B) (vi) B.mul(A) (vii) A.rdiv(B) (viii) B.div(A)
- Write function to create following:
(1) Line Chart (2) Bar Chart (3) Horizontal Bar Chart (4) Histogram (5) Scatter Chart (6) Box Plot (7) Pie Chart - Write SQL commands for the following in the basis of given table STUDENT.
- Write SQL commands for the following on the basis of given table Club.
- Write statement(s) to delete a column from a Dataframe.
- Write statement(s) to delete a row from Dataframe
- Write the code segment to list the following, from Dataframe namely sales. (a) List only columns ‘Item’ and ‘revenue’ (b) List rows from 3 to 7 (c) List the value of cell in 5th row, ‘Item’ column.
- Write the SQL statement to print the day of the week of your birthday in the year 1999.
- Write the statement to change the value at 5th row, 6th column in a Dataframe df.
- Write the statement to change the value to 750 at 4th row to 9th row, 7th column in Dataframe df.
- Write two advantages and disadvantages of bus topology
- Wwhy is a dictionary termed as an unordered collection of objects?
error: Content is protected !!