{ "cells": [ { "cell_type": "markdown", "metadata": {}, "source": [ "## Exercise 1: Eurovision Song Lyrics Analysis\n", "\n", "In this exercise, we will analyze the lyrics of the songs that participated in the Eurovision Song Contest from 1956 to 2023.\n", "\n", "Let's first have look at the data:" ] }, { "cell_type": "code", "execution_count": 121, "metadata": {}, "outputs": [], "source": [ "import pandas as pd\n", "\n", "dataset_df = pd.read_csv('eurovision_lyrics.csv')" ] }, { "cell_type": "code", "execution_count": 122, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", " | host_city | \n", "lyrics | \n", "artist | \n", "language | \n", "country | \n", "eurovision_number | \n", "year | \n", "title | \n", "lyrics_english | \n", "host_country | \n", "
---|---|---|---|---|---|---|---|---|---|---|
1716 | \n", "Liverpool | \n", "YA EA EA YA EA EA (Ole!) Ay ven a mí niño mío.... | \n", "Blanca Paloma | \n", "Spanish | \n", "Spain | \n", "67 | \n", "2023 | \n", "Eaea | \n", "Ya ea Ya ea (Ole!) Oh, come to me, child of mi... | \n", "United Kingdom | \n", "
1717 | \n", "Liverpool | \n", "I don't wanna go But baby we both know This is... | \n", "Loreen | \n", "English | \n", "Sweden | \n", "67 | \n", "2023 | \n", "Tattoo | \n", "I don't wanna go But baby we both know This is... | \n", "United Kingdom | \n", "
1718 | \n", "Liverpool | \n", "When we were boys We played pretend Army tanks... | \n", "Remo Forrer | \n", "English | \n", "Switzerland | \n", "67 | \n", "2023 | \n", "Watergun | \n", "When we were boys We played pretend Army tanks... | \n", "United Kingdom | \n", "
1719 | \n", "Liverpool | \n", "Sometimes gotta let it go Sometimes gotta look... | \n", "TVORCHI | \n", "English/Ukrainian | \n", "Ukraine | \n", "67 | \n", "2023 | \n", "Heart Of Steel | \n", "Sometimes gotta let it go Sometimes gotta look... | \n", "United Kingdom | \n", "
1720 | \n", "Liverpool | \n", "When you said you were leavin' To work on your... | \n", "Mae Muller | \n", "English | \n", "United Kingdom | \n", "67 | \n", "2023 | \n", "I Wrote A Song | \n", "When you said you were leavin' To work on your... | \n", "United Kingdom | \n", "
\\n\"+\n \"BokehJS does not appear to have successfully loaded. If loading BokehJS from CDN, this \\n\"+\n \"may be due to a slow or bad network connection. Possible fixes:\\n\"+\n \"
\\n\"+\n \"\\n\"+\n \"from bokeh.resources import INLINE\\n\"+\n \"output_notebook(resources=INLINE)\\n\"+\n \"
\\n\"+\n \"