All our Data Science projects include bite-sized activities to test your knowledge and practice in an environment with constant feedback.
All our activities include solutions with explanations on how they work and why we chose them.
Remove the column labeled Unnamed: 0
from the dataframe df
as it does not contain any meaningful information related to mobile phone specifications or prices.
This is how your result will look like:
Renamed the column Brand me
to Model Name
to clarify the data it represents within the dataset.
This is how your result will look like:
Eliminate duplicate entries from the dataframe df
to ensure each record is unique and maintain data consistency.
This is how your result will look like:
Remove all null values from the dataframe df
to uphold data integrity.
This is how your result will look like:
Filter out ratings less than 1
and ratings equal to #FIELD!
.
This is how your result will look like:
Remove the GB
from the RAM
and ROM
columns (do not forget to remove the trailing whitespace).
This is how your result will look like:
This is how your result will look like:
This is how your result will look like:
This is how your result will look like:
Do not forget to remove the trailing whitespace.
This is how your result will look like:
Remove MP
from Primary_Cam
column (do not forget to remove the trailing whitespace) then convert it from object
to integer
.
This is how your result will look like:
Remove MP
from Selfi_Cam
column (do not forget to remove the trailing whitespace) then convert it from object
to integer
. Remember to first convert it to float
and then to int
.
This is how your result will look like:
Remove mAh
from Battery_Power
column (do not forget to remove the trailing whitespace).
This is how your result will look like:
Remove the underscore that are present in few records of Battery_Power
column and then convert it to integer
.
This is how your result will look like:
Remove values in the Battery_Power
column that are less than or equal to zero
and greater than 6000
.
This is how your result will look like:
Remove the Rs.
prefix from the Price
column (do not forget to remove the trailing whitespace), then eliminate any underscores present in the data, and finally convert it into numerical format from object.
This is how your result will look like:
Exclude all records with prices less than or equal to zero
and greater than 140300
.
This is how your result will look like:
Removing any text enclosed within parentheses, including the parentheses themselves.
This is how your result will look like: