Nocturnal vocalization behavior and related behavioral data of wild tibetan macaques

Description of the data and file structureEquipment:Infrared cameras: Hikvision DS-2XS2T46XM (4G night-vision, high resolution)Passive acoustic recorders: Luyin (sampling rate: 0-44 kHz)GPS synchronization for accurate temporal alignmentMonitoring Sites:Cameras installed along cliff edges where macaques rest25 cameras placed at identified sleeping and activity hotspotsBehavior Recording:All-occurrence sampling method used to document behaviorsIndividual macaques identified based on scars, fur color, body size, and facial expressionsFiles and variablesFiles and variablesFile: ACI-气象数据.xlsxDescription: The file contains data collected from November 2023 to January 2024, sourced from the Xihe Energy Meteorological Big Data Platform and field passive acoustic monitoring devices. The data includes meteorological parameters (such as temperature, humidity, wind speed, etc.) and the Acoustic Complexity Index (ACI), used to analyze the influence of environmental factors on the nocturnal vocalization behavior of Tibetan macaques.Variables：DateTime – Timestamp of the recorded data (YYYY-MM-DD HH:MM:SS).Date – The date of the measurement (YYYY-MM-DD).Time – The specific time of the measurement (HH:MM:SS).气温 (Air Temperature) – The measured temperature in degrees Celsius (°C).湿度 (Humidity) – Relative humidity percentage (%).气压 (Atmospheric Pressure) – Atmospheric pressure in hectopascals (hPa).降水量 (Precipitation) – Total precipitation amount in millimeters (mm).经向风 (Zonal Wind Component) – Wind speed in the east-west direction (m/s).纬向风 (Meridional Wind Component) – Wind speed in the north-south direction (m/s).地面风速 (Surface Wind Speed) – Wind speed at the surface level (m/s).风向 (Wind Direction) – The direction the wind is coming from, in degrees (°).地表水平辐射 (Surface Horizontal Radiation) – Solar radiation received at the surface in watts per square meter (W/m²).法向直接辐射 (Direct Normal Radiation) – The amount of direct solar radiation incident on a surface perpendicular to the sun's rays (W/m²).散射辐射 (Diffuse Radiation) – The solar radiation scattered by molecules and particles in the atmosphere that reaches the surface (W/m²).ACI_Value (Acoustic Complexity Index) – A computed metric representing acoustic variability, used for ecological and behavioral analysis.<br>File: 行为类型与时间.xlsxDescription: The 行为类型与时间.xlsx file contains data across multiple sheets, and the first sheet includes the following columns:TIME: This appears to represent the time at which a specific behavior occurs. The unit is likely seconds (s).behavior: This column contains codes or labels that represent different types of behavior. For example, "APP", "AVO", etc.Frequency: This column indicates the frequency of the behavior, which might represent how often the behavior occurs during a specific time period.含义 (Meaning): This column provides the Chinese description or meaning of the behavior (e.g., "接近" for "approach", "回避" for "avoid").Type: This column classifies behaviors into categories, such as "社交相关" (Social-related) or "攻击相关" (Aggression-related).Variables：TIME: Time (单位：秒, s)behavior: Behavior label (e.g., APP, AVO, etc.)Frequency: Frequency (单位：次数)含义: Meaning or description of the behavior (in Chinese)Type: Behavior type classification (e.g., Social-related, Aggression-related)<br>File: 发声时间与种类.xlsxDescription: The 发声时间与种类.xlsx file contains the following columns in the first sheet:Date: The date when the sound event occurred.时间 (Time): The specific time at which the sound was made, likely recorded in the format HH:MM:SS.声音种类 (Sound Type): This column seems to represent the type of sound made, possibly indicated by numerical codes (e.g., "15", "3", etc.).Variables：Date: Date (单位：年-月-日, YYYY-MM-DD)时间 (Time): Time (单位：时:分:秒, HH:MM:SS)声音种类 (Sound Type): Sound type (represented by numerical codes, possibly categorizing different types of sounds)<br>File: 发声数据.xlsxDescription: The 发声数据.xlsx file contains the following columns in the first sheet:ID: This column seems to represent a unique identifier for each data entry.发声种类 (Sound Type): This column represents the type of sound made, likely indicated by numerical codes (e.g., "4", "11").发声类型 (Sound Category): This column categorizes the sound type in a descriptive way, such as "冲突叫声" (conflict call).Variables：Variables and Definitions:ID: Identifier (typically used to uniquely distinguish each data entry)发声种类 (Sound Type): Sound type (represented by numerical codes)发声类型 (Sound Category): Sound category (e.g., "冲突叫声" for conflict call)<br>File: 个体属性.xlsxDescription: he 个体属性.xlsx file contains the following columns in the first sheet:ID: A unique identifier for each individual.顺位 (Rank): The rank or order of the individual, which could represent their position in a specific hierarchy or sequence.性别 (Gender): The gender of the individual, likely coded (e.g., "1" for male, "2" for female).年龄 (Age): The age of the individual, possibly represented by categories or exact age.社会向量中心度 (Social Vector Centrality): A measure related to the individual's social centrality, likely in a network context.亲缘数量 (Kinship Number): The number of kin or family members associated with the individual.Variables：Variables and Definitions:ID: Identifier (used to uniquely distinguish each individual)顺位 (Rank): Rank or order (typically an integer, could be used for hierarchical positioning)性别 (Gender): Gender (typically coded: "1" for male, "2" for female)年龄 (Age): Age (either a direct value or categorical representation)社会向量中心度 (Social Vector Centrality): Social centrality measure (likely a numeric value indicating the individual’s centrality in a social network)亲缘数量 (Kinship Number): Kinship number (number of family members or kin connected to the individual)Code/softwareCode/softwareThere are several free and open-source software options can be used. Below is a description of the necessary software, versions, required packages, and the workflow, including the relationship between the file and the software used.1. R Software and EnvironmentSoftware Description: R is an open-source environment for statistical computing and data analysis, widely used for data manipulation, statistical modeling, and visualization. R has a large ecosystem of packages that support various data processing tasks.Version Requirements:R version: It is recommended to use the latest stable version of R (e.g., R 4.0.6 or higher). Download the latest version from the CRAN website.Required Packages: In R, you will need to install and load the following packages to perform the necessary tasks:<br>ggplot2: Used for data visualization.<br><br>readxl: Used to read Excel files.<br><br>dplyr: Used for data manipulation (e.g., filtering, grouping, summarizing).<br><br>writexl: Used to write data back to Excel.<br><br>extrafont: Used to load additional fonts for enhancing graphics.<br>2. Workflow in R<br>The following is the workflow for processing and visualizing my data in R:<br>Read the Excel File: The package is used to read the Excel file (). The file is loaded into the variable.readxlACI-气象数据.xlsxdataData Processing: The package is used to manipulate the data, such as filtering for a specific time range (18:00 to 07:00), adjusting the hour values, and calculating the average ACI value per hour.dplyrData Visualization: The package is used to create a line plot showing how the average ACI value changes over time.ggplot2Save Results: The processed data, including the average ACI values and the peak/trough labels, is saved to a new Excel file. The plot is saved as a JPEG image using .ggsave