Viewing annotations made in CSV

I have a set of annotations for videos that were exported in CSV format. We want to try and check the annotations. Is there a way to view the videos and pre-made annotaions that were created from the server along with the videos - the same way that they were made?

1 Like

hi @thoughtful!

Thanks for your question and welcome to the Prodigy community :wave:

What type of annotations are they? Transcripts? Image-like annotation like object tracking/bounding boxes? Categories? Something else?

How were these annotations created? If in Prodigy, what UI or recipe? If not, what tool exported this csv and/or what columns are in your csv? If you can you give an example that'll make it a lot easier.

Depending on what type of annotation, you may need to create a custom recipe that combines the video with another UI type that aligns to that annotation type (e.g., for categories you'd need the choice).

At minimum, you'll need either a path to your videos (".mpeg", ".mpg", ".mp4") or a base64 data URI for the video. The Prodigy docs have a section on different loaders including for video.

1 Like

The annotations were made on the audio of videos using prodigy and I'm assuming exported as a CSV with the header being:

video,text,meta,path,_input_hash,_task_hash,_is_binary,_view_id,audio_spans,answer,_timestamp

The audio_spans has jsonl formatted text that notes the timestamps of clips from each of the recordings, along with the classification labels for each of the clips.

The video files are in mp4 format and I was able to point the server towards the videos and successfully read them if I want to reannotated the videos using the audio.manual with the --load video switch, but I want to see the existing annotations.

Unfortunately, the person that made the annotations is not available.

Let's assume this is your data:

# wow-video.jsonl
{"video":"https://videos.ctfassets.net/bs8ntwkklfua/37JfmMxgY5URkfzGHVFzz6/7b3a2c28337b907156b9d188d915f808/Midnight_in_Paris_Wow_10_480p.mp4","text":"Midnight in Paris","_input_hash":-2034503873,"_task_hash":-591136661,"_view_id":"audio_manual","audio_spans":[{"start":0.2603688983,"end":0.5032927285,"label":"WOW","id":"07e199a6-a4b1-403e-9415-ae6a2043bddf","color":"rgba(255,215,0,0.2)"}],"answer":"accept","_timestamp":1669147206,"_is_binary":false}
{"video":"https://videos.ctfassets.net/bs8ntwkklfua/2DfiudsiNA5n0CR2ibzu38/a405bd61b9c11240aa4dd7e163cc0903/Cars_3_Wow_9_480p.mp4","text":"Cars 3","_input_hash":1465204248,"_task_hash":-460213143,"_view_id":"audio_manual","audio_spans":[{"start":0.0898107358,"end":0.8975401325,"label":"WOW","id":"bfbba0b5-2583-4bd7-9931-1e46e35f25df","color":"rgba(255,215,0,0.2)"}],"answer":"accept","_timestamp":1669147212,"_is_binary":false}
{"video":"https://videos.ctfassets.net/bs8ntwkklfua/7tA15W0lgJr7CpJNCf1m4Z/86a953df81d88f5fa79e35aa1e4e4dc1/The_Big_Bounce_Wow_2_480p.mp4","text":"The Big Bounce","_input_hash":334946211,"_task_hash":-1916326215,"_view_id":"audio_manual","audio_spans":[{"start":0.19570347,"end":0.5278422713,"label":"WOW","id":"eeb6f211-f55e-478c-8c62-8ad9bdd1ff33","color":"rgba(255,215,0,0.2)"}],"answer":"accept","_timestamp":1669147215,"_is_binary":false}

First, load that data into Prodigy as dataset:

python -m prodigy db-in wow-video-annotations wow-video.jsonl

The key is having the audio_spans populated as mentioned here.

Now run this:

python -m prodigy audio.manual review_wow_data dataset:wow-video-annotations --label WOW --loader video

The key is using dataset: prefix to use your loaded dataset (with the audio_spans) as your source. Be sure the value in your --label corresponds to the labels you have in your audio_spans.

Let me know if this works!