<p>And if you wanted to do that &quot;automatically&quot; you could just use your favourite programming language or even Excel.
In R, using the <em>lubridate</em> package, you would set the start <code>Date_Time</code> of the recording as a <code>ymd_hms</code> object like
<code>floor_time = lubridate::ymd_hms(name_of_your_file)</code></p>
<p>set the start and end time as lubridate-time objects alike.</p>
<p><code>datetime_start = lubridate::ymd_hms(paste(date, time_start)</code></p>
<p>the you can just add them to your <code>start_date_time</code> with a +.
<code>datetime_start = (floor_time + datetime_start)</code></p>
<p>hope that helps.</p>

CC BY-SA 4.0
2023-12-05T03:57:12.703Z
Thank you very much for the suggestion, that was very helpful! :)
Parus major
CC BY-SA 4.0
2023-10-16T09:33:29.717Z
2023-10-16T09:56:37.937Z
2023-10-16T09:56:37.937Z
Dominik
<p>In order to <em>&quot;...automatically reference each frame to start time of the file...&quot;</em> you have to know the start time of that file (well, duh!).  Fortunately, sound files commonly include that information as part of their filename.</p>
<p>For example, I was recently asked to analyze a sound file with the following filename:</p>
<p>SWIFT #2_96K_<strong>20200621_172433</strong>.wav</p>
<p>Note the bolded portion, which contains the <strong>date_time</strong> that the recording started.  This recording started on June 21, 2020 at 24 minutes and 33 seconds after 5 pm.  The field recorder automatically appended that information to the filename as <strong>yyyymmdd_hhmmss</strong>, where:</p>
<p><strong>yyyy</strong> = year<br>
<strong>mm</strong> = month<br>
<strong>dd</strong> = day<br>
<strong>hh</strong> = hour (24)<br>
<strong>mm</strong> = minute<br>
<strong>ss</strong> = second</p>
<p>If this file contained a sound that had a start time of 14 seconds, then that time is simply added to the filename's <strong>date_time</strong>.  In this case that sound would have started on June 21, 2020 at 24 minutes and 47 seconds after 5 pm.</p>
<p>AFAIK, most field recorders automatically include the starting <strong>date_time</strong> as part of the filename.  If your sound files do not include this, then you'll need to locate some metadata that includes the recording's start time.  Failing that, I don't know how you would be able to determine a start time...</p>

CC BY-SA 4.0
2023-10-15T17:03:27.003Z
2023-10-15T17:11:38.723Z
2023-10-15T17:11:38.723Z
Stu Smith
<p>I deployed some passive acoustic devices to record bird song, and I am using birdNET for the first time. I downloaded the Windows version of the app, set the parameters I preferred and, after running a .wav file, this is what I get:</p>
<p><a href="https://i.sstatic.net/2an5I.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/2an5I.png" alt="enter image description here" /></a></p>
<p>Is there any way to automatically reference each frame to start time of the file in excel or R instead of getting the start and end of each frame in seconds?
I am using GUI, with the following settings: minimum conf: 0.5, Sensitivity : 1, Overlap: 0., species by location. Latitude: 43, Longitude: -110, Week: 24</p>
<p>Thank you!</p>

CC BY-SA 4.0
2023-10-09T06:29:01.773Z
extrapolate with respect to which time? I guess you mean to reference each frame to start time of the file, which would not call extrapolate. Please clarify.
WMXZ
CC BY-SA 4.0
2023-10-09T14:04:56.767Z
Thanks for the comment @WMXZ, I've edited my question accordingly.
Parus major
CC BY-SA 4.0
2023-10-09T16:31:57.977Z
Could you please add, how you invoke Birdnet (CLI or GUI) and if CLI which parameter and for GUI which parameter settigs?
WMXZ
CC BY-SA 4.0
2023-10-13T18:34:52.140Z
Thanks, question edited again with these details.
Parus major
<r><birdsong><birdnet><data-processing><acoustic-monitoring>
How to extrapolate time (as hour) per each recording (.wav file) identified in BirdNET?
# How to extrapolate time (as hour) per each recording (.wav file) identified in BirdNET?

(Asked by: username_0 on 2023-10-08)

I deployed some passive acoustic devices to record bird song, and I am using birdNET for the first time. I downloaded the Windows version of the app, set the parameters I preferred and, after running a .wav file, this is what I get:

[![enter image description here](https://i.sstatic.net/2an5I.png)](https://i.sstatic.net/2an5I.png)

Is there any way to automatically reference each frame to start time of the file in excel or R instead of getting the start and end of each frame in seconds?
I am using GUI, with the following settings: minimum conf: 0.5, Sensitivity : 1, Overlap: 0., species by location. Latitude: 43, Longitude: -110, Week: 24

Thank you!

**Tags:** r, birdsong, birdnet, data-processing, acoustic-monitoring

> **Comments:**
> **username_1**: extrapolate with respect to which time? I guess you mean to reference each frame to start time of the file, which would not call extrapolate. Please clarify.  
> **username_0**: Thanks for the comment @username_1, I've edited my question accordingly.  
> **username_1**: Could you please add, how you invoke Birdnet (CLI or GUI) and if CLI which parameter and for GUI which parameter settigs?  
> **username_0**: Thanks, question edited again with these details.  

---

## 2 answers

### Answer by username_2 on 2023-10-16. Score: 2 | Accepted answer

And if you wanted to do that "automatically" you could just use your favourite programming language or even Excel.
In R, using the *lubridate* package, you would set the start `Date_Time` of the recording as a `ymd_hms` object like
`floor_time = lubridate::ymd_hms(name_of_your_file)`

set the start and end time as lubridate-time objects alike.

`datetime_start = lubridate::ymd_hms(paste(date, time_start)`

the you can just add them to your `start_date_time` with a +.
`datetime_start = (floor_time + datetime_start)`

hope that helps.

> **Comments:**
> **username_0**: Thank you very much for the suggestion, that was very helpful! :)  

---

### Answer by username_3 on 2023-10-15. Score: 2

In order to *"...automatically reference each frame to start time of the file..."* you have to know the start time of that file (well, duh!). Fortunately, sound files commonly include that information as part of their filename.

For example, I was recently asked to analyze a sound file with the following filename:

SWIFT #2\_96K\_**20200621\_172433**.wav

Note the bolded portion, which contains the **date\_time** that the recording started. This recording started on June 21, 2020 at 24 minutes and 33 seconds after 5 pm. The field recorder automatically appended that information to the filename as **yyyymmdd\_hhmmss**, where:

**yyyy** = year  
**mm** = month  
**dd** = day  
**hh** = hour (24)  
**mm** = minute  
**ss** = second

If this file contained a sound that had a start time of 14 seconds, then that time is simply added to the filename's **date\_time**. In this case that sound would have started on June 21, 2020 at 24 minutes and 47 seconds after 5 pm.

AFAIK, most field recorders automatically include the starting **date\_time** as part of the filename. If your sound files do not include this, then you'll need to locate some metadata that includes the recording's start time. Failing that, I don't know how you would be able to determine a start time...


---

