{ "cells": [ { "cell_type": "markdown", "id": "01e907f4", "metadata": {}, "source": [ "Kepler KIC downloaded from: https://archive.stsci.edu/pub/kepler/catalogs/" ] }, { "cell_type": "code", "execution_count": 1, "id": "84c02835", "metadata": { "ExecuteTime": { "end_time": "2022-04-05T19:02:24.530099Z", "start_time": "2022-04-05T19:02:00.795745Z" } }, "outputs": [], "source": [ "import astropy.coordinates as coord\n", "import astropy.table as at\n", "import astropy.units as u\n", "import matplotlib as mpl\n", "import matplotlib.pyplot as plt\n", "%matplotlib inline\n", "import numpy as np\n", "import pandas as pd" ] }, { "cell_type": "code", "execution_count": 2, "id": "f6dec649", "metadata": { "ExecuteTime": { "end_time": "2022-04-05T19:03:43.462529Z", "start_time": "2022-04-05T19:02:24.532097Z" } }, "outputs": [], "source": [ "df = pd.read_csv('kepler_kic_v10.csv.gz')" ] }, { "cell_type": "code", "execution_count": 14, "id": "14677669", "metadata": { "ExecuteTime": { "end_time": "2022-04-05T19:13:20.310093Z", "start_time": "2022-04-05T19:13:16.864267Z" } }, "outputs": [], "source": [ "keep_cols = ['kic_kepler_id', 'kic_kepmag', 'kic_ra', 'kic_dec', 'kic_2mass_id']\n", "tbl_data = {}\n", "for k in keep_cols:\n", " new_colname = k\n", " if 'kep' in new_colname:\n", " new_colname = new_colname[4:]\n", " \n", " if df[k].dtype == np.dtype('O'):\n", " tbl_data[new_colname] = df[k].values.astype(str)\n", " else:\n", " tbl_data[new_colname] = df[k].values\n", "tbl = at.Table(tbl_data)" ] }, { "cell_type": "code", "execution_count": 15, "id": "6b6cf757", "metadata": { "ExecuteTime": { "end_time": "2022-04-05T19:13:20.317087Z", "start_time": "2022-04-05T19:13:20.311724Z" } }, "outputs": [ { "data": { "text/html": [ "
Table length=13161029\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "
kepler_idkepmagkic_rakic_deckic_2mass_id
int64float64float64float64str17
1004288918.499000549316420.145897246.93991120084522+4656229
1004289017.166999816894520.145907646.96854220084525+4658065
1004289118.284999847412120.145913746.952444nan
1004289218.853000640869120.145915246.979697nan
1004289319.708000183105520.146011946.985275nan
1004289416.997999191284220.14602246.94357220084566+4656366
1004289519.131000518798820.14606246.956906nan
1004289620.024999618530320.146073346.964931nan
1004289720.482000350952120.146074646.952375nan
1004289820.232999801635720.14609246.993831nan
...............
1316102013.43400001525880.845520785.3518900504387+8521068
1316102114.71199989318850.846900785.3042500504884+8518153
1316102214.90600013732910.849987385.3526900505995+8521096
1316102316.40500068664550.850461385.3855900510165+8523081
1316102416.68799972534180.85463885.3064600511669+8518232
1316102514.72000026702880.85580285.3781900512088+8522414
1316102612.97999954223630.85673685.3009300512425+8518033
1316102715.36499977111820.858383385.3355700513017+8520080
1316102815.06099987030030.8611985.3577300514028+8521278
1316102916.1329994201660.861733385.3373800514224+8520145
" ], "text/plain": [ "\n", "kepler_id kepmag kic_ra kic_dec kic_2mass_id \n", " int64 float64 float64 float64 str17 \n", "--------- ---------------- ---------- --------- ----------------\n", " 10042889 18.4990005493164 20.1458972 46.939911 20084522+4656229\n", " 10042890 17.1669998168945 20.1459076 46.968542 20084525+4658065\n", " 10042891 18.2849998474121 20.1459137 46.952444 nan\n", " 10042892 18.8530006408691 20.1459152 46.979697 nan\n", " 10042893 19.7080001831055 20.1460119 46.985275 nan\n", " 10042894 16.9979991912842 20.146022 46.943572 20084566+4656366\n", " 10042895 19.1310005187988 20.146062 46.956906 nan\n", " 10042896 20.0249996185303 20.1460733 46.964931 nan\n", " 10042897 20.4820003509521 20.1460746 46.952375 nan\n", " 10042898 20.2329998016357 20.146092 46.993831 nan\n", " ... ... ... ... ...\n", " 13161020 13.4340000152588 0.8455207 85.35189 00504387+8521068\n", " 13161021 14.7119998931885 0.8469007 85.30425 00504884+8518153\n", " 13161022 14.9060001373291 0.8499873 85.35269 00505995+8521096\n", " 13161023 16.4050006866455 0.8504613 85.38559 00510165+8523081\n", " 13161024 16.6879997253418 0.854638 85.30646 00511669+8518232\n", " 13161025 14.7200002670288 0.855802 85.37819 00512088+8522414\n", " 13161026 12.9799995422363 0.856736 85.30093 00512425+8518033\n", " 13161027 15.3649997711182 0.8583833 85.33557 00513017+8520080\n", " 13161028 15.0609998703003 0.86119 85.35773 00514028+8521278\n", " 13161029 16.132999420166 0.8617333 85.33738 00514224+8520145" ] }, "execution_count": 15, "metadata": {}, "output_type": "execute_result" } ], "source": [ "tbl" ] }, { "cell_type": "code", "execution_count": 16, "id": "27a94544", "metadata": { "ExecuteTime": { "end_time": "2022-04-05T19:14:12.725857Z", "start_time": "2022-04-05T19:14:01.416924Z" } }, "outputs": [], "source": [ "tbl.write('kepler_kic.fits', overwrite=True)" ] }, { "cell_type": "code", "execution_count": null, "id": "d92a60ec", "metadata": {}, "outputs": [], "source": [] } ], "metadata": { "kernelspec": { "display_name": "apw-py3", "language": "python", "name": "apw-py3" }, "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.9.7" }, "toc": { "base_numbering": 1, "nav_menu": {}, "number_sections": true, "sideBar": true, "skip_h1_title": false, "title_cell": "Table of Contents", "title_sidebar": "Contents", "toc_cell": false, "toc_position": {}, "toc_section_display": true, "toc_window_display": false } }, "nbformat": 4, "nbformat_minor": 5 }