[Text]S8_02_Text_in_pandas_1

Echodot2_Reviews.csv

2.34MB

 

 

 

 

데이터 출처:

https://www.kaggle.com/datasets/PromptCloudHQ/amazon-echo-dot-2-reviews-dataset

 

In [3]:

import pandas as pd
import matplotlib.pyplot as plt
import seaborn as sns

 

In [4]:

echo_df =  pd.read_csv('Echodot2_Reviews.csv', encoding='utf-8')
echo_df.head()

 

Out[4]:

	Rating	Review Date	Configuration Text	Review Text	Review Color	Title	User Verified	Review Useful Count	Declaration Text	Pageurl
0	3	10/3/2017	Echo Dot	Not great speakers	Black	Three Stars	Verified Purchase	NaN	NaN	https://www.amazon.com/All-New-Amazon-Echo-Dot...
1	4	9/26/2017	Echo Dot	Great little gagit	White	Four Stars	Verified Purchase	NaN	NaN	https://www.amazon.com/All-New-Amazon-Echo-Dot...
2	5	9/8/2017	Echo Dot	Awesome 👏🏽	White	Awesome!	Verified Purchase	NaN	NaN	https://www.amazon.com/All-New-Amazon-Echo-Dot...
3	5	10/19/2017	Echo Dot	Love my Echo	Black	Five Stars	Verified Purchase	NaN	NaN	https://www.amazon.com/All-New-Amazon-Echo-Dot...
4	5	9/17/2017	Echo Dot	Great device	Black	Five Stars	Verified Purchase	NaN	NaN	https://www.amazon.com/All-New-Amazon-Echo-Dot...

 

In [5]:

# the length
echo_df['reviews_length'] = echo_df['Review Text'].str.len()
echo_df.head()

 

Out[5]:

	Rating	Review Date	Configuration Text	Review Text	Review Color	Title	User Verified	Review Useful Count	Declaration Text	Pageurl	reviews_length
0	3	10/3/2017	Echo Dot	Not great speakers	Black	Three Stars	Verified Purchase	NaN	NaN	https://www.amazon.com/All-New-Amazon-Echo-Dot...	18.0
1	4	9/26/2017	Echo Dot	Great little gagit	White	Four Stars	Verified Purchase	NaN	NaN	https://www.amazon.com/All-New-Amazon-Echo-Dot...	18.0
2	5	9/8/2017	Echo Dot	Awesome 👏🏽	White	Awesome!	Verified Purchase	NaN	NaN	https://www.amazon.com/All-New-Amazon-Echo-Dot...	10.0
3	5	10/19/2017	Echo Dot	Love my Echo	Black	Five Stars	Verified Purchase	NaN	NaN	https://www.amazon.com/All-New-Amazon-Echo-Dot...	12.0
4	5	9/17/2017	Echo Dot	Great device	Black	Five Stars	Verified Purchase	NaN	NaN	https://www.amazon.com/All-New-Amazon-Echo-Dot...	12.0

 

In [6]:

# the shortest review
min_char = echo_df['reviews_length'].min()
min_char

 

Out[6]:

2.0

 

In [7]:

# the longest review
max_char = echo_df['reviews_length'].max()
max_char

 

Out[7]:

3535.0

 

In [8]:

echo_df[echo_df['reviews_length'] == max_char]

 

Out[8]:

	Rating	Review Date	Configuration Text	Review Text	Review Color	Title	User Verified	Review Useful Count	Declaration Text	Pageurl	reviews_length
2022	5	10/1/2017	Echo Dot	I have never asked my Echo Dot to switch on my...	White	Great value as an internet radio, and for stre...	Verified Purchase	NaN	NaN	https://www.amazon.com/All-New-Amazon-Echo-Dot...	3535.0

 

In [9]:

echo_df[echo_df['reviews_length'] == max_char]['Review Text'].iloc[0]

 

Out[9]:

'I have never asked my Echo Dot to switch on my lights or order me pizza. I can do those things myself. I bought it as an internet radio. I wanted it to replace an Ocean Digital unit that worked, but was awkward to use and kept losing the WiFi signal. I also hoped the Echo would be able to stream Spotify, which the internet radio couldn’t. I chose the Dot rather than the ‘big’ Echo because it seemed pointless spending $179 instead of $49 just to get better sound quality, when I could easily plug in a pair of speakers.At first, the Echo Dot would only send sound to one speaker, so it was retired to a bedroom draw. But when I tried it again a few months later it worked properly (an Alexa update?). And it works really well. Besides the local New York stations, which it gets through iHeart, it has no difficulty streaming domestic stations from the UK, in that case through TuneIn. It even managed to find an obscure community-run station in my home town in England.There is the odd glitch. You need to tell Alexa which station you want very clearly. Also, public radio stations sometimes have a message before the station itself plays, and occasionally those messages can loop, and stop the livestream from loading. And I was unable at first to get BBC World Service, until I remembered that Alexa is only a computer program and needs to be told World Service is a radio station (you ask for World Service Radio). Overall, though, the Echo Dot makes a great little Internet radio. It also has an effective sleep timer, and can wake you up (though not yet with a radio station – but I suspect that will come).The Echo Dot can also stream Spotify, important for me because I have a premium account and am a heavy user. But here Alexa is less effective; you have to ask very clearly for what you want. Also, asking for (say) Beethoven’s Fifth Symphony will only get you the first movement  – if you want the whole thing, you must ask clearly for the album by its full name, or group the tracks under a playlist and ask for that. (That’s often the easiest way, as you can give the playlist a clear, simple name that Alexa can understand.) Just occasionally there are tracks Alexa can’t find at all; ask her for Bob Dylan’s Blind Willie McTell and she will give you one of those two musicians, not the song. I think Amazon has some work to do here. But Spotify does function, and when you do get what you want, the sound quality is excellent. In fact it’s not bad even without external speakers – I sometimes use the Dot ion its own n the kitchen or bathroom, and it’s more than good enough for a small room.I have two reservations. First, I’d like it to be easier to manage my Echo Dot from a proper keyboard; you can, but Amazon don’t seem to like it, preferring you to use an Apple or Android app. But not everyone likes fiddling around on small screens. Second, and more important, if you use an Echo you’re giving Alexa a lot of information about you.  For example, if she knows which radio stations you listen to, she may be able to target you for advertising. Or figure out your politics, and target you for fundraising.  So far as I know Amazon don’t use my Alexa data for this, and I would prefer them not to.Even so, I think the Echo Dot is great value. It does work with Spotify, albeit not perfectly; and as an internet radio it’s first-class, much better value than a dedicated unit, which can cost $120 or more.  And if you use it to work your lights or order your pizza as well, you’ll be getting an awful lot for $49.'