P36: Estudando a base de dados flags.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "20e21dcf",
   "metadata": {},
   "outputs": [],
   "source": [
    "#P36: Estudando a base de dados flags\n",
    "#I. Propriedades básicas de cada atributo\n",
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "184afdc5",
   "metadata": {},
   "outputs": [],
   "source": [
    "#Importa a base de dados\n",
    "flags = pd.read_csv('/Users/TullioPires/flags.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "b7c27abb",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "(1) atributo: name \t dtype: object \t nulos: False \n",
      " dominio (primeiros elementos): ['Afghanistan' 'Albania' 'Algeria' 'American-Samoa' 'Andorra' 'Angola'\n",
      " 'Anguilla' 'Antigua-Barbuda' 'Argentina' 'Argentine' 'Australia'\n",
      " 'Austria' 'Bahamas' 'Bahrain' 'Bangladesh' 'Barbados' 'Belgium' 'Belize'\n",
      " 'Benin' 'Bermuda' 'Bhutan' 'Bolivia' 'Botswana' 'Brazil'\n",
      " 'British-Virgin-Isles' 'Brunei' 'Bulgaria' 'Burkina' 'Burma' 'Burundi'\n",
      " 'Cameroon' 'Canada' 'Cape-Verde-Islands' 'Cayman-Islands'\n",
      " 'Central-African-Republic' 'Chad' 'Chile' 'China' 'Colombia'\n",
      " 'Comorro-Islands' 'Congo' 'Cook-Islands' 'Costa-Rica' 'Cuba' 'Cyprus'\n",
      " 'Czechoslovakia' 'Denmark' 'Djibouti' 'Dominica' 'Dominican-Republic'\n",
      " 'Ecuador' 'Egypt' 'El-Salvador' 'Equatorial-Guinea' 'Ethiopia' 'Faeroes'\n",
      " 'Falklands-Malvinas' 'Fiji' 'Finland' 'France' 'French-Guiana'\n",
      " 'French-Polynesia' 'Gabon' 'Gambia' 'Germany-DDR' 'Germany-FRG' 'Ghana'\n",
      " 'Gibraltar' 'Greece' 'Greenland' 'Grenada' 'Guam' 'Guatemala' 'Guinea'\n",
      " 'Guinea-Bissau' 'Guyana' 'Haiti' 'Honduras' 'Hong-Kong' 'Hungary'\n",
      " 'Iceland' 'India' 'Indonesia' 'Iran' 'Iraq' 'Ireland' 'Israel' 'Italy'\n",
      " 'Ivory-Coast' 'Jamaica' 'Japan' 'Jordan' 'Kampuchea' 'Kenya' 'Kiribati'\n",
      " 'Kuwait' 'Laos' 'Lebanon' 'Lesotho' 'Liberia' 'Libya' 'Liechtenstein'\n",
      " 'Luxembourg' 'Malagasy' 'Malawi' 'Malaysia' 'Maldive-Islands' 'Mali'\n",
      " 'Malta' 'Marianas' 'Mauritania' 'Mauritius' 'Mexico' 'Micronesia'\n",
      " 'Monaco' 'Mongolia' 'Montserrat' 'Morocco' 'Mozambique' 'Nauru' 'Nepal'\n",
      " 'Netherlands' 'Netherlands-Antilles' 'New-Zealand' 'Nicaragua' 'Niger'\n",
      " 'Nigeria' 'Niue' 'North-Korea' 'North-Yemen' 'Norway' 'Oman' 'Pakistan'\n",
      " 'Panama' 'Papua-New-Guinea' 'Parguay' 'Peru' 'Philippines' 'Poland'\n",
      " 'Portugal' 'Puerto-Rico' 'Qatar' 'Romania' 'Rwanda' 'San-Marino'\n",
      " 'Sao-Tome' 'Saudi-Arabia' 'Senegal' 'Seychelles' 'Sierra-Leone'\n",
      " 'Singapore' 'Soloman-Islands' 'Somalia' 'South-Africa' 'South-Korea'\n",
      " 'South-Yemen' 'Spain' 'Sri-Lanka' 'St-Helena' 'St-Kitts-Nevis' 'St-Lucia'\n",
      " 'St-Vincent' 'Sudan' 'Surinam' 'Swaziland' 'Sweden' 'Switzerland' 'Syria'\n",
      " 'Taiwan' 'Tanzania' 'Thailand' 'Togo' 'Tonga' 'Trinidad-Tobago' 'Tunisia'\n",
      " 'Turkey' 'Turks-Cocos-Islands' 'Tuvalu' 'UAE' 'Uganda' 'UK' 'Uruguay'\n",
      " 'US-Virgin-Isles' 'USA' 'USSR' 'Vanuatu' 'Vatican-City' 'Venezuela'\n",
      " 'Vietnam' 'Western-Samoa' 'Yugoslavia' 'Zaire' 'Zambia' 'Zimbabwe']\n",
      "(2) atributo: landmass \t dtype: int64 \t nulos: False \n",
      " dominio: [5 3 4 6 1 2]\n",
      "(3) atributo: zone \t dtype: int64 \t nulos: False \n",
      " dominio: [1 3 2 4]\n",
      "(4) atributo: area \t dtype: int64 \t nulos: False \n",
      " min: 0 \t max: 22402 \t média: 700.0463917525773 \t d.p: 2170.93\n",
      "(5) atributo: population \t dtype: int64 \t nulos: False \n",
      " min: 0 \t max: 1008 \t média: 23.2680412371134 \t d.p: 91.93\n",
      "(6) atributo: language \t dtype: int64 \t nulos: False \n",
      " min: 1 \t max: 10 \t média: 5.34020618556701 \t d.p: 3.5\n",
      "(7) atributo: religion \t dtype: int64 \t nulos: False \n",
      " min: 0 \t max: 7 \t média: 2.1907216494845363 \t d.p: 2.06\n",
      "(8) atributo: bars \t dtype: int64 \t nulos: False \n",
      " dominio: [0 2 3 1 5]\n",
      "(9) atributo: stripes \t dtype: int64 \t nulos: False \n",
      " min: 0 \t max: 14 \t média: 1.5515463917525774 \t d.p: 2.33\n",
      "(10) atributo: colours \t dtype: int64 \t nulos: False \n",
      " min: 1 \t max: 8 \t média: 3.463917525773196 \t d.p: 1.3\n",
      "(11) atributo: red \t dtype: int64 \t nulos: False \n",
      " dominio: [1 0]\n",
      "(12) atributo: green \t dtype: int64 \t nulos: False \n",
      " dominio: [1 0]\n",
      "(13) atributo: blue \t dtype: int64 \t nulos: False \n",
      " dominio: [0 1]\n",
      "(14) atributo: gold \t dtype: int64 \t nulos: False \n",
      " dominio: [1 0]\n",
      "(15) atributo: white \t dtype: int64 \t nulos: False \n",
      " dominio: [1 0]\n",
      "(16) atributo: black \t dtype: int64 \t nulos: False \n",
      " dominio: [1 0]\n",
      "(17) atributo: orange \t dtype: int64 \t nulos: False \n",
      " dominio: [0 1]\n",
      "(18) atributo: mainhue \t dtype: object \t nulos: False \n",
      " dominio (primeiros elementos): ['green' 'red' 'blue' 'gold' 'white' 'orange' 'black' 'brown']\n",
      "(19) atributo: circles \t dtype: int64 \t nulos: False \n",
      " dominio: [0 1 4 2]\n",
      "(20) atributo: crosses \t dtype: int64 \t nulos: False \n",
      " dominio: [0 1 2]\n",
      "(21) atributo: saltires \t dtype: int64 \t nulos: False \n",
      " dominio: [0 1]\n",
      "(22) atributo: quarters \t dtype: int64 \t nulos: False \n",
      " dominio: [0 1 4]\n",
      "(23) atributo: sunstars \t dtype: int64 \t nulos: False \n",
      " min: 0 \t max: 50 \t média: 1.3865979381443299 \t d.p: 4.4\n",
      "(24) atributo: crescent \t dtype: int64 \t nulos: False \n",
      " dominio: [0 1]\n",
      "(25) atributo: triangle \t dtype: int64 \t nulos: False \n",
      " dominio: [0 1]\n",
      "(26) atributo: icon \t dtype: int64 \t nulos: False \n",
      " dominio: [1 0]\n",
      "(27) atributo: animate \t dtype: int64 \t nulos: False \n",
      " dominio: [0 1]\n",
      "(28) atributo: text \t dtype: int64 \t nulos: False \n",
      " dominio: [0 1]\n",
      "(29) atributo: topleft \t dtype: object \t nulos: False \n",
      " dominio: ['black' 'red' 'green' 'blue' 'white' 'orange' 'gold']\n",
      "(30) atributo: botright \t dtype: object \t nulos: False \n",
      " dominio (primeiros elementos): ['green' 'red' 'white' 'black' 'blue' 'gold' 'orange' 'brown']\n"
     ]
    }
   ],
   "source": [
    "#Obtém as propriedades básicas de cada atributo\n",
    "i=0\n",
    "for c in flags.columns:\n",
    "    i +=1                  \n",
    "    att = flags[c]                          #atributo\n",
    "    att_dtype=att.dtype                     #dtype\n",
    "    att_tam_dominio = att.unique().size     #tamanho do domínio\n",
    "    \n",
    "    att_tem_nulo = any(att.isnull())        #possui valor nulo?\n",
    "    if (att_tam_dominio < 8):\n",
    "        print(\"(\"+str(i)+\") atributo:\", c, \"\\t\",\n",
    "             \"dtype:\", att_dtype, \"\\t\",\n",
    "             \"nulos:\", att_tem_nulo, \"\\n\",\n",
    "             \"dominio:\", att.unique())\n",
    "    \n",
    "    else:\n",
    "        if (att_dtype == 'object'):\n",
    "            print(\"(\"+str(i)+\") atributo:\", c, \"\\t\",\n",
    "                 \"dtype:\", att_dtype, \"\\t\",\n",
    "                 \"nulos:\", att_tem_nulo, \"\\n\",\n",
    "                 \"dominio (primeiros elementos):\", att.unique())\n",
    "            \n",
    "        else:\n",
    "            print(\"(\"+str(i)+\") atributo:\", c, \"\\t\",\n",
    "                 \"dtype:\", att_dtype, \"\\t\",\n",
    "                 \"nulos:\", att_tem_nulo, \"\\n\",\n",
    "                 \"min:\", att.min(), \"\\t\",\n",
    "                 \"max:\", att.max(), \"\\t\",\n",
    "                 \"média:\", att.mean(), \"\\t\",\n",
    "                 \"d.p:\", round(att.std(), 2))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "71217757",
   "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.8.8"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}