sandrews__homework-structuring data.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "4de406fe",
   "metadata": {},
   "source": [
    "Completed by Stephanie Andrews\n",
    "2023-07-18"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "8c15b108",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "2ff7a180",
   "metadata": {},
   "outputs": [],
   "source": [
    "df = pd.read_csv(\"./Data Tidying Examples - Sidewinder Library.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "e38fab7a",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 11 entries, 0 to 10\n",
      "Data columns (total 10 columns):\n",
      " #   Column                 Non-Null Count  Dtype \n",
      "---  ------                 --------------  ----- \n",
      " 0   First Name             11 non-null     object\n",
      " 1   Last Name              11 non-null     object\n",
      " 2   Date of Birth          11 non-null     object\n",
      " 3   Library Card Expired?  11 non-null     object\n",
      " 4   Book                   11 non-null     object\n",
      " 5   Author_A               11 non-null     object\n",
      " 6   Author_B               11 non-null     object\n",
      " 7   Genres                 11 non-null     object\n",
      " 8   Days Late              11 non-null     int64 \n",
      " 9   Late Fees              11 non-null     object\n",
      "dtypes: int64(1), object(9)\n",
      "memory usage: 1008.0+ bytes\n"
     ]
    }
   ],
   "source": [
    "df.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "1713123e",
   "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>Last Name</th>\n",
       "      <th>First Name</th>\n",
       "      <th>Date of Birth</th>\n",
       "      <th>Library Card Expired?</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Massey</td>\n",
       "      <td>?</td>\n",
       "      <td>?</td>\n",
       "      <td>No</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Torrance</td>\n",
       "      <td>Danny</td>\n",
       "      <td>1971-12-11</td>\n",
       "      <td>Yes</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Torrance</td>\n",
       "      <td>Jack</td>\n",
       "      <td>1946-08-03</td>\n",
       "      <td>No</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Torrance</td>\n",
       "      <td>Wendy</td>\n",
       "      <td>1946-03-05</td>\n",
       "      <td>No</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  Last Name First Name Date of Birth Library Card Expired?\n",
       "9    Massey          ?             ?                    No\n",
       "0  Torrance      Danny    1971-12-11                   Yes\n",
       "2  Torrance       Jack    1946-08-03                    No\n",
       "5  Torrance      Wendy    1946-03-05                    No"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "library_patrons_df = df[[\"Last Name\", \"First Name\", \"Date of Birth\", \"Library Card Expired?\"]].copy().drop_duplicates()\n",
    "# library_patrons_df[\"Full Name\"] = df[\"First Name\"] + \" \" + df[\"Last Name\"]\n",
    "# library_patrons_df.sort_values(\"Full Name\")\n",
    "library_patrons_df.sort_values(by=[\"Last Name\", \"First Name\"])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "d58a32a7",
   "metadata": {},
   "outputs": [],
   "source": [
    "library_patrons_df.to_csv(\"library_patrons.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "b1f249d4",
   "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>Genres</th>\n",
       "      <th>Book</th>\n",
       "      <th>Author_A</th>\n",
       "      <th>Author_B</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Fiction</td>\n",
       "      <td>Emma</td>\n",
       "      <td>Jane Austen</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Fiction</td>\n",
       "      <td>Pride and Prejudice</td>\n",
       "      <td>Jane Austen</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Fiction; Youth</td>\n",
       "      <td>A Wrinkle in Time</td>\n",
       "      <td>Madeleine L'Engle</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Fiction; Youth</td>\n",
       "      <td>The Phantom Tollbooth</td>\n",
       "      <td>Norton Juster</td>\n",
       "      <td>Jules Feiffer</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Nonfiction</td>\n",
       "      <td>Slouching Towards Bethlehem</td>\n",
       "      <td>Joan Didion</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Nonfiction</td>\n",
       "      <td>The Communist Manifesto</td>\n",
       "      <td>Karl Marx</td>\n",
       "      <td>Friedrich Engels</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Nonfiction</td>\n",
       "      <td>The Electric Kool-Aid Acid Test</td>\n",
       "      <td>Tom Wolfe</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Nonfiction; Memoir</td>\n",
       "      <td>I Know Why the Caged Bird Sings</td>\n",
       "      <td>Maya Angelou</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                Genres                             Book           Author_A  \\\n",
       "5              Fiction                             Emma        Jane Austen   \n",
       "2              Fiction              Pride and Prejudice        Jane Austen   \n",
       "1       Fiction; Youth                A Wrinkle in Time  Madeleine L'Engle   \n",
       "0       Fiction; Youth            The Phantom Tollbooth      Norton Juster   \n",
       "10          Nonfiction      Slouching Towards Bethlehem        Joan Didion   \n",
       "7           Nonfiction          The Communist Manifesto          Karl Marx   \n",
       "6           Nonfiction  The Electric Kool-Aid Acid Test          Tom Wolfe   \n",
       "3   Nonfiction; Memoir  I Know Why the Caged Bird Sings       Maya Angelou   \n",
       "\n",
       "            Author_B  \n",
       "5                  -  \n",
       "2                  -  \n",
       "1                  -  \n",
       "0      Jules Feiffer  \n",
       "10                 -  \n",
       "7   Friedrich Engels  \n",
       "6                  -  \n",
       "3                  -  "
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "library_books_df = df[[\"Genres\", \"Book\", \"Author_A\", \"Author_B\"]].copy().drop_duplicates()\n",
    "library_books_df.sort_values([\"Genres\", \"Book\", \"Author_A\"])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "2877d25f",
   "metadata": {},
   "outputs": [],
   "source": [
    "library_books_df.to_csv(\"library_books.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "b7741520",
   "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>Last Name</th>\n",
       "      <th>First Name</th>\n",
       "      <th>Book</th>\n",
       "      <th>Days Late</th>\n",
       "      <th>Late Fees</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Massey</td>\n",
       "      <td>?</td>\n",
       "      <td>Pride and Prejudice</td>\n",
       "      <td>15</td>\n",
       "      <td>$1.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Massey</td>\n",
       "      <td>?</td>\n",
       "      <td>Slouching Towards Bethlehem</td>\n",
       "      <td>15</td>\n",
       "      <td>$1.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Torrance</td>\n",
       "      <td>Danny</td>\n",
       "      <td>A Wrinkle in Time</td>\n",
       "      <td>15</td>\n",
       "      <td>$0.45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Torrance</td>\n",
       "      <td>Danny</td>\n",
       "      <td>The Phantom Tollbooth</td>\n",
       "      <td>15</td>\n",
       "      <td>$0.45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Torrance</td>\n",
       "      <td>Jack</td>\n",
       "      <td>A Wrinkle in Time</td>\n",
       "      <td>15</td>\n",
       "      <td>$0.45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Torrance</td>\n",
       "      <td>Jack</td>\n",
       "      <td>I Know Why the Caged Bird Sings</td>\n",
       "      <td>15</td>\n",
       "      <td>$1.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Torrance</td>\n",
       "      <td>Jack</td>\n",
       "      <td>Pride and Prejudice</td>\n",
       "      <td>7</td>\n",
       "      <td>$0.70</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Torrance</td>\n",
       "      <td>Wendy</td>\n",
       "      <td>A Wrinkle in Time</td>\n",
       "      <td>15</td>\n",
       "      <td>$0.45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Torrance</td>\n",
       "      <td>Wendy</td>\n",
       "      <td>Emma</td>\n",
       "      <td>7</td>\n",
       "      <td>$0.70</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Torrance</td>\n",
       "      <td>Wendy</td>\n",
       "      <td>The Communist Manifesto</td>\n",
       "      <td>15</td>\n",
       "      <td>$6.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Torrance</td>\n",
       "      <td>Wendy</td>\n",
       "      <td>The Electric Kool-Aid Acid Test</td>\n",
       "      <td>15</td>\n",
       "      <td>$4.50</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   Last Name First Name                             Book  Days Late Late Fees\n",
       "9     Massey          ?              Pride and Prejudice         15     $1.50\n",
       "10    Massey          ?      Slouching Towards Bethlehem         15     $1.50\n",
       "1   Torrance      Danny                A Wrinkle in Time         15     $0.45\n",
       "0   Torrance      Danny            The Phantom Tollbooth         15     $0.45\n",
       "4   Torrance       Jack                A Wrinkle in Time         15     $0.45\n",
       "3   Torrance       Jack  I Know Why the Caged Bird Sings         15     $1.50\n",
       "2   Torrance       Jack              Pride and Prejudice          7     $0.70\n",
       "8   Torrance      Wendy                A Wrinkle in Time         15     $0.45\n",
       "5   Torrance      Wendy                             Emma          7     $0.70\n",
       "7   Torrance      Wendy          The Communist Manifesto         15     $6.00\n",
       "6   Torrance      Wendy  The Electric Kool-Aid Acid Test         15     $4.50"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "library_fees_df = df[[\"Last Name\", \"First Name\", \"Book\", \"Days Late\", \"Late Fees\"]].copy()\n",
    "# library_fees_df[\"Full Name\"] = df[\"First Name\"] + \" \" + df[\"Last Name\"]\n",
    "library_fees_df.sort_values([\"Last Name\", \"First Name\", \"Book\"])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "c4ec39c7",
   "metadata": {},
   "outputs": [],
   "source": [
    "library_fees_df.to_csv(\"library_fees.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "9849d173",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "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.10.11"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}