<jupyter_start><jupyter_text>These should all be included in the list of active schemas.<jupyter_code>active_tables["tableName"].pipe(pd_display_all)<jupyter_output><empty_output><jupyter_text>Now, manually assess any schemas listed as active but not found in the list above. If they're truly inactive, they should be removed from the list, but keep in mind they also might represent rare events or have recently been implemented.The key question is whether the schema is used by the latest version of whatever codebase it applies to.One good way to check this is to search for the schema name with the [MediaWiki code search tool](https://codesearch.wmflabs.org). However, note the search doesn't cover the mobile apps and some other codebases that aren't part of MediaWiki.<jupyter_code>extra_active_tables = [
  "guidedtourinternallinkactivation",
  "mobilewikiapplangselect",
  "mobilewikiappofflinelibrary",
  "mobilewikiapponboarding",
  "mobilewikiappwidgets",
  "translationrecommendationuirequests",
  "translationrecommendationuseraction",
  "wikimediablogvisit"
]

eventlogging_tables.query("tableName in @extra_active_tables")<jupyter_output><empty_output>
{'fraction_non_alphanumeric': 0.06763698630136987, 'fraction_numerical': 0.0, 'mean_word_length': 6.898648648648648, 'pattern_counts': {'":': 0, '<': 9, '<?xml version=': 0, '>': 9, 'https://': 1, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'chain_length': '2', 'dir': 'jupyter-structured-clean-dedup', 'id': '175339', 'license': 'MIT', 'n_tokens_mistral': 337, 'n_tokens_neox': 327, 'n_words': 116, 'path': '2020-05-active-EventLogging-streams.ipynb', 'repo_name': 'neilpquinn/misc-wikimedia-analysis', 'size': '1168'}