{"metadata":{"kernelspec":{"language":"python","display_name":"Python 3","name":"python3"},"language_info":{"pygments_lexer":"ipython3","nbconvert_exporter":"python","version":"3.6.4","file_extension":".py","codemirror_mode":{"name":"ipython","version":3},"name":"python","mimetype":"text/x-python"}},"nbformat_minor":4,"nbformat":4,"cells":[{"cell_type":"code","source":"import numpy as np\nimport pandas as pd\nfrom sklearn.datasets import load_boston","metadata":{"id":"aMABblzxZJkS"},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"data = pd.read_csv('/content/FL_insurance_sampleNEW.csv')\ndata","metadata":{"id":"_OlHxvHCZk7T","outputId":"cfeca2b8-4bc3-4ee9-986b-2a68ed6f391c"},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"data.drop('D', inplace=True, axis=1)\ndata.head()","metadata":{"id":"Fe2F3fMwfsg8","outputId":"9d0b05f5-290f-4711-d066-6b61311823a7"},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"data.drop('C', inplace=True, axis=1)\ndata.head()","metadata":{"id":"jwwbE5Dqh18m","outputId":"42a11f0a-4bc6-4d62-a96d-8768414ca48d"},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"data.drop('A', inplace=True, axis=1)\ndata.head()","metadata":{"id":"ERYOMDmNh5pb","outputId":"4a4c65b6-fcc8-4f3f-9bf5-639513c5a51a"},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"data.drop('B', inplace=True, axis=1)\ndata.head()","metadata":{"id":"RiUO8rYmh8w4","outputId":"3b9fd644-3425-4384-e86a-67e146605998"},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"def outliers(numbers):\n  sorted(numbers)\n  q1 = np.percentile(numbers,25)\n  q3 = np.percentile(numbers,75)\n  Iqr = q3 - q1\n  lr = q1 - (Iqr * 1.5)\n  ur = q3 + (Iqr * 1.5)\n  print(lr,ur)\n  return lr,ur","metadata":{"id":"lJl16_FOiVyz"},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"outliers(data)","metadata":{"id":"awXnjGnGc9sD","outputId":"0a1cdadb-94a4-4084-9b42-818745c6b252"},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"new_data = data[(data['policyID'] < 209900) & (data['policyID'] > -125940)]\nnew_data","metadata":{"id":"Znnqvkrkjuqt","outputId":"2834c40e-7654-4265-f94f-9d712faed219"},"execution_count":null,"outputs":[]}]}