Where are CATS in the world?

! pip install slackclient

import altair

import pandas

import logging

logger = logging.getLogger()

logger.setLevel(logging.INFO)

import os

import slack

import json

from collections import Counter

import pprint

class TimeZoneCounter:

    client = None

    def __init__(self):

        # connect to the slack API

        self.client = slack.WebClient(token=os.environ['SLACK_API_TOKEN'])

    def summary(self):

        # make a counter thingo in python

        cntr = Counter()

        # get a list of our users

        # TODO: we need to paginate through this

#       https://api.slack.com/methods/users.list

        res = self.client.users_list()

        data = res.data

        metadata = data.get("response_metadata")

        if metadata:

          cursor = metadata.get("next_cursor")

        members = [*data["members"]]

        while cursor:

          print(f"Fetching next page for cursor {cursor}")

          res = self.client.users_list(cursor=cursor)

          metadata = res.data.get("response_metadata")

          if metadata:

            cursor = metadata.get("next_cursor")

          members = [*members, *res.data["members"]]

        # pull out the timezones

        timezones = [mem.get('tz') for mem in members]

        # make running totals of timezones

        for tz in timezones:

            cntr[tz] += 1

        return cntr

tzc = TimeZoneCounter()

res = tzc.summary()

len(res)

data = list(res.items())

df = pandas.DataFrame.from_records(data, columns=['timezone', 'count'])

df.sort_values('count', ascending=False)

altair.Chart(data=df, mark="bar").encode(x='timezone', y='count')

df.to_csv("results/cat.timezones.csv")