# ---
# jupyter:
#   jupytext:
#     text_representation:
#       extension: .py
#       format_name: light
#       format_version: '1.5'
#       jupytext_version: 1.14.4
#   kernelspec:
#     display_name: Python 3
#     language: python
#     name: python3
# ---

# <!--NAVIGATION-->
# < [List of Cruises](Cruises.ipynb) | [Index](Index.ipynb) | [Cruise Spatio-Temporal Bounds](CruiseBounds.ipynb) >
#
# <a href="https://colab.research.google.com/github/simonscmap/pycmap/blob/master/docs/CruiseByName.ipynb"><img align="left" src="https://colab.research.google.com/assets/colab-badge.svg" alt="Open in Colab" title="Open and Execute in Google Colaboratory"></a>
#
# <a href="https://mybinder.org/v2/gh/simonscmap/pycmap/master?filepath=docs%2FCruiseByName.ipynb"><img align="right" src="https://mybinder.org/badge_logo.svg" alt="Open in Colab" title="Open and Execute in Binder"></a>

# ## *cruise_by_name(cruiseName)*
#
# Returns a dataframe containing some details about the specified cruise. 
# <br />The details include cruise official name, nickname, ship name, start/end time/location, etc ...

# > **Parameters:** 
# >> **cruiseName: string**
# >>  <br />The official cruise name. If applicable, you may also use cruise "nickname" ('Diel', 'Gradients_1' ...). <br />A full list of cruise names can be retrieved using [cruise](Cruises.ipynb) method.
#
#
# >**Returns:** 
# >>  Pandas dataframe.

# ### Example

# +
# #!pip install pycmap -q     #uncomment to install pycmap, if necessary

import pycmap

api = pycmap.API(token='<YOUR_API_KEY>')
api.cruise_by_name('KOK1606')

# alternatively, you may pass cruise nickname, if exists.
# below, "meso_scope" is a nickname, the official name is "KM1709"
# api.cruise_by_name('meso_scope')      
# -

# <img src="figures/sql.png" alt="SQL" align="left" width="40"/> 
# <br/>
# ### SQL Statement
# Here is how to achieve the same results using a direct SQL statement. Please refere to [Query](Query.ipynb) for more information.

# <code>EXEC uspCruiseByName 'KOK1606'<code/>

StarcoderdataJupyterScriptsDedupFiltered