01.02b.math-numpy-matplotlib-pandas-exercises.ipynb

{"nbformat":4,"nbformat_minor":0,"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"},"colab":{"name":"01.02b.math-numpy-matplotlib-pandas-exercises.ipynb","provenance":[],"collapsed_sections":[]}},"cells":[{"cell_type":"markdown","metadata":{"id":"DM41t7Xen5Qg","colab_type":"text"},"source":["# Math Exercise\n","\n","Now it's your turn! Go to the Python [Math Docs](https://www.programiz.com/python-programming/modules/math) and select one of the following math functions:\n","\n","- Calculate the area of a triangle \n","     - $area = 1/2 * Base * Height$\n","    \n","- Calculate the area of a circle\n","    - $area = \\pi r^2$\n","    \n","- Calculate the length of an unknown side of a right triangle, given two sides that are known\n","    - $Pythagorean$  $Theorem: a^2 + b^2 = c^2$\n","\n","- Calculate the area of a room\n","    - $area$ = $length$ * $width$"]},{"cell_type":"code","metadata":{"pycharm":{"is_executing":false},"id":"l2BnjLpin5Qp","colab_type":"code","colab":{}},"source":["# Import libraries\n","import math\n","\n","# Area of a triangle\n","def area_of_triangle(base, height):\n","    \"\"\"\n","        Purpose:\n","            - This function is to calculate the area of a triangle\n","\n","        Parameters:\n","            - base (type float)\n","            - height (type float)\n","\n","        Return:\n","            - area_of_triangle (type float)\n","    \"\"\"\n","    area = (base * height) / 2\n","    print(type(area))\n","    return area\n","\n","\n","# Area of a cirlcle\n","def area_of_circle(radius):\n","    \"\"\"\n","        Purpose:\n","            - This function is to calculate the area of a cirlcle\n","\n","        Parameters:\n","            - radius (type float)\n","\n","        Return:\n","            - area_of_circle (type float)\n","    \"\"\"\n","    area = math.pi * math.pow(radius, 2)\n","    print(type(area))\n","    return area\n","\n","\n","# Pythagorean Theorem\n","def length_of_side(side1, side2):\n","    \"\"\"\n","        Purpose:\n","            - This function is to calculate the length of a side of a\n","            right triangle, given the 2 other sides\n","\n","        Parameters:\n","            - side1 (type float)\n","            - side2 (type float)\n","\n","        Return:\n","            - length (type float)\n","    \"\"\"\n","    length = math.pow(side1, 2) + math.pow(side2, 2)\n","    print(type(length))\n","    return math.sqrt(length)\n","    \n","    \n","# Area of a room\n","def area_of_room(length, width):\n","    \"\"\"\n","        Purpose:\n","            - This function is to calculate the area of a room\n","\n","        Parameters:\n","            - length (type float)\n","            - height (type float)\n","\n","        Return:\n","            - area_of_room (type float)\n","    \"\"\"\n","    area = length * width\n","    print(type(area))\n","    return area"],"execution_count":0,"outputs":[]},{"cell_type":"markdown","metadata":{"id":"S0hKXElcn5Qx","colab_type":"text"},"source":["#### Executing the cell below will test the above functions and print the results"]},{"cell_type":"code","metadata":{"id":"9BJ3QDpOn5Qz","colab_type":"code","colab":{}},"source":["# This section is used to test the above math functions\n","# Running cell will output results\n","\n","aot = area_of_triangle(base=10, height=3)\n","print(\"area_of_triangle returned: {}, should've returned 15.0\\n\".format(aot))\n","\n","\n","aoc = area_of_circle(radius=2)\n","print(\"area_of_circle returned: {0:.2f}, should've returned 12.57\\n\".format(aoc))\n","\n","\n","los = length_of_side(side1=12, side2=5)\n","print(\"length_of_side returned: {0:.2f}, should've returned 13.00\\n\".format(los))\n","\n","\n","los = area_of_room(length=4.2, width=5)\n","print(\"area_of_room returned: {0:.2f}, should've returned 21.00\".format(los))"],"execution_count":0,"outputs":[]},{"cell_type":"markdown","metadata":{"id":"QqQw42avn5Q6","colab_type":"text"},"source":["# Numpy & Matplotlib Exercise\n","\n","#### Create 3 separate functions:\n","- First function will return a random number, either zero or one representing heads or tails\n","- Next function will use the first one to simulate n number of coin flips\n","- Last one will incorporate both prior functions to simulate n number of simulations"]},{"cell_type":"code","metadata":{"id":"Zv6buUW-n5Q7","colab_type":"code","colab":{}},"source":["def flip_coin():\n","    \"\"\"\n","        Info:\n","            This function will return a random number, either zero or one, representing heads or tails\n","        Params:\n","            None\n","        Output:\n","            value: Integer\n","    \"\"\"\n","    # YOUR CODE GOES HERE\n","    value = np.random.randint(2)\n","    return value"],"execution_count":0,"outputs":[]},{"cell_type":"code","metadata":{"id":"np3kp5bGn5RB","colab_type":"code","colab":{}},"source":["def coin_game(num_flips):\n","    \"\"\"\n","        Info:\n","            This function will return a list containing integers which represent the results of a coin flip\n","        Params:\n","            num_flips: Integer\n","        Output:\n","            value: List of integers\n","    \"\"\"\n","    # List to save coin flips\n","    value = []\n","    \n","    # Loop thru num_flips\n","    for x in range(num_flips):\n","        # Flip the coin\n","        coin = flip_coin()\n","        # Save coin result to list\n","        value.append(coin)\n","        \n","    # Return list of coin flips\n","    return value"],"execution_count":0,"outputs":[]},{"cell_type":"code","metadata":{"id":"uQhmtCK9n5RG","colab_type":"code","colab":{}},"source":["def run_sims(num_sims, num_flips):\n","    \"\"\"\n","        Info:\n","            This function will execute n number of simulations, n number of flips and returns a list\n","            containing the sum of all times each simulation landed on tails\n","        Params:\n","            num_sims: Integer\n","            num_flips: Integer\n","        Output:\n","            value: List of integers\n","    \"\"\"\n","    # List to save simulations\n","    value = []\n","    \n","    # Loop thru num_sims\n","    for sim in range(num_sims):\n","        \n","        # Create list of coin games\n","        coin_tosses = coin_game(num_flips)\n","        \n","        # Save simulation results filtering by tails\n","        value.append(sum(coin_tosses))\n","    \n","    # Return list of integers, each integer represents the number\n","    # of times the coin landed on tails\n","    return np.array(value)"],"execution_count":0,"outputs":[]},{"cell_type":"markdown","metadata":{"id":"-fuIbZOSn5RL","colab_type":"text"},"source":["### Run Simulation & Plot the distribution"]},{"cell_type":"code","metadata":{"id":"zp8HKFnnn5RN","colab_type":"code","colab":{}},"source":["# Import libraries\n","import numpy as np\n","import matplotlib.pyplot as plt\n","\n","# Simulate 1,000 simulations consisting of 10 flips per simulation\n","all_tails = run_sims(1000, 10)\n","\n","# Plot results\n","plt.hist(all_tails)\n","plt.ylabel(\"Freq of Simulations\")\n","plt.xlabel(\"Tails / Total Flips\")\n","plt.show()"],"execution_count":0,"outputs":[]},{"cell_type":"markdown","metadata":{"id":"odRIIGrEn5RT","colab_type":"text"},"source":["# Pandas Exercise\n","\n","Now it's your turn! Create a function for one of the following:\n","\n","- Renames columns in a dataframe\n","    - [Example](https://chrisalbon.com/python/data_wrangling/pandas_rename_multiple_columns/)\n","    \n","- Drop a row if it contains a certain value\n","    - [Example](https://chrisalbon.com/python/data_wrangling/pandas_dropping_column_and_rows/)\n","    \n","- Sorts records in a dataframe\n","    - [Example](https://chrisalbon.com/python/data_wrangling/pandas_sorting_rows_dataframe/)\n","\n","Go to the [Pandas](https://pandas.pydata.org/pandas-docs/version/0.25) Documentation or [Chris Albon](https://pandas.pydata.org/pandas-docs/version/0.25) site for reference."]},{"cell_type":"code","metadata":{"id":"Q-_yobfYn5RV","colab_type":"code","colab":{}},"source":["def rename_columns(dataframe, column_names):\n","    \"\"\"\n","        Info:\n","            This function will rename all the columns of a pandas dataframe\n","        Params:\n","            dataframe (type: pandas dataframe)\n","            column_names: (type: List)\n","        Output:\n","            dataframe (type: pandas dataframe)\n","    \"\"\"\n","    dataframe.columns = column_names\n","    return dataframe"],"execution_count":0,"outputs":[]},{"cell_type":"code","metadata":{"id":"kx-sZQi4n5RZ","colab_type":"code","colab":{}},"source":["def drop_record_by_value(dataframe, column_name, column_value):\n","    \"\"\"\n","        Info:\n","            This function will drop records that contain a given value in a given column\n","        Params:\n","            dataframe: Target dataframe\n","            column_name: Column of focus\n","            column_value: Target value\n","        Output:\n","            dataframe (type: pandas dataframe)\n","    \"\"\"\n","    new_df = dataframe[dataframe[column_name] != column_value]\n","    return new_df"],"execution_count":0,"outputs":[]},{"cell_type":"code","metadata":{"id":"sOwUZb6Dn5Rd","colab_type":"code","colab":{}},"source":["def sort_records(dataframe, column_name):\n","    \"\"\"\n","        Info:\n","            This function will return a dataframe in sorted order by column name given\n","        Params:\n","            dataframe: (type: pandas dataframe)\n","            column_name: Can be a column name or list of column names to sort by\n","        Output:\n","            dataframe (type: pandas dataframe)\n","    \"\"\"\n","    new_df = dataframe.sort_values(by=column_name)\n","    return new_df"],"execution_count":0,"outputs":[]},{"cell_type":"markdown","metadata":{"id":"hSH3wxivn5Rj","colab_type":"text"},"source":["### Mock data to test Pandas exercise"]},{"cell_type":"code","metadata":{"id":"7_9gr1twn5Rl","colab_type":"code","colab":{}},"source":["# Import libraries\n","import pandas as pd\n","\n","raw_data = {\n","    'first_name': ['Jason', 'Molly', 'Tina', 'Jake', 'Amy'], \n","    'last_name': ['Miller', 'Jacobson', 'Ali', 'Milner', 'Cooze'], \n","    'age': [42, 52, 36, 24, 73], \n","    'preTestScore': [-999, -999, -999, 2, 1],\n","    'postTestScore': [2, 2, -999, 2, -999]}\n","\n","def get_sample_data():\n","    return pd.DataFrame(raw_data, columns = ['first_name', 'last_name', 'age', 'preTestScore', 'postTestScore'])"],"execution_count":0,"outputs":[]},{"cell_type":"markdown","metadata":{"id":"jJGsiFvWn5Rp","colab_type":"text"},"source":["#### Test `rename_columns` function"]},{"cell_type":"code","metadata":{"id":"E6cF7YRwn5Rq","colab_type":"code","colab":{}},"source":["# Get mock data\n","df = get_sample_data()\n","print(\"ORIGINAL DF\\n{}\\n\".format(df.head()))\n","\n","# Set function params\n","names = ['first', 'last', 'age', 'preScore', 'postScore']\n","\n","# Create new df with renamed columns\n","new_df = rename_columns(df, names)\n","\n","print(new_df)"],"execution_count":0,"outputs":[]},{"cell_type":"markdown","metadata":{"id":"7HCuD904n5Rv","colab_type":"text"},"source":["#### Test `drop_record_by_value` function"]},{"cell_type":"code","metadata":{"id":"J8J5qyyWn5Rw","colab_type":"code","colab":{}},"source":["# Get mock data\n","df = get_sample_data()\n","print(\"ORIGINAL DF\\n{}\\n\".format(df.head()))\n","\n","# Set function params\n","column_name = 'age'\n","column_value = 24\n","\n","# Create new df with removed records\n","new_df = drop_record_by_value(df, column_name, column_value)\n","\n","print(new_df)"],"execution_count":0,"outputs":[]},{"cell_type":"markdown","metadata":{"id":"bX7dFuPAn5R0","colab_type":"text"},"source":["#### Test `sort_records` function"]},{"cell_type":"code","metadata":{"id":"LLYXi9thn5R1","colab_type":"code","colab":{}},"source":["# Get mock data\n","df = get_sample_data()\n","print(\"ORIGINAL DF\\n{}\\n\".format(df.head()))\n","\n","# Set function params\n","column_name = 'age'\n","column_names = ['first_name', 'age']\n","\n","# Create new df with sorted records\n","new_df = sort_records(dataframe=df, column_name=column_names)\n","\n","print(\"SORTED DF\\n{}\\n\".format(new_df))"],"execution_count":0,"outputs":[]}]}