Membership Constraints

Question 1

What is the set()?

Answer 1

are used to store multiple items in a single variable.

stores its unique values

Question 2

What is Anti-Join?

Answer 2

take in two DataFrames A and B, and return data from one DataFrame that is not contained in another. we are performing a left anti join of A and B, and are returning the columns of DataFrames A and B for values only found in A of the common column between them being joined on.

Question 3

What is Inner Join?

Answer 3

return only the data that is contained in both DataFrames. For example, an inner join of A and B, would return columns from both DataFrames for values only found in A and B, of the common column between them being joined on.

Question 4

How do you find inconsistent categories?

Answer 4

You do set to find the unique values

inconsistent_catergories= set(dataframe[column]).difference(categories[column])

Question 5

What is the difference()?

Answer 5

the method returns a set that contains the difference between two sets.

Question 6

How do you find inconsistent rows?

Answer 6

inconsistent_rows= dataframe.[column].isin(inconsistent_categories)

subset data:

inconsistent_data= dateframe[inconsistent_rows]

Question 7

What is the isin() method?

Answer 7

a method is used to filter data frames. isin() method helps in selecting rows with having a particular(or Multiple) value in a particular column

Question 8

How do you drop inconsistent rows?

Answer 8

consistent_data= dataframe[~inconsistent_rows]

Question 9

What is member constraint?

Answer 9

a membership constraint is when a categorical column has values that are not in the predefined set of categories of your column.