{"metadata":{"kernelspec":{"language":"python","display_name":"Python 3","name":"python3"},"language_info":{"name":"python","version":"3.10.13","mimetype":"text/x-python","codemirror_mode":{"name":"ipython","version":3},"pygments_lexer":"ipython3","nbconvert_exporter":"python","file_extension":".py"},"kaggle":{"accelerator":"none","dataSources":[{"sourceId":70367,"databundleVersionId":9188054,"sourceType":"competition"}],"dockerImageVersionId":30746,"isInternetEnabled":true,"language":"python","sourceType":"notebook","isGpuEnabled":false}},"nbformat_minor":4,"nbformat":4,"cells":[{"cell_type":"markdown","source":"![](https://www.googleapis.com/download/storage/v1/b/kaggle-forum-message-attachments/o/inbox%2F761268%2F449ed3cb8bc43f498fcd917733a33064%2FScreenshot%202024-08-04%20at%209.24.19PM.png?generation=1722786886542329&alt=media)","metadata":{}},{"cell_type":"code","source":"import os\nimport pandas as pd\nimport numpy as np\nimport matplotlib.pyplot as plt\nfrom IPython.core.display import HTML, Markdown\nimport seaborn as sns\nfrom glob import glob\nimport warnings\nwarnings.filterwarnings(\"ignore\", category=FutureWarning)\n\nsns.set(style='whitegrid')\ncomp_dir = \"/kaggle/input/ariel-data-challenge-2024\"","metadata":{"execution":{"iopub.status.busy":"2024-08-10T05:39:17.344733Z","iopub.execute_input":"2024-08-10T05:39:17.345166Z","iopub.status.idle":"2024-08-10T05:39:18.389134Z","shell.execute_reply.started":"2024-08-10T05:39:17.34513Z","shell.execute_reply":"2024-08-10T05:39:18.387966Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"def render(values, style='section', level=1):\n    if style == 'section':\n        #display(Markdown(f'<h{level} class=\"section\">{values}</h{level}>'))\n        pass\n    html = \"\"\n    flag = False\n    for value in values:\n        if style == 'insight':\n            html += f'<ul class=\"bullet\"><li class=\"insight\"> - {value}</li></ul>'\n        if style == 'data-insight':\n            if ':' in value:\n                flag = True\n                html += f'<ul class=\"bullet\"><li class=\"data-insight\"><span>{value.split(\":\")[0]}</span>{value.split(\":\")[1]}</li></ul>'\n            else:\n                html += f'<ul class=\"bullet\"><li class=\"data-insight\">{value}</li></ul>'\n    \n    if flag == True:\n        html += \"<hr>\"\n    display(HTML(html))\ndef css_styling():\n    styles = \"\"\"\n    <style>\n        .section {\n            color:#33A1C9;\n            font-size:20px;\n            font-weight: bold;\n            padding-top:15px;\n        }\n        .sub_section {\n            color:#f1c40f;\n            font-size:16px;\n            font-weight: bold;\n            padding-top:10px;\n        }\n        .insight {\n            color:teal;\n            font-size:14px;\n            font-weight: bold;\n        }\n        .data-insight {\n            background-color: #f9f9f9;\n            border-left: 4px solid #C70039;\n            padding: 8px;\n            margin-top: 5px;\n            font-weight: normal;\n        }\n        .data-insight span{\n            font-weight: bold;\n            display: block;\n        }\n        .bullet {\n            list-style-type: circle;\n        }\n        ul{\n            margin:0px;\n            display: contents;\n            list-style-type: square;\n        }\n    </style>\n    \"\"\"\n    return HTML(styles)\n\ncss_styling()","metadata":{"_uuid":"85b3b6ad-59f7-439f-86e6-6737c9d1f48f","_cell_guid":"ab7811ca-651a-4592-ae44-4ea667b1e545","collapsed":false,"_kg_hide-input":true,"_kg_hide-output":true,"jupyter":{"outputs_hidden":false},"execution":{"iopub.status.busy":"2024-08-10T06:16:11.099643Z","iopub.execute_input":"2024-08-10T06:16:11.100281Z","iopub.status.idle":"2024-08-10T06:16:11.11551Z","shell.execute_reply.started":"2024-08-10T06:16:11.100241Z","shell.execute_reply":"2024-08-10T06:16:11.11418Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"markdown","source":"# 🌑 Files 🌒","metadata":{}},{"cell_type":"code","source":"train_adc_info = pd.read_csv(f'{comp_dir}/train_adc_info.csv')\ntest_adc_info = pd.read_csv(f'{comp_dir}/test_adc_info.csv')\ntrain_labels = pd.read_csv(f'{comp_dir}/train_labels.csv')\nwavelengths = pd.read_csv(f'{comp_dir}/wavelengths.csv')\naxis_info = pd.read_parquet(f'{comp_dir}/axis_info.parquet')\nfiles = [x.replace(f'{comp_dir}/','') for x in sorted(glob(f'{comp_dir}/*.*'))]\nrender(files, 'insight')\nfiles = [x.replace(f'{comp_dir}/','') for x in sorted(glob(f'{comp_dir}/train/100468857/**/*.*', recursive=True))]\nrender(files, 'insight')","metadata":{"_uuid":"0c8b618f-0678-40b9-9aed-f2775207353c","_cell_guid":"2f4cfa82-b121-4b79-b135-e5363307e135","collapsed":false,"jupyter":{"outputs_hidden":false},"execution":{"iopub.status.busy":"2024-08-10T06:16:12.712137Z","iopub.execute_input":"2024-08-10T06:16:12.712677Z","iopub.status.idle":"2024-08-10T06:16:12.843735Z","shell.execute_reply.started":"2024-08-10T06:16:12.712639Z","shell.execute_reply":"2024-08-10T06:16:12.842278Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"render('Exoplanets Folder sizes')\ndef get_exoplanets_sizes(exoplanets_dir):\n    metadata = []\n    for entry in os.scandir(exoplanets_dir):\n        if entry.is_dir():\n            stat = entry.stat()\n            metadata.append({\n                'exoplanet': entry.name,\n                'size': sum(os.path.getsize(os.path.join(dp, f)) for dp, dn, fn in os.walk(entry.path) for f in fn)/(1024**2),\n                'created': pd.to_datetime(stat.st_ctime, unit='s'),\n                'modified': pd.to_datetime(stat.st_mtime, unit='s')\n            })\n    return pd.DataFrame(metadata)\n\n\nexoplanets_meta_df = get_exoplanets_sizes(f\"{comp_dir}/train/\")\nexoplanets_meta_df.head()","metadata":{"_uuid":"b00ff733-277a-4597-be46-c83a423b72d2","_cell_guid":"042946f4-ba7e-4da3-8508-e3e6852c1a41","collapsed":false,"jupyter":{"outputs_hidden":false},"execution":{"iopub.status.busy":"2024-08-10T06:16:14.006711Z","iopub.execute_input":"2024-08-10T06:16:14.007256Z","iopub.status.idle":"2024-08-10T06:16:29.860582Z","shell.execute_reply.started":"2024-08-10T06:16:14.007219Z","shell.execute_reply":"2024-08-10T06:16:29.859414Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"exoplanets_meta_df['ctime'] = exoplanets_meta_df['created'].dt.time\nexoplanets_meta_df['mtime'] = exoplanets_meta_df['modified'].dt.time\nexoplanets_meta_df = exoplanets_meta_df.sort_values(by=['exoplanet'])\nexoplanets_meta_df","metadata":{"_uuid":"7c56fda4-a2b1-4bd6-b462-8d046238c84e","_cell_guid":"16be969d-946d-493e-b78b-13fc700227ea","collapsed":false,"jupyter":{"outputs_hidden":false},"execution":{"iopub.status.busy":"2024-08-10T06:16:29.862842Z","iopub.execute_input":"2024-08-10T06:16:29.863276Z","iopub.status.idle":"2024-08-10T06:16:29.890306Z","shell.execute_reply.started":"2024-08-10T06:16:29.863244Z","shell.execute_reply":"2024-08-10T06:16:29.888906Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"sns.boxplot(x=exoplanets_meta_df['size'])","metadata":{"_uuid":"ab474819-0a66-46a7-9219-17460bc4330f","_cell_guid":"df8b6274-abaa-4328-903e-80c98f6d36f7","collapsed":false,"jupyter":{"outputs_hidden":false},"execution":{"iopub.status.busy":"2024-08-10T06:16:29.892179Z","iopub.execute_input":"2024-08-10T06:16:29.892716Z","iopub.status.idle":"2024-08-10T06:16:30.171811Z","shell.execute_reply.started":"2024-08-10T06:16:29.892678Z","shell.execute_reply":"2024-08-10T06:16:30.170436Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"exoplanets_meta_df['ctimestamp'] = exoplanets_meta_df['created'].astype('int64') // 10**9\nexoplanets_meta_df['mtimestamp'] = exoplanets_meta_df['modified'].astype('int64') // 10**9\nplt.figure(figsize=(10, 25))\nplt.plot(exoplanets_meta_df['ctimestamp'], exoplanets_meta_df['exoplanet'])\nplt.show()","metadata":{"_uuid":"8ea163ec-ed2f-4a1e-9d4b-9408e9dfd83b","_cell_guid":"7d47b7bf-5a95-45bd-bfc2-afab2557ee9a","collapsed":false,"jupyter":{"outputs_hidden":false},"execution":{"iopub.status.busy":"2024-08-10T05:39:25.677314Z","iopub.execute_input":"2024-08-10T05:39:25.677679Z","iopub.status.idle":"2024-08-10T05:39:30.32656Z","shell.execute_reply.started":"2024-08-10T05:39:25.677649Z","shell.execute_reply":"2024-08-10T05:39:30.325243Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"exoplanets_meta_df['size'].describe()\nrender(['Size: ~250Mb per explanet', 'Correlation?: name correlate with created timestamp', 'Size Bins: 242-244Mb, 250-252Mb'], 'data-insight')","metadata":{"_uuid":"a6ff07c4-86e2-4b60-8494-cbbe916f877a","_cell_guid":"2e0d3290-fc80-403d-abe9-b8acdecfa8ab","collapsed":false,"jupyter":{"outputs_hidden":false},"execution":{"iopub.status.busy":"2024-08-10T05:39:30.328604Z","iopub.execute_input":"2024-08-10T05:39:30.32903Z","iopub.status.idle":"2024-08-10T05:39:30.343017Z","shell.execute_reply.started":"2024-08-10T05:39:30.328994Z","shell.execute_reply":"2024-08-10T05:39:30.340646Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"markdown","source":"# 🌒 ADC Info 🌓","metadata":{}},{"cell_type":"code","source":"test_adc_info.head(5)","metadata":{"_uuid":"a166d129-95bc-4d62-83f5-4a778744dc66","_cell_guid":"cca6ae2a-68f4-4ad7-a604-a1659fcaa3cd","collapsed":false,"jupyter":{"outputs_hidden":false},"execution":{"iopub.status.busy":"2024-08-10T05:39:30.345209Z","iopub.execute_input":"2024-08-10T05:39:30.34571Z","iopub.status.idle":"2024-08-10T05:39:30.363294Z","shell.execute_reply.started":"2024-08-10T05:39:30.345673Z","shell.execute_reply":"2024-08-10T05:39:30.361987Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"train_adc_info.describe()","metadata":{"_uuid":"ab0cde5a-9410-4bff-8a93-43381f7ddb15","_cell_guid":"20b297dc-fe94-4b63-b4cf-cdf4028afaee","collapsed":false,"jupyter":{"outputs_hidden":false},"execution":{"iopub.status.busy":"2024-08-10T05:39:30.369161Z","iopub.execute_input":"2024-08-10T05:39:30.369904Z","iopub.status.idle":"2024-08-10T05:39:30.40771Z","shell.execute_reply.started":"2024-08-10T05:39:30.369863Z","shell.execute_reply":"2024-08-10T05:39:30.40643Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"render(['Exoplanets:673', 'Sensors: FGS1 & CH0', 'Stars: 2', 'Sensor Data: Gain & Offsets'], 'data-insight')","metadata":{"_uuid":"448a3a94-74da-4303-96d5-54c4020119e1","_cell_guid":"aa91c440-d286-4604-86b6-8b1fb9e474d5","collapsed":false,"_kg_hide-input":true,"jupyter":{"outputs_hidden":false},"execution":{"iopub.status.busy":"2024-08-10T05:39:30.409792Z","iopub.execute_input":"2024-08-10T05:39:30.410262Z","iopub.status.idle":"2024-08-10T05:39:30.419078Z","shell.execute_reply.started":"2024-08-10T05:39:30.410223Z","shell.execute_reply":"2024-08-10T05:39:30.417421Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"train_adc_info.replace([np.inf, -np.inf], np.nan, inplace=True)\nplt.figure(figsize=(20, 10))\n\nplt.subplot(2, 2, 1)\nsns.histplot(train_adc_info['FGS1_adc_offset'], kde=True, bins=30, color='teal')\nplt.xlabel('FGS1 Offset')\nplt.ylabel('freq')\n\nplt.subplot(2, 2, 2)\nsns.histplot(train_adc_info['FGS1_adc_gain'], kde=True, bins=15, color='orange')\nplt.xlabel('FGS1 Gain')\nplt.ylabel('freq')\n\nplt.subplot(2, 2, 3)\nsns.histplot(train_adc_info['AIRS-CH0_adc_offset'], kde=True, bins=30, color='purple')\nplt.xlabel('CH0 Offset')\nplt.ylabel('freq')\n\nplt.subplot(2, 2, 4)\nsns.histplot(train_adc_info['AIRS-CH0_adc_gain'], kde=True, bins=15, color='green')\nplt.xlabel('CH0 Gain')\nplt.ylabel('freq')\n\nplt.show()","metadata":{"_uuid":"313e8a6d-b23d-4fea-9582-b310169efb46","_cell_guid":"21f3abb8-8fc2-4715-80c9-3635929e14c1","collapsed":false,"jupyter":{"outputs_hidden":false},"execution":{"iopub.status.busy":"2024-08-10T05:39:30.420682Z","iopub.execute_input":"2024-08-10T05:39:30.421155Z","iopub.status.idle":"2024-08-10T05:39:32.235197Z","shell.execute_reply.started":"2024-08-10T05:39:30.421116Z","shell.execute_reply":"2024-08-10T05:39:32.233991Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"render(['FGS1 Offsets: -325 to -425', 'CH0 Offsets: -700 to -1000', 'FGS1 Gains: 5 values', 'CH0 Gains: 2 values'], 'data-insight')","metadata":{"_uuid":"2b77c3fd-4162-43ea-9cde-109b43a46abb","_cell_guid":"849ef50d-c4bd-40c1-a234-57171edd089c","collapsed":false,"_kg_hide-input":true,"jupyter":{"outputs_hidden":false},"execution":{"iopub.status.busy":"2024-08-10T05:39:32.236812Z","iopub.execute_input":"2024-08-10T05:39:32.237188Z","iopub.status.idle":"2024-08-10T05:39:32.245439Z","shell.execute_reply.started":"2024-08-10T05:39:32.237158Z","shell.execute_reply":"2024-08-10T05:39:32.243968Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"markdown","source":"# 🌓 Train Labels 🌔","metadata":{}},{"cell_type":"code","source":"train_labels.shape","metadata":{"_uuid":"7cf72bd9-a33e-49d3-9dce-504caa356f52","_cell_guid":"39a0b97c-a806-4760-97e2-40de83e3b0aa","collapsed":false,"jupyter":{"outputs_hidden":false},"execution":{"iopub.status.busy":"2024-08-10T05:39:32.246655Z","iopub.execute_input":"2024-08-10T05:39:32.247052Z","iopub.status.idle":"2024-08-10T05:39:32.259786Z","shell.execute_reply.started":"2024-08-10T05:39:32.247019Z","shell.execute_reply":"2024-08-10T05:39:32.258467Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"train_labels.head(5)","metadata":{"_uuid":"21e9a503-7f7a-4007-b8f9-f061192c48d5","_cell_guid":"e7e1f58e-4b67-41b2-b7d3-6b284b20db2a","collapsed":false,"jupyter":{"outputs_hidden":false},"execution":{"iopub.status.busy":"2024-08-10T05:39:32.26117Z","iopub.execute_input":"2024-08-10T05:39:32.261572Z","iopub.status.idle":"2024-08-10T05:39:32.293801Z","shell.execute_reply.started":"2024-08-10T05:39:32.261539Z","shell.execute_reply":"2024-08-10T05:39:32.292644Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"train_labels.describe()","metadata":{"_uuid":"2e36e7a8-883b-400d-9f96-e8adc656f765","_cell_guid":"b355ab84-0c1b-480a-b02f-5dc509695a44","collapsed":false,"jupyter":{"outputs_hidden":false},"execution":{"iopub.status.busy":"2024-08-10T05:39:32.295464Z","iopub.execute_input":"2024-08-10T05:39:32.295927Z","iopub.status.idle":"2024-08-10T05:39:32.873416Z","shell.execute_reply.started":"2024-08-10T05:39:32.295885Z","shell.execute_reply":"2024-08-10T05:39:32.87216Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"%%time\nplt.figure(figsize=(20, 6))\nsns.histplot(train_labels['wl_1'], bins=30, kde=True)\nplt.title('wl_1')\nplt.ylabel('freq')\nplt.show()\n\nplt.figure(figsize=(20, 6))\nsns.histplot(train_labels['wl_183'], bins=30, kde=True)\nplt.title('wl_183')\nplt.ylabel('freq')\nplt.show()","metadata":{"_uuid":"ce7dcea4-7375-4314-bd82-8f2f7c8acf3b","_cell_guid":"f84bdce1-4606-4e05-86c9-277755ec1e81","collapsed":false,"jupyter":{"outputs_hidden":false},"execution":{"iopub.status.busy":"2024-08-10T05:39:32.875082Z","iopub.execute_input":"2024-08-10T05:39:32.875671Z","iopub.status.idle":"2024-08-10T05:39:34.192638Z","shell.execute_reply.started":"2024-08-10T05:39:32.875629Z","shell.execute_reply":"2024-08-10T05:39:34.191437Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"plt.figure(figsize=(16, 32))\ncorrelation_matrix = train_labels[[col for col in train_labels.columns if 'wl_' in col]].corr()\nsns.heatmap(correlation_matrix, annot=True, fmt=\".2f\", cmap='coolwarm')\nplt.title('Corr Wavelengths')\nplt.show()","metadata":{"_uuid":"f6ee73f4-7b4d-4a0c-a6b2-dce26f2f8003","_cell_guid":"a3980eaa-c0ab-40c6-9837-8075eeb9a014","collapsed":false,"jupyter":{"outputs_hidden":false},"execution":{"iopub.status.busy":"2024-08-10T05:39:34.194325Z","iopub.execute_input":"2024-08-10T05:39:34.19532Z","iopub.status.idle":"2024-08-10T05:42:13.142623Z","shell.execute_reply.started":"2024-08-10T05:39:34.195276Z","shell.execute_reply":"2024-08-10T05:42:13.14124Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"render(['is targets too correlate each other?: each wl well correlate with few wl itself'], 'data-insight')","metadata":{"_uuid":"457a31fe-2e51-40ce-8fe2-16c495e04b40","_cell_guid":"e277a6b9-7250-48b0-ad68-e4056e3c4fef","collapsed":false,"jupyter":{"outputs_hidden":false},"execution":{"iopub.status.busy":"2024-08-10T05:42:13.144117Z","iopub.execute_input":"2024-08-10T05:42:13.14447Z","iopub.status.idle":"2024-08-10T05:42:13.151965Z","shell.execute_reply.started":"2024-08-10T05:42:13.14444Z","shell.execute_reply":"2024-08-10T05:42:13.150898Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"from sklearn.manifold import TSNE\nX = train_labels.drop('planet_id', axis=1)\nids = train_labels['planet_id']\ntsne = TSNE(n_components=2, random_state=42)\nX_tsne = tsne.fit_transform(X)\n\npalette = sns.color_palette(\"hsv\", len(ids))\ncolor_map = {planet_id: palette[i] for i, planet_id in enumerate(ids)}\n\ncluster_df = pd.DataFrame(X_tsne, columns=['TSNE1', 'TSNE2'])\ncluster_df['planet_id'] = ids\nplt.figure(figsize=(20, 50))\nplt.scatter(cluster_df['TSNE1'], cluster_df['TSNE2'], alpha=0.6, label='platent_id', color=palette)\nplt.show()","metadata":{"_uuid":"b729d6cc-6856-4e5b-a7d5-33c497def412","_cell_guid":"ed805bf3-2cce-4082-9be2-e38bfd4ca807","collapsed":false,"jupyter":{"outputs_hidden":false},"execution":{"iopub.status.busy":"2024-08-10T05:42:13.153459Z","iopub.execute_input":"2024-08-10T05:42:13.153784Z","iopub.status.idle":"2024-08-10T05:42:16.965087Z","shell.execute_reply.started":"2024-08-10T05:42:13.153755Z","shell.execute_reply":"2024-08-10T05:42:16.963987Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"render(['Exoplanets: is exoplanets making sign curve as per the wavelenghts? - pattern clusters'], 'data-insight')","metadata":{"_uuid":"83c05089-d12c-47a3-9472-85c52b1d472c","_cell_guid":"e58adaf5-c279-4e20-bebc-05ccc7725025","collapsed":false,"jupyter":{"outputs_hidden":false},"execution":{"iopub.status.busy":"2024-08-10T05:42:16.966518Z","iopub.execute_input":"2024-08-10T05:42:16.966899Z","iopub.status.idle":"2024-08-10T05:42:16.973897Z","shell.execute_reply.started":"2024-08-10T05:42:16.966868Z","shell.execute_reply":"2024-08-10T05:42:16.972837Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"unique_means = sorted(list(set([round(x,5) for x in list(train_labels.describe().loc[['mean']].values)[0][1:]])))\nunique_std = sorted(list(set([round(x,5) for x in list(train_labels.describe().loc[['std']].values)[0][1:]])))\nrender(['Targets: wl_1 to wl_283', f'Means: {unique_means}', f'Std: {unique_std}'], 'data-insight')","metadata":{"_uuid":"cc41a62b-2da8-4b5f-97c6-4ccc67bede03","_cell_guid":"a7d104eb-1ceb-4ba1-b8ff-b5e9b6f72813","collapsed":false,"_kg_hide-input":true,"jupyter":{"outputs_hidden":false},"execution":{"iopub.status.busy":"2024-08-10T05:42:16.975608Z","iopub.execute_input":"2024-08-10T05:42:16.975956Z","iopub.status.idle":"2024-08-10T05:42:18.019775Z","shell.execute_reply.started":"2024-08-10T05:42:16.975927Z","shell.execute_reply":"2024-08-10T05:42:18.018512Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"markdown","source":"# 🌔 Wavelenghts & Axis Info 🌕","metadata":{}},{"cell_type":"code","source":"wavelengths.head(5)","metadata":{"_uuid":"31bd82fc-dc0b-4495-98a1-324361329b3e","_cell_guid":"54953448-e32c-42ac-868c-1a1078832302","collapsed":false,"jupyter":{"outputs_hidden":false},"execution":{"iopub.status.busy":"2024-08-10T05:42:18.021326Z","iopub.execute_input":"2024-08-10T05:42:18.021736Z","iopub.status.idle":"2024-08-10T05:42:18.047655Z","shell.execute_reply.started":"2024-08-10T05:42:18.021705Z","shell.execute_reply":"2024-08-10T05:42:18.046297Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"wavelengths.T.describe()","metadata":{"_uuid":"a01ab620-abca-4f56-a37e-ac2f934c0e3d","_cell_guid":"96d57c7f-9407-4b0d-9b58-08c33749f251","collapsed":false,"jupyter":{"outputs_hidden":false},"execution":{"iopub.status.busy":"2024-08-10T05:42:18.049287Z","iopub.execute_input":"2024-08-10T05:42:18.049705Z","iopub.status.idle":"2024-08-10T05:42:18.069472Z","shell.execute_reply.started":"2024-08-10T05:42:18.049673Z","shell.execute_reply":"2024-08-10T05:42:18.068179Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"wavelengths_diff = sorted(list(set([ round(x[0],4) for x in list(wavelengths.T.diff().values) ])))\nrender(['wavelengths: 283', 'min wavelenght: 0.705', 'max wavelenght: 3.895036', f'wavelenght diff: {wavelengths_diff}'], 'data-insight')","metadata":{"_uuid":"0873b1bf-8f62-4b53-84a1-48b46eb3ec4b","_cell_guid":"86896f48-e173-4659-8eeb-0ca5e00c1bac","collapsed":false,"_kg_hide-input":true,"jupyter":{"outputs_hidden":false},"execution":{"iopub.status.busy":"2024-08-10T05:42:18.071027Z","iopub.execute_input":"2024-08-10T05:42:18.071491Z","iopub.status.idle":"2024-08-10T05:42:18.085407Z","shell.execute_reply.started":"2024-08-10T05:42:18.071452Z","shell.execute_reply":"2024-08-10T05:42:18.084107Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"axis_info.head(5)","metadata":{"_uuid":"93c2d131-7e40-4456-854f-224eaac19fdb","_cell_guid":"3453f5bf-839d-4fda-8c47-c848ce15f111","collapsed":false,"jupyter":{"outputs_hidden":false},"execution":{"iopub.status.busy":"2024-08-10T05:42:18.086868Z","iopub.execute_input":"2024-08-10T05:42:18.087261Z","iopub.status.idle":"2024-08-10T05:42:18.104839Z","shell.execute_reply.started":"2024-08-10T05:42:18.087231Z","shell.execute_reply":"2024-08-10T05:42:18.103524Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"axis_info.shape","metadata":{"_uuid":"92f803fd-d9fe-4e1c-9963-64315b6a6951","_cell_guid":"2c377949-536b-421b-899c-2df808c09cff","collapsed":false,"jupyter":{"outputs_hidden":false},"execution":{"iopub.status.busy":"2024-08-10T05:42:18.106466Z","iopub.execute_input":"2024-08-10T05:42:18.106917Z","iopub.status.idle":"2024-08-10T05:42:18.118011Z","shell.execute_reply.started":"2024-08-10T05:42:18.106877Z","shell.execute_reply":"2024-08-10T05:42:18.116717Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"axis_info.describe()","metadata":{"_uuid":"dd65e2e3-b738-48eb-8581-ee391bfb5bec","_cell_guid":"5d7ef51c-36b0-42bc-bb7c-f943bb52cfb6","collapsed":false,"jupyter":{"outputs_hidden":false},"execution":{"iopub.status.busy":"2024-08-10T05:42:18.126255Z","iopub.execute_input":"2024-08-10T05:42:18.126782Z","iopub.status.idle":"2024-08-10T05:42:18.165903Z","shell.execute_reply.started":"2024-08-10T05:42:18.12675Z","shell.execute_reply":"2024-08-10T05:42:18.164739Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"plt.figure(figsize=(20, 5))\n\nplt.plot(axis_info['AIRS-CH0-axis0-h'], label='AIRS-CH0-axis0-h', color='blue')\nplt.plot(axis_info['FGS1-axis0-h'], label='FGS1-axis0-h', color='red')\nplt.show()","metadata":{"_uuid":"ef01795d-67c4-4152-895e-7f174bf7eb24","_cell_guid":"f017c63b-9f30-4d90-a11b-de3a39565a66","collapsed":false,"jupyter":{"outputs_hidden":false},"execution":{"iopub.status.busy":"2024-08-10T05:42:18.167432Z","iopub.execute_input":"2024-08-10T05:42:18.167886Z","iopub.status.idle":"2024-08-10T05:42:18.521922Z","shell.execute_reply.started":"2024-08-10T05:42:18.167845Z","shell.execute_reply":"2024-08-10T05:42:18.520665Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"render([\"Axis: AIRS-CH0-axis0-h, AIRS-CH0-axis2-um, AIRS-CH0-integration_time, FGS1-axis0-h\", \"Total CHO: 11_250\",\"Total FGS1: 135_000\", \"Both FGS1 & CHO: Start at 0 and ends at ~7.5\"], \"data-insight\")","metadata":{"_uuid":"8220991d-5da3-4615-89de-f7e8fa67cf54","_cell_guid":"1f7a4811-1599-4c40-a5da-caf0a59ee034","collapsed":false,"_kg_hide-input":true,"jupyter":{"outputs_hidden":false},"execution":{"iopub.status.busy":"2024-08-10T05:42:18.523667Z","iopub.execute_input":"2024-08-10T05:42:18.524037Z","iopub.status.idle":"2024-08-10T05:42:18.53124Z","shell.execute_reply.started":"2024-08-10T05:42:18.524006Z","shell.execute_reply":"2024-08-10T05:42:18.530151Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"markdown","source":"# 🌕 FGS1 & CH0 Signal 🌖","metadata":{}},{"cell_type":"code","source":"render(\"FGS1 Signal\")\nfgs1_signal_path = f'{comp_dir}/train/100468857/FGS1_signal.parquet'\nfgs1_signal_df = pd.read_parquet(fgs1_signal_path)\n\nfgs1_signal_df.replace([np.inf, -np.inf], np.nan, inplace=True)\n\nfgs1_signal_df.head()","metadata":{"_uuid":"c8fa9742-95fe-487d-9b29-1e712873c27e","_cell_guid":"4a3682c9-d150-4202-9125-02f777f0ac07","collapsed":false,"jupyter":{"outputs_hidden":false},"execution":{"iopub.status.busy":"2024-08-10T06:16:38.121249Z","iopub.execute_input":"2024-08-10T06:16:38.121811Z","iopub.status.idle":"2024-08-10T06:16:38.819746Z","shell.execute_reply.started":"2024-08-10T06:16:38.121776Z","shell.execute_reply":"2024-08-10T06:16:38.818438Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"fgs1_signal_df.describe()","metadata":{"_uuid":"800eba8e-7c5b-47b6-af87-39ae2692108d","_cell_guid":"d2ccaa47-6df5-4f0b-9673-b4e3731de008","collapsed":false,"jupyter":{"outputs_hidden":false},"execution":{"iopub.status.busy":"2024-08-10T06:16:39.85708Z","iopub.execute_input":"2024-08-10T06:16:39.857633Z","iopub.status.idle":"2024-08-10T06:16:46.22594Z","shell.execute_reply.started":"2024-08-10T06:16:39.857592Z","shell.execute_reply":"2024-08-10T06:16:46.224621Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"fgs1_image = fgs1_signal_df.iloc[0, :].values.reshape(32, 32)\nplt.figure(figsize=(10, 10))\nplt.imshow(fgs1_image, cmap='inferno')\nplt.colorbar()\nplt.show()","metadata":{"_uuid":"aa014c58-ee18-4b49-acbf-dd6b3cdc29db","_cell_guid":"3009dc80-c254-4f57-89e3-5c838013312b","collapsed":false,"jupyter":{"outputs_hidden":false},"execution":{"iopub.status.busy":"2024-08-10T06:16:46.228611Z","iopub.execute_input":"2024-08-10T06:16:46.229684Z","iopub.status.idle":"2024-08-10T06:16:46.688141Z","shell.execute_reply.started":"2024-08-10T06:16:46.229635Z","shell.execute_reply":"2024-08-10T06:16:46.686897Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"render(\"CH0 Signal\")\nch0_signal_path = f'{comp_dir}/train/100468857/AIRS-CH0_signal.parquet'\nch0_signal_df = pd.read_parquet(ch0_signal_path)\n\nch0_signal_df.replace([np.inf, -np.inf], np.nan, inplace=True)\n\nch0_signal_df.head()","metadata":{"_uuid":"42743c2e-3f0a-4419-a5c4-0311dfdd3300","_cell_guid":"47920aa0-d147-4b32-b62e-371ef522fd5c","collapsed":false,"jupyter":{"outputs_hidden":false},"execution":{"iopub.status.busy":"2024-08-10T06:16:46.690127Z","iopub.execute_input":"2024-08-10T06:16:46.690676Z","iopub.status.idle":"2024-08-10T06:16:48.192085Z","shell.execute_reply.started":"2024-08-10T06:16:46.690616Z","shell.execute_reply":"2024-08-10T06:16:48.190719Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"ch0_signal_df.describe()","metadata":{"_uuid":"7730d457-30bc-414c-b62e-248abe582e77","_cell_guid":"ed2e37ca-9e16-4e82-b81b-e2ee6706b6c1","collapsed":false,"jupyter":{"outputs_hidden":false},"execution":{"iopub.status.busy":"2024-08-10T06:16:48.195917Z","iopub.execute_input":"2024-08-10T06:16:48.196672Z","iopub.status.idle":"2024-08-10T06:17:19.088301Z","shell.execute_reply.started":"2024-08-10T06:16:48.196632Z","shell.execute_reply":"2024-08-10T06:17:19.086977Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"ch0_image = ch0_signal_df.iloc[0, :].values.reshape(32, 356)\n\nplt.figure(figsize=(20, 5))\nplt.imshow(ch0_image, cmap='viridis')\nplt.colorbar()\nplt.show()","metadata":{"_uuid":"c0a2c87d-4651-4413-8999-e7afd9214cb4","_cell_guid":"0add4cc1-b832-40f0-ace8-bcb020fb6d00","collapsed":false,"jupyter":{"outputs_hidden":false},"execution":{"iopub.status.busy":"2024-08-10T06:17:19.090205Z","iopub.execute_input":"2024-08-10T06:17:19.09072Z","iopub.status.idle":"2024-08-10T06:17:19.56752Z","shell.execute_reply.started":"2024-08-10T06:17:19.090682Z","shell.execute_reply":"2024-08-10T06:17:19.566029Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"markdown","source":"# 🌖 Calibrations 🌗","metadata":{}},{"cell_type":"code","source":"render(\"CH0 Dark\")\nch0_dark_path = f'{comp_dir}/train/100468857/AIRS-CH0_calibration/dark.parquet'\nch0_dark_df = pd.read_parquet(ch0_dark_path)\nch0_dark_df.replace([np.inf, -np.inf], np.nan, inplace=True)\n\nch0_dark_df.head()","metadata":{"_uuid":"3fc468d6-c241-4dcc-aa48-f9dcd5484648","_cell_guid":"bb872f18-39cf-4772-a7aa-1d2a32c7c51e","collapsed":false,"jupyter":{"outputs_hidden":false},"execution":{"iopub.status.busy":"2024-08-10T06:17:19.569282Z","iopub.execute_input":"2024-08-10T06:17:19.569745Z","iopub.status.idle":"2024-08-10T06:17:19.636719Z","shell.execute_reply.started":"2024-08-10T06:17:19.569709Z","shell.execute_reply":"2024-08-10T06:17:19.635246Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"ch0_dark_df.describe()","metadata":{"_uuid":"deca7385-ac77-4564-88e0-f80e171007a4","_cell_guid":"52f35216-b7ec-4664-b6f8-82438f7aafa9","collapsed":false,"jupyter":{"outputs_hidden":false},"execution":{"iopub.status.busy":"2024-08-10T06:17:19.638226Z","iopub.execute_input":"2024-08-10T06:17:19.638631Z","iopub.status.idle":"2024-08-10T06:17:20.429677Z","shell.execute_reply.started":"2024-08-10T06:17:19.638599Z","shell.execute_reply":"2024-08-10T06:17:20.428333Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"render(\"CH0 Dead\")\nch0_dead_path = f'{comp_dir}/train/100468857/AIRS-CH0_calibration/dead.parquet'\nch0_dead_df = pd.read_parquet(ch0_dead_path)\nch0_dead_df.replace([np.inf, -np.inf], np.nan, inplace=True)\ndisplay(ch0_dead_df.shape)\ndisplay(ch0_dead_df.head())\n\ndisplay(ch0_dead_df.describe())\n\ncho_dead_image = ch0_dead_df.iloc[0, :].values.reshape(1, 356)\n\nplt.figure(figsize=(12, 6))\nplt.imshow(cho_dead_image, cmap='cividis')\nplt.colorbar()\nplt.show()","metadata":{"_uuid":"c4056a65-16f1-4266-a558-fd1a15260495","_cell_guid":"c63f9321-b4ee-4664-afa1-77345206705d","collapsed":false,"jupyter":{"outputs_hidden":false},"execution":{"iopub.status.busy":"2024-08-10T06:17:20.43152Z","iopub.execute_input":"2024-08-10T06:17:20.432056Z","iopub.status.idle":"2024-08-10T06:17:21.393408Z","shell.execute_reply.started":"2024-08-10T06:17:20.432011Z","shell.execute_reply":"2024-08-10T06:17:21.392001Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"render(\"CH0 Dead\")\nch0_flat_path = f'{comp_dir}/train/100468857/AIRS-CH0_calibration/flat.parquet'\nch0_flat_df = pd.read_parquet(ch0_flat_path)\nch0_flat_df.replace([np.inf, -np.inf], np.nan, inplace=True)\ndisplay(ch0_flat_df.shape)\ndisplay(ch0_flat_df.head())\n\ndisplay(ch0_flat_df.describe())\n\ncho_flat_image = ch0_flat_df.iloc[0, :].values.reshape(1, 356)\n\nplt.figure(figsize=(12, 6))\nplt.imshow(cho_flat_image, cmap='cividis')\nplt.colorbar()\nplt.show()","metadata":{"execution":{"iopub.status.busy":"2024-08-10T06:17:21.395239Z","iopub.execute_input":"2024-08-10T06:17:21.395749Z","iopub.status.idle":"2024-08-10T06:17:22.536161Z","shell.execute_reply.started":"2024-08-10T06:17:21.395713Z","shell.execute_reply":"2024-08-10T06:17:22.534672Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"render(\"CH0 Dead\")\nch0_corr_path = f'{comp_dir}/train/100468857/AIRS-CH0_calibration/linear_corr.parquet'\nch0_corr_df = pd.read_parquet(ch0_corr_path)\nch0_corr_df.replace([np.inf, -np.inf], np.nan, inplace=True)\ndisplay(ch0_corr_df.shape)\ndisplay(ch0_corr_df.head())\n\ndisplay(ch0_corr_df.describe())\n\ncho_corr_image = ch0_corr_df.iloc[0, :].values.reshape(1, 356)\n\nplt.figure(figsize=(12, 6))\nplt.imshow(cho_corr_image, cmap='cividis')\nplt.colorbar()\nplt.show()","metadata":{"execution":{"iopub.status.busy":"2024-08-10T06:17:22.541384Z","iopub.execute_input":"2024-08-10T06:17:22.541788Z","iopub.status.idle":"2024-08-10T06:17:23.905947Z","shell.execute_reply.started":"2024-08-10T06:17:22.541757Z","shell.execute_reply":"2024-08-10T06:17:23.904597Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"render(\"CH0 Dead\")\nch0_read_path = f'{comp_dir}/train/100468857/AIRS-CH0_calibration/read.parquet'\nch0_read_df = pd.read_parquet(ch0_read_path)\nch0_read_df.replace([np.inf, -np.inf], np.nan, inplace=True)\ndisplay(ch0_read_df.shape)\ndisplay(ch0_read_df.head())\n\ndisplay(ch0_read_df.describe())\n\ncho_read_image = ch0_read_df.iloc[0, :].values.reshape(1, 356)\n\nplt.figure(figsize=(12, 6))\nplt.imshow(cho_read_image, cmap='cividis')\nplt.colorbar()\nplt.show()","metadata":{"execution":{"iopub.status.busy":"2024-08-10T06:17:23.907898Z","iopub.execute_input":"2024-08-10T06:17:23.908306Z","iopub.status.idle":"2024-08-10T06:17:25.049851Z","shell.execute_reply.started":"2024-08-10T06:17:23.908273Z","shell.execute_reply":"2024-08-10T06:17:25.048672Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"markdown","source":"# 🌗 Stars 🌘","metadata":{}},{"cell_type":"code","source":"train_adc_info['star'] =  train_adc_info['star'].apply(lambda x: f'Star {x}')","metadata":{"execution":{"iopub.status.busy":"2024-08-10T06:17:25.051333Z","iopub.execute_input":"2024-08-10T06:17:25.051736Z","iopub.status.idle":"2024-08-10T06:17:25.059544Z","shell.execute_reply.started":"2024-08-10T06:17:25.051703Z","shell.execute_reply":"2024-08-10T06:17:25.058284Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"train_adc_info.groupby('star')['planet_id'].count()","metadata":{"execution":{"iopub.status.busy":"2024-08-10T06:17:25.06128Z","iopub.execute_input":"2024-08-10T06:17:25.062308Z","iopub.status.idle":"2024-08-10T06:17:25.0774Z","shell.execute_reply.started":"2024-08-10T06:17:25.062267Z","shell.execute_reply":"2024-08-10T06:17:25.076165Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"star_0_planets = set(train_adc_info[train_adc_info['star'] == 0]['planet_id'])\nstar_1_planets = set(train_adc_info[train_adc_info['star'] == 1]['planet_id'])\n\n\"Total common planets between 2 stars :\", len(star_0_planets.intersection(star_1_planets))","metadata":{"execution":{"iopub.status.busy":"2024-08-10T06:17:25.079064Z","iopub.execute_input":"2024-08-10T06:17:25.079522Z","iopub.status.idle":"2024-08-10T06:17:25.092552Z","shell.execute_reply.started":"2024-08-10T06:17:25.079483Z","shell.execute_reply":"2024-08-10T06:17:25.091392Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"plt.figure(figsize=(20, 5))\nsns.histplot(data=train_adc_info, x='FGS1_adc_offset', hue=train_adc_info['star'])\nplt.xlabel('FGS1_adc_offset')\nplt.show()","metadata":{"execution":{"iopub.status.busy":"2024-08-10T06:17:25.09392Z","iopub.execute_input":"2024-08-10T06:17:25.094283Z","iopub.status.idle":"2024-08-10T06:17:25.711271Z","shell.execute_reply.started":"2024-08-10T06:17:25.094255Z","shell.execute_reply":"2024-08-10T06:17:25.710045Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"plt.figure(figsize=(20, 5))\nsns.boxplot(data=train_adc_info, x=train_adc_info['star'], y='FGS1_adc_offset')\nplt.xlabel('')\nplt.ylabel('FGS1_adc_offset')\nplt.show()","metadata":{"execution":{"iopub.status.busy":"2024-08-10T06:17:25.712768Z","iopub.execute_input":"2024-08-10T06:17:25.713138Z","iopub.status.idle":"2024-08-10T06:17:26.028389Z","shell.execute_reply.started":"2024-08-10T06:17:25.713109Z","shell.execute_reply":"2024-08-10T06:17:26.02717Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"plt.figure(figsize=(20, 5))\nsns.histplot(data=train_adc_info, x='FGS1_adc_gain', hue=train_adc_info['star'])\nplt.xlabel('FGS1_adc_gain')\nplt.show()","metadata":{"execution":{"iopub.status.busy":"2024-08-10T06:17:26.030058Z","iopub.execute_input":"2024-08-10T06:17:26.030474Z","iopub.status.idle":"2024-08-10T06:17:26.449978Z","shell.execute_reply.started":"2024-08-10T06:17:26.03044Z","shell.execute_reply":"2024-08-10T06:17:26.448722Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"plt.figure(figsize=(20, 10))\nsns.boxplot(data=train_adc_info, x=train_adc_info['star'], y='FGS1_adc_gain')\nplt.xlabel('')\nplt.show()","metadata":{"execution":{"iopub.status.busy":"2024-08-10T06:17:26.45208Z","iopub.execute_input":"2024-08-10T06:17:26.452635Z","iopub.status.idle":"2024-08-10T06:17:26.72285Z","shell.execute_reply.started":"2024-08-10T06:17:26.452582Z","shell.execute_reply":"2024-08-10T06:17:26.721669Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"plt.figure(figsize=(20, 5))\nsns.histplot(data=train_adc_info, x='AIRS-CH0_adc_offset', hue=train_adc_info['star'])\nplt.xlabel('AIRS-CH0_adc_offset')\nplt.show()","metadata":{"execution":{"iopub.status.busy":"2024-08-10T06:17:26.724371Z","iopub.execute_input":"2024-08-10T06:17:26.724715Z","iopub.status.idle":"2024-08-10T06:17:27.25513Z","shell.execute_reply.started":"2024-08-10T06:17:26.724686Z","shell.execute_reply":"2024-08-10T06:17:27.254032Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"plt.figure(figsize=(20, 5))\nsns.boxplot(data=train_adc_info, x=train_adc_info['star'], y='AIRS-CH0_adc_offset')\nplt.xlabel('')\nplt.show()","metadata":{"execution":{"iopub.status.busy":"2024-08-10T06:17:27.256589Z","iopub.execute_input":"2024-08-10T06:17:27.25692Z","iopub.status.idle":"2024-08-10T06:17:27.558196Z","shell.execute_reply.started":"2024-08-10T06:17:27.256892Z","shell.execute_reply":"2024-08-10T06:17:27.55693Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"plt.figure(figsize=(20, 5))\nsns.histplot(data=train_adc_info, x='AIRS-CH0_adc_gain', hue=train_adc_info['star'])\nplt.xlabel('AIRS-CH0_adc_gain')\nplt.show()","metadata":{"execution":{"iopub.status.busy":"2024-08-10T06:17:27.559963Z","iopub.execute_input":"2024-08-10T06:17:27.56047Z","iopub.status.idle":"2024-08-10T06:17:28.229428Z","shell.execute_reply.started":"2024-08-10T06:17:27.560425Z","shell.execute_reply":"2024-08-10T06:17:28.228118Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"plt.figure(figsize=(20, 20))\nsns.boxplot(data=train_adc_info, x=train_adc_info['star'], y='AIRS-CH0_adc_gain')\nplt.xlabel('')\nplt.show()","metadata":{"execution":{"iopub.status.busy":"2024-08-10T06:17:28.23143Z","iopub.execute_input":"2024-08-10T06:17:28.23195Z","iopub.status.idle":"2024-08-10T06:17:28.668773Z","shell.execute_reply.started":"2024-08-10T06:17:28.231904Z","shell.execute_reply":"2024-08-10T06:17:28.66744Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"markdown","source":"# 🌑 🌒 🌓 🌔 End of EDA 🌕 🌖 🌗 🌘 🌑","metadata":{}},{"cell_type":"code","source":"","metadata":{},"execution_count":null,"outputs":[]}]}