[FFmpeg-user] astats to csv file

Benjamin Houtman houtmania at gmail.com
Thu Feb 11 15:26:37 EET 2021


I've tried ffprobe at a basic level but it doesn't provide what I'm looking
for, at least as I know how to use it. I basically want the
"Parsed_astats..."  outputs in columns as header: value, for multiple wav
files in a folder.

On Thu, Feb 11, 2021 at 8:16 AM Paul B Mahol <onemda at gmail.com> wrote:

> On Thu, Feb 11, 2021 at 2:13 PM Benjamin Houtman <houtmania at gmail.com>
> wrote:
>
> > I'm trying to find a simple way to push a file's astats metadata to a csv
> > file with headers. It feels like it should be easy to do, but I've not
> been
> > successful so far.
> >
>
> Tried ffprobe csv output with filtering?
>
>
> > Thanks
> > _______________________________________________
> > ffmpeg-user mailing list
> > ffmpeg-user at ffmpeg.org
> > https://ffmpeg.org/mailman/listinfo/ffmpeg-user
> >
> > To unsubscribe, visit link above, or email
> > ffmpeg-user-request at ffmpeg.org with subject "unsubscribe".
> _______________________________________________
> ffmpeg-user mailing list
> ffmpeg-user at ffmpeg.org
> https://ffmpeg.org/mailman/listinfo/ffmpeg-user
>
> To unsubscribe, visit link above, or email
> ffmpeg-user-request at ffmpeg.org with subject "unsubscribe".



-- 
Benjamin Houtman
Archivist
-------------- next part --------------
Last login: Thu Feb 11 08:07:39 on ttys000
TBDC-Archive-2:~ tbdcpreservation$ ffmpeg -i /Users/tbdcpreservation/Desktop/_output/WAV/4A_001_a_access.wav -af astats -f null -
ffmpeg version 4.3.1 Copyright (c) 2000-2020 the FFmpeg developers
  built with Apple clang version 11.0.0 (clang-1100.0.33.17)
  configuration: --prefix=/usr/local/Cellar/ffmpeg/4.3.1_7 --enable-shared --enable-pthreads --enable-version3 --enable-avresample --cc=clang --host-cflags= --host-ldflags= --enable-ffplay --enable-gnutls --enable-gpl --enable-libaom --enable-libbluray --enable-libdav1d --enable-libmp3lame --enable-libopus --enable-librav1e --enable-librubberband --enable-libsnappy --enable-libsrt --enable-libtesseract --enable-libtheora --enable-libvidstab --enable-libvorbis --enable-libvpx --enable-libwebp --enable-libx264 --enable-libx265 --enable-libxml2 --enable-libxvid --enable-lzma --enable-libfontconfig --enable-libfreetype --enable-frei0r --enable-libass --enable-libopencore-amrnb --enable-libopencore-amrwb --enable-libopenjpeg --enable-librtmp --enable-libspeex --enable-libsoxr --enable-videotoolbox --enable-libzmq --enable-libzimg --disable-libjack --disable-indev=jack
  libavutil      56. 51.100 / 56. 51.100
  libavcodec     58. 91.100 / 58. 91.100
  libavformat    58. 45.100 / 58. 45.100
  libavdevice    58. 10.100 / 58. 10.100
  libavfilter     7. 85.100 /  7. 85.100
  libavresample   4.  0.  0 /  4.  0.  0
  libswscale      5.  7.100 /  5.  7.100
  libswresample   3.  7.100 /  3.  7.100
  libpostproc    55.  7.100 / 55.  7.100
Guessed Channel Layout for Input Stream #0.0 : mono
Input #0, wav, from '/Users/tbdcpreservation/Desktop/_output/WAV/4A_001_a_access.wav':
  Metadata:
    comment         : Trisha Brown Dance Company
    encoded_by      : The MediaPreserve
    date            : 2018-08-29
    creation_time   : 16:26:39
    time_reference  : 0
    coding_history  : A=ANALOGUE,M=mono,T=Studer A-807; open reel 
                    : A=PCM,F=96000,W=24,M=mono,T=Antelope Audio;Orion 32;A/D 
                    : A=PCM,F=44100,W=16,M=mono,T=Steinberg;Wavelab 7;Crystal Resampler;Apogee;UV22HR;Dither
  Duration: 00:30:01.04, bitrate: 705 kb/s
    Stream #0:0: Audio: pcm_s16le ([1][0][0][0] / 0x0001), 44100 Hz, mono, s16, 705 kb/s
Stream mapping:
  Stream #0:0 -> #0:0 (pcm_s16le (native) -> pcm_s16le (native))
Press [q] to stop, [?] for help
Output #0, null, to 'pipe:':
  Metadata:
    comment         : Trisha Brown Dance Company
    encoded_by      : The MediaPreserve
    date            : 2018-08-29
    coding_history  : A=ANALOGUE,M=mono,T=Studer A-807; open reel 
                    : A=PCM,F=96000,W=24,M=mono,T=Antelope Audio;Orion 32;A/D 
                    : A=PCM,F=44100,W=16,M=mono,T=Steinberg;Wavelab 7;Crystal Resampler;Apogee;UV22HR;Dither
    time_reference  : 0
    encoder         : Lavf58.45.100
    Stream #0:0: Audio: pcm_s16le, 44100 Hz, mono, s16, 705 kb/s
    Metadata:
      encoder         : Lavc58.91.100 pcm_s16le
size=N/A time=00:30:01.03 bitrate=N/A speed= 951x    
video:0kB audio:155129kB subtitle:0kB other streams:0kB global headers:0kB muxing overhead: unknown
[Parsed_astats_0 @ 0x7fa9bd601900] Channel: 1
[Parsed_astats_0 @ 0x7fa9bd601900] DC offset: -0.000016
[Parsed_astats_0 @ 0x7fa9bd601900] Min level: -18126.000000
[Parsed_astats_0 @ 0x7fa9bd601900] Max level: 17603.000000
[Parsed_astats_0 @ 0x7fa9bd601900] Min difference: 0.000000
[Parsed_astats_0 @ 0x7fa9bd601900] Max difference: 7329.000000
[Parsed_astats_0 @ 0x7fa9bd601900] Mean difference: 132.570980
[Parsed_astats_0 @ 0x7fa9bd601900] RMS difference: 288.642428
[Parsed_astats_0 @ 0x7fa9bd601900] Peak level dB: -5.142694
[Parsed_astats_0 @ 0x7fa9bd601900] RMS level dB: -29.248426
[Parsed_astats_0 @ 0x7fa9bd601900] RMS peak dB: -16.291305
[Parsed_astats_0 @ 0x7fa9bd601900] RMS trough dB: -84.165528
[Parsed_astats_0 @ 0x7fa9bd601900] Crest factor: 16.043037
[Parsed_astats_0 @ 0x7fa9bd601900] Flat factor: 0.000000
[Parsed_astats_0 @ 0x7fa9bd601900] Peak count: 2
[Parsed_astats_0 @ 0x7fa9bd601900] Noise floor dB: -inf
[Parsed_astats_0 @ 0x7fa9bd601900] Noise floor count: 32758
[Parsed_astats_0 @ 0x7fa9bd601900] Bit depth: 16/16
[Parsed_astats_0 @ 0x7fa9bd601900] Dynamic range: 91.186639
[Parsed_astats_0 @ 0x7fa9bd601900] Zero crossings: 9078071
[Parsed_astats_0 @ 0x7fa9bd601900] Zero crossings rate: 0.114296
[Parsed_astats_0 @ 0x7fa9bd601900] Overall
[Parsed_astats_0 @ 0x7fa9bd601900] DC offset: -0.000016
[Parsed_astats_0 @ 0x7fa9bd601900] Min level: -18126.000000
[Parsed_astats_0 @ 0x7fa9bd601900] Max level: 17603.000000
[Parsed_astats_0 @ 0x7fa9bd601900] Min difference: 0.000000
[Parsed_astats_0 @ 0x7fa9bd601900] Max difference: 7329.000000
[Parsed_astats_0 @ 0x7fa9bd601900] Mean difference: 132.570980
[Parsed_astats_0 @ 0x7fa9bd601900] RMS difference: 288.642428
[Parsed_astats_0 @ 0x7fa9bd601900] Peak level dB: -5.142694
[Parsed_astats_0 @ 0x7fa9bd601900] RMS level dB: -29.248426
[Parsed_astats_0 @ 0x7fa9bd601900] RMS peak dB: -16.291305
[Parsed_astats_0 @ 0x7fa9bd601900] RMS trough dB: -84.165528
[Parsed_astats_0 @ 0x7fa9bd601900] Flat factor: 0.000000
[Parsed_astats_0 @ 0x7fa9bd601900] Peak count: 2.000000
[Parsed_astats_0 @ 0x7fa9bd601900] Noise floor dB: -inf
[Parsed_astats_0 @ 0x7fa9bd601900] Noise floor count: 32758.000000
[Parsed_astats_0 @ 0x7fa9bd601900] Bit depth: 16/16
[Parsed_astats_0 @ 0x7fa9bd601900] Number of samples: 79425802
TBDC-Archive-2:~ tbdcpreservation$ 


More information about the ffmpeg-user mailing list