Guided Project 1: Deleting Wrong Data Google Play Store Data Set Row 10742

Hello All!
I followed the links to the Kaggle Discussion about row 10742 in the Google Play Store Data Set.
I ran the code and I did not get same info. The row was correct, but the data set did not contain errors. Row 10474 actually contains the incorrect info with a rating of 19. I also made sure to download the data set and review it. My only recourse is to proceed with deleting row 10474 and move on with the projuect. Does anyone have any other suggestions? I have pasted the images of row 10742 and 10474.

Screen Link: <!-- https://app.dataquest.io/m/350/guided-project%3A-profitable-app-profiles-for-the-app-store-and-google-play-markets/3/deleting-wrong-data>

My Code:

print(android[10742]) # incorrect row
print('\n')
print(android_header) # header
print('\n')
print(android[0]) # a correct row

What I expected to happen:

[‘Life Made WI-Fi Touchscreen Photo Frame’, ‘1.9’, ‘19’, ‘3.0M’, ‘1,000+’, ‘Free’, ‘0’, ‘Everyone’, ‘’, ‘February 11, 2018’, ‘1.0.19’, ‘4.0 and up’]

[‘App’, ‘Category’, ‘Rating’, ‘Reviews’, ‘Size’, ‘Installs’, ‘Type’, ‘Price’, ‘Content Rating’, ‘Genres’, ‘Last Updated’, ‘Current Ver’, ‘Android Ver’]

[‘Photo Editor & Candy Camera & Grid & ScrapBook’, ‘ART_AND_DESIGN’, ‘4.1’, ‘159’, ‘19M’, ‘10,000+’, ‘Free’, ‘0’, ‘Everyone’, ‘Art & Design’, ‘January 7, 2018’, ‘1.0.0’, ‘4.0.3 and up’]

What actually happened:

'GKPB FP Online Church', 'LIFESTYLE', '5.0', '32', '7.9M', '1,000+', 'Free', '0', 'Everyone', 'Lifestyle', 'December 31, 2017', '0.7.1', '4.4 and up']


['App', 'Category', 'Rating', 'Reviews', 'Size', 'Installs', 'Type', 'Price', 'Content Rating', 'Genres', 'Last Updated', 'Current Ver', 'Android Ver']


['Photo Editor & Candy Camera & Grid & ScrapBook', 'ART_AND_DESIGN', '4.1', '159', '19M', '10,000+', 'Free', '0', 'Everyone', 'Art & Design', 'January 7, 2018', '1.0.0', '4.0.3 and up']

Hey @Koala007,

Error is in row no 10473 (if you are including header in the dataset), and if you have excluded the header from the dataset, error is in row no 10472.

If you see the screenshot, which i have taken from your notebook. Row no. 10473 has a problem (with header included in the dataset)
Exclude the header and you will see error in 10472. Try this.

thanks.

@rksiiita Thanks! Got it!

1 Like