Spending_Based_On_Personality.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Spending money based on personality"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "I have recentlly read an article titled [Money Buys Happiness When Spending Fits Our Personality](https://doi.org/10.1177/0956797616635200). Unlike most of the material, that I read so far, this one showed, that maybe spending money can make us more happy, if we spend it in the right way. For example, for an extroverted person, going for the drink in a pub would make them happier, while it would not make introverts happier. The reverse is true for buying books: making introverts happier and extroverts less happier. "
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "So here I have included the analysis, that can help a person decide, where to spend their money. "
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Importing Libaries"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas\n",
    "import os"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Data"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Here we are adding the person't personality, that we are researching. If you don't know your personality scores, then you either need to take a test (like [https://sapa-project.org/](https://sapa-project.org/)) or do analysis based on you data (like [https://personality-insights-livedemo.mybluemix.net/](https://personality-insights-livedemo.mybluemix.net/)). The later one can also be used for other people. "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "e = 14 #Extraversion\n",
    "n = 38 #Neuroticism\n",
    "a = 38 #Agreeableness\n",
    "c = 31 #Conscientiousness\n",
    "o = 69 #Openness"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "And here I am importing the table data, that I had copied from the article. "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "with open(os.path.join(\"data\", \"spending.csv\")) as f:\n",
    "    data = f.readlines()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Analysis"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Simply run all the steps here. "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "def my_levels(data, e=50, n=50, a=50, c=50, o=50, column=\"Score\"):\n",
    "    e = e-50\n",
    "    a = a-50\n",
    "    n = n-50\n",
    "    c = c-50\n",
    "    o = o-50\n",
    "    for name, traits_levels in data.items():\n",
    "        data[name][column] = o*data[name][\"Openness\"] + c*data[name][\"Conscientiousness\"] + e*data[name][\"Extraversion\"] + a*data[name][\"Agreeableness\"] + n*data[name][\"Neuroticism\"]\n",
    "    return data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "all_data = dict()\n",
    "personality_traits = data[0].replace(\";\\n\", \"\").split(\";\")[1:]\n",
    "for d in data[1:]:\n",
    "    d = d.replace(\";\\n\", \"\").split(\";\")\n",
    "    name = d[0]\n",
    "    for trait, level in zip(personality_traits, d[1:]):\n",
    "        if not name in all_data:\n",
    "            all_data[name] = dict()\n",
    "        all_data[name][trait] = float(level.replace(\"−\", \"-\"))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "all_data = my_levels(all_data, e, n, a, c, o)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "data_pandas = pandas.DataFrame.from_dict(all_data)\n",
    "data_pandas = data_pandas.T"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Results"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "And here I am simply ordering the data based on the calculated score. "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [],
   "source": [
    "data_pandas = data_pandas.sort_values(\"Score\", ascending=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Agreeableness</th>\n",
       "      <th>Conscientiousness</th>\n",
       "      <th>Extraversion</th>\n",
       "      <th>Neuroticism</th>\n",
       "      <th>Openness</th>\n",
       "      <th>Score</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Books</th>\n",
       "      <td>1.53</td>\n",
       "      <td>1.92</td>\n",
       "      <td>-0.82</td>\n",
       "      <td>-1.39</td>\n",
       "      <td>1.71</td>\n",
       "      <td>23.85</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Gardening</th>\n",
       "      <td>1.94</td>\n",
       "      <td>1.75</td>\n",
       "      <td>-0.73</td>\n",
       "      <td>-1.59</td>\n",
       "      <td>0.59</td>\n",
       "      <td>0.04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Accountants’fees</th>\n",
       "      <td>-0.68</td>\n",
       "      <td>2.02</td>\n",
       "      <td>-1.40</td>\n",
       "      <td>-0.62</td>\n",
       "      <td>-1.81</td>\n",
       "      <td>-6.77</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Artsandcrafts</th>\n",
       "      <td>1.71</td>\n",
       "      <td>0.20</td>\n",
       "      <td>1.05</td>\n",
       "      <td>-0.46</td>\n",
       "      <td>2.51</td>\n",
       "      <td>-8.91</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Stationery</th>\n",
       "      <td>1.51</td>\n",
       "      <td>1.98</td>\n",
       "      <td>-0.78</td>\n",
       "      <td>-1.63</td>\n",
       "      <td>-0.14</td>\n",
       "      <td>-10.76</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Residentialmortgages</th>\n",
       "      <td>-0.48</td>\n",
       "      <td>1.98</td>\n",
       "      <td>-1.40</td>\n",
       "      <td>-0.85</td>\n",
       "      <td>-2.10</td>\n",
       "      <td>-11.16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Hardware</th>\n",
       "      <td>0.04</td>\n",
       "      <td>1.73</td>\n",
       "      <td>-0.61</td>\n",
       "      <td>-1.22</td>\n",
       "      <td>-0.78</td>\n",
       "      <td>-11.57</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Healthinsurance</th>\n",
       "      <td>-0.16</td>\n",
       "      <td>1.52</td>\n",
       "      <td>-1.11</td>\n",
       "      <td>-0.50</td>\n",
       "      <td>-1.61</td>\n",
       "      <td>-11.59</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Informationtechnology</th>\n",
       "      <td>0.15</td>\n",
       "      <td>1.36</td>\n",
       "      <td>0.33</td>\n",
       "      <td>-0.80</td>\n",
       "      <td>0.93</td>\n",
       "      <td>-12.25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Discountstores</th>\n",
       "      <td>0.28</td>\n",
       "      <td>-0.42</td>\n",
       "      <td>0.32</td>\n",
       "      <td>0.19</td>\n",
       "      <td>-0.17</td>\n",
       "      <td>-12.41</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Digital</th>\n",
       "      <td>0.02</td>\n",
       "      <td>1.05</td>\n",
       "      <td>0.77</td>\n",
       "      <td>-0.45</td>\n",
       "      <td>1.55</td>\n",
       "      <td>-13.06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Computersandtechnology</th>\n",
       "      <td>0.19</td>\n",
       "      <td>2.05</td>\n",
       "      <td>0.28</td>\n",
       "      <td>-1.00</td>\n",
       "      <td>1.36</td>\n",
       "      <td>-13.47</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Familyclothes</th>\n",
       "      <td>1.16</td>\n",
       "      <td>0.43</td>\n",
       "      <td>0.00</td>\n",
       "      <td>-0.96</td>\n",
       "      <td>-0.28</td>\n",
       "      <td>-15.89</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Gambling</th>\n",
       "      <td>-1.81</td>\n",
       "      <td>-2.08</td>\n",
       "      <td>2.33</td>\n",
       "      <td>1.98</td>\n",
       "      <td>1.55</td>\n",
       "      <td>-16.95</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Catalogueandbargainstores</th>\n",
       "      <td>0.54</td>\n",
       "      <td>-0.27</td>\n",
       "      <td>0.35</td>\n",
       "      <td>-0.21</td>\n",
       "      <td>-0.34</td>\n",
       "      <td>-17.89</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Homeinsurance</th>\n",
       "      <td>0.33</td>\n",
       "      <td>2.40</td>\n",
       "      <td>-1.46</td>\n",
       "      <td>-1.48</td>\n",
       "      <td>-2.05</td>\n",
       "      <td>-18.19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Toysandhobbies</th>\n",
       "      <td>0.78</td>\n",
       "      <td>-0.90</td>\n",
       "      <td>1.94</td>\n",
       "      <td>-0.06</td>\n",
       "      <td>2.19</td>\n",
       "      <td>-19.77</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Subscriptions</th>\n",
       "      <td>0.44</td>\n",
       "      <td>1.42</td>\n",
       "      <td>-0.26</td>\n",
       "      <td>-0.86</td>\n",
       "      <td>-0.43</td>\n",
       "      <td>-20.75</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Confectionersandtobacconists</th>\n",
       "      <td>0.42</td>\n",
       "      <td>0.21</td>\n",
       "      <td>0.77</td>\n",
       "      <td>-0.06</td>\n",
       "      <td>0.75</td>\n",
       "      <td>-21.78</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Homefurnishing</th>\n",
       "      <td>1.38</td>\n",
       "      <td>1.48</td>\n",
       "      <td>0.17</td>\n",
       "      <td>-1.22</td>\n",
       "      <td>0.63</td>\n",
       "      <td>-24.19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Takeoutfood</th>\n",
       "      <td>0.23</td>\n",
       "      <td>-0.07</td>\n",
       "      <td>1.16</td>\n",
       "      <td>-0.19</td>\n",
       "      <td>0.84</td>\n",
       "      <td>-24.95</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Carrentals</th>\n",
       "      <td>0.31</td>\n",
       "      <td>1.39</td>\n",
       "      <td>-0.06</td>\n",
       "      <td>-0.96</td>\n",
       "      <td>-0.53</td>\n",
       "      <td>-26.52</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Trafficfines</th>\n",
       "      <td>-2.33</td>\n",
       "      <td>0.91</td>\n",
       "      <td>-0.58</td>\n",
       "      <td>1.34</td>\n",
       "      <td>-2.25</td>\n",
       "      <td>-27.28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Shoeshops</th>\n",
       "      <td>0.58</td>\n",
       "      <td>1.19</td>\n",
       "      <td>0.43</td>\n",
       "      <td>-0.77</td>\n",
       "      <td>0.40</td>\n",
       "      <td>-28.21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Lifeinsurance</th>\n",
       "      <td>1.11</td>\n",
       "      <td>2.21</td>\n",
       "      <td>-1.02</td>\n",
       "      <td>-1.25</td>\n",
       "      <td>-1.30</td>\n",
       "      <td>-28.29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>TVlicense</th>\n",
       "      <td>-0.33</td>\n",
       "      <td>1.29</td>\n",
       "      <td>0.26</td>\n",
       "      <td>-0.39</td>\n",
       "      <td>-0.17</td>\n",
       "      <td>-28.46</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Coffeeshops</th>\n",
       "      <td>1.79</td>\n",
       "      <td>1.24</td>\n",
       "      <td>0.45</td>\n",
       "      <td>-1.23</td>\n",
       "      <td>0.89</td>\n",
       "      <td>-29.57</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Photography</th>\n",
       "      <td>1.09</td>\n",
       "      <td>0.69</td>\n",
       "      <td>1.44</td>\n",
       "      <td>-0.33</td>\n",
       "      <td>2.33</td>\n",
       "      <td>-29.80</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Giftshops</th>\n",
       "      <td>1.74</td>\n",
       "      <td>0.94</td>\n",
       "      <td>0.55</td>\n",
       "      <td>-0.94</td>\n",
       "      <td>0.83</td>\n",
       "      <td>-31.49</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Cinemas</th>\n",
       "      <td>0.71</td>\n",
       "      <td>0.22</td>\n",
       "      <td>1.75</td>\n",
       "      <td>-0.02</td>\n",
       "      <td>2.30</td>\n",
       "      <td>-31.76</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>DIYprojects</th>\n",
       "      <td>0.98</td>\n",
       "      <td>1.37</td>\n",
       "      <td>1.20</td>\n",
       "      <td>-0.54</td>\n",
       "      <td>2.22</td>\n",
       "      <td>-32.33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Clothes</th>\n",
       "      <td>0.89</td>\n",
       "      <td>0.44</td>\n",
       "      <td>0.96</td>\n",
       "      <td>-0.44</td>\n",
       "      <td>0.83</td>\n",
       "      <td>-32.55</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Dentalcare</th>\n",
       "      <td>0.32</td>\n",
       "      <td>1.79</td>\n",
       "      <td>-0.59</td>\n",
       "      <td>-0.59</td>\n",
       "      <td>-1.25</td>\n",
       "      <td>-33.28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Hairandbeauty</th>\n",
       "      <td>0.85</td>\n",
       "      <td>0.31</td>\n",
       "      <td>1.49</td>\n",
       "      <td>0.22</td>\n",
       "      <td>1.91</td>\n",
       "      <td>-36.08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CableandsatelliteTV</th>\n",
       "      <td>-0.17</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1.29</td>\n",
       "      <td>0.14</td>\n",
       "      <td>0.48</td>\n",
       "      <td>-36.96</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Airportsandduty-freeshops</th>\n",
       "      <td>-0.18</td>\n",
       "      <td>0.96</td>\n",
       "      <td>0.34</td>\n",
       "      <td>-0.02</td>\n",
       "      <td>-0.50</td>\n",
       "      <td>-37.58</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Caravansandcamping</th>\n",
       "      <td>1.00</td>\n",
       "      <td>0.60</td>\n",
       "      <td>1.51</td>\n",
       "      <td>-0.64</td>\n",
       "      <td>1.65</td>\n",
       "      <td>-38.73</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Jewelry</th>\n",
       "      <td>0.96</td>\n",
       "      <td>0.73</td>\n",
       "      <td>1.43</td>\n",
       "      <td>-0.61</td>\n",
       "      <td>1.60</td>\n",
       "      <td>-39.15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Bakersandconfectioners</th>\n",
       "      <td>1.41</td>\n",
       "      <td>1.59</td>\n",
       "      <td>0.86</td>\n",
       "      <td>-0.80</td>\n",
       "      <td>1.45</td>\n",
       "      <td>-40.94</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Entertainment</th>\n",
       "      <td>0.31</td>\n",
       "      <td>-0.43</td>\n",
       "      <td>2.51</td>\n",
       "      <td>0.49</td>\n",
       "      <td>2.67</td>\n",
       "      <td>-41.06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Hotels</th>\n",
       "      <td>1.55</td>\n",
       "      <td>1.69</td>\n",
       "      <td>0.31</td>\n",
       "      <td>-1.63</td>\n",
       "      <td>-0.16</td>\n",
       "      <td>-45.35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Florists</th>\n",
       "      <td>1.87</td>\n",
       "      <td>1.38</td>\n",
       "      <td>1.13</td>\n",
       "      <td>-0.98</td>\n",
       "      <td>1.69</td>\n",
       "      <td>-45.47</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Eatingout:restaurants</th>\n",
       "      <td>0.91</td>\n",
       "      <td>0.44</td>\n",
       "      <td>1.74</td>\n",
       "      <td>-0.39</td>\n",
       "      <td>1.56</td>\n",
       "      <td>-47.60</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Music</th>\n",
       "      <td>0.94</td>\n",
       "      <td>0.12</td>\n",
       "      <td>2.33</td>\n",
       "      <td>0.15</td>\n",
       "      <td>2.61</td>\n",
       "      <td>-49.65</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Foreigntravel</th>\n",
       "      <td>0.85</td>\n",
       "      <td>0.65</td>\n",
       "      <td>2.15</td>\n",
       "      <td>-0.11</td>\n",
       "      <td>2.54</td>\n",
       "      <td>-50.37</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Charities</th>\n",
       "      <td>2.31</td>\n",
       "      <td>1.65</td>\n",
       "      <td>0.10</td>\n",
       "      <td>-1.39</td>\n",
       "      <td>-0.35</td>\n",
       "      <td>-52.64</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Advertisingservices</th>\n",
       "      <td>-0.04</td>\n",
       "      <td>0.70</td>\n",
       "      <td>2.04</td>\n",
       "      <td>0.34</td>\n",
       "      <td>1.98</td>\n",
       "      <td>-52.72</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Supermarkets</th>\n",
       "      <td>0.58</td>\n",
       "      <td>1.27</td>\n",
       "      <td>0.51</td>\n",
       "      <td>-0.73</td>\n",
       "      <td>-0.69</td>\n",
       "      <td>-53.80</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Travel</th>\n",
       "      <td>1.18</td>\n",
       "      <td>0.24</td>\n",
       "      <td>2.37</td>\n",
       "      <td>-0.20</td>\n",
       "      <td>2.51</td>\n",
       "      <td>-53.95</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Departmentstores</th>\n",
       "      <td>0.57</td>\n",
       "      <td>1.28</td>\n",
       "      <td>0.70</td>\n",
       "      <td>-0.62</td>\n",
       "      <td>-0.30</td>\n",
       "      <td>-54.62</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Newsagents</th>\n",
       "      <td>-0.29</td>\n",
       "      <td>0.76</td>\n",
       "      <td>1.06</td>\n",
       "      <td>0.12</td>\n",
       "      <td>-0.22</td>\n",
       "      <td>-54.74</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Unionsandsubscriptions</th>\n",
       "      <td>-0.58</td>\n",
       "      <td>1.26</td>\n",
       "      <td>0.42</td>\n",
       "      <td>0.25</td>\n",
       "      <td>-1.04</td>\n",
       "      <td>-54.86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Eatingout:pubs</th>\n",
       "      <td>0.40</td>\n",
       "      <td>-0.41</td>\n",
       "      <td>2.22</td>\n",
       "      <td>0.48</td>\n",
       "      <td>1.35</td>\n",
       "      <td>-57.04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Daysoutandtourism</th>\n",
       "      <td>1.10</td>\n",
       "      <td>0.57</td>\n",
       "      <td>2.25</td>\n",
       "      <td>-0.28</td>\n",
       "      <td>2.19</td>\n",
       "      <td>-60.06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Motorsports</th>\n",
       "      <td>-0.55</td>\n",
       "      <td>0.09</td>\n",
       "      <td>2.32</td>\n",
       "      <td>0.82</td>\n",
       "      <td>1.34</td>\n",
       "      <td>-63.01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Mobiletelephone</th>\n",
       "      <td>0.33</td>\n",
       "      <td>1.33</td>\n",
       "      <td>1.65</td>\n",
       "      <td>-0.13</td>\n",
       "      <td>1.02</td>\n",
       "      <td>-67.69</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Pets</th>\n",
       "      <td>1.98</td>\n",
       "      <td>0.08</td>\n",
       "      <td>2.04</td>\n",
       "      <td>0.24</td>\n",
       "      <td>1.14</td>\n",
       "      <td>-79.94</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Sports</th>\n",
       "      <td>-0.41</td>\n",
       "      <td>1.30</td>\n",
       "      <td>2.24</td>\n",
       "      <td>0.77</td>\n",
       "      <td>1.44</td>\n",
       "      <td>-82.30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Healthandfitness</th>\n",
       "      <td>1.00</td>\n",
       "      <td>2.22</td>\n",
       "      <td>1.29</td>\n",
       "      <td>-0.93</td>\n",
       "      <td>0.32</td>\n",
       "      <td>-83.38</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                              Agreeableness  Conscientiousness  Extraversion  \\\n",
       "Books                                  1.53               1.92         -0.82   \n",
       "Gardening                              1.94               1.75         -0.73   \n",
       "Accountants’fees                      -0.68               2.02         -1.40   \n",
       "Artsandcrafts                          1.71               0.20          1.05   \n",
       "Stationery                             1.51               1.98         -0.78   \n",
       "Residentialmortgages                  -0.48               1.98         -1.40   \n",
       "Hardware                               0.04               1.73         -0.61   \n",
       "Healthinsurance                       -0.16               1.52         -1.11   \n",
       "Informationtechnology                  0.15               1.36          0.33   \n",
       "Discountstores                         0.28              -0.42          0.32   \n",
       "Digital                                0.02               1.05          0.77   \n",
       "Computersandtechnology                 0.19               2.05          0.28   \n",
       "Familyclothes                          1.16               0.43          0.00   \n",
       "Gambling                              -1.81              -2.08          2.33   \n",
       "Catalogueandbargainstores              0.54              -0.27          0.35   \n",
       "Homeinsurance                          0.33               2.40         -1.46   \n",
       "Toysandhobbies                         0.78              -0.90          1.94   \n",
       "Subscriptions                          0.44               1.42         -0.26   \n",
       "Confectionersandtobacconists           0.42               0.21          0.77   \n",
       "Homefurnishing                         1.38               1.48          0.17   \n",
       "Takeoutfood                            0.23              -0.07          1.16   \n",
       "Carrentals                             0.31               1.39         -0.06   \n",
       "Trafficfines                          -2.33               0.91         -0.58   \n",
       "Shoeshops                              0.58               1.19          0.43   \n",
       "Lifeinsurance                          1.11               2.21         -1.02   \n",
       "TVlicense                             -0.33               1.29          0.26   \n",
       "Coffeeshops                            1.79               1.24          0.45   \n",
       "Photography                            1.09               0.69          1.44   \n",
       "Giftshops                              1.74               0.94          0.55   \n",
       "Cinemas                                0.71               0.22          1.75   \n",
       "DIYprojects                            0.98               1.37          1.20   \n",
       "Clothes                                0.89               0.44          0.96   \n",
       "Dentalcare                             0.32               1.79         -0.59   \n",
       "Hairandbeauty                          0.85               0.31          1.49   \n",
       "CableandsatelliteTV                   -0.17               0.00          1.29   \n",
       "Airportsandduty-freeshops             -0.18               0.96          0.34   \n",
       "Caravansandcamping                     1.00               0.60          1.51   \n",
       "Jewelry                                0.96               0.73          1.43   \n",
       "Bakersandconfectioners                 1.41               1.59          0.86   \n",
       "Entertainment                          0.31              -0.43          2.51   \n",
       "Hotels                                 1.55               1.69          0.31   \n",
       "Florists                               1.87               1.38          1.13   \n",
       "Eatingout:restaurants                  0.91               0.44          1.74   \n",
       "Music                                  0.94               0.12          2.33   \n",
       "Foreigntravel                          0.85               0.65          2.15   \n",
       "Charities                              2.31               1.65          0.10   \n",
       "Advertisingservices                   -0.04               0.70          2.04   \n",
       "Supermarkets                           0.58               1.27          0.51   \n",
       "Travel                                 1.18               0.24          2.37   \n",
       "Departmentstores                       0.57               1.28          0.70   \n",
       "Newsagents                            -0.29               0.76          1.06   \n",
       "Unionsandsubscriptions                -0.58               1.26          0.42   \n",
       "Eatingout:pubs                         0.40              -0.41          2.22   \n",
       "Daysoutandtourism                      1.10               0.57          2.25   \n",
       "Motorsports                           -0.55               0.09          2.32   \n",
       "Mobiletelephone                        0.33               1.33          1.65   \n",
       "Pets                                   1.98               0.08          2.04   \n",
       "Sports                                -0.41               1.30          2.24   \n",
       "Healthandfitness                       1.00               2.22          1.29   \n",
       "\n",
       "                              Neuroticism  Openness  Score  \n",
       "Books                               -1.39      1.71  23.85  \n",
       "Gardening                           -1.59      0.59   0.04  \n",
       "Accountants’fees                    -0.62     -1.81  -6.77  \n",
       "Artsandcrafts                       -0.46      2.51  -8.91  \n",
       "Stationery                          -1.63     -0.14 -10.76  \n",
       "Residentialmortgages                -0.85     -2.10 -11.16  \n",
       "Hardware                            -1.22     -0.78 -11.57  \n",
       "Healthinsurance                     -0.50     -1.61 -11.59  \n",
       "Informationtechnology               -0.80      0.93 -12.25  \n",
       "Discountstores                       0.19     -0.17 -12.41  \n",
       "Digital                             -0.45      1.55 -13.06  \n",
       "Computersandtechnology              -1.00      1.36 -13.47  \n",
       "Familyclothes                       -0.96     -0.28 -15.89  \n",
       "Gambling                             1.98      1.55 -16.95  \n",
       "Catalogueandbargainstores           -0.21     -0.34 -17.89  \n",
       "Homeinsurance                       -1.48     -2.05 -18.19  \n",
       "Toysandhobbies                      -0.06      2.19 -19.77  \n",
       "Subscriptions                       -0.86     -0.43 -20.75  \n",
       "Confectionersandtobacconists        -0.06      0.75 -21.78  \n",
       "Homefurnishing                      -1.22      0.63 -24.19  \n",
       "Takeoutfood                         -0.19      0.84 -24.95  \n",
       "Carrentals                          -0.96     -0.53 -26.52  \n",
       "Trafficfines                         1.34     -2.25 -27.28  \n",
       "Shoeshops                           -0.77      0.40 -28.21  \n",
       "Lifeinsurance                       -1.25     -1.30 -28.29  \n",
       "TVlicense                           -0.39     -0.17 -28.46  \n",
       "Coffeeshops                         -1.23      0.89 -29.57  \n",
       "Photography                         -0.33      2.33 -29.80  \n",
       "Giftshops                           -0.94      0.83 -31.49  \n",
       "Cinemas                             -0.02      2.30 -31.76  \n",
       "DIYprojects                         -0.54      2.22 -32.33  \n",
       "Clothes                             -0.44      0.83 -32.55  \n",
       "Dentalcare                          -0.59     -1.25 -33.28  \n",
       "Hairandbeauty                        0.22      1.91 -36.08  \n",
       "CableandsatelliteTV                  0.14      0.48 -36.96  \n",
       "Airportsandduty-freeshops           -0.02     -0.50 -37.58  \n",
       "Caravansandcamping                  -0.64      1.65 -38.73  \n",
       "Jewelry                             -0.61      1.60 -39.15  \n",
       "Bakersandconfectioners              -0.80      1.45 -40.94  \n",
       "Entertainment                        0.49      2.67 -41.06  \n",
       "Hotels                              -1.63     -0.16 -45.35  \n",
       "Florists                            -0.98      1.69 -45.47  \n",
       "Eatingout:restaurants               -0.39      1.56 -47.60  \n",
       "Music                                0.15      2.61 -49.65  \n",
       "Foreigntravel                       -0.11      2.54 -50.37  \n",
       "Charities                           -1.39     -0.35 -52.64  \n",
       "Advertisingservices                  0.34      1.98 -52.72  \n",
       "Supermarkets                        -0.73     -0.69 -53.80  \n",
       "Travel                              -0.20      2.51 -53.95  \n",
       "Departmentstores                    -0.62     -0.30 -54.62  \n",
       "Newsagents                           0.12     -0.22 -54.74  \n",
       "Unionsandsubscriptions               0.25     -1.04 -54.86  \n",
       "Eatingout:pubs                       0.48      1.35 -57.04  \n",
       "Daysoutandtourism                   -0.28      2.19 -60.06  \n",
       "Motorsports                          0.82      1.34 -63.01  \n",
       "Mobiletelephone                     -0.13      1.02 -67.69  \n",
       "Pets                                 0.24      1.14 -79.94  \n",
       "Sports                               0.77      1.44 -82.30  \n",
       "Healthandfitness                    -0.93      0.32 -83.38  "
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data_pandas"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}