Class 12 IP: Python Pandas 50 MCQs Online Practice Test (Instant Result)

Class XII - Informatics Practices (065)

Python Pandas – I & II | 50 Important MCQs Test

📋 Total Questions: 50 🎯 Full Marks: 50 ⏱️ CBSE Board Prep 2026-27

1. Which of the following is the correct way to import Pandas?

A. import pandas as pd B. import pd as pandas C. include pandas D. import panda

2. Which Pandas data structure is one-dimensional and labelled?

A. DataFrame B. Series C. Array D. Tuple

3. Which Pandas data structure is two-dimensional?

A. Series B. List C. DataFrame D. Dictionary

4. Which function is used to create a Series?

A. pd.series() B. pd.Series() C. pd.createSeries() D. pd.SeriesData()

5. Which function is used to create a DataFrame?

A. pd.Frame() B. pd.dataframe() C. pd.DataFrame() D. pd.createFrame()

6. By default, how many rows are displayed by head()?

A. 3 B. 5 C. 7 D. 10

7. Which function displays the last five rows of a DataFrame by default?

A. start() B. last() C. tail() D. bottom()

8. Which function is used to read a CSV file in Pandas?

A. pd.open_csv() B. pd.read_csv() C. pd.get_csv() D. pd.csv_read()

9. Which method is used to save a DataFrame as a CSV file?

A. save_csv() B. write_csv() C. to_csv() D. export_csv()

10. In a Series, labels associated with values are called:

A. Columns B. Indexes C. Fields D. Headers

11. What does df.shape return?

A. Only number of rows B. Only number of columns C. Rows and columns as a tuple D. Data types

12. What does df.columns return?

A. Row labels B. Column labels C. Data values D. Data types

13. What does df.index return?

A. Column names B. Row labels/index C. Number of rows D. Data types

14. Which attribute displays the data types of columns?

A. df.type B. df.dtype C. df.dtypes D. df.datatype

15. Which argument is commonly used in drop() to specify a column?

A. axis=0 B. axis=1 C. column=1 D. col=True

16. Which value commonly represents a missing value in Pandas?

A. NULL B. 0 C. NaN D. EMPTY

17. Which of the following creates a Series with values 10, 20 and 30?

A. pd.Series([10,20,30]) B. pd.series(10,20,30) C. pd.Series(10,20,30) D. pd.create([10,20,30])

18. What is the default index of pd.Series([10,20,30])?

A. 1,2,3 B. 0,1,2 C. 10,20,30 D. a,b,c

19. What is the output of s[1] if s = pd.Series([10,20,30])?

A. 10 B. 20 C. 30 D. Error

20. Which expression selects elements from position 1 up to but not including 4?

A. s[1:4] B. s[1,4] C. s[0:4] D. s[1::4]

21. Which statement creates a Series from a dictionary?

A. pd.Series({'A':10,'B':20}) B. pd.Series(A=10,B=20) C. pd.DictionarySeries({'A':10}) D. pd.SeriesDict({'A':10})

22. When a scalar is used to create a Series, what is required?

A. A CSV file B. An index C. A DataFrame D. A column name

23. Which statement is correct for scalar Series creation?

A. pd.Series(5, index=['A','B']) B. pd.Series([5], index='A') C. pd.Series.scalar(5) D. pd.scalarSeries(5)

24. Which operator can be used for element-wise addition of two compatible Series?

A. + B. // C. ** D. <>

25. Which method returns the maximum value of a Series?

A. largest() B. max() C. maximum() D. top()

26. Which method returns the minimum value of a Series?

A. min() B. minimum() C. smallest() D. bottom()

27. Which method returns the sum of values in a Series?

A. total() B. add() C. sum() D. plus()

28. Which statement creates a DataFrame from a dictionary of lists?

A. pd.DataFrame({'Name':['A','B'],'Marks':[80,90]}) B. pd.Frame({'Name':['A']}) C. pd.DataFrame(Name='A',Marks=80) D. pd.createFrame(['A',80])

29. Which statement creates a DataFrame from a list of dictionaries?

A. pd.DataFrame([{'Name':'A','Marks':80}]) B. pd.DataFrame({'Name':'A','Marks':80}) C. pd.ListFrame([80]) D. pd.DataFrameList({'A':80})

30. How can a new column 'Grade' be added to df?

A. df.add('Grade') B. df['Grade'] = values C. df.column('Grade') D. df.new('Grade')

31. Which statement selects the Marks column from df?

A. df(Marks) B. df['Marks'] C. df.Marks() D. df.select(Marks)

32. Which statement selects two columns Name and Marks?

A. df['Name','Marks'] B. df[['Name','Marks']] C. df[Name,Marks] D. df.columns('Name','Marks')

33. Which statement deletes a column named Marks?

A. df.delete('Marks') B. df.remove('Marks') C. df.drop('Marks', axis=1) D. df.erase('Marks')

34. Which statement renames Marks to Score?

A. df.rename({'Marks':'Score'}) B. df.rename(columns={'Marks':'Score'}) C. df.change('Marks','Score') D. df.column_rename('Marks','Score')

35. What does axis=1 generally refer to in DataFrame operations?

A. Rows B. Columns C. Index values only D. Cells

36. What does axis=0 generally refer to in DataFrame operations?

A. Columns B. Rows/index C. Cells D. Headers only

37. Which expression filters rows where Marks are greater than 80?

A. df['Marks'] > 80 B. df[df['Marks'] > 80] C. df.filter(Marks>80) D. df[Marks > 80]

38. What type of selection is df[df['Marks'] > 80]?

A. Sequential indexing B. Boolean indexing C. String indexing D. Random indexing

39. Which command displays the first 3 rows?

A. df.head(3) B. df.top(3) C. df.first(3) D. df.start(3)

40. Which command displays the last 3 rows?

A. df.end(3) B. df.tail(3) C. df.last(3) D. df.bottom(3)

41. What does df.info() provide?

A. Only first row B. Summary information about the DataFrame C. Only column names D. A graph

42. Which statement reads student.csv into a DataFrame named df?

A. df = pd.csv('student.csv') B. df = pd.read_csv('student.csv') C. df = pd.open('student.csv') D. df = read.pandas('student.csv')

43. Which statement saves df to student.csv without writing the index?

A. df.to_csv('student.csv', index=False) B. df.save_csv('student.csv', index=False) C. df.csv('student.csv', index=False) D. df.write('student.csv', index=False)

44. If df has 4 rows and 3 columns, what is df.shape?

A. (4,3) B. (3,4) C. 4,3 D. [4,3]

45. What is the output type of df.shape?

A. String B. Tuple C. List D. Dictionary

46. Which code gives rows where Marks are equal to 90?

A. df[df['Marks'] = 90] B. df[df['Marks'] == 90] C. df[df['Marks'] := 90] D. df.where('Marks'=90)

47. Which operator means 'not equal to' in Python?

A. <> B. != C. =! D. NOT=

48. Which of the following is a valid DataFrame column assignment?

A. df['Total'] = df['Maths'] + df['IP'] B. df['Total'] == df['Maths'] + df['IP'] C. df.Total <- df.Maths + df.IP D. df.addcolumn Total

49. Which Pandas structure is best suited for tabular data with rows and columns?

A. Series B. DataFrame C. Scalar D. Tuple

50. Which of the following is NOT a Pandas operation?

A. Filtering B. Reading CSV C. Creating DataFrame D. Creating a Python class automatically

🔄 Want to Retake this Test?

Next attempt available in 24 hours OR unlock instantly by clicking our Sponsor Ad!

SPONSORED ADVERTISEMENT 👉 Click Here to Unlock Instant Retake (Sponsored Link)

Class 10 Computer Application Question Paper 2026-27 with Answer Key

SAMPLE QUESTION PAPER  (2026–27)

Class-X | Computer Application

⏱️ TIME: 02:00 HOURS                                                                             📝 MAX MARKS: 50

📌 General Instructions

• The question paper contains 5 sections labeled A through E.
• Compulsory Questions: All questions are mandatory, though internal choices are provided.
• Section A: 12 MCQs (1 mark each = 12 Marks).
• Section B: 7 Short Answer questions (2 marks each = 14 Marks).
• Section C: 4 Long Answer-I questions (3 marks each = 12 Marks).
• Section D: 1 Long Answer-II question (4 marks = 4 Marks).
• Section E: 2 Case-based questions (4 marks each = 8 Marks).

SECTION - A (Objective / MCQs) 12 × 1 = 12 Marks

1. What does WWW stand for?

a) World Wide Web

b) World Web Wide

c) Web World Wide

d) Wide World Web

💡 Show Answer

Answer: a) World Wide Web

2. Which of the following is used to identify a website on the Internet?

a) URL

b) CPU

c) RAM

d) ROM

💡 Show Answer

Answer: a) URL

3. Which protocol is commonly used for accessing web pages?

a) HTTP

b) FTP

c) SMTP

d) POP

💡 Show Answer

Answer: a) HTTP

4. Which Internet service is mainly used for sending and receiving electronic messages?

a) E-mail

b) FTP

c) WWW

d) Video conferencing

💡 Show Answer

Answer: a) E-mail

5. Which attribute specifies the path/location of an image in HTML?

a) href

b) alt

c) src

d) link

💡 Show Answer

Answer: c) src

6. Which HTML tag is used to create a hyperlink?

a) <a>

b) <link>

c) <href>

d) <url>

💡 Show Answer

Answer: a) <a>

7. Which attribute is used with the <a> tag to specify the destination of a link?

a) src

b) href

c) target

d) alt

💡 Show Answer

Answer: b) href

8. Which HTML tag is used to create a table row?

a) <td>

b) <th>

c) <tr>

d) <table>

💡 Show Answer

Answer: c) <tr>

9. Which tag is used to create a table heading/cell heading?

a) <td>

b) <th>

c) <tr>

d) <caption>

💡 Show Answer

Answer: b) <th>

10. Which Internet service allows users to transfer files from one computer to another?

a) E-mail

b) FTP

c) Chat

d) Search engine

💡 Show Answer

Answer: b) FTP

11. Assertion (A): The <a> tag is used to create a hyperlink in an HTML document.
Reason (R): The href attribute specifies the destination URL of the hyperlink.

a) Both A and R are true, and R is the correct explanation of A.

b) Both A and R are true, but R is not the correct explanation of A.

c) A is true, but R is false.

d) A is false, but R is true.

💡 Show Answer

Answer: a) Both A and R are true, and R is the correct explanation of A.

12. Assertion (A): The <img> tag is used to insert an image into an HTML webpage.
Reason (R): The src attribute specifies the location or path of the image.

a) Both A and R are true, and R is the correct explanation of A.

b) Both A and R are true, but R is not the correct explanation of A.

c) A is true, but R is false.

d) A is false, but R is true.

💡 Show Answer

Answer: a) Both A and R are true, and R is the correct explanation of A.

SECTION - B (Short Answer Questions) 7 × 2 = 14 Marks

13. Explain the difference between SMTP and POP protocols.

💡 Show Answer

Answer: SMTP (Simple Mail Transfer Protocol) is used for sending outgoing emails from a client to a server. POP (Post Office Protocol) is used for retrieving incoming emails from a server to a local device.

14. What is a web browser? Give two examples of web browsers.

💡 Show Answer

Answer: A web browser is software used to access and view web pages on the Internet.
Examples: Google Chrome, Mozilla Firefox.

15. What is a URL? Write its full form and explain its purpose.

💡 Show Answer

Answer: Full form: Uniform Resource Locator.
Purpose: It serves as the unique web address of a specific resource (webpage, file, image) on the Internet.

16. Explain E-mail with an example? Mention any two advantages of an E-mail.

💡 Show Answer

Answer: E-mail is a method of exchanging digital messages over the Internet (e.g., student@example.com).
Advantages:
1. Fast and instant delivery.
2. Cost-effective and paperless.

17. A webpage contains text that takes the user to another website when clicked. What is this feature called? Explain its use.

💡 Show Answer

Answer: It is called a Hyperlink.
Use: It allows users to jump instantly from one webpage or document to another.

18. Write the purpose of the following attribute: a) cellpadding b) cellspacing

💡 Show Answer

Answer:
a) cellpadding: Space between cell content and its border.
b) cellspacing: Space between individual adjacent table cells.

19. Differentiate between rowspan and colspan attributes with examples.

💡 Show Answer

Answer:
• rowspan: Merges cells vertically across rows (e.g., <td rowspan="2">).
• colspan: Merges cells horizontally across columns (e.g., <td colspan="3">).

SECTION - C (Long Answer Questions - I) 4 × 3 = 12 Marks

20. Rohan wants to use the Internet for different purposes (sending teacher messages, online classes, transferring files, buying books). Identify the four Internet services.

💡 Show Answer

Answer:
1. E-mail: For sending messages.
2. Video Conferencing: For online classes.
3. FTP: For file transfers.
4. E-commerce: For online shopping.

21. Neha wants to display school logo (school.jpg) with alt text. Answer the questions:

a) Which tag? b) Which attribute? c) Write the HTML code.

💡 Show Answer

Answer:
a) Tag: <img>
b) Attribute: src
c) Code: <img src="school.jpg" alt="School Logo">

22. Aman wants to create website and email link for school@example.com. Answer the questions:

a) Which tag? b) Which attribute? c) Write HTML code for email link.

💡 Show Answer

Answer:
a) Tag: <a>
b) Attribute: href
c) Code: <a href="mailto:school@example.com">Send Email</a>

23. Functions of <table>, <tr>, <th>, <td> and code example for 3 students' marks.

💡 Show Answer

Answer:
• <table>: Creates table container.
• <tr>: Table Row | <th>: Header Cell | <td>: Data Cell.

<table border="1"><tr><th>Name</th><th>Marks</th></tr><tr><td>Amit</td><td>85</td></tr><tr><td>Priya</td><td>92</td></tr><tr><td>Rahul</td><td>78</td></tr></table>

SECTION - D (Long Answer Question - II) 1 × 4 = 4 Marks

24. Types of Lists in HTML OR Physical vs Logical Tags with examples.

💡 Show Answer

Answer (Types of Lists):
1. Unordered List: <ul>, <li>
2. Ordered List: <ol>, <li>
3. Description List: <dl>, <dt>, <dd>

Answer (Physical vs Logical):
• Physical: <b>, <i>, <u> (Visual styling)
• Logical: <strong>, <em> (Semantic importance)

SECTION - E (Case-Based Questions) 2 × 4 = 8 Marks

25. Case Study 1: List Tags

1. Unordered list tag? 2. Item tag? 3. Description term tag? 4. Description detail tag?

💡 Show Answer

Answers: 1. <ul> | 2. <li> | 3. <dt> | 4. <dd>

26. Case Study 2: Table Attributes

1. Space between cells? 2. Space inside cell? 3. Border purpose? 4. Bgcolor purpose?

💡 Show Answer

Answers:
1. cellspacing
2. cellpadding
3. Sets border thickness.
4. Sets table/cell background color.