EDApt1Exercises.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "508b5a5d-bbec-41dc-9610-b9929c89536a",
   "metadata": {},
   "source": [
    "# Import Pandas\n",
    "\n",
    "To use the Pandas library, you need to import it into your coding environment. For these exercises, our coding environment is this Jupyter notebook. Pandas is typically imported and named as \"pd\"."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "c18c6c3a-909e-4be2-bec6-fffe39a15f18",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "010157cf-333f-4aaa-a87d-afd88645752b",
   "metadata": {},
   "source": [
    "# Series\n",
    "\n",
    "A series is a data type used by Pandas. It is like a one dimensional list, whose elements can be of any data type themselves.\n",
    "Pandas contains a method, ``.Series()``, that initiates a series object from a Python list, tuple, "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "e31b74b5-2f8e-4126-bf65-be577a3e5b06",
   "metadata": {
    "tags": []
   },
   "outputs": [],
   "source": [
    "#create the s1 series from the list: [10,20,30,40,50]\n",
    "s1=pd.Series([10,20,30,40,50])\n",
    "\n",
    "# additional practice\n",
    "# create a series called s_tuple from the tuple: (\"apple\", \"banana\", \"cherry\")\n",
    "tuple=('apple','banana','cherry')\n",
    "s_tuple=pd.Series(tuple)\n",
    "\n",
    "# create a series called s_dictionary from the dictionary: {\"brand\": \"Ford\", \"model\": \"Mustang\", \"year\": 1964}\n",
    "dict={'brand':'Ford','model':'Mustang','year':1964}\n",
    "s_dictionary=pd.Series(dict)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "76d730b9-fd65-4278-af53-22c1674005a9",
   "metadata": {
    "tags": []
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "The s1 series values are: [10 20 30 40 50]\n",
      "The s1 index values are: [0 1 2 3 4]\n",
      "\n",
      "\n",
      "The s_tuple series values are: ['apple' 'banana' 'cherry']\n",
      "The s_tuple index values are: [0 1 2]\n",
      "\n",
      "\n",
      "The s_dictionary series values are: ['Ford' 'Mustang' 1964]\n",
      "The s_dictionary index values are: ['brand' 'model' 'year']\n"
     ]
    }
   ],
   "source": [
    "# fill in the blank with the series values and index values\n",
    "print(\"The s1 series values are:\", s1.values)\n",
    "print(\"The s1 index values are:\", s1.index.values)\n",
    "print(\"\\n\")\n",
    "print(\"The s_tuple series values are:\", s_tuple.values)\n",
    "print(\"The s_tuple index values are:\", s_tuple.index.values)\n",
    "print(\"\\n\")\n",
    "print(\"The s_dictionary series values are:\", s_dictionary.values)\n",
    "print(\"The s_dictionary index values are:\", s_dictionary.index.values)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "69fb52bf-9acc-4df9-b7ae-1f54c91313b3",
   "metadata": {},
   "source": [
    "Index values in a series are generated by default. We can also define custom indexes at the time of creating series.\n",
    "\n",
    "Below is a series of marks (grades) and the associated subjects can be defined as custom row indexes."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "f7794bcc-c9f0-4c21-80f5-c71258532c13",
   "metadata": {},
   "outputs": [],
   "source": [
    "# create the s2 series from the list [80,93,78,85,97] and with labeled indexes ['English','Science','Social','Tamil','Maths']\n",
    "s2 = pd.Series([80,93,78,85,97], index=['English','Science','Social','Tamil','Maths'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "5674059a-a773-4bc0-b6f1-94ff3d5e2bf6",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "s2 series are English    80\n",
      "Science    93\n",
      "Social     78\n",
      "Tamil      85\n",
      "Maths      97\n",
      "dtype: int64\n"
     ]
    }
   ],
   "source": [
    "# print the s2 series\n",
    "print(\"s2 series are\", s2)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "49dc78f7-1183-45a7-8750-55cc291d3dc7",
   "metadata": {},
   "source": [
    "We can provide a name for the whole series, as well as a name for the indexes."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "36a58fa6-c808-4ca4-8209-c53b97d298bf",
   "metadata": {},
   "outputs": [],
   "source": [
    "# assign the s2 series name to be \"Student Marks\"\n",
    "s2.name='Student Marks'\n",
    "s2.index.name='Subject'\n",
    "# assign the s2 index name to be \"Subject\"\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "id": "0ead4e61-9a2d-4efc-bdb6-aaaad033654f",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "the newly assigned series are\n",
      " Subject\n",
      "English    80\n",
      "Science    93\n",
      "Social     78\n",
      "Tamil      85\n",
      "Maths      97\n",
      "Name: Student Marks, dtype: int64\n"
     ]
    }
   ],
   "source": [
    "# print the s2 series again to see the newly assigned name and index name\n",
    "print(\"the newly assigned series are\\n\",s2)\n"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "232015d7-c9e8-4645-be46-000956a642f4",
   "metadata": {},
   "source": [
    "## Subsetting the Series\n",
    "\n",
    "Values inside the series can be accessed using the ``[ ]`` square bracket slicing operation\n",
    "\n",
    "- Series can be sliced using the default index\n",
    "- Series can also be sliced using string indices (indexes)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "id": "fa73dcf8-8afb-4a9a-a11f-2549a078137d",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "80"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# return the first element in the s2 series\n",
    "\n",
    "s2[0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "id": "325c7f72-35e7-40cf-ab84-756ad241ba53",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Subject\n",
       "Science    93\n",
       "Social     78\n",
       "Tamil      85\n",
       "Name: Student Marks, dtype: int64"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# slicing using default integer index\n",
    "# return the elements starting at position one and ending with the element at index 3\n",
    "s2[1:4]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "id": "47f1247d-bbbb-482b-b420-1e26c4acd7a8",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "85"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Slicing using string index\n",
    "# return the element associated with the index 'Tamil'\n",
    "s2['Tamil']\n"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "3818d8c1-bddf-4733-a327-a54251fde82f",
   "metadata": {},
   "source": [
    "## Creating a Series from a Dictionary\n",
    "\n",
    "- A Python dictionary is a data structure which maps keys to a set of values.\n",
    "- A dictionary contains key-value pairs.\n",
    "- A series is similar to a dictionary in a way that it maps given indexes to a set of values.\n",
    "\n",
    "Let's see how to create a series from a dictionary\n",
    "\n",
    "I have a dictionary that represents fruits and prices. Let's create a series from this dictionary"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "id": "e518a820-ab1f-41c1-8740-7df589d2e145",
   "metadata": {},
   "outputs": [],
   "source": [
    "# create a dictionary of fruit names and their prices. Use the values from the article\n",
    "dict_fruits = {'Orange':80,'Mango':70,'Pine apple':60,'Grapes':90}"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "id": "f55a91ad-4954-44a7-ab9e-0dc9f049866f",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Lets convert this dictionary into a series\n",
    "# use the pandas method .Series() \n",
    "fruits=pd.Series(dict_fruits)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "id": "e7ffad90-5e49-46bb-93ba-d6b66682f8b0",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "fruits series are\n",
      " Orange        80\n",
      "Mango         70\n",
      "Pine apple    60\n",
      "Grapes        90\n",
      "dtype: int64\n"
     ]
    }
   ],
   "source": [
    "# print the series\n",
    "print('fruits series are\\n', fruits)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "id": "a4477e73-b2f8-472c-a8ce-d25455fceda0",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "the price of grapes per kg is: 90\n"
     ]
    }
   ],
   "source": [
    "# Slice the series and retrieve price of grapes\n",
    "print('the price of grapes per kg is:',fruits['Grapes'])\n"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "4395fadd-db90-49f7-9ca4-4185e41b3879",
   "metadata": {},
   "source": [
    "# DataFrame\n",
    "\n",
    "## Create a DataFrame from a Series object\n",
    "\n",
    "Let's create a DataFrame from the marks series we created in the above step."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 46,
   "id": "7b8c6007-fb21-4609-b98f-5e8a7359ba42",
   "metadata": {},
   "outputs": [],
   "source": [
    "# create a dataframe from the s2 series\n",
    "df_marks = pd.DataFrame(s2,columns = ['Student'])\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 47,
   "id": "3440fb09-d503-4471-8d68-5fb91c77b0c8",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Student mark series are: Empty DataFrame\n",
      "Columns: [Student]\n",
      "Index: []\n"
     ]
    }
   ],
   "source": [
    "# print the dataframeprint('dataframe created from series',df_marks)\n",
    "\n",
    "print('Student mark series are:', df_marks)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "4b1ea072-e99a-4155-af6d-d02586272089",
   "metadata": {
    "tags": []
   },
   "source": [
    "## Create a DataFrame from a Dictionary\n",
    "\n",
    "Let's say we have 2 series of heights and weights of the same set of persons and we want to put it together in a table.\n",
    "\n",
    "Here we can create dictionary using both series and create a DataFrame using the Pandas ``.DataFrame()`` method."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 49,
   "id": "4ce55704-083e-480d-9acd-44304b341f31",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Create height series using [5.3, 6.2,5.8,5.0,5.5] for values, ['Person 1','Person 2','Person 3','Person 4','Person 5'] for indexes\n",
    "height = pd.Series([5.3,6.2,5.8,5.0,5.5],index = ['Person1','Person2','Person3','Person4','Person5'])\n",
    "\n",
    "# Create weight series (in kgs) using [65,89,75,60,59] for values and the same indexes as height\n",
    "weight= pd.Series([65,89,75,60,59], index = ['Person1','Person2','Person3','Person4','Person5'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 50,
   "id": "1bd7b205-0443-454e-85d5-bcd9e5478aea",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "The Person table details are:n          height  weight\n",
      "Person1     5.3      65\n",
      "Person2     6.2      89\n",
      "Person3     5.8      75\n",
      "Person4     5.0      60\n",
      "Person5     5.5      59\n"
     ]
    }
   ],
   "source": [
    "# Create a dataframe from the height and weight series above\n",
    "person_df = pd.DataFrame({'height':height, 'weight':weight})\n",
    "# print the dataframe\n",
    "print(\"The Person table details are:n\", person_df)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "010a2133",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "4b8b19e9",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "ee3594d6",
   "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.9"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}