Informatics Practices
Fill in the Blank
Boolean indexing in Pandas DataFrame can be used for ……………
- Creating a new DataFrame
- Sorting data based on index labels
- Joining data using labels
- Filtering data based on condition
Related Questions
While creating a Series using a dictionary, the keys of the dictionary become:
- Values of the Series
- Indices of the Series
- Data type of the Series
- Name of the Series
Match the following SQL functions/clauses with their descriptions:
SQL Function Description P. MAX() 1. Find the position of a substring in a string. Q. SUBSTRING() 2. Returns the maximum value in a column. R. INSTR() 3. Sorts the data based on a column. S. ORDER BY 4. Extracts a portion of a string. - P-2, Q-4, R-3, S-1
- P-2, Q-4, R-1, S-3
- P-4, Q-3, R-2, S-1
- P-4, Q-2, R-1, S-3
Which Matplotlib plot is best suited to represent changes in data over time?
- Bar plot
- Histogram
- Line plot
- Histogram & Bar plot
Which type of network covers a small geographical area like a single office, building, or school campus?
- PAN
- MAN
- LAN
- WAN