{ "cells": [ { "cell_type": "markdown", "metadata": {}, "source": [ "# Insights\n", "\n", "From [ESS](http://www.europeansocialsurvey.org/downloadwizard/) I obtained the CSV that contains the following columns:\n", "- `netustm`\n", "- `gndr`\n", "- `agea`\n", "\n", "I will explore this data and provide some insights on the usage habbits of the net depending on age and country." ] }, { "cell_type": "code", "execution_count": 1, "metadata": {}, "outputs": [ { "data": { "text/html": [ " \n", " " ] }, "metadata": {}, "output_type": "display_data" } ], "source": [ "import pandas as pd\n", "import plotly.express as px\n", "import plotly.graph_objects as go\n", "from plotly.subplots import make_subplots\n", "from plotly.offline import init_notebook_mode\n", "from plotly.colors import n_colors\n", "\n", "pd.options.plotting.backend = \"plotly\"\n", "import plotly.io as pio\n", "init_notebook_mode()" ] }, { "cell_type": "code", "execution_count": 2, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", " | cntry | \n", "cname | \n", "cedition | \n", "cproddat | \n", "cseqno | \n", "name | \n", "essround | \n", "edition | \n", "idno | \n", "dweight | \n", "pspwght | \n", "pweight | \n", "anweight | \n", "netustm | \n", "gndr | \n", "agea | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "AT | \n", "ESS1-9e01 | \n", "1.0 | \n", "10.12.2020 | \n", "1 | \n", "ESS1e06_6 | \n", "1 | \n", "6.6 | \n", "1 | \n", "0.945200 | \n", "0.940933 | \n", "0.271488 | \n", "0.255452 | \n", "NaN | \n", "1 | \n", "54 | \n", "
1 | \n", "AT | \n", "ESS1-9e01 | \n", "1.0 | \n", "10.12.2020 | \n", "2 | \n", "ESS1e06_6 | \n", "1 | \n", "6.6 | \n", "2 | \n", "0.472600 | \n", "0.470466 | \n", "0.271488 | \n", "0.127726 | \n", "NaN | \n", "1 | \n", "50 | \n", "
2 | \n", "AT | \n", "ESS1-9e01 | \n", "1.0 | \n", "10.12.2020 | \n", "3 | \n", "ESS1e06_6 | \n", "1 | \n", "6.6 | \n", "3 | \n", "0.945200 | \n", "1.392155 | \n", "0.271488 | \n", "0.377953 | \n", "NaN | \n", "2 | \n", "63 | \n", "
3 | \n", "AT | \n", "ESS1-9e01 | \n", "1.0 | \n", "10.12.2020 | \n", "4 | \n", "ESS1e06_6 | \n", "1 | \n", "6.6 | \n", "4 | \n", "0.945200 | \n", "1.382163 | \n", "0.271488 | \n", "0.375240 | \n", "NaN | \n", "1 | \n", "44 | \n", "
4 | \n", "AT | \n", "ESS1-9e01 | \n", "1.0 | \n", "10.12.2020 | \n", "5 | \n", "ESS1e06_6 | \n", "1 | \n", "6.6 | \n", "6 | \n", "1.890500 | \n", "1.437766 | \n", "0.271488 | \n", "0.390336 | \n", "NaN | \n", "2 | \n", "41 | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
106673 | \n", "IL | \n", "ESS1-9e01 | \n", "1.0 | \n", "10.12.2020 | \n", "268361 | \n", "ESS8e02_2 | \n", "8 | \n", "2.2 | \n", "8021 | \n", "1.118244 | \n", "0.682302 | \n", "0.239750 | \n", "0.163582 | \n", "6666.0 | \n", "2 | \n", "65 | \n", "
106674 | \n", "IL | \n", "ESS1-9e01 | \n", "1.0 | \n", "10.12.2020 | \n", "268362 | \n", "ESS8e02_2 | \n", "8 | \n", "2.2 | \n", "8022 | \n", "1.961206 | \n", "2.062875 | \n", "0.239750 | \n", "0.494574 | \n", "6666.0 | \n", "2 | \n", "70 | \n", "
106675 | \n", "IL | \n", "ESS1-9e01 | \n", "1.0 | \n", "10.12.2020 | \n", "268363 | \n", "ESS8e02_2 | \n", "8 | \n", "2.2 | \n", "8023 | \n", "0.559122 | \n", "0.341151 | \n", "0.239750 | \n", "0.081791 | \n", "120.0 | \n", "2 | \n", "65 | \n", "
106676 | \n", "IL | \n", "ESS1-9e01 | \n", "1.0 | \n", "10.12.2020 | \n", "268364 | \n", "ESS8e02_2 | \n", "8 | \n", "2.2 | \n", "8024 | \n", "1.118244 | \n", "0.682302 | \n", "0.239750 | \n", "0.163582 | \n", "6666.0 | \n", "2 | \n", "79 | \n", "
106677 | \n", "IL | \n", "ESS1-9e01 | \n", "1.0 | \n", "10.12.2020 | \n", "268365 | \n", "ESS8e02_2 | \n", "8 | \n", "2.2 | \n", "8025 | \n", "1.118244 | \n", "0.682302 | \n", "0.239750 | \n", "0.163582 | \n", "300.0 | \n", "2 | \n", "59 | \n", "
106678 rows × 16 columns
\n", "\n", " | agea | \n", "netustm | \n", "cntry | \n", "netustm_hr | \n", "age_group | \n", "
---|---|---|---|---|---|
8713 | \n", "34 | \n", "180.0 | \n", "AT | \n", "3.0 | \n", "30th | \n", "
8714 | \n", "52 | \n", "120.0 | \n", "AT | \n", "2.0 | \n", "50th | \n", "
8716 | \n", "54 | \n", "120.0 | \n", "AT | \n", "2.0 | \n", "50th | \n", "
8717 | \n", "20 | \n", "180.0 | \n", "AT | \n", "3.0 | \n", "19- | \n", "
8718 | \n", "65 | \n", "120.0 | \n", "AT | \n", "2.0 | \n", "60th | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
106669 | \n", "45 | \n", "30.0 | \n", "IL | \n", "0.5 | \n", "40th | \n", "
106670 | \n", "55 | \n", "30.0 | \n", "IL | \n", "0.5 | \n", "50th | \n", "
106672 | \n", "49 | \n", "60.0 | \n", "IL | \n", "1.0 | \n", "40th | \n", "
106675 | \n", "65 | \n", "120.0 | \n", "IL | \n", "2.0 | \n", "60th | \n", "
106677 | \n", "59 | \n", "300.0 | \n", "IL | \n", "5.0 | \n", "50th | \n", "
17473 rows × 5 columns
\n", "