A script analysis
I.Introduction
  1. About the data analysis
  2. Clean data overview
II.Dialogues analysis
  1. The characters who speak the most
III.Words analysis
  1. The data used for the analysis
  2. Wordcloud of every words pronounced
  3. Words pronounced by the characters
  4. Correlation between the characters
  5. Most pronounced words by season
IV.Sentiment analysis
  1. The data used for the analysis
  2. Words connotation
  3. Main characters dialogues
  4. Character comparison dialogues
  5. Sentiment evolution along the series
  6. Sentiment and rating correlation
V.Conclusion
  1. Main observations
Here is a statistical analysis of the script of the series FRIENDS.
First, we cleaned the data and grouped all the files into a single data frame.
Then, using the clean data frame, we conducted an analysis based on the dialogues and the words told during the series.
Finally, we conducted a sentiment analysis, meaning that we assigned a connotation to each word and analysed it relatively to other variables.
| Season | Episode | Title | Character | Dialogue |
|---|---|---|---|---|
| 01 | 01 | The One Where Monica Gets a New Roomate (The Pilot-The Uncut Version) | By | Marta Kauffman & David Crane |
| 01 | 01 | The One Where Monica Gets a New Roomate (The Pilot-The Uncut Version) | Monica | There’s nothing to tell! He’s just some guy I work with! |
| 01 | 01 | The One Where Monica Gets a New Roomate (The Pilot-The Uncut Version) | Joey | C’mon, you’re going out with the guy! There’s gotta be something wrong with him! |
| 01 | 01 | The One Where Monica Gets a New Roomate (The Pilot-The Uncut Version) | Chandler | All right Joey, be nice. So does he have a hump? A hump and a hairpiece? |
| 01 | 01 | The One Where Monica Gets a New Roomate (The Pilot-The Uncut Version) | Phoebe | Wait, does he eat chalk? |
| 01 | 01 | The One Where Monica Gets a New Roomate (The Pilot-The Uncut Version) | Phoebe | Just, ’cause, I don’t want her to go through what I went through with Carl- oh! |
| 01 | 01 | The One Where Monica Gets a New Roomate (The Pilot-The Uncut Version) | Monica | Okay, everybody relax. This is not even a date. It’s just two people going out to dinner and- not having sex. |
| 01 | 01 | The One Where Monica Gets a New Roomate (The Pilot-The Uncut Version) | Chandler | Sounds like a date to me. |
| 01 | 01 | The One Where Monica Gets a New Roomate (The Pilot-The Uncut Version) | Chandler | Alright, so I’m back in high school, I’m standing in the middle of the cafeteria, and I realize I am totally naked. |
| 01 | 01 | The One Where Monica Gets a New Roomate (The Pilot-The Uncut Version) | All | Oh, yeah. Had that dream. |
| Season | Character | word | n |
|---|---|---|---|
| 08 | Rachel | ross | 102 |
| 07 | Rachel | joey | 96 |
| 07 | Chandler | monica | 95 |
| 08 | Rachel | don | 95 |
| 06 | Rachel | ross | 94 |
| 03 | Rachel | ross | 91 |
| 05 | Rachel | y’know | 87 |
| 10 | Rachel | ross | 85 |
| 05 | Joey | ross | 84 |
| 08 | Rachel | joey | 82 |
| word | sentiment_score | Season | Episode | Title | Character | value |
|---|---|---|---|---|---|---|
| abandon | -2 | 05 | 02 | The One With All The Kissing | Ross | -2 |
| abandoned | -14 | 02 | 03 | The One Where Mr. Heckles Dies | Phoebe | -2 |
| abandoned | -14 | 03 | 14 | The One With Phoebe’s Ex-Partner | Phoebe | -2 |
| abandoned | -14 | 05 | 02 | The One With All The Kissing | Monica | -2 |
| abandoned | -14 | 05 | 02 | The One With All The Kissing | Rachel | -2 |
| abandoned | -14 | 05 | 08 | The One With The Thanksgiving Flashbacks | Chandler | -2 |
| abandoned | -14 | 05 | 13 | The One With Joey’s Bag | Phoebe | -2 |
| abandoned | -14 | 05 | 13 | The One With Joey’s Bag | Ross | -2 |
| ability | 8 | 03 | 10 | The One Where Rachel Quits | Monica | 2 |
| ability | 8 | 03 | 23 | The One With Ross’s Thing | Phoebe | 2 |
