{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "acbefd77-e37a-4e32-abdf-cb02f239007d",
   "metadata": {},
   "outputs": [],
   "source": [
    "# 安装astroquery\n",
    "# !pip install --pre astroquery"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "efe707af-7479-4af5-ae27-e1f1227cec8b",
   "metadata": {},
   "outputs": [],
   "source": [
    "import numpy as np\n",
    "from matplotlib import cm, colors, pyplot as plt\n",
    "\n",
    "import astropy.units as u\n",
    "\n",
    "from astroquery import gaia\n",
    "from astroquery.gaia import Gaia as g\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 115,
   "id": "4eb21566-ae84-470d-a1cf-6720f7d66d06",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "INFO: Query finished. [astroquery.utils.tap.core]\n",
      "100\n",
      "CPU times: user 104 ms, sys: 3.38 ms, total: 108 ms\n",
      "Wall time: 6.46 s\n"
     ]
    }
   ],
   "source": [
    "%%time\n",
    "\n",
    "# 使用SQL(ADQL)查询：按视差降序排序，前100条数据\n",
    "tab = g.launch_job_async('''\n",
    "    select top 100\n",
    "        *\n",
    "    from gaiadr3.gaia_source_lite\n",
    "    where parallax > 0\n",
    "    order by parallax desc\n",
    "''').get_results()\n",
    "\n",
    "print(len(tab))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 116,
   "id": "6fb80950-bc44-4df1-97ac-97baab081025",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAWoAAAD4CAYAAADFAawfAAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjUuMiwgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy8qNh9FAAAACXBIWXMAAAsTAAALEwEAmpwYAAAOYklEQVR4nO3dfYxldX3H8ffHXaiCFERuqbJMh7RKQ0l56JSqUFpBDboE+od/YIqprc0kxgcgpmZpkxr+I2qs/mFsNoCaihhFaA1EC/WhxqSu3V0eBBaKxZVnGWIsaBsR++0f9846jDPMGXbOPb+y71cymXPvOXvv594985lzf+ecOakqJEntesHQASRJz86ilqTGWdSS1DiLWpIaZ1FLUuM29/GgRx11VM3Ozvbx0JL0vLRr167Hq2q00rxeinp2dpadO3f28dCS9LyU5PurzXPoQ5IaZ1FLUuMsaklqnEUtSY2zqCWpcRa1JDWuU1EnuSTJnUnuSHJNkhf2HUySNLZmUSc5BngPMFdVJwKbgAv6DiZJGus69LEZeFGSzcAhwMP9RZIkLbXmmYlV9VCSDwH3A/8D3FRVNy1fLsk8MA8wMzOz0Tklab/Nbrtx3/Tey7cOmGR9ugx9vAQ4HzgOeDlwaJILly9XVduraq6q5kajFU9XlyQ9B12GPl4HfK+qFqrqZ8B1wGv6jSVJWtSlqO8HXpXkkCQBzgb29BtLkrRozaKuqh3AtcBu4DuTf7O951ySpIlOf+a0qt4PvL/nLJKkFXhmoiQ1zqKWpMZZ1JLUOItakhpnUUtS4yxqSWqcRS1JjbOoJalxFrUkNc6ilqTGWdSS1DiLWpIaZ1FLUuMsaklqnEUtSY2zqCWpcV0ubnt8kluXfD2R5OIpZJMk0eEKL1V1D3AyQJJNwEPA9f3GkiQtWu/Qx9nAf1bV9/sII0n6Zest6guAa/oIIklaWeeiTnIwcB7w+VXmzyfZmWTnwsLCRuWTpAPeerao3wjsrqofrDSzqrZX1VxVzY1Go41JJ0laV1G/BYc9JGnqOhV1kkOB1wPX9RtHkrTcmofnAVTVT4CX9pxFkrQCz0yUpMZZ1JLUOItakhpnUUtS4yxqSWqcRS1JjbOoJalxFrUkNc6ilqTGWdSS1DiLWpIaZ1FLUuMsaklqnEUtSY2zqCWpcRa1JDXOopakxnW9FNcRSa5NcneSPUle3XcwSdJYp0txAR8FvlxVb05yMHBIj5kkSUusWdRJDgfOBN4GUFVPAU/1G0uStKjL0MdxwALwiSS3JLliclXyZ0gyn2Rnkp0LCwsbHlSSDlRdinozcCrw8ao6BfgJsG35QlW1varmqmpuNBptcExJOnB1KeoHgQerasfk9rWMi1uSNAVrFnVVPQo8kOT4yV1nA3f1mkqStE/Xoz7eDVw9OeLjPuDP+4skSVqqU1FX1a3AXL9RJEkr8cxESWqcRS1JjbOoJalxFrUkNc6ilqTGWdSS1DiLWpIaZ1FLUuMsaklqnEUtSY2zqCWpcRa1JDXOopakxlnUktQ4i1qSGmdRS1LjLGpJalynK7wk2Qs8CfwceLqqvNqLJE1J12smAry2qh7vLYkkaUUOfUhS47oWdQE3JdmVZH6lBZLMJ9mZZOfCwsLGJZSkA1zXoj6jqk4F3gi8M8mZyxeoqu1VNVdVc6PRaENDStKBrFNRV9VDk++PAdcDp/UZSpL0C2sWdZJDkxy2OA28Abij72CSpLEuR30cDVyfZHH5z1TVl3tNJUnaZ82irqr7gJOmkEWStAIPz5OkxlnUktQ4i1qSGmdRS1LjLGpJapxFLUmNs6glqXEWtSQ1zqKWpMZZ1JLUOItakhpnUUtS4yxqSWqcRS1JjbOoJalxFrUkNc6ilqTGdS7qJJuS3JLkhj4DSZKeaT1b1BcBe/oKIklaWaeiTrIF2Apc0W8cSdJyXa5CDvAR4H3AYastkGQemAeYmZnZ72DS88nsthv3Te+9fOuASdb2/ylrC6bxfq25RZ3kXOCxqtr1bMtV1faqmququdFotGEBJelA12Xo43TgvCR7gc8CZyX5dK+pJEn7rFnUVXVpVW2pqlngAuCrVXVh78kkSYDHUUtS87ruTASgqr4OfL2XJJKkFblFLUmNs6glqXEWtSQ1zqKWpMZZ1JLUOItakhpnUUtS4yxqSWqcRS1JjbOoJalxFrUkNc6ilqTGWdSS1DiLWpIaZ1FLUuMsaklqnEUtSY3rchXyFyb5dpLbktyZ5LJpBJMkjXW5FNdPgbOq6sdJDgK+meRLVfWtnrNJkuhQ1FVVwI8nNw+afFWfoSRJv9Dp4rZJNgG7gN8CPlZVO1ZYZh6YB5iZmdnIjNIzzG67cd/03su3rnm/Nkbr7+9687X+epbqtDOxqn5eVScDW4DTkpy4wjLbq2ququZGo9EGx5SkA9e6jvqoqh8BXwPO6SWNJOmXdDnqY5TkiMn0i4DXA3f3nEuSNNFljPplwKcm49QvAD5XVTf0G0uStKjLUR+3A6dMIYskaQWemShJjbOoJalxFrUkNc6ilqTGWdSS1DiLWpIaZ1FLUuMsaklqnEUtSY2zqCWpcRa1JDXOopakxlnUktQ4i1qSGmdRS1LjLGpJapxFLUmN63LNxGOTfC3JXUnuTHLRNIJJksa6XDPxaeC9VbU7yWHAriQ3V9VdPWeTJNFhi7qqHqmq3ZPpJ4E9wDF9B5MkjXXZot4nySzjC93uWGHePDAPMDMzsxHZtB9mt924b3rv5VsHTPLcLX0NLWSYxvu42vOt9/7VHnN/8nRZZn/eo+XP1eWx1ptvvcu08rPTeWdikhcDXwAurqonls+vqu1VNVdVc6PRaCMzStIBrVNRJzmIcUlfXVXX9RtJkrRUl6M+AlwJ7KmqD/cfSZK0VJct6tOBtwJnJbl18vWmnnNJkibW3JlYVd8EMoUskqQVeGaiJDXOopakxlnUktQ4i1qSGmdRS1LjLGpJapxFLUmNs6glqXEWtSQ1zqKWpMZZ1JLUOItakhpnUUtS4yxqSWqcRS1JjbOoJalxFrUkNa7LNROvSvJYkjumEUiS9Exdtqg/CZzTcw5J0irWLOqq+gbwwylkkSStYM2L23aVZB6YB5iZmXnOjzO77cZ903sv37rfuVp/3mezWqb1Zt2f17Y/z/Vs9uf1dHm+LjlWy9CK/XltfduobM/2/93y65y2DduZWFXbq2ququZGo9FGPawkHfA86kOSGmdRS1Ljuhyedw3wb8DxSR5M8vb+Y0mSFq25M7Gq3jKNIJKklTn0IUmNs6glqXEWtSQ1zqKWpMZZ1JLUOItakhpnUUtS4yxqSWqcRS1JjbOoJalxFrUkNc6ilqTGWdSS1DiLWpIaZ1FLUuMsaklqnEUtSY3rVNRJzklyT5LvJtnWdyhJ0i90uWbiJuBjwBuBE4C3JDmh72CSpLEuW9SnAd+tqvuq6ings8D5/caSJC1KVT37AsmbgXOq6i8nt98K/EFVvWvZcvPA/OTm8cA9HZ7/KODx9YaeghZzmam7FnOZqbsWc00j029U1WilGWtehbyrqtoObF/Pv0mys6rmNirDRmkxl5m6azGXmbprMdfQmboMfTwEHLvk9pbJfZKkKehS1P8OvCLJcUkOBi4AvthvLEnSojWHPqrq6STvAv4Z2ARcVVV3btDzr2uoZIpazGWm7lrMZabuWsw1aKY1dyZKkoblmYmS1DiLWpIaN2hRJ9mU5JYkNwyZY1GSI5Jcm+TuJHuSvLqBTJckuTPJHUmuSfLCgXJcleSxJHcsue/IJDcnuXfy/SUNZPrg5P/v9iTXJzlimplWy7Vk3nuTVJKjWsiU5N2T9+vOJB8YOlOSk5N8K8mtSXYmOW3KmY5N8rUkd03ek4sm9w+6rg+9RX0RsGfgDEt9FPhyVf02cBIDZ0tyDPAeYK6qTmS8M/eCgeJ8Ejhn2X3bgK9U1SuAr0xuD53pZuDEqvpd4D+AS6ecCVbORZJjgTcA9087ECtkSvJaxmcZn1RVvwN8aOhMwAeAy6rqZOBvJ7en6WngvVV1AvAq4J2TP5kx6Lo+WFEn2QJsBa4YKsNSSQ4HzgSuBKiqp6rqR4OGGtsMvCjJZuAQ4OEhQlTVN4AfLrv7fOBTk+lPAX8ydKaquqmqnp7c/Bbj4/6napX3CuDvgPcBU9+Dv0qmdwCXV9VPJ8s81kCmAn51Mn04U17fq+qRqto9mX6S8cbaMQy8rg+5Rf0Rxivt/w6YYanjgAXgE5PhmCuSHDpkoKp6iPFWzv3AI8B/VdVNQ2Za5uiqemQy/Shw9JBhVvAXwJeGDgGQ5Hzgoaq6begsS7wS+MMkO5L8a5LfHzoQcDHwwSQPMF73h/hEBECSWeAUYAcDr+uDFHWSc4HHqmrXEM+/is3AqcDHq+oU4CdM/6P8M0zGwc5n/Evk5cChSS4cMtNqanycZzPHeib5G8YfY69uIMshwF8z/ijfks3AkYw/4v8V8LkkGTYS7wAuqapjgUuYfMKdtiQvBr4AXFxVTyydN8S6PtQW9enAeUn2Mv5rfGcl+fRAWRY9CDxYVTsmt69lXNxDeh3wvapaqKqfAdcBrxk401I/SPIygMn3qX50Xk2StwHnAn9abZwo8JuMf9neNlnntwC7k/z6oKnG6/x1NfZtxp9up7qTcwV/xng9B/g847/eOVVJDmJc0ldX1WKWQdf1QYq6qi6tqi1VNct459hXq2rQLcWqehR4IMnxk7vOBu4aMBKMhzxeleSQyZbO2bS18/WLjH+wmHz/pwGzAOOLXDAeUjuvqv576DwAVfWdqvq1qpqdrPMPAqdO1rkh/SPwWoAkrwQOZvi/Wvcw8EeT6bOAe6f55JOfsyuBPVX14SWzhl3Xq2rQL+CPgRuGzjHJcjKwE7id8Ur8kgYyXQbcDdwB/APwKwPluIbxOPnPGBfN24GXMt4Dfi/wL8CRDWT6LvAAcOvk6+9beK+Wzd8LHDV0JsbF/OnJurUbOKuBTGcAu4DbGI8N/96UM53BeFjj9iXr0JuGXtc9hVySGjf0cdSSpDVY1JLUOItakhpnUUtS4yxqSWqcRS1JjbOoJalx/web8EwWtDEVRgAAAABJRU5ErkJggg==\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "距离我们最近的100颗恒星\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div><i>Table length=100</i>\n",
       "<table id=\"table140417475390480\" class=\"table-striped table-bordered table-condensed\">\n",
       "<thead><tr><th>source_id</th><th>random_index</th><th>ra</th><th>dec</th><th>parallax</th><th>parallax_error</th><th>parallax_over_error</th><th>pmra</th><th>pmra_error</th><th>pmdec</th><th>pmdec_error</th><th>astrometric_params_solved</th><th>pseudocolour</th><th>pseudocolour_error</th><th>ipd_frac_multi_peak</th><th>ipd_frac_odd_win</th><th>ruwe</th><th>phot_g_mean_flux_over_error</th><th>phot_g_mean_mag</th><th>phot_bp_mean_flux_over_error</th><th>phot_bp_mean_mag</th><th>phot_rp_mean_flux_over_error</th><th>phot_rp_mean_mag</th><th>phot_bp_rp_excess_factor</th><th>bp_rp</th><th>radial_velocity</th><th>radial_velocity_error</th><th>rv_nb_transits</th><th>rv_expected_sig_to_noise</th><th>rv_renormalised_gof</th><th>rv_chisq_pvalue</th><th>phot_variable_flag</th><th>l</th><th>b</th><th>in_qso_candidates</th><th>in_galaxy_candidates</th><th>non_single_star</th><th>has_xp_continuous</th><th>has_xp_sampled</th><th>has_rvs</th><th>has_epoch_photometry</th><th>has_epoch_rv</th><th>has_mcmc_gspphot</th><th>has_mcmc_msc</th><th>in_andromeda_survey</th><th>teff_gspphot</th><th>logg_gspphot</th><th>mh_gspphot</th><th>distance_gspphot</th><th>ag_gspphot</th><th>ebpminrp_gspphot</th><th>distance</th></tr></thead>\n",
       "<thead><tr><th></th><th></th><th>deg</th><th>deg</th><th>mas</th><th>mas</th><th></th><th>mas / yr</th><th>mas / yr</th><th>mas / yr</th><th>mas / yr</th><th></th><th>1 / um</th><th>1 / um</th><th></th><th></th><th></th><th></th><th>mag</th><th></th><th>mag</th><th></th><th>mag</th><th></th><th>mag</th><th>km / s</th><th>km / s</th><th></th><th></th><th></th><th></th><th></th><th>deg</th><th>deg</th><th></th><th></th><th></th><th></th><th></th><th></th><th></th><th></th><th></th><th></th><th></th><th>K</th><th>log(cm.s**-2)</th><th>dex</th><th>pc</th><th>mag</th><th>mag</th><th>lyr</th></tr></thead>\n",
       "<thead><tr><th>int64</th><th>int64</th><th>float64</th><th>float64</th><th>float64</th><th>float32</th><th>float32</th><th>float64</th><th>float32</th><th>float64</th><th>float32</th><th>int16</th><th>float32</th><th>float32</th><th>int16</th><th>int16</th><th>float32</th><th>float32</th><th>float32</th><th>float32</th><th>float32</th><th>float32</th><th>float32</th><th>float32</th><th>float32</th><th>float32</th><th>float32</th><th>int16</th><th>float32</th><th>float32</th><th>float32</th><th>object</th><th>float64</th><th>float64</th><th>bool</th><th>bool</th><th>int16</th><th>bool</th><th>bool</th><th>bool</th><th>bool</th><th>bool</th><th>bool</th><th>bool</th><th>bool</th><th>float32</th><th>float32</th><th>float32</th><th>float32</th><th>float32</th><th>float32</th><th>float64</th></tr></thead>\n",
       "<tr><td>5853498713190525696</td><td>1320081859</td><td>217.39232147200883</td><td>-62.67607511676666</td><td>768.0665391873573</td><td>0.049872905</td><td>15400.477</td><td>-3781.741008265163</td><td>0.031386077</td><td>769.4650146478623</td><td>0.050524533</td><td>95</td><td>1.1408331</td><td>0.007456389</td><td>11</td><td>0</td><td>0.97145325</td><td>1527.8928</td><td>8.984749</td><td>420.41574</td><td>11.373116</td><td>618.5337</td><td>7.5685353</td><td>1.6316793</td><td>3.8045802</td><td>-21.942726</td><td>0.21612652</td><td>7</td><td>222.26839</td><td>-3.3928843</td><td>0.8895482</td><td>NOT_AVAILABLE</td><td>313.92549558326704</td><td>-1.9177544232946377</td><td>False</td><td>False</td><td>0</td><td>True</td><td>True</td><td>False</td><td>False</td><td>False</td><td>True</td><td>False</td><td>False</td><td>2829.3542</td><td>5.1373</td><td>-0.1806</td><td>1.3011</td><td>0.0</td><td>0.0</td><td>4.246459923404928</td></tr>\n",
       "<tr><td>4472832130942575872</td><td>1329945144</td><td>269.44850252543836</td><td>4.739420051112412</td><td>546.975939730948</td><td>0.040116355</td><td>13634.737</td><td>-801.5509783684709</td><td>0.031820867</td><td>10362.394206546573</td><td>0.036070455</td><td>31</td><td>--</td><td>--</td><td>0</td><td>0</td><td>1.0848505</td><td>1553.9851</td><td>8.1939745</td><td>951.9071</td><td>9.791788</td><td>1518.3344</td><td>6.9580913</td><td>1.4803807</td><td>2.8336968</td><td>-110.46822</td><td>0.13125522</td><td>12</td><td>381.34583</td><td>-4.171129</td><td>0.5895669</td><td>NOT_AVAILABLE</td><td>31.049417957939717</td><td>14.08660366802383</td><td>False</td><td>False</td><td>0</td><td>True</td><td>True</td><td>False</td><td>False</td><td>False</td><td>True</td><td>False</td><td>False</td><td>3099.6335</td><td>4.764</td><td>-0.9072</td><td>1.8275</td><td>0.0</td><td>0.0</td><td>5.962901729775837</td></tr>\n",
       "<tr><td>3864972938605115520</td><td>766292388</td><td>164.10319030755974</td><td>7.002726940984864</td><td>415.17941567802137</td><td>0.06837086</td><td>6072.462</td><td>-3866.3382751436793</td><td>0.08130645</td><td>-2699.214987679166</td><td>0.06910815</td><td>95</td><td>1.0886071</td><td>0.015429774</td><td>3</td><td>0</td><td>0.8353354</td><td>722.8211</td><td>11.038391</td><td>232.04747</td><td>13.770287</td><td>504.92255</td><td>9.58545</td><td>1.6632524</td><td>4.1848364</td><td>--</td><td>--</td><td>--</td><td>--</td><td>--</td><td>--</td><td>NOT_AVAILABLE</td><td>244.05115057496633</td><td>56.09885280026159</td><td>False</td><td>False</td><td>0</td><td>True</td><td>True</td><td>False</td><td>False</td><td>False</td><td>False</td><td>False</td><td>False</td><td>--</td><td>--</td><td>--</td><td>--</td><td>--</td><td>--</td><td>7.8557935533509955</td></tr>\n",
       "<tr><td>762815470562110464</td><td>970765473</td><td>165.83095967577933</td><td>35.948653032660104</td><td>392.75294543876464</td><td>0.03206665</td><td>12248.019</td><td>-580.0570872139048</td><td>0.025565954</td><td>-4776.588719443488</td><td>0.030034095</td><td>95</td><td>1.2979331</td><td>0.0075547816</td><td>0</td><td>0</td><td>0.9638494</td><td>2079.2886</td><td>6.551172</td><td>974.18225</td><td>7.6911216</td><td>1037.6364</td><td>5.475513</td><td>1.3874384</td><td>2.2156086</td><td>-85.11064</td><td>0.13100341</td><td>11</td><td>709.08905</td><td>--</td><td>0.49117628</td><td>NOT_AVAILABLE</td><td>185.1695098360815</td><td>65.4339878357637</td><td>False</td><td>False</td><td>0</td><td>True</td><td>True</td><td>False</td><td>False</td><td>False</td><td>True</td><td>False</td><td>False</td><td>3511.045</td><td>4.8322</td><td>-0.1783</td><td>2.5453</td><td>0.0</td><td>0.0</td><td>8.304364906859634</td></tr>\n",
       "<tr><td>2947050466531873024</td><td>52974825</td><td>101.28662552099249</td><td>-16.720932526023173</td><td>374.48958852876103</td><td>0.2313347</td><td>1618.8214</td><td>-461.570505530133</td><td>0.2779457</td><td>-914.5196209016666</td><td>0.33150372</td><td>31</td><td>--</td><td>--</td><td>18</td><td>0</td><td>2.4190555</td><td>621.3722</td><td>8.524133</td><td>23.208166</td><td>8.120362</td><td>27.79296</td><td>8.398789</td><td>1.5243522</td><td>-0.27842712</td><td>--</td><td>--</td><td>--</td><td>--</td><td>--</td><td>--</td><td>NOT_AVAILABLE</td><td>227.2344521579568</td><td>-8.892834154293482</td><td>False</td><td>False</td><td>0</td><td>True</td><td>True</td><td>False</td><td>False</td><td>False</td><td>False</td><td>False</td><td>False</td><td>--</td><td>--</td><td>--</td><td>--</td><td>--</td><td>--</td><td>8.7093576886369</td></tr>\n",
       "<tr><td>5140693571158946048</td><td>575090658</td><td>24.771674208211856</td><td>-17.947682860008488</td><td>373.8443122683992</td><td>0.50087124</td><td>746.38806</td><td>3178.6942575748953</td><td>0.42692018</td><td>584.0613350385156</td><td>0.30229247</td><td>95</td><td>1.7280899</td><td>0.07499732</td><td>10</td><td>0</td><td>10.453167</td><td>538.3399</td><td>10.817838</td><td>108.16757</td><td>13.252207</td><td>70.54292</td><td>9.423653</td><td>1.5971872</td><td>3.8285542</td><td>10.249533</td><td>3.2381904</td><td>4</td><td>59.103638</td><td>--</td><td>--</td><td>NOT_AVAILABLE</td><td>175.5190466595442</td><td>-75.6864408461554</td><td>False</td><td>False</td><td>0</td><td>False</td><td>False</td><td>False</td><td>False</td><td>False</td><td>False</td><td>False</td><td>False</td><td>--</td><td>--</td><td>--</td><td>--</td><td>--</td><td>--</td><td>8.724390528712428</td></tr>\n",
       "<tr><td>5140693571158739840</td><td>633518913</td><td>24.771554293454546</td><td>-17.948299887129313</td><td>367.71189618147696</td><td>0.74180114</td><td>495.70142</td><td>3385.315810465071</td><td>0.67216444</td><td>544.3863845619521</td><td>0.3787539</td><td>31</td><td>--</td><td>--</td><td>9</td><td>0</td><td>12.367461</td><td>1439.128</td><td>10.507542</td><td>194.82921</td><td>12.820644</td><td>86.96797</td><td>9.067688</td><td>1.6715958</td><td>3.7529564</td><td>21.458223</td><td>0.7900771</td><td>7</td><td>83.45942</td><td>--</td><td>--</td><td>NOT_AVAILABLE</td><td>175.52059241295885</td><td>-75.6869385406657</td><td>False</td><td>False</td><td>0</td><td>True</td><td>True</td><td>False</td><td>False</td><td>False</td><td>False</td><td>False</td><td>False</td><td>--</td><td>--</td><td>--</td><td>--</td><td>--</td><td>--</td><td>8.869889201402808</td></tr>\n",
       "<tr><td>4075141768785646848</td><td>249919922</td><td>282.4587890175222</td><td>-23.83709744872712</td><td>336.0266016683708</td><td>0.031666122</td><td>10611.549</td><td>639.367850335873</td><td>0.03683873</td><td>-193.95792507116096</td><td>0.031829588</td><td>31</td><td>--</td><td>--</td><td>0</td><td>0</td><td>0.98801184</td><td>1233.3462</td><td>9.126414</td><td>341.96747</td><td>10.732183</td><td>798.3095</td><td>7.898147</td><td>1.4699805</td><td>2.8340364</td><td>-11.11644</td><td>0.5655069</td><td>11</td><td>241.3441</td><td>-2.5438895</td><td>0.0017242172</td><td>NOT_AVAILABLE</td><td>11.307625151239241</td><td>-10.287475752633519</td><td>False</td><td>False</td><td>0</td><td>False</td><td>False</td><td>True</td><td>False</td><td>False</td><td>False</td><td>False</td><td>False</td><td>3117.376</td><td>4.776</td><td>-0.84</td><td>2.9762</td><td>1e-04</td><td>1e-04</td><td>9.70626659012644</td></tr>\n",
       "<tr><td>1926461164913660160</td><td>1195011327</td><td>355.4800152581559</td><td>44.170375700747755</td><td>316.48118678226916</td><td>0.044448785</td><td>7120.1313</td><td>112.52746493350043</td><td>0.036434025</td><td>-1591.6497618145506</td><td>0.026793785</td><td>31</td><td>--</td><td>--</td><td>8</td><td>0</td><td>1.0273284</td><td>1519.5181</td><td>10.379277</td><td>527.5998</td><td>12.546428</td><td>1637.9124</td><td>9.017014</td><td>1.5746436</td><td>3.5294142</td><td>-77.289825</td><td>0.18532437</td><td>12</td><td>142.50458</td><td>-2.7386127</td><td>0.09257997</td><td>VARIABLE</td><td>109.98933805855953</td><td>-16.947350494260327</td><td>False</td><td>False</td><td>0</td><td>True</td><td>True</td><td>False</td><td>True</td><td>False</td><td>False</td><td>False</td><td>False</td><td>--</td><td>--</td><td>--</td><td>--</td><td>--</td><td>--</td><td>10.305711408404521</td></tr>\n",
       "<tr><td>...</td><td>...</td><td>...</td><td>...</td><td>...</td><td>...</td><td>...</td><td>...</td><td>...</td><td>...</td><td>...</td><td>...</td><td>...</td><td>...</td><td>...</td><td>...</td><td>...</td><td>...</td><td>...</td><td>...</td><td>...</td><td>...</td><td>...</td><td>...</td><td>...</td><td>...</td><td>...</td><td>...</td><td>...</td><td>...</td><td>...</td><td>...</td><td>...</td><td>...</td><td>...</td><td>...</td><td>...</td><td>...</td><td>...</td><td>...</td><td>...</td><td>...</td><td>...</td><td>...</td><td>...</td><td>...</td><td>...</td><td>...</td><td>...</td><td>...</td><td>...</td><td>...</td></tr>\n",
       "<tr><td>4847957293278177024</td><td>108944108</td><td>50.00034361894219</td><td>-43.06655252783423</td><td>165.5242095575573</td><td>0.07836173</td><td>2112.3093</td><td>3035.01731561514</td><td>0.0812309</td><td>726.9644815849239</td><td>0.101254486</td><td>95</td><td>1.48711</td><td>0.020080015</td><td>0</td><td>0</td><td>1.976701</td><td>1044.884</td><td>4.063915</td><td>535.3128</td><td>4.440891</td><td>337.56985</td><td>3.5082927</td><td>1.2146823</td><td>0.9325981</td><td>87.75779</td><td>0.12703782</td><td>18</td><td>1827.109</td><td>--</td><td>0.016656557</td><td>NOT_AVAILABLE</td><td>250.73404566404008</td><td>-56.06475866970972</td><td>False</td><td>False</td><td>0</td><td>True</td><td>True</td><td>False</td><td>False</td><td>False</td><td>True</td><td>False</td><td>False</td><td>5427.3184</td><td>4.4433</td><td>0.0247</td><td>6.0327</td><td>0.0</td><td>0.0</td><td>19.704451607928075</td></tr>\n",
       "<tr><td>946632924007399936</td><td>91728796</td><td>107.50514340448903</td><td>38.52526941964586</td><td>165.2146994337292</td><td>0.06364261</td><td>2595.976</td><td>-439.4204467281696</td><td>0.065588385</td><td>-944.7934896029223</td><td>0.058826566</td><td>95</td><td>1.1692526</td><td>0.01691827</td><td>3</td><td>0</td><td>1.1360852</td><td>1072.4795</td><td>9.934659</td><td>458.038</td><td>11.747847</td><td>1013.1161</td><td>8.641891</td><td>1.5211012</td><td>3.105956</td><td>--</td><td>--</td><td>--</td><td>--</td><td>--</td><td>--</td><td>NOT_AVAILABLE</td><td>178.9577895000976</td><td>19.901669191941114</td><td>False</td><td>False</td><td>0</td><td>True</td><td>True</td><td>False</td><td>False</td><td>False</td><td>False</td><td>False</td><td>False</td><td>--</td><td>--</td><td>--</td><td>--</td><td>--</td><td>--</td><td>19.74136555855134</td></tr>\n",
       "<tr><td>6427464123776727168</td><td>82124097</td><td>302.19503988923026</td><td>-66.18709128441725</td><td>163.9544145383167</td><td>0.12218077</td><td>1341.9004</td><td>1211.7606270999615</td><td>0.07212469</td><td>-1130.2369049548956</td><td>0.10327922</td><td>95</td><td>1.490049</td><td>0.01786107</td><td>0</td><td>0</td><td>2.8562405</td><td>1219.4386</td><td>3.3641381</td><td>106.95936</td><td>3.8463583</td><td>346.84515</td><td>2.8270798</td><td>1.1554333</td><td>1.0192785</td><td>--</td><td>--</td><td>--</td><td>--</td><td>--</td><td>--</td><td>NOT_AVAILABLE</td><td>329.76078020612954</td><td>-32.42131089268436</td><td>False</td><td>False</td><td>0</td><td>True</td><td>True</td><td>False</td><td>False</td><td>False</td><td>True</td><td>False</td><td>False</td><td>5437.5474</td><td>4.3012</td><td>0.0321</td><td>6.099</td><td>0.0</td><td>0.0</td><td>19.89311349957701</td></tr>\n",
       "<tr><td>2572901021957789568</td><td>296063152</td><td>24.24124978791965</td><td>9.563070454755835</td><td>163.44784569658697</td><td>0.4628947</td><td>353.0994</td><td>1238.2439374026383</td><td>0.5540863</td><td>-16.155571796869925</td><td>0.32792777</td><td>95</td><td>0.7173792</td><td>0.08122052</td><td>0</td><td>0</td><td>1.1058807</td><td>167.75575</td><td>19.461197</td><td>5.497416</td><td>21.107285</td><td>75.279015</td><td>17.640982</td><td>2.4098299</td><td>3.4663029</td><td>--</td><td>--</td><td>--</td><td>--</td><td>--</td><td>--</td><td>NOT_AVAILABLE</td><td>141.2250759328284</td><td>-51.68433605805002</td><td>False</td><td>False</td><td>0</td><td>False</td><td>False</td><td>False</td><td>False</td><td>False</td><td>False</td><td>False</td><td>False</td><td>--</td><td>--</td><td>--</td><td>--</td><td>--</td><td>--</td><td>19.954767609613956</td></tr>\n",
       "<tr><td>6673000841376349696</td><td>1493486120</td><td>303.4773905559996</td><td>-45.16473054247641</td><td>162.2171000791857</td><td>0.022484917</td><td>7214.4854</td><td>778.3309821152101</td><td>0.02004672</td><td>-159.9388249728239</td><td>0.017635535</td><td>31</td><td>--</td><td>--</td><td>0</td><td>0</td><td>1.0053535</td><td>2765.9475</td><td>7.2426615</td><td>1211.0605</td><td>8.190446</td><td>1238.8899</td><td>6.278736</td><td>1.3257185</td><td>1.9117098</td><td>-33.51682</td><td>0.11843188</td><td>11</td><td>468.1204</td><td>-2.4713318</td><td>0.985096</td><td>NOT_AVAILABLE</td><td>354.8063478610685</td><td>-32.97826039920067</td><td>False</td><td>False</td><td>0</td><td>True</td><td>True</td><td>False</td><td>False</td><td>False</td><td>True</td><td>False</td><td>False</td><td>3588.5205</td><td>4.0644</td><td>-1.4065</td><td>6.1659</td><td>0.0003</td><td>0.0002</td><td>20.10616498245445</td></tr>\n",
       "<tr><td>1638979384378696704</td><td>1624596075</td><td>267.01612290514834</td><td>70.88157381434476</td><td>160.99524492008814</td><td>0.011894624</td><td>13535.128</td><td>-1266.3871707976418</td><td>0.015870238</td><td>1108.8007104699252</td><td>0.016470628</td><td>31</td><td>--</td><td>--</td><td>0</td><td>0</td><td>1.0637181</td><td>3653.4583</td><td>13.778201</td><td>980.8214</td><td>14.179064</td><td>2145.4294</td><td>13.176234</td><td>1.2341527</td><td>1.0028296</td><td>--</td><td>--</td><td>--</td><td>--</td><td>--</td><td>--</td><td>NOT_AVAILABLE</td><td>101.43804084104781</td><td>30.691322551716652</td><td>False</td><td>False</td><td>0</td><td>True</td><td>True</td><td>False</td><td>False</td><td>False</td><td>False</td><td>False</td><td>False</td><td>--</td><td>--</td><td>--</td><td>--</td><td>--</td><td>--</td><td>20.258758442128823</td></tr>\n",
       "<tr><td>6324325225803432320</td><td>1416906431</td><td>218.56843175696892</td><td>-12.516923853592898</td><td>159.9225477824956</td><td>0.054619387</td><td>2927.9448</td><td>-355.1381150377546</td><td>0.052832775</td><td>593.0401507540619</td><td>0.043415446</td><td>31</td><td>--</td><td>--</td><td>0</td><td>0</td><td>1.4434574</td><td>1008.93677</td><td>9.894982</td><td>627.9283</td><td>11.569429</td><td>780.0093</td><td>8.646179</td><td>1.4847639</td><td>2.9232502</td><td>-1.359221</td><td>0.19820952</td><td>8</td><td>132.83919</td><td>-2.105764</td><td>0.092563055</td><td>NOT_AVAILABLE</td><td>338.4202515815191</td><td>43.1573140452653</td><td>False</td><td>False</td><td>0</td><td>True</td><td>True</td><td>False</td><td>False</td><td>False</td><td>True</td><td>False</td><td>False</td><td>3000.055</td><td>4.3516</td><td>-0.5936</td><td>6.2554</td><td>0.0</td><td>0.0</td><td>20.394646173367363</td></tr>\n",
       "<tr><td>2824770686019004032</td><td>541819637</td><td>352.9716753030632</td><td>19.937313746866927</td><td>159.90846046252173</td><td>0.051349618</td><td>3114.112</td><td>552.3494119624912</td><td>0.055147033</td><td>20.27460819805265</td><td>0.036104545</td><td>31</td><td>--</td><td>--</td><td>6</td><td>0</td><td>1.5881655</td><td>1491.2142</td><td>10.828941</td><td>145.96365</td><td>12.704212</td><td>748.20654</td><td>9.530133</td><td>1.5212379</td><td>3.174079</td><td>--</td><td>--</td><td>--</td><td>--</td><td>--</td><td>--</td><td>NOT_AVAILABLE</td><td>98.58054051342569</td><td>-39.14342615324564</td><td>False</td><td>False</td><td>0</td><td>False</td><td>False</td><td>False</td><td>False</td><td>False</td><td>False</td><td>False</td><td>False</td><td>--</td><td>--</td><td>--</td><td>--</td><td>--</td><td>--</td><td>20.396442863208335</td></tr>\n",
       "<tr><td>2824770686019003904</td><td>770267785</td><td>352.97012375450475</td><td>19.93699282660293</td><td>159.66339203721853</td><td>0.03412789</td><td>4678.3843</td><td>578.0086593589436</td><td>0.035451487</td><td>-59.768604898823476</td><td>0.02324439</td><td>31</td><td>--</td><td>--</td><td>1</td><td>0</td><td>1.3173962</td><td>1476.4573</td><td>9.043998</td><td>284.76175</td><td>10.507311</td><td>765.9866</td><td>7.8463645</td><td>1.4568522</td><td>2.6609464</td><td>-0.20729986</td><td>0.8243951</td><td>14</td><td>267.29807</td><td>-1.4795082</td><td>0.3191088</td><td>NOT_AVAILABLE</td><td>98.5786475699206</td><td>-39.14315221697577</td><td>False</td><td>False</td><td>0</td><td>True</td><td>True</td><td>True</td><td>False</td><td>False</td><td>False</td><td>False</td><td>False</td><td>--</td><td>--</td><td>--</td><td>--</td><td>--</td><td>--</td><td>20.427749501946835</td></tr>\n",
       "<tr><td>6322070093095493504</td><td>1320391257</td><td>229.85630133329227</td><td>-7.722707024157902</td><td>158.71827296463243</td><td>0.030101538</td><td>5272.763</td><td>-1221.2776289653712</td><td>0.03665181</td><td>-97.22923861858034</td><td>0.026740635</td><td>31</td><td>--</td><td>--</td><td>0</td><td>0</td><td>1.3033525</td><td>1622.9315</td><td>9.421787</td><td>619.3337</td><td>10.813405</td><td>2136.1707</td><td>8.251837</td><td>1.4377834</td><td>2.5615683</td><td>-9.745852</td><td>0.15540636</td><td>12</td><td>195.53186</td><td>-3.1428182</td><td>0.12624983</td><td>NOT_AVAILABLE</td><td>354.07215955069114</td><td>40.02218731174595</td><td>False</td><td>False</td><td>0</td><td>False</td><td>False</td><td>False</td><td>False</td><td>False</td><td>True</td><td>False</td><td>False</td><td>3110.4065</td><td>4.2666</td><td>-0.849</td><td>6.2984</td><td>0.0</td><td>0.0</td><td>20.549390541152214</td></tr>\n",
       "</table></div>"
      ],
      "text/plain": [
       "<Table length=100>\n",
       "     source_id      random_index ... ebpminrp_gspphot      distance     \n",
       "                                 ...       mag               lyr        \n",
       "       int64           int64     ...     float32           float64      \n",
       "------------------- ------------ ... ---------------- ------------------\n",
       "5853498713190525696   1320081859 ...              0.0  4.246459923404928\n",
       "4472832130942575872   1329945144 ...              0.0  5.962901729775837\n",
       "3864972938605115520    766292388 ...               -- 7.8557935533509955\n",
       " 762815470562110464    970765473 ...              0.0  8.304364906859634\n",
       "2947050466531873024     52974825 ...               --    8.7093576886369\n",
       "5140693571158946048    575090658 ...               --  8.724390528712428\n",
       "5140693571158739840    633518913 ...               --  8.869889201402808\n",
       "4075141768785646848    249919922 ...            1e-04   9.70626659012644\n",
       "1926461164913660160   1195011327 ...               -- 10.305711408404521\n",
       "                ...          ... ...              ...                ...\n",
       "4847957293278177024    108944108 ...              0.0 19.704451607928075\n",
       " 946632924007399936     91728796 ...               --  19.74136555855134\n",
       "6427464123776727168     82124097 ...              0.0  19.89311349957701\n",
       "2572901021957789568    296063152 ...               -- 19.954767609613956\n",
       "6673000841376349696   1493486120 ...           0.0002  20.10616498245445\n",
       "1638979384378696704   1624596075 ...               -- 20.258758442128823\n",
       "6324325225803432320   1416906431 ...              0.0 20.394646173367363\n",
       "2824770686019004032    541819637 ...               -- 20.396442863208335\n",
       "2824770686019003904    770267785 ...               -- 20.427749501946835\n",
       "6322070093095493504   1320391257 ...              0.0 20.549390541152214"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "# 把周年视差转换成距离：\n",
    "# 1.距离（distance）= 1/周年视差（parallax）\n",
    "tab['distance'] = 1 / tab['parallax']\n",
    "tab['distance'].unit = 'kpc'\n",
    "# 2.距离单位转换：千秒差距 -> 光年\n",
    "tab['distance'] = tab['distance'].to(u.lightyear)\n",
    "\n",
    "# 距离分布\n",
    "plt.hist(tab['distance'], bins=(100))\n",
    "plt.show()\n",
    "\n",
    "# 打印表格\n",
    "print('距离我们最近的100颗恒星')\n",
    "display(tab)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "dec36ccb-88ef-4974-8c83-c62ccb5efa7c",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "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.8.13"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}