veyepar: Analysing Data with Python and BigQuery

Author(s):	Tom Clark
Location	Auditorium
Date	dec Sun 03	Days Raw Files
Start	14:00	First Raw Start	13:48
Duration	40:00	Offset	0:11:55
End	14:40	Last Raw End	15:18
Chapters	00:00 0:17:21 0:33:37
Total cuts_time	37 min.

https://nz.pycon.org/schedule/presentation/162/
raw-playlist raw-mp4-playlist encoded-files-playlist host tweet mp4 svg png

assets release.pdf Frontend_web_development_in_Python_using_Dash.json
logs
Admin: episode episode list cut list raw files day marks day marks day image_files

State:
Locked:	clear this to unlock
Locked by:	user/process that locked.
Start:	initially scheduled time from master, adjusted to match reality
Duration:	length in hh:mm:ss
Name:	Video Title (shows in video search results)
Emails:	email(s) of the presenter(s)
Released:	has someone authorised pubication
Normalise:
Channelcopy:	m=mono, 01=copy left to right, 10=right to left, 00=ignore.
Thumbnail:	filename.png
Description:	BigQuery is a Google tool to quickly analyse large sets of data. A web console and CLI tools are available, but we can also use BigQuery's remote API and Python libraries. In this talk we will introduce BigQuery and use Python to manage a project and analyse some data. Most of the examples found online are either too basic or very advanced. We hope to land somewhere between those extremes. markdown
Comment:	production notes

2017-12-03/13_48_05.ts Apply: 13:48:05 - 13:54:26 ( 00:06:21 ) S: 13:48:05 - E: 14:18:04 D: 00:29:59 (End: 381.0) show more...

vlc ~/Videos/veyepar/kiwipycon/kiwi_pycon_2017/dv/Auditorium/2017-12-03/13_48_05.ts :start-time=00.0 --audio-desync=0

	Raw File	Cut List
	13:48:05		seconds: 0.0 Wall: 13:48:05
Duration	00:29:59
	14:18:04		seconds: 381.0 Wall: 13:54:26
Comments:
mp4 mp4.m3u	dv.m3u	Split: Sequence:: delete

2017-12-03/13_48_05.ts Apply: 13:54:26 - 14:00:43 ( 00:06:17 ) S: 13:48:05 - E: 14:18:04 D: 00:29:59 (Start: 381.0) (End: 758.0) show more...

vlc ~/Videos/veyepar/kiwipycon/kiwi_pycon_2017/dv/Auditorium/2017-12-03/13_48_05.ts :start-time=0381.0 --audio-desync=0

	Raw File	Cut List
	13:48:05		seconds: 381.0 Wall: 13:54:26
Duration	00:29:59
	14:18:04		seconds: 758.0 Wall: 14:00:43
Comments:
mp4 mp4.m3u	dv.m3u	Split: Sequence:: delete

2017-12-03/13_48_05.ts Apply: 14:00:43 - 14:18:04 ( 00:17:21 ) S: 13:48:05 - E: 14:18:04 D: 00:29:59 (Start: 758.0) show more...

vlc ~/Videos/veyepar/kiwipycon/kiwi_pycon_2017/dv/Auditorium/2017-12-03/13_48_05.ts :start-time=0758.0 --audio-desync=0

	Raw File	Cut List
	13:48:05		seconds: 758.0 Wall: 14:00:43
Duration	00:29:59
	14:18:04		seconds: 0.0 Wall: 13:48:05
Comments:
mp4 mp4.m3u	dv.m3u	Split: Sequence:: delete

2017-12-03/14_18_05.ts Apply: 14:18:05 - 14:34:21 ( 00:16:16 ) S: 14:18:05 - E: 14:48:04 D: 00:29:59 (End: 976.0) show more...

vlc ~/Videos/veyepar/kiwipycon/kiwi_pycon_2017/dv/Auditorium/2017-12-03/14_18_05.ts :start-time=00.0 --audio-desync=0

	Raw File	Cut List
	14:18:05		seconds: 0.0 Wall: 14:18:05
Duration	00:29:59
	14:48:04		seconds: 976.0 Wall: 14:34:21
Comments:
mp4 mp4.m3u	dv.m3u	Split: Sequence:: delete

2017-12-03/14_18_05.ts Apply: 14:34:21 - 14:38:15 ( 00:03:54 ) S: 14:18:05 - E: 14:48:04 D: 00:29:59 (Start: 976.0) (End: 1210.0) show more...

vlc ~/Videos/veyepar/kiwipycon/kiwi_pycon_2017/dv/Auditorium/2017-12-03/14_18_05.ts :start-time=0976.0 --audio-desync=0

	Raw File	Cut List
	14:18:05		seconds: 976.0 Wall: 14:34:21
Duration	00:29:59
	14:48:04		seconds: 1210.0 Wall: 14:38:15
Comments:
mp4 mp4.m3u	dv.m3u	Split: Sequence:: delete

2017-12-03/14_18_05.ts Apply: 14:38:15 - 14:48:04 ( 00:09:49 ) S: 14:18:05 - E: 14:48:04 D: 00:29:59 (Start: 1210.0) show more...

vlc ~/Videos/veyepar/kiwipycon/kiwi_pycon_2017/dv/Auditorium/2017-12-03/14_18_05.ts :start-time=01210.0 --audio-desync=0

	Raw File	Cut List
	14:18:05		seconds: 1210.0 Wall: 14:38:15
Duration	00:29:59
	14:48:04		seconds: 0.0 Wall: 14:18:05
Comments:
mp4 mp4.m3u	dv.m3u	Split: Sequence:: delete

2017-12-03/14_48_05.ts Apply: 14:48:05 - 15:16:18 ( 00:28:13 ) S: 14:48:05 - E: 15:18:04 D: 00:29:59 (End: 1693.0) show more...

vlc ~/Videos/veyepar/kiwipycon/kiwi_pycon_2017/dv/Auditorium/2017-12-03/14_48_05.ts :start-time=00.0 --audio-desync=0

	Raw File	Cut List
	14:48:05		seconds: 0.0 Wall: 14:48:05
Duration	00:29:59
	15:18:04		seconds: 1693.0 Wall: 15:16:18
Comments:
mp4 mp4.m3u	dv.m3u	Split: Sequence:: delete

2017-12-03/14_48_05.ts Apply: 15:16:18 - 15:18:04 ( 00:01:46 ) S: 14:48:05 - E: 15:18:04 D: 00:29:59 (Start: 1693.0) show more...

vlc ~/Videos/veyepar/kiwipycon/kiwi_pycon_2017/dv/Auditorium/2017-12-03/14_48_05.ts :start-time=01693.0 --audio-desync=0

	Raw File	Cut List
	14:48:05		seconds: 1693.0 Wall: 15:16:18
Duration	00:29:59
	15:18:04		seconds: 0.0 Wall: 14:48:05
Comments:
mp4 mp4.m3u	dv.m3u	Split: Sequence:: delete

Rf filename:	root is .../show/dv/location/, example: 2013-03-13/13:13:30.dv
Sequence:
get this:	check and save to add this