Python – Replace Null or Blank values with NaN

Python – Replace Null or Blank values with NaN

I’m trying to study for my Programming course and I need some help to understand this question.

You are working as an Analytics Engineer for one of the book retail website. You need to identify best selling books based on the data. You have received the data in Excel file. You need to sort the result based on the best-selling book. You need to display following information on the website.

1. Brand
2. Name
3. List_Price
4. Model

Use the attached file- paytm_com-ecommerce_sample.csv file.

A brand column in the CSV file has various Null or Blank rows. These need to be replaced.

Directions:

1. Use Pandas to read the csv file
2. Analyze the Brand data column
3. Replace Null or Blank value with NaN.
4. Filter out NaN values from the current file and write it into another file.
5. Your python script should generate two files.
   1. File without any NaN value in Brand column
   2. File with NaN value in Brand column

Submission:

• Python Script
• Two files – one file without any NaN value in Brand column; One file with NaN value in Brand column
• Output Screenshot

"96% of our customers have reported a 90% and above score. You might want to place an order with us."