Reshaping and Pivot Tables

Question 1

Data is often stored in _____ or _____ format?

Answer 1

stacked or record format

Question 2

if the value arguement is omitted , and the input dataframe has more than one column of values which are not used as column or index inputs to pivot(), then the resulting dataframe will have a ________

Answer 2

Hierarchical columns

Question 3

can you select subsets of a pivoted dataframe?

Answer 3

yes

Question 4

What will happen if the index and column pair is not …..?

Answer 4

unique

Question 5

what are the two methods that are closely related to pivot() method?

Answer 5

stack() and unstack()

Question 6

What is the first arg of the method .pivot()?

Answer 6

index=

Question 7

what type of input does the index parameter take ?

Answer 7

str or object or list

Question 8

what is the second parameter of the method .pivot()?

Answer 8

—> column=

Question 9

what are the acceptable inputs of the parameter column?

Answer 9

str or object or list

Question 10

what is the third parameter of the method .pivot()?

Answer 10

—– values=

Question 11

what is are the acceptable inputs of the parameter values?

Answer 11

str, object, or list

it is optional

Question 12

what does the method .pivot() return?

Answer 12

a reshaped data frame

Question 13

If I want to input multiple values into a parameter in .pivot() what do they need to be surrounded by?

Answer 13

[ ]

Question 14

Define what the .pivot() method does to a dataframe?

Answer 14

Reshapes the data based on column values.