val df = load("search?q=cute%20cats&maxResults=50&part=snippet", 5)
df

val items = df.items.concat()
items

val videos = items.dropNulls { id.videoId }
    .select { id.videoId named "id" and snippet }
    .distinct()
videos

val clean = loaded.move { snippet.channelId and snippet.channelTitle }.under("channel")
    .move { snippet.title and snippet.publishedAt }.toTop()
    .remove { snippet }

clean.head().toHtml()

val statPages = clean.id.chunked(50).map {
    val ids = it.joinToString("%2C")
    load("videos?part=statistics&id=$ids")
}
statPages

val stats = statPages.items.concat().select { id and statistics.allCols() }.parse()
stats

val joined = clean.join(stats)

joined.head().toHtml()

val view by column<Int>()

val channels = joined.groupBy { channel }.sortByCount().aggregate {
    viewCount.sum() into view

    val last = maxBy { publishedAt }
    last.title into "last title"
    last.publishedAt into "time"
    last.viewCount into "viewCount"
}.sortByDesc(view).flatten()
channels

channels.sortBy { viewCount.desc() }.plot {
    bars {
        x(channelTitle.map { it.take(10) })
        y(viewCount)
    }
}

growth.plot {
    area {
        x(publishedAt)
        y(viewCount)
    }
}