Interesting JQ filters

[Kagami]

Post cool JQ filters you've come up with. Is there some interesting correlation in K-pop data you've discovered?

Here are few examples:

• Common idol names: .idols | group_by(.real_name_original)[] | select(length>=4)
• Group debuts per year: .groups | group_by(.debut_date[:4]) | sort_by(-length)[] | "\(.[0].debut_date[:4]): \(length)"

[Kagami]

Average debut age: [.idols[] | select(.debut_date != null) | ((.debut_date|strptime("%Y-%m-%d")|mktime) - (.birth_date|strptime("%Y-%m-%d")|mktime)) / 31536000] | add/length

[Kagami]

Average group live time: [.groups[] | select(.debut_date != null and .disband_date != null) | ((.disband_date|strptime("%Y-%m-%d")|mktime) - (.debut_date|strptime("%Y-%m-%d")|mktime)) / 31536000] | add/length

[Kagami]

Find idols from group matching regexp: . as $r | .groups[] | select(.name|test("pristin$";"i")).id as $id | $r.idols[] | select(.groups[]|contains($id))

But this gets complicated quickly, easier to copy-paste the ID probably...

[Kagami]

Average number of members in groups debuted after 2015: [.groups[] | select(.debut_date != null and (.debut_date | strptime("%Y-%m-%d")[0] > 2015)) | .members|length] | add/length

[Kagami]

Most common birth dates: .idols | group_by(.birth_date|strptime("%Y-%m-%d")[1:3]) | sort_by(-length)[] | . as $a | map(.name) | join(" ") | "\($a[0].birth_date[5:]): \(.) (\($a|length) times)"