DataHerb
Flora Add Data Articles
Ecosystem
Python Package
Community
Telegram
About

DataHerb:

NASA Exoplanet Archive

• [ #Astronomy ]

DataHerb Metadata

  • DataHerb ID: nasa_exoplanet_archive
  • DataHerb Name: NASA Exoplanet Archive
  • Contributors: Interplanetary Immigration Center
  • Description: Exoplanet data from NASA Exoplanet Archive.
  • GitHub Repository: InterImm/nasa-exoplanet-archive

DataHerb Leaves: Files in Dataset

  • Metadata
  • Usage
  • File:
  • Format: csv
  • Size: 21K

Fields

  1. pl_hostname: Host Name
  2. pl_letter: Planet Letter
  3. pl_name: Planet Name
  4. pl_discmethod: Discovery Method
  5. pl_controvflag: Controversial Flag
  6. pl_pnum: Number of Planets in System
  7. pl_orbper: Orbital Period [days]
  8. pl_orbpererr1: Orbital Period Upper Unc. [days]
  9. pl_orbpererr2: Orbital Period Lower Unc. [days]
  10. pl_orbperlim: Orbital Period Limit Flag
  11. pl_orbsmax: Orbit Semi-Major Axis [AU])
  12. pl_orbsmaxerr1: Orbit Semi-Major Axis Upper Unc. [AU]
  13. pl_orbsmaxerr2: Orbit Semi-Major Axis Lower Unc. [AU]
  14. pl_orbsmaxlim: Orbit Semi-Major Axis Limit Flag
  15. pl_orbeccen: Eccentricity
  16. pl_orbeccenerr1: Eccentricity Upper Unc.
  17. pl_orbeccenerr2: Eccentricity Lower Unc.
  18. pl_orbeccenlim: Eccentricity Limit Flag
  19. pl_orbincl: Inclination [deg]
  20. pl_orbinclerr1: Inclination Upper Unc. [deg]
  21. pl_orbinclerr2: Inclination Lower Unc. [deg]
  22. pl_orbincllim: Inclination Limit Flag
  23. pl_bmassj: Planet Mass or M*sin(i) [Jupiter mass]
  24. pl_bmassjerr1: Planet Mass or M*sin(i) Upper Unc. [Jupiter mass]
  25. pl_bmassjerr2: Planet Mass or M*sin(i) Lower Unc. [Jupiter mass]
  26. pl_bmassjlim: Planet Mass or M*sin(i) Limit Flag
  27. pl_bmassprov: Planet Mass or M*sin(i) Provenance
  28. pl_radj: Planet Radius [Jupiter radii]
  29. pl_radjerr1: Planet Radius Upper Unc. [Jupiter radii]
  30. pl_radjerr2: Planet Radius Lower Unc. [Jupiter radii]
  31. pl_radjlim: Planet Radius Limit Flag
  32. pl_dens: Planet Density [g/cm**3]
  33. pl_denserr1: Planet Density Upper Unc. [g/cm**3]
  34. pl_denserr2: Planet Density Lower Unc. [g/cm**3]
  35. pl_denslim: Planet Density Limit Flag
  36. pl_ttvflag: TTV Flag
  37. pl_kepflag: Kepler Field Flag
  38. pl_k2flag: K2 Mission Flag
  39. pl_nnotes: Number of Notes
  40. ra_str: RA [sexagesimal]
  41. ra: RA [decimal degrees]
  42. dec_str: Dec [sexagesimal]
  43. dec: Dec [decimal degrees]
  44. st_dist: Distance [pc]
  45. st_disterr1: Distance Upper Unc. [pc]
  46. st_disterr2: Distance Lower Unc. [pc]
  47. st_distlim: Distance Limit Flag
  48. gaia_dist: Gaia Distance [pc]
  49. gaia_disterr1: Gaia Distance Upper Unc. [pc]
  50. gaia_disterr2: Gaia Distance Lower Unc. [pc]
  51. gaia_distlim: Gaia Distance Limit Flag
  52. st_optmag: Optical Magnitude [mag]
  53. st_optmagerr: Optical Magnitude Unc. [mag]
  54. st_optmaglim: Optical Magnitude Limit Flag
  55. st_optband: Optical Magnitude Band
  56. gaia_gmag: G-band (Gaia) [mag]
  57. gaia_gmagerr: G-band (Gaia) Unc. [mag]
  58. gaia_gmaglim: G-band (Gaia) Limit Flag
  59. st_teff: Effective Temperature [K]
  60. st_tefferr1: Effective Temperature Upper Unc. [K]
  61. st_tefferr2: Effective Temperature Lower Unc. [K]
  62. st_tefflim: Effective Temperature Limit Flag
  63. st_mass: Stellar Mass [Solar mass]
  64. st_masserr1: Stellar Mass Upper Unc. [Solar mass]
  65. st_masserr2: Stellar Mass Lower Unc. [Solar mass]
  66. st_masslim: Stellar Mass Limit Flag
  67. st_rad: Stellar Radius [Solar radii]
  68. st_raderr1: Stellar Radius Upper Unc. [Solar radii]
  69. st_raderr2: Stellar Radius Lower Unc. [Solar radii]
  70. st_radlim: Stellar Radius Limit Flag
  71. rowupdate: Date of Last Update
  72. pl_facility: Discovery Facility

Preview

Import Data

Copy the following code and paste into a Google Spreadsheet cell. 
=IMPORTDATA("https://raw.githubusercontent.com/InterImm/nasa-exoplanet-archive/master/dataset/confirmed_exoplanets.csv")
Load data into a Pandas DataFrame: 
import pandas as pd
url = "https://raw.githubusercontent.com/InterImm/nasa-exoplanet-archive/master/dataset/confirmed_exoplanets.csv"
df = pd.read_csv(url)
  • File:
  • Format: json
  • Size: 70K

Fields

  1. pl_hostname: Host Name
  2. pl_letter: Planet Letter
  3. pl_name: Planet Name
  4. pl_discmethod: Discovery Method
  5. pl_controvflag: Controversial Flag
  6. pl_pnum: Number of Planets in System
  7. pl_orbper: Orbital Period [days]
  8. pl_orbpererr1: Orbital Period Upper Unc. [days]
  9. pl_orbpererr2: Orbital Period Lower Unc. [days]
  10. pl_orbperlim: Orbital Period Limit Flag
  11. pl_orbsmax: Orbit Semi-Major Axis [AU])
  12. pl_orbsmaxerr1: Orbit Semi-Major Axis Upper Unc. [AU]
  13. pl_orbsmaxerr2: Orbit Semi-Major Axis Lower Unc. [AU]
  14. pl_orbsmaxlim: Orbit Semi-Major Axis Limit Flag
  15. pl_orbeccen: Eccentricity
  16. pl_orbeccenerr1: Eccentricity Upper Unc.
  17. pl_orbeccenerr2: Eccentricity Lower Unc.
  18. pl_orbeccenlim: Eccentricity Limit Flag
  19. pl_orbincl: Inclination [deg]
  20. pl_orbinclerr1: Inclination Upper Unc. [deg]
  21. pl_orbinclerr2: Inclination Lower Unc. [deg]
  22. pl_orbincllim: Inclination Limit Flag
  23. pl_bmassj: Planet Mass or M*sin(i) [Jupiter mass]
  24. pl_bmassjerr1: Planet Mass or M*sin(i) Upper Unc. [Jupiter mass]
  25. pl_bmassjerr2: Planet Mass or M*sin(i) Lower Unc. [Jupiter mass]
  26. pl_bmassjlim: Planet Mass or M*sin(i) Limit Flag
  27. pl_bmassprov: Planet Mass or M*sin(i) Provenance
  28. pl_radj: Planet Radius [Jupiter radii]
  29. pl_radjerr1: Planet Radius Upper Unc. [Jupiter radii]
  30. pl_radjerr2: Planet Radius Lower Unc. [Jupiter radii]
  31. pl_radjlim: Planet Radius Limit Flag
  32. pl_dens: Planet Density [g/cm**3]
  33. pl_denserr1: Planet Density Upper Unc. [g/cm**3]
  34. pl_denserr2: Planet Density Lower Unc. [g/cm**3]
  35. pl_denslim: Planet Density Limit Flag
  36. pl_ttvflag: TTV Flag
  37. pl_kepflag: Kepler Field Flag
  38. pl_k2flag: K2 Mission Flag
  39. pl_nnotes: Number of Notes
  40. ra_str: RA [sexagesimal]
  41. ra: RA [decimal degrees]
  42. dec_str: Dec [sexagesimal]
  43. dec: Dec [decimal degrees]
  44. st_dist: Distance [pc]
  45. st_disterr1: Distance Upper Unc. [pc]
  46. st_disterr2: Distance Lower Unc. [pc]
  47. st_distlim: Distance Limit Flag
  48. gaia_dist: Gaia Distance [pc]
  49. gaia_disterr1: Gaia Distance Upper Unc. [pc]
  50. gaia_disterr2: Gaia Distance Lower Unc. [pc]
  51. gaia_distlim: Gaia Distance Limit Flag
  52. st_optmag: Optical Magnitude [mag]
  53. st_optmagerr: Optical Magnitude Unc. [mag]
  54. st_optmaglim: Optical Magnitude Limit Flag
  55. st_optband: Optical Magnitude Band
  56. gaia_gmag: G-band (Gaia) [mag]
  57. gaia_gmagerr: G-band (Gaia) Unc. [mag]
  58. gaia_gmaglim: G-band (Gaia) Limit Flag
  59. st_teff: Effective Temperature [K]
  60. st_tefferr1: Effective Temperature Upper Unc. [K]
  61. st_tefferr2: Effective Temperature Lower Unc. [K]
  62. st_tefflim: Effective Temperature Limit Flag
  63. st_mass: Stellar Mass [Solar mass]
  64. st_masserr1: Stellar Mass Upper Unc. [Solar mass]
  65. st_masserr2: Stellar Mass Lower Unc. [Solar mass]
  66. st_masslim: Stellar Mass Limit Flag
  67. st_rad: Stellar Radius [Solar radii]
  68. st_raderr1: Stellar Radius Upper Unc. [Solar radii]
  69. st_raderr2: Stellar Radius Lower Unc. [Solar radii]
  70. st_radlim: Stellar Radius Limit Flag
  71. rowupdate: Date of Last Update
  72. pl_facility: Discovery Facility

Import Data

Load data into a Pandas DataFrame: 
import pandas as pd
url = "https://raw.githubusercontent.com/InterImm/nasa-exoplanet-archive/master/dataset/confirmed_exoplanets.json"
df = pd.read_json(url)

References:

  • NASA EXOPLANET ARCHIVE
explorer@dataherb: ~
The DataHerb Terminal — Type help.
➜ ~

The DataHerb Index by DataHerb.