Question
Questions is regarding cleaning values in columns of pandas Dataframe. Assuming given the following dataset stored in an Python/dataframe object, write Python code snippets to
Questions is regarding cleaning values in columns of pandas Dataframe.
Assuming given the following dataset stored in an Python/dataframe object, write Python code snippets to clean this dataframe object according to the following constraints.
Columns: INVOICE, ZIP, VENDOR, SELLER_STATUS, DATE_MONTH
1) Requirement: INVOICE values can be composed of only characters
2) Requirement: address ZIP values can be composed of only digits
3) Requirement: VENDOR values can be only any of the following values (V_A, V_B, V_C)
4) Requirement: SELLER_STATUS values can be any of the following values (ACTIVE, INACTIVE, SOLD_OUT)
5) Requirement: DATE_MONTH values can be composed of only digits
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started