Example

Header (YAML):

import audformat.testing

db = audformat.testing.create_db()
db

name: unittest
description: A database for unit testing.
source: internal
usage: unrestricted
languages: [deu, eng]
author: J. Wagner, H. Wierstorf
organization: audEERING GmbH
license: CC0-1.0
attachments:
  file: {path: extra/file.txt}
  folder: {path: extra/folder}
media:
  microphone: {type: other, format: wav, channels: 1, bit_depth: 16, sampling_rate: 16000}
  webcam:
    type: other
    format: avi
    video_fps: 25
    video_resolution: [800, 600]
    video_channels: 3
    video_depth: 8
raters:
  gold: {description: Gold standard by taking the average ratings., type: human}
  machine: {description: Predictions made by the machine., type: machine, classifier: LibSVM,
    features: ComParE_2016}
schemes:
  bool: {dtype: bool}
  date: {dtype: date}
  float: {dtype: float, minimum: -1.0, maximum: 1.0}
  int: {dtype: int, minimum: 0, maximum: 100}
  label:
    dtype: str
    labels: [label1, label2, label3]
  label_map_int:
    dtype: int
    labels: {1: a, 2: b, 3: c}
  label_map_misc: {dtype: str, labels: misc}
  label_map_str:
    dtype: str
    labels:
      label1: {prop1: 1, prop2: a}
      label2: {prop1: 2, prop2: b}
      label3: {prop1: 3, prop2: c}
  string: {dtype: str}
  time: {dtype: time}
splits:
  dev: {type: dev}
  test: {type: test}
  train: {type: train}
tables:
  files:
    type: filewise
    split_id: train
    media_id: microphone
    columns:
      bool: {scheme_id: bool, rater_id: gold}
      date: {scheme_id: date, rater_id: gold}
      float: {scheme_id: float, rater_id: gold}
      int: {scheme_id: int, rater_id: gold}
      label: {scheme_id: label, rater_id: gold}
      label_map_int: {scheme_id: label_map_int, rater_id: gold}
      label_map_misc: {scheme_id: label_map_misc, rater_id: gold}
      label_map_str: {scheme_id: label_map_str, rater_id: gold}
      string: {scheme_id: string, rater_id: gold}
      time: {scheme_id: time, rater_id: gold}
      no_scheme: {}
  segments:
    type: segmented
    split_id: dev
    media_id: microphone
    columns:
      bool: {scheme_id: bool, rater_id: gold}
      date: {scheme_id: date, rater_id: gold}
      float: {scheme_id: float, rater_id: gold}
      int: {scheme_id: int, rater_id: gold}
      label: {scheme_id: label, rater_id: gold}
      label_map_int: {scheme_id: label_map_int, rater_id: gold}
      label_map_misc: {scheme_id: label_map_misc, rater_id: gold}
      label_map_str: {scheme_id: label_map_str, rater_id: gold}
      string: {scheme_id: string, rater_id: gold}
      time: {scheme_id: time, rater_id: gold}
      no_scheme: {}
misc_tables:
  misc:
    levels: {labels: str}
    columns:
      int: {scheme_id: int}
      label: {scheme_id: label}
audformat: https://github.com/audeering/audformat

Filewise table as pd.DataFrame:

db["files"].get()

	bool	date	float	int	label	label_map_int	label_map_misc	label_map_str	string	time	no_scheme
file
audio/001.wav	False	1970-01-01 00:00:00.990	0.487578	85	label1	1	label3	NaN	zf9GzkxI9A	0 days 00:00:00.950000	Lan5xiVkuz
audio/002.wav	False	NaT	-0.198316	26	label2	1	label3	label3	osHgK2X689	NaT	pszyYDJh9M
audio/003.wav	False	NaT	-0.984106	82	label3	NaN	NaN	label3	<NA>	NaT	t9s79ZKqtr
audio/004.wav	False	NaT	0.271231	80	NaN	1	label1	label2	OqGhQTYrXu	NaT	UWOWZdoerO
audio/005.wav	True	NaT	NaN	<NA>	NaN	2	NaN	label2	<NA>	0 days 00:00:00.320000	jlS50rl4Lc
...	...	...	...	...	...	...	...	...	...	...	...
audio/096.wav	False	1970-01-01 00:00:00.930	0.132588	81	label2	NaN	label2	label2	MdVoewBic6	0 days 00:00:00.120000	jpLDg5V1MX
audio/097.wav	<NA>	NaT	NaN	15	label2	1	NaN	label1	<NA>	0 days 00:00:00.080000	Nunc2iID9O
audio/098.wav	False	NaT	0.456499	66	label3	1	label1	NaN	rkXjdqHAjn	0 days 00:00:00.360000	None
audio/099.wav	<NA>	1970-01-01 00:00:00.410	NaN	48	label1	3	label1	label3	<NA>	0 days 00:00:00.940000	Q9wJcbnRQ1
audio/100.wav	False	1970-01-01 00:00:00.400	0.780144	<NA>	label3	2	label2	label2	<NA>	NaT	SYJplxGbrj

100 rows × 11 columns

and as CSV:

file,bool,date,float,int,label,label_map_int,label_map_misc,label_map_str,string,time,no_scheme
audio/001.wav,False,1970-01-01 00:00:00.990,0.4875779292440072,85,label1,1,label3,,zf9GzkxI9A,0 days 00:00:00.950000,Lan5xiVkuz
audio/002.wav,False,,-0.1983156471197054,26,label2,1,label3,label3,osHgK2X689,,pszyYDJh9M
audio/003.wav,False,,-0.984106110767405,82,label3,,,label3,,,t9s79ZKqtr
audio/004.wav,False,,0.2712305128055372,80,,1,label1,label2,OqGhQTYrXu,,UWOWZdoerO
audio/005.wav,True,,,,,2,,label2,,0 days 00:00:00.320000,jlS50rl4Lc
audio/006.wav,True,1970-01-01 00:00:00.170,0.9182492279191328,67,,3,label1,,Y3laMXeczJ,0 days 00:00:00.800000,kvWxI5jT8X
audio/007.wav,False,,-0.2634886706713828,92,,,label2,label3,,,
audio/008.wav,True,1970-01-01 00:00:00.470,-0.07378514516176704,65,label2,2,label3,,CyQ2UT5I0x,0 days 00:00:00.040000,05hsrkonf5
audio/009.wav,False,1970-01-01 00:00:00.910,0.3340900843463219,,label2,3,,label2,43lBz0RiJD,0 days 00:00:00.190000,
audio/010.wav,,,0.1878222132743954,8,label3,1,,label3,BWtFIL5yyL,0 days 00:00:00.480000,nEEJcpXDp2
audio/011.wav,True,1970-01-01 00:00:00.360,-0.7351831735883583,80,,1,label2,label2,LivehyFr2t,0 days 00:00:00.320000,jdR5pYenwU
audio/012.wav,True,1970-01-01 00:00:00.140,,24,label2,,label2,,1qBDk8eHeK,0 days 00:00:00.090000,swNuxc8oAv
audio/013.wav,False,1970-01-01 00:00:00.350,0.9565444852628844,7,label3,,label1,label3,Cvq2PeRYgA,0 days 00:00:00.360000,BaHruIre5E
audio/014.wav,False,,0.7736684480841995,6,,2,label3,,pLp2W1aBdC,0 days 00:00:00.960000,
audio/015.wav,False,1970-01-01 00:00:00.450,-0.8460493240802707,64,label2,,,,08SZlrFTed,0 days 00:00:00.490000,8SzdQKDLbh
audio/016.wav,False,1970-01-01 00:00:00.000,0.4973209111102672,62,label3,3,,,JhqKnZf2F8,0 days 00:00:00.960000,w5RLldkBRH
audio/017.wav,,1970-01-01 00:00:00.540,0.0012961932290695977,19,label1,1,label2,label2,,0 days 00:00:00.280000,DlBVbeLsvk
audio/018.wav,False,1970-01-01 00:00:00.810,0.8305929205436962,19,label3,2,label2,,,0 days 00:00:00.370000,XukVuhqhFA
audio/019.wav,False,1970-01-01 00:00:00.540,0.958497297450535,69,label1,1,label3,label3,CbFhIP5p8X,0 days 00:00:00.610000,goxuj3m4mw
audio/020.wav,False,1970-01-01 00:00:00.710,0.20651246249303234,83,label3,1,,label1,qiDjTdf1AV,0 days 00:00:00.510000,P649kgNk04
audio/021.wav,False,1970-01-01 00:00:00.270,-0.007032606279765652,49,,2,label3,label1,ga4PXqvNcm,0 days 00:00:00.380000,
audio/022.wav,,1970-01-01 00:00:00.200,,26,,1,label2,label1,,0 days 00:00:00.080000,GT38EKme2B
audio/023.wav,,1970-01-01 00:00:00.660,0.9001880210654707,,label2,1,label1,label2,63YH7YzSzQ,0 days 00:00:00.470000,
audio/024.wav,True,1970-01-01 00:00:00.550,0.6780417687747924,62,label1,1,label3,label3,OonURZJekt,0 days 00:00:00.440000,lrCh9IQtf2
audio/025.wav,,,-0.00431888896201249,81,label1,2,label3,label1,slXcG9x5es,,iIGSTihU42
audio/026.wav,True,1970-01-01 00:00:00.950,0.8804009072950725,27,label1,3,,label3,SUawATRzkY,0 days 00:00:00.560000,BAnhnbNLIb
audio/027.wav,True,1970-01-01 00:00:00.820,0.13369300326651,,,1,,,GtoLFlrcyZ,0 days 00:00:00.380000,a87OglbBcj
audio/028.wav,True,,,,label3,,label2,label3,w0y4Sy3gXn,,AKfyjxTvsB
audio/029.wav,False,1970-01-01 00:00:00.520,-0.816647672119686,86,,3,label3,,oY7zM28giu,,I4bWTnfmKZ
audio/030.wav,,1970-01-01 00:00:00.900,0.6644217703861375,66,,2,label3,label2,EgGUw752Gw,0 days 00:00:00.130000,Pk5LuyNVYq
audio/031.wav,,1970-01-01 00:00:00.350,0.30006531342066634,10,label2,2,label2,label1,SL97nbnhWv,,
audio/032.wav,,1970-01-01 00:00:00.110,,71,label3,1,label1,label3,kDPBsCILQI,,WfOGWj6L7f
audio/033.wav,False,1970-01-01 00:00:00.980,0.8819476189534501,90,label1,2,,label1,MNbIhjiYuM,,BkuBGlafcG
audio/034.wav,True,1970-01-01 00:00:00.430,0.11634642115220784,51,,,label3,label1,Is0mUEWsx6,0 days 00:00:00.230000,
audio/035.wav,True,1970-01-01 00:00:00.480,0.0336320550089686,97,label2,,label1,label2,fzX0xRBpI9,0 days 00:00:00.210000,OT8QX1wXAi
audio/036.wav,,,-0.7752228827490002,,label1,3,label2,label1,Ix2jB4ifQn,,hYCa2RMhfv
audio/037.wav,False,1970-01-01 00:00:00.840,0.2640746616802985,,label1,2,label3,label1,BgsItfJaXL,0 days 00:00:00.940000,AYrRYeyuin
audio/038.wav,False,1970-01-01 00:00:00.320,-0.47420489794858955,22,,2,label2,label2,,0 days 00:00:00,ixofwdf8oN
audio/039.wav,False,1970-01-01 00:00:00.120,0.4170128739554009,66,,1,label1,,eVMJsbEQ2O,0 days 00:00:00.970000,dYqztA1oFb
audio/040.wav,False,1970-01-01 00:00:00.040,-0.6386380546073323,74,label3,1,label1,label1,1Ub0Vn6Z7l,0 days 00:00:00.170000,UcGbXgOt2x
audio/041.wav,False,,,51,label3,2,label3,label1,,0 days 00:00:00.630000,ciEtcS269f
audio/042.wav,False,1970-01-01 00:00:00.890,,43,,3,,label2,,,5huECXC2g4
audio/043.wav,,1970-01-01 00:00:00.340,0.7892174831136216,25,,1,label1,label1,,0 days 00:00:00.970000,VjB8ax7DeR
audio/044.wav,,,0.243189472290271,60,label3,3,,label3,1Ephi9KJGM,,K0sBANPssj
audio/045.wav,False,1970-01-01 00:00:00.670,-0.5138350352259673,36,,,label3,label2,cbXzPhztL3,0 days 00:00:00.870000,WzMzXRJXAu
audio/046.wav,True,,-0.9559492860603804,25,label2,1,label1,label1,,0 days 00:00:00.610000,idMtIzQ1sU
audio/047.wav,False,,0.344251611138191,47,,3,label2,label2,3hhQqZcKc9,0 days 00:00:00.440000,
audio/048.wav,True,1970-01-01 00:00:00.230,-0.1743875358295408,33,label3,,label3,label2,,0 days 00:00:00.380000,VnO4nZP6Jv
audio/049.wav,,1970-01-01 00:00:00.040,0.19286669834965808,45,,,label1,label2,2YbJpCRewK,0 days 00:00:00.760000,dPSPdVIXnR
audio/050.wav,False,1970-01-01 00:00:00.610,0.34910228934230836,64,,,label3,label1,fzjIP5E3T7,,XHEJ50zs3U
audio/051.wav,True,1970-01-01 00:00:00.580,0.7250206403977284,,label3,,label2,label3,bYZF43AJSb,0 days 00:00:00.940000,M2C5ar82EV
audio/052.wav,True,1970-01-01 00:00:00.330,-0.8995211862197503,54,label1,1,label3,label1,ycG23pccWF,0 days 00:00:00.650000,REzR4CcCEV
audio/053.wav,False,1970-01-01 00:00:00.500,-0.06262942711455088,54,label3,1,label3,,tHB1nwS0Jg,,TYrtfv6z5f
audio/054.wav,False,1970-01-01 00:00:00.070,0.49190933159786887,,,2,label2,label2,dQH0cVCDg0,0 days 00:00:00.640000,
audio/055.wav,False,1970-01-01 00:00:00.690,,85,label3,3,,,wfszfayE5E,0 days 00:00:00.690000,CWQZX9LOfj
audio/056.wav,False,1970-01-01 00:00:00.350,-0.4611389340665617,22,label1,1,label1,label1,,0 days 00:00:00.870000,d9vaByzfxN
audio/057.wav,True,1970-01-01 00:00:00.260,0.43159966603530564,47,,3,label2,label1,,0 days 00:00:00.780000,wEtNWfiCig
audio/058.wav,,1970-01-01 00:00:00.270,-0.17317088925319113,,label3,,label1,label1,DW4At1Cdjd,0 days 00:00:00.500000,
audio/059.wav,True,,-0.8866732804157373,,,3,label3,label2,,,L2MN1haPzo
audio/060.wav,False,1970-01-01 00:00:00.710,-0.7735341166805265,78,,3,label3,,y2PhneohGJ,0 days 00:00:00.460000,rCqduweHdz
audio/061.wav,False,1970-01-01 00:00:00.810,0.7176392530183042,17,,2,label2,,GrATU1zRw7,0 days 00:00:00.110000,
audio/062.wav,True,1970-01-01 00:00:00.870,-0.30803724968965596,,label3,3,label3,label2,,0 days 00:00:00.790000,InRnBU8cCs
audio/063.wav,,1970-01-01 00:00:00.210,-0.7662108064604904,65,,1,label2,,naIch5PnSl,0 days 00:00:00.570000,XKvGjtJFKg
audio/064.wav,False,1970-01-01 00:00:00.740,,,,,label1,label1,KIArVPmUah,0 days 00:00:00.020000,
audio/065.wav,True,1970-01-01 00:00:00.390,,,label1,1,label1,label1,eaDueBnhxa,0 days 00:00:00.310000,kYOeQfj1I2
audio/066.wav,False,1970-01-01 00:00:00.690,,0,,,label2,label3,,0 days 00:00:00.920000,tCJMJmlRfw
audio/067.wav,,1970-01-01 00:00:00.470,0.5501855362151629,40,,,label3,,VUEU9OEIs1,0 days 00:00:00.330000,
audio/068.wav,False,1970-01-01 00:00:00.300,-0.20759742798664726,8,label1,,label2,label2,UgSjAoqhSj,0 days 00:00:00.320000,TVvZcHxxKy
audio/069.wav,False,1970-01-01 00:00:00.850,0.9639604182998942,87,label3,1,label2,label2,hsr9JORlNp,0 days 00:00:00.860000,v4lfgSGyCw
audio/070.wav,False,1970-01-01 00:00:00.580,-0.8131546392658844,15,label1,1,label2,label2,rfpTiD9Mgm,0 days 00:00:00.660000,QLTFXqrx7D
audio/071.wav,True,,0.22857130634395273,13,,3,,label1,,0 days 00:00:00.200000,fwcrgYPW1J
audio/072.wav,False,1970-01-01 00:00:00.730,0.5585345476163079,,label1,2,,label1,qXlHWhz9yc,,sdaMKUGIYe
audio/073.wav,,1970-01-01 00:00:00.090,-0.3815698845521953,,label3,2,,label1,S1vdYxX9gC,0 days 00:00:00.040000,mu0gNgaO9J
audio/074.wav,False,1970-01-01 00:00:00.110,-0.21007054322423424,29,,,label2,,a1WWzCFFCR,0 days 00:00:00.810000,POgalWTOkU
audio/075.wav,True,1970-01-01 00:00:00.220,-0.6693182426006856,67,label2,,label2,label2,PTKV5UoI0y,,hIL2jXFLaq
audio/076.wav,,1970-01-01 00:00:00.990,0.48225754774778573,91,label2,2,label3,label3,JMEIlYfA7G,0 days 00:00:00.590000,KzXkG6ZegO
audio/077.wav,True,1970-01-01 00:00:00.900,-0.5193183754186947,20,,2,label3,,pQw7wUCFrW,0 days 00:00:00.980000,pBNblVPIzb
audio/078.wav,,1970-01-01 00:00:00.540,0.22874130943843363,52,label1,3,label1,,0DB8chRMWS,0 days 00:00:00.290000,BFYLzE9aPc
audio/079.wav,False,1970-01-01 00:00:00.650,-0.8786252515463824,54,label3,,label2,label3,DCf2kR85V7,0 days 00:00:00.030000,
audio/080.wav,False,1970-01-01 00:00:00.970,0.6070464520783208,42,label3,1,label3,label1,gxdc6Uo0B0,0 days 00:00:00.810000,3NK5CqdqYQ
audio/081.wav,,,,84,label1,2,,label2,IEhcaK3j0U,0 days 00:00:00.320000,6135rsKIwQ
audio/082.wav,True,,-0.08244817416204198,75,label1,1,label2,,,0 days 00:00:00.830000,HO1J3iuBzK
audio/083.wav,False,,0.23350661602385436,,label2,3,label1,label1,QIhf7BCDgx,,Hh2LVogee1
audio/084.wav,False,1970-01-01 00:00:00.990,-0.6275211429635814,,label1,,label3,,xLTdw6nxIi,,FelDa4dDng
audio/085.wav,False,1970-01-01 00:00:00.400,0.31683004278753213,97,label1,,label2,label2,zcrQVPj37l,0 days 00:00:00.160000,
audio/086.wav,False,1970-01-01 00:00:00.770,,79,label2,1,label2,label1,,0 days 00:00:00.660000,CznPLKunlZ
audio/087.wav,True,1970-01-01 00:00:00.930,0.6874787075131978,18,label3,2,label3,label3,,,ybsCkSiXIv
audio/088.wav,,1970-01-01 00:00:01.000,0.8362482874548276,18,label2,,,label3,50WhIEsMLe,,
audio/089.wav,False,1970-01-01 00:00:00.340,,7,label1,,label2,,3KqQnJpmty,,NmlxEHgwgz
audio/090.wav,True,1970-01-01 00:00:00.220,-0.5304705359280617,22,label2,1,label2,label2,WWiVhPEx5f,0 days 00:00:00.730000,Je9Mqb52TX
audio/091.wav,,1970-01-01 00:00:00.820,0.37322068756480276,,,3,label1,label3,MzFdAlMa3G,0 days 00:00:00.550000,CA6XviYR5W
audio/092.wav,False,1970-01-01 00:00:00.650,-0.7790336924571926,51,label2,,label1,label3,TDM0nWgdEO,0 days 00:00:00.210000,UUSYIIk7f4
audio/093.wav,True,1970-01-01 00:00:00.010,,50,label2,1,,label3,3PYtbVt0ms,0 days 00:00:00.850000,AOKW7cogUc
audio/094.wav,True,1970-01-01 00:00:00.950,-0.20607864911962737,69,label2,2,label1,label1,,0 days 00:00:00.960000,Zvn9o41JCq
audio/095.wav,True,1970-01-01 00:00:00.190,,6,label2,,label1,label3,9JxiQqx0dw,0 days 00:00:00.880000,JdZZdcfXxT
audio/096.wav,False,1970-01-01 00:00:00.930,0.13258813682744064,81,label2,,label2,label2,MdVoewBic6,0 days 00:00:00.120000,jpLDg5V1MX
audio/097.wav,,,,15,label2,1,,label1,,0 days 00:00:00.080000,Nunc2iID9O
audio/098.wav,False,,0.4564991311899944,66,label3,1,label1,,rkXjdqHAjn,0 days 00:00:00.360000,
audio/099.wav,,1970-01-01 00:00:00.410,,48,label1,3,label1,label3,,0 days 00:00:00.940000,Q9wJcbnRQ1
audio/100.wav,False,1970-01-01 00:00:00.400,0.7801444693813411,,label3,2,label2,label2,,,SYJplxGbrj

Segmented table as pd.DataFrame:

db["segments"].get()

			bool	date	float	int	label	label_map_int	label_map_misc	label_map_str	string	time	no_scheme
file	start	end
audio/001.wav	0 days 00:00:01.522768380	0 days 00:00:04.365893691	False	1970-01-01 00:00:00.290	0.175378	13	label3	3	label2	label3	<NA>	0 days 00:00:00.150000	Giaq8sJUIU
	0 days 00:00:08.218877876	0 days 00:00:08.905515244	True	1970-01-01 00:00:00.620	NaN	68	label2	3	NaN	label3	<NA>	0 days 00:00:00.280000	ew4ghr3DlX
	0 days 00:00:11.148407921	0 days 00:00:11.793873551	True	1970-01-01 00:00:00.410	-0.979005	<NA>	NaN	NaN	label3	label1	qXYJr2jzPS	0 days 00:00:00.430000	ILzba2gP83
	0 days 00:00:18.117781626	0 days 00:00:18.449090017	True	NaT	-0.984370	41	NaN	1	label3	NaN	qWzyYCE9qH	NaT	m4QxxkSp9Y
	0 days 00:00:20.713438068	0 days 00:00:24.047806718	False	1970-01-01 00:00:00.960	0.507933	44	label1	NaN	label1	label2	ziQqxRs52q	0 days 00:00:00.230000	6nZZG0qFiN
...	...	...	...	...	...	...	...	...	...	...	...	...	...
audio/010.wav	0 days 00:00:29.674901563	0 days 00:00:33.847657448	<NA>	1970-01-01 00:00:00.850	0.594633	<NA>	label3	3	label2	label2	LZKaCO13f4	0 days 00:00:00.820000	ySbmjUNFVL
	0 days 00:00:36.337384125	0 days 00:00:36.728754525	True	1970-01-01 00:00:00.130	0.760784	7	label2	3	label1	label2	B11SYDWuTQ	0 days 00:00:00.100000	mJCk5Q9XP4
	0 days 00:00:38.706991339	0 days 00:00:39.247813427	False	NaT	0.810112	70	label1	2	label3	label3	<NA>	0 days 00:00:00.510000	gFbPOEqp6Q
	0 days 00:00:43.067119454	0 days 00:00:43.639530986	True	1970-01-01 00:00:00.790	0.304292	86	label1	2	NaN	label3	<NA>	0 days 00:00:00.210000	KtYw7bFGeE
	0 days 00:00:47.093458301	0 days 00:00:49.199121333	False	1970-01-01 00:00:00.810	0.674034	<NA>	label2	NaN	label1	NaN	Uj6AuX67hr	NaT	r3Frl7rtjZ

100 rows × 11 columns

and as CSV:

file,start,end,bool,date,float,int,label,label_map_int,label_map_misc,label_map_str,string,time,no_scheme
audio/001.wav,0 days 00:00:01.522768380,0 days 00:00:04.365893691,False,1970-01-01 00:00:00.290,0.17537826089833475,13,label3,3,label2,label3,,0 days 00:00:00.150000,Giaq8sJUIU
audio/001.wav,0 days 00:00:08.218877876,0 days 00:00:08.905515244,True,1970-01-01 00:00:00.620,,68,label2,3,,label3,,0 days 00:00:00.280000,ew4ghr3DlX
audio/001.wav,0 days 00:00:11.148407921,0 days 00:00:11.793873551,True,1970-01-01 00:00:00.410,-0.9790050844659839,,,,label3,label1,qXYJr2jzPS,0 days 00:00:00.430000,ILzba2gP83
audio/001.wav,0 days 00:00:18.117781626,0 days 00:00:18.449090017,True,,-0.984370112858709,41,,1,label3,,qWzyYCE9qH,,m4QxxkSp9Y
audio/001.wav,0 days 00:00:20.713438068,0 days 00:00:24.047806718,False,1970-01-01 00:00:00.960,0.5079330658700718,44,label1,,label1,label2,ziQqxRs52q,0 days 00:00:00.230000,6nZZG0qFiN
audio/001.wav,0 days 00:00:28.824865528,0 days 00:00:30.695423975,,1970-01-01 00:00:00.620,,62,label3,3,label3,label2,mThRF1u3Ns,0 days 00:00:00.770000,7pHyhe81u9
audio/001.wav,0 days 00:00:33.434576406,0 days 00:00:35.717021013,False,1970-01-01 00:00:00.230,0.7714824424682345,,label2,1,label1,label2,blJNVvKjKn,0 days 00:00:00.700000,a2G9tr969N
audio/001.wav,0 days 00:00:43.707676229,0 days 00:00:48.104003646,False,,-0.22222988994719928,17,,1,,label2,,0 days 00:00:00.810000,Oz0rZvA6XM
audio/001.wav,0 days 00:00:50.193509586,0 days 00:00:53.470090099,True,1970-01-01 00:00:00.050,,26,,2,label1,,,0 days 00:00:00.120000,4Erby2rw9G
audio/001.wav,0 days 00:00:54.029447711,0 days 00:00:57.266271965,,1970-01-01 00:00:00.690,,40,label1,,label1,label1,qPFbAuhwkT,0 days 00:00:00.940000,n6H1BZsltJ
audio/002.wav,0 days 00:00:02.579904314,0 days 00:00:02.714530153,True,1970-01-01 00:00:00.790,,24,label1,1,label3,,7C49NJnRy0,,
audio/002.wav,0 days 00:00:05.726607815,0 days 00:00:08.655978876,,1970-01-01 00:00:00.690,,,label2,,label3,label1,ZUcy1WYUVr,0 days 00:00:00.670000,dB6WWM5Pz0
audio/002.wav,0 days 00:00:16.024153747,0 days 00:00:19.621149161,False,1970-01-01 00:00:00.040,,25,,1,label2,label1,,0 days 00:00:00.890000,ryeakF24fn
audio/002.wav,0 days 00:00:27.256473042,0 days 00:00:32.243386041,True,1970-01-01 00:00:00.270,-0.30759218966265833,,label3,2,label1,label2,QCEvsQwYeX,0 days 00:00:00.200000,X6gTwzts4k
audio/002.wav,0 days 00:00:33.326230183,0 days 00:00:33.780142621,,1970-01-01 00:00:00.880,-0.01185744981136061,82,label2,1,label1,,zNpLQd0kIJ,,sGmdKLdK2O
audio/002.wav,0 days 00:00:37.447979218,0 days 00:00:37.460101474,,,0.557300184448936,,,1,label2,label3,,0 days 00:00:00.550000,
audio/002.wav,0 days 00:00:37.715391472,0 days 00:00:40.818340108,,1970-01-01 00:00:00.570,0.12911026855446006,25,label1,1,label2,,SPfThzX1tS,,
audio/002.wav,0 days 00:00:43.216111551,0 days 00:00:51.144247100,False,1970-01-01 00:00:00.170,-0.4808436563980798,66,label3,3,label2,label1,EeyXFDnL3c,,
audio/002.wav,0 days 00:00:52.798017800,0 days 00:00:55.106692903,True,1970-01-01 00:00:00.050,-0.13076160217219868,35,label1,3,label2,,N8OMopzBG3,0 days 00:00:00.670000,mAycHWQDQJ
audio/002.wav,0 days 00:00:56.068540865,0 days 00:00:57.576961031,True,1970-01-01 00:00:00.760,,42,label2,3,label3,label1,GAcOyVt3DU,0 days 00:00:00.040000,
audio/003.wav,0 days 00:00:00.854828383,0 days 00:00:01.591135399,True,1970-01-01 00:00:00.430,0.9126351884954902,6,label2,3,label3,label3,ZSgdtENbPf,,
audio/003.wav,0 days 00:00:03.873479500,0 days 00:00:05.645180478,False,1970-01-01 00:00:00.880,-0.296863654754129,11,label2,3,label3,label2,FIBfWTzQ9T,0 days 00:00:00.470000,6xDBflslqh
audio/003.wav,0 days 00:00:07.154927397,0 days 00:00:16.533860688,True,1970-01-01 00:00:00.540,,32,,2,label1,,Sf60gnSyaN,0 days 00:00:00.830000,LuUBtDdQ1t
audio/003.wav,0 days 00:00:20.835387149,0 days 00:00:29.719822388,,,,,label2,,label1,label2,SKe4q8Np50,,oTcglqCVHm
audio/003.wav,0 days 00:00:34.741721197,0 days 00:00:34.817152146,True,,0.6225691730518084,6,label3,3,label2,label2,Co55hp1hR8,,M1j1uhkgbv
audio/003.wav,0 days 00:00:35.307732047,0 days 00:00:45.914408615,True,,,57,label2,3,label2,,,0 days 00:00:00.550000,ibhx7daZGJ
audio/003.wav,0 days 00:00:45.921296494,0 days 00:00:46.826982779,False,1970-01-01 00:00:00.120,-0.230284531357678,96,label3,,label2,,3daLMA3sZQ,,FiQ1RRaZWJ
audio/003.wav,0 days 00:00:47.038127522,0 days 00:00:47.823191303,,1970-01-01 00:00:00.050,0.9866528484247554,84,label3,,,label1,DgEMXNawc0,,8SF29e8mCe
audio/003.wav,0 days 00:00:50.440089776,0 days 00:00:56.863887186,,,,,label1,,label1,,xkf1ONyYLC,0 days 00:00:00,QZVvnGhHdR
audio/003.wav,0 days 00:00:57.741288452,0 days 00:00:59.793859281,,1970-01-01 00:00:00.210,0.7224950907392866,32,label1,3,label3,label1,,0 days 00:00:00.350000,
audio/004.wav,0 days 00:00:00.233870197,0 days 00:00:00.837059106,False,1970-01-01 00:00:00.660,,7,label2,1,label3,label3,KorBjrtP7M,0 days 00:00:00.530000,
audio/004.wav,0 days 00:00:00.931841172,0 days 00:00:05.011292786,False,1970-01-01 00:00:00.650,0.5248416082390852,,label3,3,label2,,,0 days 00:00:00.860000,qcAAbGidMI
audio/004.wav,0 days 00:00:05.317630221,0 days 00:00:06.278556478,True,,,79,,,label3,label2,,0 days 00:00:00.120000,
audio/004.wav,0 days 00:00:18.328059368,0 days 00:00:18.740688129,False,1970-01-01 00:00:00.490,-0.9132159554689987,20,,,label3,,V7KqWamvvO,0 days 00:00:00.340000,joBbXN517A
audio/004.wav,0 days 00:00:23.106615,0 days 00:00:23.356674920,True,1970-01-01 00:00:00.400,0.16686031665974754,82,,,label1,label2,HfQoXbIgKI,0 days 00:00:00.360000,
audio/004.wav,0 days 00:00:35.651328718,0 days 00:00:38.788707809,False,,0.7855318446515818,,label1,1,,label2,,0 days 00:00:00.790000,
audio/004.wav,0 days 00:00:40.328606108,0 days 00:00:40.364201848,False,1970-01-01 00:00:00.420,0.7597760295743423,49,label3,3,,,e2E2xQJS26,0 days 00:00:00.730000,a8jvFAWPnJ
audio/004.wav,0 days 00:00:40.736928454,0 days 00:00:43.365077216,False,,-0.6861147807512111,,label1,2,label1,label1,,0 days 00:00:00.120000,44cnjcbUBR
audio/004.wav,0 days 00:00:52.273702038,0 days 00:00:53.944236605,False,1970-01-01 00:00:00.150,0.6183829895565212,,label2,,label2,label2,L8u8NYlgxB,,kv23EZuql4
audio/004.wav,0 days 00:00:58.175404050,0 days 00:00:59.128924370,,1970-01-01 00:00:00.360,,13,label2,3,label3,label2,vev8DsMWWE,0 days 00:00:00.410000,c2oChx2aIm
audio/005.wav,0 days 00:00:04.257353088,0 days 00:00:05.543883691,True,1970-01-01 00:00:00.240,0.4007691228878978,,label3,1,,label3,oy0GgA4RrZ,0 days 00:00:00.290000,fNLwkvFxxR
audio/005.wav,0 days 00:00:06.693596033,0 days 00:00:07.484192549,,1970-01-01 00:00:00.350,0.153170150366281,53,label3,1,,,AODvFG6smd,0 days 00:00:00.720000,57lqaBcZaI
audio/005.wav,0 days 00:00:10.941952616,0 days 00:00:11.186388688,True,1970-01-01 00:00:00.190,-0.4985394941712906,24,,2,label1,,CUZq1XjkYG,0 days 00:00:00.300000,pFRaMOUwlV
audio/005.wav,0 days 00:00:17.257897991,0 days 00:00:24.677735420,True,1970-01-01 00:00:00.790,,,label1,3,label1,label2,XoErMRw5PN,0 days 00:00:00.880000,
audio/005.wav,0 days 00:00:31.831839808,0 days 00:00:32.744505021,True,1970-01-01 00:00:00.960,-0.6064016959765945,16,,3,label3,label1,MGgOaY0RaX,0 days 00:00:00.120000,AUSFbGcU8T
audio/005.wav,0 days 00:00:37.590084760,0 days 00:00:38.181709596,False,1970-01-01 00:00:00.260,,,label1,2,label3,,IUVT6weDn8,0 days 00:00:00.960000,jXlRqCoLau
audio/005.wav,0 days 00:00:39.915518081,0 days 00:00:45.314531413,True,,0.5150737829225307,,,,,,,0 days 00:00:00.180000,4QE4mMgK03
audio/005.wav,0 days 00:00:45.957799054,0 days 00:00:49.789315960,,1970-01-01 00:00:00.290,-0.38496824867932,43,label2,1,,label3,QZkPTnKBPU,0 days 00:00:00.390000,W0y2Snx7bM
audio/005.wav,0 days 00:00:53.478360791,0 days 00:00:54.866161955,False,1970-01-01 00:00:00.890,0.6538678675407805,,,,label1,,,0 days 00:00:00.640000,
audio/005.wav,0 days 00:00:57.257232754,0 days 00:00:59.126336964,False,1970-01-01 00:00:00.740,,4,label2,1,,label3,KRXqvraJsC,0 days 00:00:00.900000,o9iXNEGB3a
audio/006.wav,0 days 00:00:01.018623846,0 days 00:00:04.302267953,True,1970-01-01 00:00:00.740,,77,label3,2,,label1,4vJX9hvJ8c,0 days 00:00:00.450000,fbKAJNmXgk
audio/006.wav,0 days 00:00:04.802373785,0 days 00:00:05.246303156,False,1970-01-01 00:00:00.790,-0.9652021465544356,26,label2,2,label3,label3,,0 days 00:00:00.990000,0ZWdoChRdM
audio/006.wav,0 days 00:00:10.103801037,0 days 00:00:12.989508324,True,1970-01-01 00:00:00.430,,37,label2,3,label1,label2,,0 days 00:00:00.990000,r6nKYNOAbQ
audio/006.wav,0 days 00:00:15.132300374,0 days 00:00:17.788031048,,1970-01-01 00:00:00.510,,4,label3,1,,label1,RNM528xOQY,0 days 00:00:00.470000,4Nj9W5fvHX
audio/006.wav,0 days 00:00:24.277958277,0 days 00:00:33.424193976,True,1970-01-01 00:00:00.510,,,label1,1,label2,label2,wFcaU2CEzp,0 days 00:00:00.640000,
audio/006.wav,0 days 00:00:35.074584740,0 days 00:00:39.120205848,False,1970-01-01 00:00:00.310,0.7278411140714551,27,label1,,,,0CDmW0jNZu,,go99cmkcMJ
audio/006.wav,0 days 00:00:40.241383282,0 days 00:00:42.460328540,True,,0.42218559807676503,50,label1,,label2,label1,,0 days 00:00:00.450000,
audio/006.wav,0 days 00:00:44.250445315,0 days 00:00:47.327609385,True,,,57,,3,label2,label3,ZCQvTAbEu3,0 days 00:00:00.020000,y7Xxb9NBpS
audio/006.wav,0 days 00:00:51.438065397,0 days 00:00:55.623563691,False,1970-01-01 00:00:00.850,-0.36177646306767186,62,label2,3,label3,label1,HmLgcpbWen,0 days 00:00:00.300000,We5G1dFqgA
audio/006.wav,0 days 00:00:57.933771364,0 days 00:00:58.329462208,False,1970-01-01 00:00:00.560,,72,label2,2,,label3,,0 days 00:00:00.360000,
audio/007.wav,0 days 00:00:08.693021375,0 days 00:00:09.170792735,True,,,96,,,,label2,soKtKlOmI7,0 days 00:00:00.580000,hBPiq1Y3X5
audio/007.wav,0 days 00:00:10.532535326,0 days 00:00:12.551643468,False,1970-01-01 00:00:00.690,0.7446168715729935,87,,2,label3,label1,wh5lTgNN9l,0 days 00:00:00.590000,j6CbXeXqTX
audio/007.wav,0 days 00:00:13.537160436,0 days 00:00:13.990406075,True,1970-01-01 00:00:00.290,0.5839370664813819,65,,3,label1,label3,Ll5HeIjQpv,,rRR3RT5cYv
audio/007.wav,0 days 00:00:17.129793699,0 days 00:00:17.277497817,False,,0.6401140952001612,90,label1,,label2,label2,,0 days 00:00:00.850000,EFxmk4uGKZ
audio/007.wav,0 days 00:00:20.118334070,0 days 00:00:21.686753936,True,1970-01-01 00:00:00.040,-0.6347550079157647,,label2,1,label3,,gqmvMT6Rbm,,eQf95dEXwN
audio/007.wav,0 days 00:00:24.205267431,0 days 00:00:28.866722804,True,,,72,label1,2,label2,label1,f1E7I0CES3,0 days 00:00:01,
audio/007.wav,0 days 00:00:30.411118446,0 days 00:00:35.284409683,False,1970-01-01 00:00:00.000,0.8242129455140679,,label1,,label3,label3,pc4RCH6BdI,0 days 00:00:00.140000,
audio/007.wav,0 days 00:00:45.512359460,0 days 00:00:49.064367586,,,,92,label1,3,,,jCbZrlve1u,0 days 00:00:00.020000,eJDhoUNIJf
audio/007.wav,0 days 00:00:52.944895066,0 days 00:00:55.239650599,False,,,59,,1,label3,label1,,0 days 00:00:00.720000,
audio/007.wav,0 days 00:00:55.249850128,0 days 00:00:59.242798228,,1970-01-01 00:00:00.250,-0.6752719174147332,86,,,label1,label1,OngS48UmgC,0 days 00:00:00.430000,VIn6KIcT8L
audio/008.wav,0 days 00:00:04.974470050,0 days 00:00:11.192762215,False,1970-01-01 00:00:00.400,-0.299838043464546,,label3,,label3,,7uPucB7g62,,Xu7aRLgUKm
audio/008.wav,0 days 00:00:11.929976764,0 days 00:00:13.860134170,,,0.24409976142018808,91,label3,2,label3,label3,gQV42c3oft,,
audio/008.wav,0 days 00:00:20.842238920,0 days 00:00:23.285104641,True,1970-01-01 00:00:00.840,,4,label1,,label1,label1,,,
audio/008.wav,0 days 00:00:25.747093282,0 days 00:00:28.926367161,False,,-0.9660764579522108,69,,,label1,label1,51xCSjJIV0,0 days 00:00:00.030000,43JXlVkZMK
audio/008.wav,0 days 00:00:34.370525191,0 days 00:00:39.161828681,False,,-0.3733063055447796,37,label2,,label2,label3,Ok7AfdPqJI,0 days 00:00:00.200000,XZDm0cPVWC
audio/008.wav,0 days 00:00:42.834593899,0 days 00:00:43.394345697,False,,,,label2,3,label1,label2,pfEP2gwNqR,0 days 00:00:00.970000,1t6BxGkKmN
audio/008.wav,0 days 00:00:43.417537764,0 days 00:00:45.727478066,True,1970-01-01 00:00:00.920,0.24620032257876434,89,label3,1,,label3,Yk4coJmyCE,,K1ral1bp5E
audio/008.wav,0 days 00:00:46.229698519,0 days 00:00:51.829470564,True,,,86,,2,label1,label1,In1EdYmDpp,0 days 00:00:00.840000,f94kTP3eGG
audio/008.wav,0 days 00:00:54.299383517,0 days 00:00:54.713671394,True,,0.15501967654965032,26,label1,,,label2,,,tvHqxrw86Z
audio/008.wav,0 days 00:00:54.918016301,0 days 00:00:59.293547847,,,,65,,,label1,label3,if4QyGpc72,0 days 00:00:00.610000,JJIklrBbo8
audio/009.wav,0 days 00:00:06.593117814,0 days 00:00:13.525793727,True,1970-01-01 00:00:00.670,0.005645941252626185,,label1,3,label1,,,,uK2PQlikfJ
audio/009.wav,0 days 00:00:26.165540920,0 days 00:00:26.885887843,False,1970-01-01 00:00:00.890,0.8400662401770755,,,1,,label1,rfmc8juKQu,0 days 00:00:00.030000,EW0zzRLieB
audio/009.wav,0 days 00:00:27.707806448,0 days 00:00:29.135150800,False,,0.13154164547766878,8,label2,1,label2,label3,,,X5XlcokjJn
audio/009.wav,0 days 00:00:31.543524981,0 days 00:00:33.065289340,True,1970-01-01 00:00:00.230,0.4545114804858428,88,,1,label3,,IVzmpfqCZt,0 days 00:00:00.750000,
audio/009.wav,0 days 00:00:34.555599754,0 days 00:00:38.433451319,,1970-01-01 00:00:00.350,0.05314927155216953,,,2,label1,label2,U4Jt30Iys7,,SvJ15Tbt5x
audio/009.wav,0 days 00:00:39.374346570,0 days 00:00:39.448393866,False,1970-01-01 00:00:00.070,-0.7449447005189995,6,label3,2,label3,label2,,0 days 00:00:00.280000,
audio/009.wav,0 days 00:00:39.585339325,0 days 00:00:49.193826853,,1970-01-01 00:00:00.870,0.8104668429845179,46,,3,label1,,,,
audio/009.wav,0 days 00:00:51.595418872,0 days 00:00:54.419313003,True,1970-01-01 00:00:00.210,-0.40814278431161655,,,,label1,label2,k1nqLRBNPp,,8AHTIf883G
audio/009.wav,0 days 00:00:57.931485060,0 days 00:00:58.194105014,True,,-0.7327533238782109,,label3,2,label1,,qfu32SMXDD,0 days 00:00:00.320000,bkoK3Q0w5w
audio/009.wav,0 days 00:00:58.454675933,0 days 00:00:59.410099975,False,1970-01-01 00:00:00.530,-0.583997770522789,24,label3,3,label2,label1,fBudUcN1XQ,0 days 00:00:00.800000,
audio/010.wav,0 days 00:00:02.197365876,0 days 00:00:09.530502302,True,1970-01-01 00:00:00.050,-0.6299632935605133,,label1,1,label2,label3,h6nvHE13eJ,0 days 00:00:00.660000,LpNC6nUwRE
audio/010.wav,0 days 00:00:10.635286595,0 days 00:00:12.233346715,False,1970-01-01 00:00:00.080,0.3593337066208502,31,label3,3,,label3,z6Deb3GpeG,0 days 00:00:00.090000,hP05LXXLYV
audio/010.wav,0 days 00:00:12.540180821,0 days 00:00:19.555898249,False,1970-01-01 00:00:00.810,,29,label3,,label3,label3,uIGgTAuffE,0 days 00:00:00.410000,LTIdvyTpBM
audio/010.wav,0 days 00:00:20.307578097,0 days 00:00:22.007387376,False,1970-01-01 00:00:00.340,,94,label1,,label1,,0aFxGlbzhi,0 days 00:00:00.080000,
audio/010.wav,0 days 00:00:22.553549449,0 days 00:00:27.588259071,True,,-0.884433503830651,71,label2,,label3,label2,IHFmRFe7Qd,0 days 00:00:00.940000,pGKDxGVdYv
audio/010.wav,0 days 00:00:29.674901563,0 days 00:00:33.847657448,,1970-01-01 00:00:00.850,0.5946328023269141,,label3,3,label2,label2,LZKaCO13f4,0 days 00:00:00.820000,ySbmjUNFVL
audio/010.wav,0 days 00:00:36.337384125,0 days 00:00:36.728754525,True,1970-01-01 00:00:00.130,0.76078443779293,7,label2,3,label1,label2,B11SYDWuTQ,0 days 00:00:00.100000,mJCk5Q9XP4
audio/010.wav,0 days 00:00:38.706991339,0 days 00:00:39.247813427,False,,0.8101120965457398,70,label1,2,label3,label3,,0 days 00:00:00.510000,gFbPOEqp6Q
audio/010.wav,0 days 00:00:43.067119454,0 days 00:00:43.639530986,True,1970-01-01 00:00:00.790,0.30429161623930434,86,label1,2,,label3,,0 days 00:00:00.210000,KtYw7bFGeE
audio/010.wav,0 days 00:00:47.093458301,0 days 00:00:49.199121333,False,1970-01-01 00:00:00.810,0.6740336086412804,,label2,,label1,,Uj6AuX67hr,,r3Frl7rtjZ

Misc table as pd.DataFrame:

db["misc"].get()

	int	label
labels
label1	39	label3
label2	41	label1
label3	21	label1

and as CSV:

labels,int,label
label1,39,label3
label2,41,label1
label3,21,label1