| 201 |
Which accessor selects rows and columns by their position numbers? |
Computer Science/Informatics Practices
Indexing, merging and CSV |
Easy |
| 202 |
Which method writes a DataFrame df to a file named result.csv? |
Computer Science/Informatics Practices
Indexing, merging and CSV |
Easy |
| 203 |
A DataFrame has index r1 to r4 and Marks 78, 45, 91 and 62. How many rows does df[df['Marks'] > 60] return? |
Computer Science/Informatics Practices
Indexing, merging and CSV |
Medium |
| 204 |
For the same DataFrame with index r1, r2, r3, r4, which two expressions both return the rows r2 and r3? |
Computer Science/Informatics Practices
Indexing, merging and CSV |
Medium |
| 205 |
d1 has id values 1, 2, 3 and d2 has id values 2, 3, 4, each with one other column. How many rows does pd.merg… |
Computer Science/Informatics Practices
Indexing, merging and CSV |
Hard |
| 206 |
Which function returns the number of non-missing values in each column of a DataFrame? |
Computer Science/Informatics Practices
Descriptive statistics |
Easy |
| 207 |
Which Pandas method gives count, mean, standard deviation, minimum, quartiles and maximum together? |
Computer Science/Informatics Practices
Descriptive statistics |
Easy |
| 208 |
For s = pd.Series([2, 4, 4, 4, 5, 5, 7, 9]), what is s.median()? |
Computer Science/Informatics Practices
Descriptive statistics |
Medium |
| 209 |
For u = pd.Series([10, np.nan, 30, 40]), what does u.mean() return? |
Computer Science/Informatics Practices
Descriptive statistics |
Medium |
| 210 |
df = pd.DataFrame({'P': [3, 1], 'Q': [4, 2]}). What does df.max(axis=1) return? |
Computer Science/Informatics Practices
Descriptive statistics |
Hard |
| 211 |
Which method arranges the rows of a DataFrame in order of the values of a column? |
Computer Science/Informatics Practices
Aggregation, grouping and pivoting |
Easy |
| 212 |
In df.groupby('Dept')['Sal'].sum(), what does groupby('Dept') do? |
Computer Science/Informatics Practices
Aggregation, grouping and pivoting |
Easy |
| 213 |
Dept values are HR, IT, HR, IT, Sales with salaries 30, 50, 40, 60, 20. What does df.groupby('Dept')['Sal'].s… |
Computer Science/Informatics Practices
Aggregation, grouping and pivoting |
Medium |
| 214 |
s = pd.Series([1, 2, 3], index=['a', 'b', 'c']). What does s.reindex(['c', 'a', 'z']) contain? |
Computer Science/Informatics Practices
Aggregation, grouping and pivoting |
Medium |
| 215 |
A sales table has columns Year, Item and Qty, and the pair (2020, Pen) appears twice. Which method can reshap… |
Computer Science/Informatics Practices
Aggregation, grouping and pivoting |
Hard |
| 216 |
What does NaN represent in a Pandas DataFrame? |
Computer Science/Informatics Practices
Missing values and MySQL |
Easy |
| 217 |
Which method replaces all missing values in df with 0? |
Computer Science/Informatics Practices
Missing values and MySQL |
Easy |
| 218 |
df has columns A = [1, NaN, 3] and B = [NaN, NaN, 6]. What is the shape of df.dropna()? |
Computer Science/Informatics Practices
Missing values and MySQL |
Medium |
| 219 |
For the same df, what is the shape of df.dropna(how='all')? |
Computer Science/Informatics Practices
Missing values and MySQL |
Medium |
| 220 |
A student wants to add the rows of a DataFrame df to an existing MySQL table result without deleting old rows… |
Computer Science/Informatics Practices
Missing values and MySQL |
Hard |
| 221 |
Which pyplot function draws a pie chart? |
Computer Science/Informatics Practices
Chart types |
Easy |
| 222 |
Which chart is most suitable for showing how a city's monthly temperature changes over a year? |
Computer Science/Informatics Practices
Chart types |
Easy |
| 223 |
A teacher wants to see how the marks of 200 students are distributed across intervals such as 0–10, 10–20 and… |
Computer Science/Informatics Practices
Chart types |
Medium |
| 224 |
Which chart directly displays the minimum, first quartile, median, third quartile and maximum of a data set? |
Computer Science/Informatics Practices
Chart types |
Medium |
| 225 |
How is a frequency polygon related to a histogram? |
Computer Science/Informatics Practices
Chart types |
Hard |
| 226 |
Which function sets the text below the x axis of a plot? |
Computer Science/Informatics Practices
Customising plots |
Easy |
| 227 |
Which function saves the current plot as an image file? |
Computer Science/Informatics Practices
Customising plots |
Easy |
| 228 |
What does plt.plot(x, y, 'r--') draw? |
Computer Science/Informatics Practices
Customising plots |
Medium |
| 229 |
A student writes plt.plot(x, y1, label='2023') and plt.plot(x, y2, label='2024') but no legend appears. What … |
Computer Science/Informatics Practices
Customising plots |
Medium |
| 230 |
A program calls plt.show() and then plt.savefig('chart.png'), and the saved image is blank. What is the most … |
Computer Science/Informatics Practices
Customising plots |
Hard |
| 231 |
Which of the following is an example of an active digital footprint? |
Computer Science/Informatics Practices
Digital footprint and netiquette |
Easy |
| 232 |
The set of good manners and behaviour expected while using the Internet is called |
Computer Science/Informatics Practices
Digital footprint and netiquette |
Easy |
| 233 |
A website records a visitor's pages viewed and location without the visitor typing anything. This data forms … |
Computer Science/Informatics Practices
Digital footprint and netiquette |
Medium |
| 234 |
A person keeps posting provocative comments in a class group to upset others. What is the advice of good neti… |
Computer Science/Informatics Practices
Digital footprint and netiquette |
Medium |
| 235 |
Ananya posts a photo showing her school badge and house number with a public setting. Why is this risky? |
Computer Science/Informatics Practices
Digital footprint and netiquette |
Hard |
| 236 |
Which type of intellectual property protects a company's logo? |
Computer Science/Informatics Practices
Intellectual property |
Easy |
| 237 |
Copying a classmate's essay and submitting it as one's own work is an example of |
Computer Science/Informatics Practices
Intellectual property |
Easy |
| 238 |
Which statement about Free and Open Source Software is correct? |
Computer Science/Informatics Practices
Intellectual property |
Medium |
| 239 |
An image is shared under a CC BY-NC licence. Which use is permitted? |
Computer Science/Informatics Practices
Intellectual property |
Medium |
| 240 |
A developer modifies a GPL-licensed program and distributes the new version. What does the GPL require? |
Computer Science/Informatics Practices
Intellectual property |
Hard |
| 241 |
Which Indian law deals with cybercrime and the legal recognition of electronic records? |
Computer Science/Informatics Practices
Cybercrime and cyber law |
Easy |
| 242 |
Unauthorised access to someone's computer system is called |
Computer Science/Informatics Practices
Cybercrime and cyber law |
Easy |
| 243 |
Ravi receives an email that looks like it is from his bank, asking him to click a link and enter his password… |
Computer Science/Informatics Practices
Cybercrime and cyber law |
Medium |
| 244 |
A student repeatedly receives threatening messages and finds edited photos of herself posted online by classm… |
Computer Science/Informatics Practices
Cybercrime and cyber law |
Medium |
| 245 |
Which is the most appropriate first response for a victim of cyberbullying? |
Computer Science/Informatics Practices
Cybercrime and cyber law |
Hard |
| 246 |
Which of these toxic substances is commonly found in e-waste? |
Computer Science/Informatics Practices
E-waste and health |
Easy |
| 247 |
The science of designing workplaces and equipment to suit the human body is called |
Computer Science/Informatics Practices
E-waste and health |
Easy |
| 248 |
A family has an old but working laptop they no longer need. Which action best follows the "reuse" principle? |
Computer Science/Informatics Practices
E-waste and health |
Medium |
| 249 |
A student who studies on a laptop for hours develops neck pain. Which change is most helpful ergonomically? |
Computer Science/Informatics Practices
E-waste and health |
Medium |
| 250 |
Why is open burning of e-waste to recover metals especially harmful? |
Computer Science/Informatics Practices
E-waste and health |
Hard |