getting insights from data challenge

import pandas as pd

df = pd.read_csv('dna.csv')

df.head(2)

indexint64

productobject

0

Apple iPhone XR (64GB) - Black

1

Apple iPhone XR (64GB) - Black

select * from df limit 8

indexint64

productobject

4

Apple iPhone XR (64GB) - Black

0

Apple iPhone XR (64GB) - Black

5

Apple iPhone XR (64GB) - Black

1

Apple iPhone XR (64GB) - Black

6

Apple iPhone XR (64GB) - Black

7

Apple iPhone XR (64GB) - Black

2

Apple iPhone XR (64GB) - Black

3

Apple iPhone XR (64GB) - Black

select review_country, count(total_comments) from df group by 1 order by 2 desc

review_countryobject

count(total_comments)int64

0

India

5010

select count(distinct product) from df

count(DISTINCT product)int64

0

1

select review_rating, count(*) from df group by 1 order by 2 desc

review_ratingobject

count_star()int64

0

5.0 out of 5 stars

3731

1

4.0 out of 5 stars

720

2

1.0 out of 5 stars

319

3

3.0 out of 5 stars

153

4

2.0 out of 5 stars

87

select round(avg(case when review_rating= '5.0 out of 5 stars' then 1 else 0 end), 2) AS high_review from df

high_reviewfloat64

0

0.74

select round(avg(case when review_rating= '5.0 out of 5 stars' then 5 when review_rating= '4.0 out of 5 stars' then 4 when review_rating= '3.0 out of 5 stars' then 3 when review_rating= '2.0 out of 5 stars' then 2 when review_rating= '1.0 out of 5 stars' then 1 end), 1) from df

round(avg(CASE WHEN ((review_rating = '5.0 out of 5 stars')) THEN (5) WHEN ((review_rating = '4.0 out of 5 stars')) THEN (4) WHEN ((review_rating = '3.0 out of 5 stars')) THEN (3) WHEN ((review_rating = '2.0 out of 5 stars')) THEN (2) WHEN ((review_rating = '1.0 out of 5 stars')) THEN (1) ELSE NULL END), 1)float64

0

4.5

select helpful_count, review_title, review_text from df where helpful_count like '5,___ people found this helpful'

helpful_countobject

review_titleobject

0

5,087 people found this helpful

Which iPhone you should Purchase ? iPhone 8, X, XS, XR ?

1

5,087 people found this helpful

Which iPhone you should Purchase ? iPhone 8, X, XS, XR ?

select review_text from df where review_text like '%expensive%'

review_textobject

Face recognition is slower some times. I have no complaints about it. I am die hard fan of XR. I was eagerly waiting for dual sim iPhone. It’s heavy but looks are so attractive that you will be ready to carry that little extra weight. I am using it since two months. Don’t watch any reviews. Just buy it and enjoy. Yes it’s expensive. Sometimes rather many times money is not worth than happiness.5.3%

I’ve been using Android for close to a decade and now decided to check out iOS. Thanks to Amazon Prime Sale, got iPhone XR for a discounted price(Still expensive), Coming to the iPhone itself, after using phone for 3 days, below are the points I came across.5.3%

17 others89.5%

0

Face recognition is slower some times. I have no complaints about it. I am die hard fan of XR. I was eagerly waiting for dual sim iPhone. It’s heavy but looks are so attractive that you will be ready to carry that little extra weight. I am using it since two months. Don’t watch any reviews. Just buy it and enjoy. Yes it’s expensive. Sometimes rather many times money is not worth than happiness.

1

I’ve been using Android for close to a decade and now decided to check out iOS. Thanks to Amazon Prime Sale, got iPhone XR for a discounted price(Still expensive), Coming to the iPhone itself, after using phone for 3 days, below are the points I came across.

2

In my initial review, I said that the iPhone XR was the best iPhone for most people right, and my thoughts about it haven't changed six months later. This is still the best iPhone in the market, offering the same smooth and terrific user experience as the more expensive iPhone XS and XS Max, but with the knowledge that you're also getting the best battery life. In fact, the battery life is at par, if not better, to what the P30 Pro and the Galaxy S10+ offer and that's saying something.

3

Easy to use, serves the purpose. I was an android guy for like last 7 years before that was using blackberry in between switched to ios as i used iphone 5c but at that time i was a bit disappointed may be because quite young i was and a bit techie but now i use my phone for basic purposes like calls, whats app, email, social media n bit gaming n music so it really handles that well though i was a bit hesitant at first as i was used to of finger touch sensor but seriously face recognition is damn good it works like a charm even when there is no light, so if you want no nonsense stuff n if it suits your requirements then go for it as now a days even droids are equally expensive in-fact some are more expensive like fold, razr etc. so just listen to your heart and buy ios or android and you wont go wrong, though i got mine in an offer for ₹43000 for 128 GB variant

4

I still don’t understand why people are crazy about iPhone. I bough this phone for 42k in great Indian sale couldn’t find much difference so for. It’s been a week now. My old android is doing all the operation faster then this which detected my face quickly. And that has fingerprint support also. I am also crazy about this phone. My friend told that he will never go back to android again. That’s the one reason for me to buy this phone. Let me wait for one more month to become addicted. Till then I’ll leave the rating to 4*. When you think that this phone is expensive, that’s proving that this phone is for royal customers :p. Go for it if you are affordable.

5

This is my third iPhone and I must say - each time Apple introduces an iPhone, they improve a lot in each model. iPhone XR is one of best selling iPhone for year 2018. Its not that cheap but still standout in crowd. Its not expensive than iPhone XS but still have all the features same as other top models- only difference is OLED screen but I can live with that. Recently introduced iPhone 11 and XR have only one difference which is of Price. Most of the features are exactly same. Best Battery backup ever in an iPhone I must say. Soothing and flawless iOS. Camera is more than average and very much improved as compared to previous generations. Glass frame back and front and very appealing to eyes. Overall, a satisfactory experience with this device. A must buy if are considering iPhone 11 but have low budget.

6

Display 3.7/5 — but u will get use too it not too bad better than expensive android phones (DONT BUY IF DISPLAY IS YOUR PRIORITY)

7

Happy with the phone, initially I was scared to buy as it is expensive, and reviews were making me go on doubt, but the product came in a good condition,phone is superb. Thank you amazon for fast reliable service

8

Not a value for money product.Apple is still giving 1amp charger with such expensive phone with almost 3000 mAh battery. The same charger is also given along with 5s and also SE.

9

This phone is kind of the best iPhone in terms of value of money. The only thing you will miss is the oled display which is on the expensive iPhones but only when you compare them side by side. Got the 128gb @50k so pretty good.