Question

The way a dataset is arranged into rows and columns is referred to as the shape of data. Following function is used to reshape and create a new DataFrame from the original one:

• A. dropna()
• B. pivot()
• C. sort()
• D. merge()
  \textbf{Correct Answer:} (2) pivot()

Hint:

The `pivot()` function is particularly useful when you need to rearrange the dataset based on the values in a column and turn those values into separate columns.

Answer 1

The Correct Option is B

In pandas, the `pivot()` function is used to reshape the DataFrame. It allows you to turn unique values from one column into multiple columns in the new DataFrame. Other options such as `dropna()`, `sort()`, and `merge()` serve different purposes (dropping missing values, sorting, and merging datasets, respectively), but they do not reshape the data as `pivot()` does.
Therefore, the correct answer is "pivot()".