{ "cells": [ { "cell_type": "markdown", "metadata": {}, "source": [ "# Day 2 Solutions" ] }, { "cell_type": "code", "execution_count": 2, "metadata": {}, "outputs": [], "source": [ "import pandas as pd\n", "import numpy as np\n", "from matplotlib import pyplot as plt\n", "from time import time" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "### Reading the lens/source catalog" ] }, { "cell_type": "code", "execution_count": 1, "metadata": { "tags": [ "hide_input" ] }, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "ra,dec,z,col_3,col_4,col_5\r\n", "30.611734783139795,-6.3569091978972425,23.901826,23.043298,22.649281,0.5\r\n", "30.61078116389429,-6.350381359287763,22.385773,21.548382,21.272576,0.38\r\n", "30.596477830319948,-6.3461523588063935,23.948118,23.121471,22.773187,0.37\r\n", "30.592680083175416,-6.3445214768250775,23.42731400000001,22.022285999999998,21.334948,0.45\r\n" ] } ], "source": [ "!head -n 5 /home/idies/workspace/Storage/divyar/IAGRG_2022/DataStore/demo_objects.csv\n", "\n", "# !wc -l /home/idies/workspace/Storage/divyar/IAGRG_2022/DataStore/demo_objects.csv" ] }, { "cell_type": "code", "execution_count": 3, "metadata": {}, "outputs": [], "source": [ "#reading lens file\n", "\n", "#tries to read everthing in the file\n", "path=\"/home/idies/workspace/Storage/divyar/IAGRG_2022/DataStore/demo_objects.csv\"\n", "\n", "df = pd.read_csv(path, sep=',')" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "\\# select required columns only" ] }, { "cell_type": "code", "execution_count": 4, "metadata": {}, "outputs": [], "source": [ "df = pd.read_csv(path, sep=',', usecols=[0,1,2])" ] }, { "cell_type": "code", "execution_count": 5, "metadata": { "scrolled": false }, "outputs": [ { "data": { "text/html": [ "
| \n", " | ra | \n", "dec | \n", "z | \n", "
|---|---|---|---|
| 0 | \n", "30.611735 | \n", "-6.356909 | \n", "23.901826 | \n", "
| 1 | \n", "30.610781 | \n", "-6.350381 | \n", "22.385773 | \n", "
| 2 | \n", "30.596478 | \n", "-6.346152 | \n", "23.948118 | \n", "
| 3 | \n", "30.592680 | \n", "-6.344521 | \n", "23.427314 | \n", "
| 4 | \n", "30.601111 | \n", "-6.338650 | \n", "21.660045 | \n", "