Removing Duplicate Entries: Part Two Error

Q&A DQ Courses
#1

Hello,
I’m a beginner and trying to understand Removing Duplicate Entries Part Two section.
Here’s the code below:

reviews_max = {}

for app in android:
    name = app[0]
    n_reviews = float(app[3])
    
    if name in reviews_max and reviews_max[name] < n_reviews:
        reviews_max[name] = n_reviews
        
    elif name not in reviews_max:
        reviews_max[name] = n_reviews

And when I try to execute, it gives this error:

ValueError Traceback (most recent call last)
in
3 for app in android:
4 name = app[0]
----> 5 n_reviews = float(app[3])
6
7 if name in reviews_max and reviews_max[name] < n_reviews:

ValueError: could not convert string to float: ‘3.0M’

Can anyone help?

#2

Hi @ozanbskya, welcome to the community!

I found a post where another community member had the same issue. It usually stems from an error in one of the rows of the dataset.