Metadata

The metadata about each site is typically the entry point for soundDENA data access, as it’s queried to identify from which sites data should be read. The Complete Metadata and Derived Data Excel workbooks are joined into one DataFrame when soundDENA is imported.

soundDENA.metadata

A DataFrame of the Complete Metadata and Derived Data workbooks. Indexed by siteID, with the union of all columns in both those workbooks. The column names and data are slightly modified for consistency; see fullMetadata() for specifics.

Though unlikely, if these workbooks ever change midway through a script or interactive session, you can reload them using:

soundDENA.fullMetadata()

Returns a DataFrame of metadata merged with derived data, with overlapping columns resolved. Some column names and values are changed for consistency.

Transformations:

• unit column refers to Park from Derived Data and unit from Metadata
• code column is renamed to site (the 4-character site code)
• site column is renamed to title
• All column names are lowercased
• In overlapping columns, values from Metadata are used where values from both Metadata and Derived Data exist
• Leading and trailing whitespace is stripped from all string values
• Columns that contain only the values 0 and 1 are assumed to be boolean, and converted to a boolean datatype

Returns:DataFrame – Indexed by siteID (the 12-character code of UNITSITEYEAR, i.e. DENAUPST2015)