Question Bank: Data Handling using Pandas - I

What is a Python library?

Which of the following libraries is primarily used for data manipulation in Python?

Which library would you use for creating visualizations in Python?

What does NumPy stand for?

Which of the following is NOT a feature of Python libraries?

How can you import a library in Python?

What is the primary use of the Pandas library?

In Pandas, which data structure is used to store one-dimensional data?

What module is commonly imported alongside Pandas for numerical operations?

When would you choose to use Matplotlib over Pandas?

What command allows you to read a CSV file into a Pandas DataFrame?

Which command would you use to output a DataFrame to a CSV file?

Which of the following is a key advantage of using libraries like NumPy and Pandas?

In the context of data handling, what does 'manipulation' typically refer to?

What is a common misconception about the use of libraries in Python?

Which command is used to install the Pandas library?

What prerequisite must be fulfilled before installing Pandas?

What does the command 'pip install pandas' do?

Where is the Pandas library primarily used?

Which of the following is not a data structure in Pandas?

To check if Pandas has been installed successfully, what command should you use in Python?

Which command would you run to upgrade Pandas to the latest version?

What will happen if you run 'pip install pandas' when it is already installed?

Why is it essential to install libraries like Pandas?

How do you import the Pandas library in Python?

What is a common mistake when installing Pandas?

Which file types can you handle using Pandas after installation?

What is a key benefit of using Pandas over basic Python data structures?

Why is it important to know how to install Pandas in a data analysis workflow?

What command can be used to list all installed packages including Pandas?

What is the primary method to create an empty DataFrame in Pandas?

Which method is used to add a new column to an existing DataFrame?

To remove a column from a DataFrame named 'df', which syntax is correct?

If you want to drop multiple columns at once, what is the appropriate command?

When adding a new row to a DataFrame, which method is typically used?

What will happen if you use df.drop(['A'], axis=1) on a DataFrame that does not contain column 'A'?

Consider the DataFrame after the command ResultDF['Preeti']=[89,78,76]. What will result if it is executed on an incompatible length?

What is the default index type for a new DataFrame created in Pandas?

If you have a DataFrame 'df' with 5 rows and you execute df.drop([0, 1]) what will be the index of the resulting DataFrame?

What happens when you try to set a new index to a DataFrame with duplicate values?

In Pandas, which method can be used to check the size of a DataFrame?

When concatenating two DataFrames 'df1' and 'df2', which parameter represents the axis along which they are concatenated?

Which method allows you to filter rows in a DataFrame based on certain conditions?

What is a Series in Pandas?

Which method is used to create a Series from scalar values?

What index does Pandas use if none is specified during Series creation?

How can you access the second item in a Series named 'data'?

What is the output type of a Series containing mixed data types?

If you create a Series with the index ['A', 'B', 'C'] and values [1, 2, 3], how would you access value '2'?

What is the primary benefit of using labels as indices in a Series?

What is the output of 'pd.Series([5, 10, 15])'?

What will 'pd.Series([1, 2, 3], index=[0, 1, 2])' output?

Which of the following statements about Series is NOT true?

When specifying an index with non-numeric values such as ['Feb', 'Mar', 'Apr'], what behavior can we expect?

In Pandas, how can a Series containing values [4, 5, 6] and an index of ['A', 'B', 'C'] be created?

Which of the following methods can be used to get the index of a Series?

If a Series is created as 'pd.Series([1, 2, 3], index=[0, 1, 2])', what value would 'series[1]' return?

Which of these statements accurately reflects the versatility of Series in Pandas?

Which Pandas function is used to read a CSV file into a DataFrame?

What will pd.read_csv('data.csv') do if the file 'data.csv' does not exist?

If you want to skip the first row of a CSV file while reading it into a DataFrame, which parameter should you use?

When exporting a DataFrame to a CSV file using to_csv(), what happens if you set the index parameter to False?

How can you load a CSV file and set custom column names using Pandas?

Which command would you use to write a DataFrame named 'dataFrame' to 'output.csv'?

If you don't specify any parameters in read_csv(), which row will be used as headers by default?

What will be the output of marks.empty if marks is a DataFrame loaded successfully with data?

If you need to remove a specific column from a DataFrame before exporting, which function should you use?

What type of data structure does pd.read_csv() return?

Which import statement is correct to begin using Pandas in a Python program?

Which parameter in read_csv() helps to specify the delimiter of the data in the file?

When creating a DataFrame from a CSV file, what is the effect of setting the parameter header=1?

Which common error might occur when reading a CSV file with inconsistent row lengths?

What is the output of the following code? `pd.Series([1, 2, 3, 4], index=['a', 'b', 'c', 'd'])`

Which method would you use to check if a Pandas Series is empty?

If you have the following series: `s = pd.Series([10, 20, 30], index=['x', 'y', 'z'])`, what will `s['y']` return?

What happens when you assign a new value using slicing in a Series?

Which of the following will correctly create a Series with a custom index?

In the code `s = pd.Series([1, 2, 3]); s.name = 'MySeries'`, what is the purpose of `s.name`?

How can you retrieve the index values of a Pandas Series?

What will be the result of executing `pd.Series([5, 6, 7], index=['a', 'b', 'a'])`?

If you use `pd.Series({'p': 5, 'q': 10})`, what will be the output if you access `s['p']`?

How would you find the number of elements in a given Pandas Series?

If you have a Series `s = pd.Series([1, 2, 3], index=['a', 'b', 'c'])`, what will `s['a':'b']` return?

How do you change the index name of a Pandas Series?

In Pandas, which attribute returns the actual values stored in the Series?

In which scenario would accessing a DataFrame column return a Series?

What attribute would you use to count non-null values in a Series?

What will `s = pd.Series([None, None]).empty` return?

What type of index can be used in a Pandas Series?

How does Pandas handle operations with unaligned Series?

What is the primary advantage of using indexed data in a Pandas Series?

Which of the following statements about NumPy ndarray is correct?

Which data structure requires more memory, Pandas Series or NumPy ndarray?

When slicing a Pandas Series with positional indices, what happens at the end index?

In which situation does Pandas Series automatically perform alignment?

What will occur if you try to perform operations on two unaligned Pandas Series without handling the missing labels?

Why might a programmer choose to use Pandas over NumPy?

Which of the following is NOT an advantage of using Pandas over NumPy?

How does the memory usage of Pandas Series compare to NumPy ndarray?

What type of computations can be performed automatically aligned in Pandas Series?

What does the read_csv() function in Pandas do?

Which of the following operations is not directly supported by NumPy?